Status
Not open for further replies.

undertable99

Customer
Hi there,

I have install superpm into my 4.2 vb site and after looks fine but when i do my moderating posts work in my ACP it gave me this error.

Database error in vBulletin 4.2.0:

Invalid SQL:

UPDATE vb4user
SET posts = posts +
CASE
WHEN userid IN (0,) THEN 1

ELSE 0
END
WHERE userid IN (0,);

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 ') THEN 1

ELSE 0
END
WHERE userid IN (0,)' at line 4
Error Number : 1064
Request Date : Sunday, October 13th 2013 @ 03:25:44 PM
Error Date : Sunday, October 13th 2013 @ 03:25:44 PM
Script : http://website.com/modcp/moderate.php?do=doposts
Referrer : http://website.com
IP Address : 183.90.103.155
Username : *******
Classname : vB_Database
MySQL Version : 5.1.56-log

When i disable it everything turn normal. Error happens in the script modcp and i have .htaccess password protected for my admincp and modcp.

PS: i tried disabled all other mods except for "superpm", still the same error.
 
Can you disable the plugins for the mod one by one till you find out which one is causing the issue? As I am unable to replicate this.
 
I don't get this part if u mean the plugins of the mods. Where do I disable them one by one. Pardon me for the lack of knowledge. Please guide
 
ACP --> Plugins & Products --> Plugin Manager, find the ones in the group, Product : DragonByte Tech: Super PM's untick them one by one, saving each time, untill you don't get the error.

Then let me know which one it was.
 
ACP --> Plugins & Products --> Plugin Manager, find the ones in the group, Product : DragonByte Tech: Super PM's untick them one by one, saving each time, untill you don't get the error.

Then let me know which one it was.



Ozzy this is the plugin that causes error:

Title: Pm reply to all str replace
Hook location: template_render_output

After setting it inactive everything resumed normal, i can moderate posts without error.
 
O, I made a change to that file yesterday, re-download and upload dbtech/vbsuper_pm/hooks/reply_all/template_render_output, and see if the issue goes away.
 
O, I made a change to that file yesterday, re-download and upload dbtech/vbsuper_pm/hooks/reply_all/template_render_output, and see if the issue goes away.

Thank you much Ozzy,

Yes it have been resolved, I downloaded the new file and uploaded it. It works fine now. Appreciate your fast respond and if this mod is doing fine i will be definitely buying the pro version. Its good to know that vbulletin have such good and responsible coders.
 
Thanks for the kind words. Good to know the issue was resolved, looks like I killed two birds with one stone with that file. :)
 
Status
Not open for further replies.

Legacy vBSuper PM's

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