forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 bridging => Topic started by: SRTst on January 03, 2006, 04:20:02 am

Title: Clicking on 'USERS' or Memberlist creates Critical errorS
Post by: SRTst on January 03, 2006, 04:20:02 am

I did the integration and all worked fine, but if I click on 'Users' while in Admin mode, or if a user clicks on Memberlist I get this error

"Critical error

There was an error while processing a database query.

While executing query "SELECT count(*) FROM `ontar2_phpb1`.phpbb_users WHERE 1" on 0

mySQL error:

File: /home/ontar2/public_html/Gallery/include/functions.inc.php - Line: 248"

phpBB 2.018
Coppermine 1.4.2
Debug mode enabled for all
Forum = http://www.ontariosrtclub.com/forum
Coppermine = http://www.ontariosrtclub.com/Gallery
Username: Test_Pilot
Pass: test

Bridge Wizard:

Forum URL:  http://www.ontariosrtclub.com/forum 
Relative path to your BBS's config file:  ../forum/ 
Use post-based groups?:  0 
Cookie prefix:  phpbb2mysql 


Any help would be greatly appreciated!

Thank you
Neven

Title: Re: Clicking on 'USERS' or Memberlist creates Critical error
Post by: SRTst on January 03, 2006, 04:38:18 am

I came accross another problem but I'm guessing it's the same issue thats causing both problems

When a User creates an Album it also creates

"User galleries"

It shows there is 1 Album in there but when you click on "User galleries" link you get the following error:

"While executing query "SELECT user_id as user_id,username as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg_albums AS a INNER JOIN `ontar2_phpb1`.phpbb_users as u on u.user_id+10000=a.category LEFT JOIN cpg_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY category ORDER BY category LIMIT 0, 60 " on 0

mySQL error:

File: /home/ontar2/public_html/Gallery/include/functions.inc.php - Line: 248 "

Title: Re: Clicking on 'USERS' or Memberlist creates Critical errorS
Post by: Joachim Müller on January 03, 2006, 07:38:05 am

upgrade to cpg1.4.3

Title: Re: Clicking on 'USERS' or Memberlist creates Critical errorS
Post by: SRTst on January 03, 2006, 08:48:42 am

Upgraded, seems to be working fine now. I chose to install it thru Fantastico from my Control Panel, and 1.4.3 wasn't avaliable. Thats what I get for going about it the faster way :)

Thanks

Title: Re: Clicking on 'USERS' or Memberlist creates Critical errorS
Post by: Joachim Müller on January 03, 2006, 09:06:51 am

we don't recommend fantastico, it is known to have additional bugs. Always use the original, available from our site only.