coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 bridging => Topic started by: Dr Preacox on November 14, 2006, 08:10:16 AM

Title: CM 1.4 to IPB 2.1.7 Problems
Post by: Dr Preacox on November 14, 2006, 08:10:16 AM
Okee dokie, lets start of with some details.

URL: http://www.zyrv.com
Gallery URL: http://www.zyrv.com/gallery/
Forum URL: http://www.zyrv.com/forums/

Bridge Manager Settings:

Forum URL:      http://www.zyrv.com/forums
Relative path to your BBS's config file:    ../forums/
Use post-based groups?:    0

Testing Account:

username: tester
password: tester

The Error

While executing query "SELECT u.id AS id, u.name AS username, u.member_login_key AS password, u. AS avatar_url, u. AS notify, u. AS auto_subscribe_post, u. AS auto_subscribe_comment, u.mgroup+100 AS group_id FROM `zyrv_forums`.ibf_members AS u INNER JOIN `zyrv_forums`.ibf_groups AS g ON u.mgroup=g.g_id WHERE u.id='2'" on 0

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 avatar_url, u. AS notify, u. AS auto_subscribe_post, u. AS auto_subscribe_com' at line 1


Any help would be much appreciated, first I run the bridgemanager program, and as soon as I go to the gallery home, I get the error above notified by a Fatal error :

Thanks in Advance,

Samuel Freeman
Title: Re: CM 1.4 to IPB 2.1.7 Problems
Post by: Joachim Müller on November 14, 2006, 08:13:32 AM
You're running cpg1.4.5 - upgrade! Most recent version is cpg1.4.10, so you're lagging 5 versions behind.
Title: Re: CM 1.4 to IPB 2.1.7 Problems
Post by: Dr Preacox on November 14, 2006, 09:48:57 AM
Yeah I just upgraded, and came back to delete my post, since its all working now,

Sorry for wasting your time GauGau, btw you been well?
Title: Re: CM 1.4 to IPB 2.1.7 Problems
Post by: Joachim Müller on November 14, 2006, 09:51:07 AM
Thanks for returning and posting the solution (yes, upgrading is a solution for many issues ;)). I'm fine, thanks ;D.

Joachim