PDA

View Full Version : Solved database error with who's online



avinashiitd
17-07-11, 04:03
I am getting this when trying to use who's online feature in VB 4.1.4


Database error in vBulletin 4.1.4:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.vbet_def_lang AS vbet_def_lang
FROM session as session

WHERE session.lastactivity > 1310867974



GROUP BY isuser;

MySQL Error : Unknown column 'user.vbet_def_lang' in 'field list'
Error Number : 1054
Request Date : Sunday, July 17th 2011 @ 08:29:34 AM
Error Date : Sunday, July 17th 2011 @ 08:29:34 AM
Script :*/online.php
Referrer : */forum.php
IP Address : 122.177.110.35
Username : Avinash
Classname : vB_Database
MySQL Version : 5.0.92-community

can anyone help?

avinashiitd
17-07-11, 04:09
Looks like I found the solution / workaround from a similar thread.
vbenterprisetranslator.com/forum/vbet4-bug-reporting/1952-vbet-error-online-users-vb-4-1-4-a-2.html#post8985

you may close the thread.

vBET
18-07-11, 12:19
Yes - we know it is open issue, but this is officially vBulletin bug. We are waiting they will solve it. Great you already found the thread about it. Closing this one :)

AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Translations by vB Enterprise Translator 4.10.1