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
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