Bug Data Base error

[max1982]

after upgrading the vbmail i got this error:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT userid, username, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM user AS user
WHERE userid IN (0Array);

MySQL Error : Unknown column '0Array' in 'where clause'
Error Number : 1054
Request Date : Thursday, April 4th 2013 @ 04:29:17 AM
Error Date : Thursday, April 4th 2013 @ 04:29:18 AM
Script : http://www.*******.com/vbmail.php
Referrer : http://www.********.com/forum.php
IP Address : ***.***.***
Username : *****

Not sure if you guys can help me.

I have placed ** on some of the info in the error sorry.

Regards
Wafic

 

[Fillip H.]

Try re-downloading and re-uploading /dbtech/vbmail/actions/mailinglists.php - that should fix it

 

[max1982]

still the same after deleting mailinglists.php and uploading it again.


Edit:
had to delete all the vbmail and upload it now its working
Thanks for the help Fillip H.

Regards
Wafic

 

[Fillip H.]

There was another hotfix to that file to fix an issue with email sending, perform the same procedure again to get the fix

 

[european]

hello,

i have self databaseerror:

Databaseerror in vBulletin 4.2.1:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_dbtech_vbmail AS phrasegroup_dbtech_vbmail,
phrasegroup_user AS phrasegroup_user,
phrasegroup_album AS phrasegroup_album,
phrasegroup_posting AS phrasegroup_posting,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM vbblanguage
WHERE languageid = 1;

MySQL-Fehler : Unknown column 'phrasegroup_dbtech_vbmail' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Thursday, 03.10.2013 @ 00:31:13
Datum : Thursday, 03.10.2013 @ 00:31:13
Skript : http://www.xy.com/forum/vbmail.php
Referrer :
IP-Adresse : xx.xxx.xxx.xx.
Benutzername :
Klassenname : vB_Database
MySQL-Version :

the vbmailversion is the last what can downloading.

can you help?

 

[Ozzy47]

hello,

i have self databaseerror:

Databaseerror in vBulletin 4.2.1:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_dbtech_vbmail AS phrasegroup_dbtech_vbmail,
phrasegroup_user AS phrasegroup_user,
phrasegroup_album AS phrasegroup_album,
phrasegroup_posting AS phrasegroup_posting,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM vbblanguage
WHERE languageid = 1;

MySQL-Fehler : Unknown column 'phrasegroup_dbtech_vbmail' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Thursday, 03.10.2013 @ 00:31:13
Datum : Thursday, 03.10.2013 @ 00:31:13
Skript : http://www.xy.com/forum/vbmail.php
Referrer :
IP-Adresse : xx.xxx.xxx.xx.
Benutzername :
Klassenname : vB_Database
MySQL-Version :

the vbmailversion is the last what can downloading.

can you help?

You should start your own thread so the dev gets a notice about the issue, he will not get a notice by you posting here, as this issue was solved. Your error is different that the original posters.