Modpack breaks User Link when bridged?

[ronronmx]

Hi guys! I need a little help if anyone's willing to help out 

I have coppermine 1.4.18 bridged with Joomla 1.5.3 using Medhi's bridge. Everything works fine, but after I installed the modpack, one of my links is broken. Visit this page:
http://ronronmx.com/cpg/index.php?cat=1

At the top of the page you'll see 2 albums, 1 named "ronronmx" and the other "testuser". If you click on the "ronronmx" or "testuser" link, you'll get an error: "There was an error while processing a database query". If you look at the actual link, you'll see the end shows : profile.php?uid=64 but if you click on the thumbnail above, the link at the end is different: index.php?cat=10064. Notice how the user link is missing "100" before "64". How can i fix that? If i can't, how can I change that broken link to be the same one as the thumb link above?

Thx a lot for any help on that matter!!!
Stephane

[ronronmx]

Can anyone help me out with this issue? Has it been discussed somewhere else already? I looked but couldn't find anything concerning my problem...did I look good enough?
Sorry if this has been asked 20 times before, i must have missed it 

[Stramm]

Your gallery works for me as is. Seems it's not bridged to Joomla... So what do you expect me to advice you? Link isn't broken, I do not know where it links.

User ID and category number look as they should. The user id is a number starting from 1 incrementing. The category, if it's a user category, is the user id+10000.

[ronronmx]

Your gallery works for me as is. Seems it's not bridged to Joomla... So what do you expect me to advice you? Link isn't broken, I do not know where it links.

User ID and category number look as they should. The user id is a number starting from 1 incrementing. The category, if it's a user category, is the user id+10000.

Hey Stramm, i'm very sorry...I removed the modpack in the meantime to test some other stuff, you looked at the wrong time...now i feel like an idiot !!!
I installed the modpack on my beta site and bridged it with Joomla, go there and click on the user name below the thumbnail and you'll get the query error i'm talking about:

http://ronronmxbeta.com/cpg/index.php

Please disregard the "profile.php?uid=64" i was talking about as this is a different gallery.
Sorry for the confusion...

Stephane

[ronronmx]

Ok, here's the debug info i got:

Error Message: "There was an error while processing a database query"
"While executing query "SELECT *, username AS user_name,
                                                                                email AS user_email,
                                                                                UNIX_TIMESTAMP(registerDate) AS user_regdate,
                                                                                '' AS user_location,
                                                                                '' AS user_website,
                                                            id AS user_id,
                                                             AS notify,
                                                             AS avatar_url

                                                                                FROM  `ronronmx_jml02`.users WHERE id = '2'" on Resource id #37

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS notify,
                                                             AS avatar_url

                                 ' at line 7"

File: /home/ronronmx/public_html/ronronmxbeta/cpg/include/functions.inc.php - Line: 248

**************************************

Debug Info:

Code Select Expand

USER:
------------------
Array
(
    [ID] => 75002260a78fba6342a539d2a4de2f7a
    [am] => 1
    [lang] => english
    [liv] => Array
        (
            [0] => 7
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 62
    [user_name] => ronronmx
    [groups] => Array
        (
            [0] => 125
        )

    [disk_max] => 100000
    [disk_min] => 100000
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Super Administrator
    [upload_form_config] => 3
    [group_quota] => 100000
    [can_see_all_albums] => 1
    [group_id] => 125
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM filetypes; (0s)
    [1] => select * from plugins order by priority asc; (0s)
    [2] => SELECT * FROM bridge (0s)
    [3] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM usergroups WHERE group_id in (125) (0s)
    [4] => SELECT group_name FROM  usergroups WHERE group_id= 125 (0s)
    [5] => SELECT user_favpics FROM favpics WHERE user_id = 62 (0s)
    [6] => DELETE FROM banned WHERE expiry < '2008-05-22 17:54:02' (0s)
    [7] => SELECT * FROM banned WHERE (ip_addr='69.26.230.178' OR ip_addr='69.26.230.178' OR user_id=62) AND brute_force=0 (0s)
    [8] => SELECT *, username AS user_name,
                                                                                email AS user_email,
                                                                                UNIX_TIMESTAMP(registerDate) AS user_regdate,
                                                                                '' AS user_location,
                                                                                '' AS user_website,
id AS user_id,
AS notify,
AS avatar_url

                                                                                FROM  `ronronmx_jml02`.users WHERE id = '2' (0s)
    [9] => SELECT COUNT(*) FROM pictures WHERE approved = 'NO' (0s)
)

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

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.6 - OK
------------------
mySQL version: 5.0.45-community-log
------------------
Coppermine version: 1.4.18(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 2
Client API version 5.0.45
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64 -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.1.2
Linked Version 1.2.3
==========================
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/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
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 | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.216 seconds - 10 queries in 0 seconds - Album set : ; Meta set: ;

*******************************************

Code Select Expand

Notices

raries/joomla/language/language.php

    * Warning line 335: file_get_contents(/home/ronronmx/public_html/ronronmxbeta/language/en-GB/en-GB.com_coppermine.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/home/ronronmx/public_html/ronronmxbeta/language/en-GB/en-GB.com_coppermine.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/home/ronronmx/public_html/ronronmxbeta/language/en-GB/en-GB.tpl_system.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/home/ronronmx/public_html/ronronmxbeta/language/en-GB/en-GB.tpl_system.ini) [function.file-get-contents]: failed to open stream: No such file or directory

/bridge/joomla15.inc.php

    * Notice line 287: Undefined property: JDatabaseMySQL::$_ressource

/include/themes.inc.php

    * Notice line 226: Undefined variable: USER_ID
    * Notice line 912: Undefined variable: pm_link

/bridge/udb_base.inc.php

    * Notice line 395: Undefined index: notify
    * Notice line 396: Undefined index: avatar_url

I hope this help, I can see a few things are missing/wrong, but I don't really know what to do now?
Thx a lot for taking time to help Stramm!!!

Stephane

[ronronmx]

Hi guys! I need a little help if anyone's willing to help out 

I have coppermine 1.4.18 bridged with Joomla 1.5.3 using Medhi's bridge. Everything works fine, but after I installed the modpack, one of my links is broken. Visit this page:
http://ronronmx.com/cpg/index.php?cat=1

At the top of the page you'll see 2 albums, 1 named "ronronmx" and the other "testuser". If you click on the "ronronmx" or "testuser" link, you'll get an error: "There was an error while processing a database query". If you look at the actual link, you'll see the end shows : profile.php?uid=64 but if you click on the thumbnail above, the link at the end is different: index.php?cat=10064. Notice how the user link is missing "100" before "64". How can i fix that? If i can't, how can I change that broken link to be the same one as the thumb link above?

Thx a lot for any help on that matter!!!
Stephane

[Stramm]

You're trying to bridge to a forum that's not supported by the modpack. Adapt the bridge file. It contains the avatar field definition and the definition how to call your forums profile.
Compare with existing modpack compatible bridge files (smf, phpbb2).

[ronronmx]

You're trying to bridge to a forum that's not supported by the modpack. Adapt the bridge file. It contains the avatar field definition and the definition how to call your forums profile.
Compare with existing modpack compatible bridge files (smf, phpbb2).

Ok i understand now, it makes sense...Thx a lot for your help Stramm!!!!

Stephane