User detail.

[Shurik_A]

Hi, all.
I've integrated My CPG 1.3 with IPB v2.0.0.
All working perfectly except one thing:

There is a links of user under each photo preview, if I'm trying to click on it instead of going to user details I'm getting a fattal error:

Code Select Expand

While executing query "SELECT name as user_name, mgroup, email as user_email, joined as user_regdate, location as user_location, interests as user_interests, website as user_website FROM `gold4not_photo`.ibf_members WHERE id = '3'" on 0

mySQL error: Unknown column 'location' in 'field list'


How can I fix it?

Thanks.

[Shurik_A]

PLEASE, somebody help!

I'm fighting with it already couple of weeks.
Here is additional information if its going to help:

Code Select Expand


USER:
------------------
Array
(
    [ID] => ***********************
    [am] => 1
    [liv] => Array
        (
            [0] => 9
            [1] => 23
        )

)

==========================
USER DATA:
------------------
Array
(
    [0] => 1
    [user_id] => 1
    [1] => *******
    [user_name] => *******
    [2] => 4
    [mgroup] => 4
    [3] => 4
    [group_id] => 4
    [4] => Admin
    [group_name] => Admin
    [5] => 0
    [group_quota] => 0
    [6] => 0
    [has_admin_access] => 1
    [7] => 1
    [can_rate_pictures] => 1
    [8] => 1
    [can_send_ecards] => 1
    [9] => 1
    [can_post_comments] => 1
    [10] => 1
    [can_upload_pictures] => 1
    [11] => 1
    [can_create_albums] => 1
    [12] => 0
    [pub_upl_need_approval] => 0
    [13] => 0
    [priv_upl_need_approval] => 0
    [14] => 0
    [upload_form_config] => 0
    [15] => 0
    [custom_user_upload] => 0
    [16] => 5
    [num_file_upload] => 5
    [17] => 3
    [num_URI_upload] => 3
    [groups] => Array
        (
            [0] => 4
        )

    [can_see_all_albums] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content FROM cpg132_filetypes;
    [1] => SELECT id as user_id, name as user_name, mgroup FROM `gold4not_photo`.ibf_members WHERE id='1' AND member_login_key='9eba281eb4e27199f39ffae79ea63a54'
    [2] => SELECT * FROM cpg132_usergroups WHERE group_id = '4'
    [3] => DELETE FROM cpg132_banned WHERE expiry < 1102489905
    [4] => SELECT * FROM cpg132_banned WHERE ip_addr='62.0.228.7' OR ip_addr='62.0.228.7' OR user_id=1
    [5] => SELECT name as user_name, mgroup, email as user_email, joined as user_regdate, location as user_location, interests as user_interests, website as user_website FROM `gold4not_photo`.ibf_members WHERE id = '3'
)

==========================
GET :
------------------
Array
(
    [uid] => 3
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.8 - OK
------------------
mySQL version: 4.0.18
------------------
Coppermine version: 1.3.2
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.23 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 3.23.49
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /var/tmp/mysql.sock
MYSQL_INCLUDE no value
MYSQL_LIBS no value
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.1
Linked Version 1.2.1
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/local/lib/php | .:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | me@localhost.com | me@localhost.com
sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.047 seconds - 6 queries in 0.002 seconds - Album set :


[Nibbler]

Either ipb has no 'location' info for a user or it is named something else. Look for the query in the bridge file and adjust it.

[Shurik_A]

Either ipb has no 'location' info for a user or it is named something else. Look for the query in the bridge file and adjust it.

That what I'm trying to and without success!
That's why I'm looking for help, what do I have to adjust?
Thanks.

[Nibbler]

I've no idea, take a look at the database.

[Joachim Müller]

the ipb bridge files are user contributions, none of the dev team uses/runs ipb, that's why we can't say anything more helpfull.

Joachim