Bug Error Number : 1064

[Globus]

After upgrade to pl2 getting this:

Database error in vBulletin 4.2.3:

Invalid SQL:

					SELECT
						gi.*,
						gc.catname,
						u.username,
						ga.hidden,
						ga.title as albumname
					FROM dbtech_gallery_images AS gi
					LEFT JOIN dbtech_gallery_categories AS gc ON(gc.catid = gi.catid)
					LEFT JOIN dbtech_gallery_albums AS ga ON(ga.albumid = gi.albumid)
					LEFT JOIN user AS u ON(u.userid = gi.userid)
					WHERE (gi.albumid = 0 OR (ga.hidden = 0 AND ga.password = '') OR ga.userid = 1)
						AND gi.instanceid = 1
						AND gi.approved = 1
						AND gi.catid IN ()
						AND gi.deleted = 0
					ORDER BY gi.imageid DESC
					LIMIT 0, 14;

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 ')
						AND gi.deleted = 0
					ORDER BY gi.imageid DESC
					LIMIT 0, 14' at line 14
Error Number  : 1064
Request Date  : Friday, September 18th 2015 @ 11:39:29 AM
Error Date    : Friday, September 18th 2015 @ 11:39:29 AM
Script        : http://www.easteuropeanshepherd.com/gallery.php?gal=gallery
Referrer      : http://www.easteuropeanshepherd.com/activity.php
IP Address    : 58.7.177.170
Username      : Alex
Classname     : vB_Database_MySQLi
MySQL Version : 5.6.23

Please help.
Alex

 

[Globus]

Had to downgrade to 1.3.2 to get it running again. Yah...

 

[Fillip H.]

Can you please provide more information as to what you were doing when you received this error message?

 

[Globus]

Can you please provide more information as to what you were doing when you received this error message?

Came up after upgrading to pl2. As much as i can tell.

 

[Fillip H.]

Nothing you can tell me about which page you were viewing or anything? Are you able to reproduce this issue or is it something that you only receive in your technicalemail email address?

 

[Globus]

Nothing you can tell me about which page you were viewing or anything? Are you able to reproduce this issue or is it something that you only receive in your technicalemail email address?

The error is actually comes up when you click on the Gallery link navigation bar. Being trying to reinstall and re-upload, all the basics. Same results, had to downgrade to 1.3.2 to get the Gallery running again.

 

[Fillip H.]

I've added a hotfix to v1.3.2 PL3 that should resolve this

 

[Fillip H.]

Hello Globus,

This ticket has now been closed with the status Fixed.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!