PDA

View Full Version : Solved error with vbry usergroup query



ctrenks
11-06-14, 02:58
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
11-06-14, 08:59
Please, you update the vB and vBET to the latest version.

ctrenks
16-06-14, 23:28
So somthing just broke on its own and an update will fix? sounds not normal

Marcin Kalak
17-06-14, 10:01
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
20-06-14, 02:34
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
20-06-14, 07:59
I would ask you to confirm if issue will be resolved.

ctrenks
20-06-14, 14:07
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
20-06-14, 14:07
there is an extra ' in the query

Marcin Kalak
21-06-14, 09:25
Please send me a PM access details to Admin CP and FTP. I will check what is going on there :)

ctrenks
23-06-14, 15:00
I will setup accounts this week,, thanks

Marcin Kalak
01-07-14, 16:12
Currently, I did not get from you PM with access data.

ctrenks
05-07-14, 18:23
Sorry out of town, this will have to wait until the 18th,,,, just letting you know im still here!

Marcin Kalak
07-07-14, 11:33
OK. I wanted to remind you, but you not need to hurry up.

Marcin Kalak
17-10-14, 08:25
No response - considered the issue is gone. If not please write here.

AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Languages translations made by vBET 4.10.1