PDA

View Full Version : Database error


erinys
06-17-2006, 05:45 PM
Hi guys!

i just got this mail with an error in VBplaza, anyone know what have gone wrong?
========================================
Database error in vBulletin 3.5.4:

Invalid SQL:

UPDATE user
SET
`vbbux` = `vbbux` + , vbp_history = 'a:1:{i:0;a:6:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:0:\"\";s:8:\"dateline\";i:1150568563;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:2:\"85\";s:12:\"fromusername\";s:5:\"Lieke\";}}'
WHERE userid = '85';

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 ' vbp_history = 'a:1:{i:0;a:6:{s:6:\"itemid\";s:1:\"7\";s:9:\"fi
Error Number : 1064
Date : Saturday, June 17th 2006 @ 08:22:44 PM
Script : http://www..nl/community/vbplaza.php
Referrer : http://www..nl/community/vbplaza.php?do=donate&userid=85
IP Address : 80.126.93.35
Username : Lieke
Classname : vb_database

erinys
06-20-2006, 08:08 AM
is there even support for this forum/addon? my last 3 questions were completely unanswered

CMX_CMGSCCC
06-20-2006, 08:37 PM
If u would have read the stickies, u would know y there were no replies for a while. As u can see, I'm back in action now from the business trip and I've responded to damn near 5 pages of threads in a few hours here!

That bug u r experiencing was fixed a long time ago, reupload all of the files in the UPLOAD folder for v1.5.6, make sure the files are OVERWRITING while they upload.

-CMX

erinys
06-21-2006, 04:37 AM
thanks, completely missed that you were on a holiday :)

CMX_CMGSCCC
06-28-2006, 01:22 PM
Did u try to reupload all of the files and make sure they are overwriting, because this issue u have described was fixed a long time ago I think.

-CMX

erinys
06-28-2006, 01:28 PM
Well the only version i ever installed, was the one just before this one, cause i just recently started with this addon.

This was the only time i have ever seen this error though, and right after your previous post i did upgrade to the latest version (i missed 1 update so i was running not the last, but the version before it)

Since then i never seen it anymore, but i only saw it once total anyway, and like i said, my previous install is also very new ;) so it depends on what a "long time ago" is ;)

thanks!

update: @ the time of the error i was running 1.5.5 fresh install
and now im running 1.5.6

CMX_CMGSCCC
06-28-2006, 02:20 PM
The issue was when someone tried to donate points, if they didnt enter a proper number for the amount of points to donate, it would generate that error.

That's y I was confused as I thought this issue had been fixed :)

Glad to hear that it is still FIXED :)

Thanx for the update on the thread and for supporting vbPlaza!

-CMX