Hello,
I have recently switched from vBSEO to DragonByte's Pro SEO.
The forum is getting a database error via an advanced search. Pages 1-15 were fine, but a database error occurred on pages 16+.
Error message:
The error database was not noticed prior to DBSEO being installed.
Any advice is appreciated.
Thank you.
I have recently switched from vBSEO to DragonByte's Pro SEO.
The forum is getting a database error via an advanced search. Pages 1-15 were fine, but a database error occurred on pages 16+.
Error message:
Invalid SQL:
SELECT post.*,userfield.*, usertextfield.*, user.*, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar,
customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height,
customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb
FROM post AS post
LEFT JOIN user AS user ON (user.userid = post.userid) LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN usertextfield AS usertextfield ON (user.userid = usertextfield.userid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = post.userid)
WHERE post.postid IN (.);
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 ')' at line 10
Error Number : 1064
The error database was not noticed prior to DBSEO being installed.
Any advice is appreciated.
Thank you.