Log in

View Full Version : Stars hack error


smokey
06-19-2001, 11:03 AM
tubdogg, in you hack, when someone posts at a board that i have the counting of the posts disabled, it gives a db error. this is the error i get in the mail:


Database error in vBulletin: Invalid SQL: UPDATE user SET

lastpost='992903127', WHERE userid='1'
mysql error: You have an error in your SQL syntax near 'WHERE userid='1'' at line 3
mysql error number: 1064
Date: Monday 18th of June 2001 06:25:27 PM
Script: /newreply.php
Referer: http://www.c2kforums.net/newreply.php?s=&action=newreply&threadid=448


other then that, the hack works great! can u help me correct this error? i dont want it to count posts in this certain forum. thanks!

tubedogg
06-19-2001, 11:06 AM
Well this isn't the right forum for this - you should have posted it in the stars thread. But it looks like you are not using v0.2.0 of my hack - the latest version of the hack specifically takes this situation into account by removing the "," by default that was previously in there.

smokey
06-19-2001, 11:38 AM
well it wouldn't let me post in the bug repots forum and i thought the stars thread was closed. sorry...

i fixed this error and updated all the scripts. Should i run the mysql.php thats in the zip or just leave it as is? everything seems to be working fine now. thanks

tubedogg
06-19-2001, 11:44 AM
No don't run mysql.php. You'll get an error anyway but don't bother. :)

The v0.1.0 thread is closed but the v0.2.0 thread is alive and well. :)

smokey
06-19-2001, 12:11 PM
yeah, i saw that while getting the updated code. ok, i wont re-run the mysql.php. thanks. :)