Bug Database Error after install

Status
Not open for further replies.

KenDude

Customer
Upon install of the Lite version and importing the XML when I click the Gallery tab I get the following database SQL error:

Database error in vBulletin 4.2.2:

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 = 3)
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 MariaDB 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 @ 09:24:15 PM
Error Date : Friday, September 18th 2015 @ 09:24:16 PM
Script : Planet-9
Referrer :
IP Address : x.x.x.x. <- changed for security reasons
Username : K-Man S
Classname : vB_Database_MySQLi
MySQL Version : 5.5.45-MariaDB-1~precise
 
Hello KenDude,

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!
 
Status
Not open for further replies.

Legacy DragonByte Gallery

vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
865
Customer rating
0.00 star(s) 0 ratings
Back
Top