Bug Database error via advanced search

[BASPUD]

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:

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.

 

[Fillip H.]

I'm unable to replicate this issue. Could you please try disabling all other modifications and let me know if this works for you?

DBSEO does not hook into the search process at all.