Bug SQL Query Bug

[designguy]

Received this message just yesterday from the board system. Seems to be a bug in the SQL generated by the thanks script. Note that I have blanked out the referrer URL since it is in a private forum and won't be viewable to guests or members without specific permissions.

Running vBulletin version 4.2.5, and the most recent Thanks product version 3.6.3. Being on version 4.2.5 means we have to be using MySQLi so perhaps not all of the queries generated by this product are compatible.

------------------------------------------
Database error in vBulletin 4.2.5:

Invalid SQL:

SELECT user.* FROM vb3_user as user WHERE user.userid =;

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 1
Error Number : 1064
Request Date : Sunday, May 6th 2018 @ 06:10:49 PM
Error Date : Sunday, May 6th 2018 @ 06:10:50 PM
Script : http://www.fitnessgeared.com/thanks.php
Referrer : <BLANKED>
IP Address : 82.102.16.227
Username : kvasir
Classname : vB_Database_MySQLi
MySQL Version :
Server : 69.73.134.122
User Agent :


Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 475
#2 vB_Database->query_read_slave() called in [path]/mobiquo/push_hook.php on line 525
#3 tapatalk_dbtech_like_or_thank() called in [path]/dbtech/thanks/contenttypes/post/save.php(246) : eval()'d code on line 12
#4 eval() called in [path]/dbtech/thanks/contenttypes/post/save.php on line 246
#5 require([path]/dbtech/thanks/contenttypes/post/save.php) called in [path]/dbtech/thanks/actions/ajax.php on line 39
#6 include_once([path]/dbtech/thanks/actions/ajax.php) called in [path]/thanks.php on line 143
#7 require([path]/thanks.php) called in [path]/dbseo.php on line 539

 

[Fillip H.]

That is not a bug in our mod, as you can see by the stack trace the problem is Tapatalk. You will unfortunately need to contact them for assistance.

 

[designguy]

Okay, thanks for your assistance. Looked like it was from the thanks module, but I see where you've indicated. Wish they were as responsive as you guys.

 

[DragonByte Technologies]

Hello @designguy,

We hope your ticket regarding Advanced Post Thanks / Like has been addressed to your satisfaction. This ticket has now been closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.