error with vbry usergroup query

[ctrenks]

SELECT usergroupid FROM vb_usergroup WHERE description='vbet_-1'';

I get this message about once a day now. Nothing has changed in over a year. (I know I should upgrade)

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT usergroupid FROM vb_usergroup WHERE description='vbet_-1'';

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 ''vbet_-1''' at line 1
Error Number  : 1064
Request Date  : Tuesday, June 10th 2014 @ 08:15:16 PM
Error Date    : Tuesday, June 10th 2014 @ 08:15:16 PM
Script        : http://www.allfreechips.com/phpBB2/register.php
Referrer      : 
IP Address    : 116.98.37.252
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

[Marcin Kalak]

Please, you update the vB and vBET to the latest version.

[ctrenks]

So somthing just broke on its own and an update will fix? sounds not normal

[Marcin Kalak]

It may be, for example, old issue fixed in the next versions of vB or vBET. I suggest you update your vB and vBET.

[ctrenks]

just upgraded to vbulletin 4.2.2

Will look into upgrading vbet tomorrow, but i need to re-pay again, funny how each time i need to upgrade its another year fee lol

[Marcin Kalak]

I would ask you to confirm if issue will be resolved.

[ctrenks]

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT usergroupid FROM vb_usergroup WHERE description='vbet_-1'';

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 ''vbet_-1''' at line 1
Error Number : 1064
Request Date : Friday, June 20th 2014 @ 07:46:56 AM
Error Date : Friday, June 20th 2014 @ 07:46:56 AM


Upgraded both to latest versions...

[ctrenks]

there is an extra ' in the query

[Marcin Kalak]

Please send me a PM access details to Admin CP and FTP. I will check what is going on there

[ctrenks]

I will setup accounts this week,, thanks