Bug vB Database Error

[Ozzy47]

I am still getting these errors, I think it has to due when you have Default Subscribed ticked and someone registers on the site.

Database error in vBulletin 4.1.3:

Invalid SQL:

INSERT IGNORE INTO user
(userid, mailinglistid, subscribed)
VALUES (
2668, 1, '1'
);

MySQL Error : Unknown column 'mailinglistid' in 'field list'
Error Number : 1054
Request Date : Friday, June 24th 2011 @ 11:03:55 PM
Error Date : Friday, June 24th 2011 @ 11:03:55 PM
Script : http://myfriendsspace.com/register.php?do=addmember
Referrer : http://myfriendsspace.com/register.php?
IP Address : **.***.**.***
Username : sposobbrosit
Classname : vB_Database
MySQL Version :

 

[Fillip H.]

Hotfix uploaded, and fixed on yours / @Trekkan / @Taurus sites, bugfixing at 3am is not a good idea it seems

 

[Ozzy47]

Ah ok cool deal, you are the best.

On a side note this forum notifications don't show in shout on New Thread/New Post yet.

 

[Fillip H.]

I knew I forgot something.

 

[dihuta]

Just installed last 5 minutes and have a similar Database error.
It's so bad to see the error on first action.

Database error in vBulletin 4.1.4:

Invalid SQL:

INSERT IGNORE INTO dbtech_vbmail_subscription
(userid, mailinglistid)
SELECT userid, 2 AS mailinglistid
FROM user
WHERE (
FIND_IN_SET(20, membergroupids)
OR usergroupid IN(20)
)
AND dbtech_vbmail_bounceflag = '0';

MySQL Error : Unknown column 'dbtech_vbmail_bounceflag' in 'where clause'

 

[Cosmic]

Just installed last 5 minutes and have a similar Database error.
It's so bad to see the error on first action.

When did you download the file? if it was more than a few hours ago, redownload then upload as the error you are reporting was hotfixed =)

Please bear in mind this is a beta. If you think it is bad to have errors I recommend you uninstall it until gold is available =)

Cosmic

 

[Ozzy47]

I would do as Cosmic said, and if that don't work report back.

I think that error is a little different than mine was, mine was related to when a user signed up to the forum, and i had auto subscribe ticked, his error seems to be when you get a bounced email.

My error: MySQL Error : Unknown column 'mailinglistid' in 'field list'

His error: MySQL Error : Unknown column 'dbtech_vbmail_bounceflag' in 'where clause'

Do you know what action you did to have that error?

 

[Fillip H.]

Possible hotfix uploaded, please report back with your MySQL version as well.

If it's less than 5.0 then please upgrade to 5.0.x, as 4.1 has been End Of Life (no longer supported by MySQL) for several years now.

 

[dihuta]

Mysql 5.5
Action: Adding new mailing-list.
I check the table and didn't see the field 'dbtech_vbmail_bounceflag'.

 

[Fillip H.]

Did you try re-downloading the files after I posted my post?

 

[dihuta]

Did you try re-downloading the files after I posted my post?

Don't know why, but I can not re-import (overwrite) VBMail. It's always time out.

 

[Fillip H.]

You don't need to reimport, just re-upload

 

[dihuta]

Re-uploaded
Same error when adding new mailing-list

nvalid SQL:

INSERT IGNORE INTO dbtech_vbmail_subscription
(userid, mailinglistid)
SELECT userid, 3 AS mailinglistid
FROM user AS user
WHERE (
FIND_IN_SET(20, membergroupids)
OR usergroupid IN(20)
)
AND user.dbtech_vbmail_bounceflag = '0';

MySQL Error : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'
Error Number : 1054

 

[Fillip H.]

I'll look into it further then and post back when it's solved.

 

[Fillip H.]

I've added another potential hotfix, please try re-downloading and re-uploading the files (XML is not needed).

I can't test it on MySQL 5.5 myself because I need 5.0 and 5.1 on my dev board and this board respectively as those are the most widespread versions available currently.

 

[dihuta]

Re-Uploaded, nothing changes.
I can not see the field: dbtech_vbmail_bounceflag on on user table?
If it isn't exist, how can you use it?

 

[Fillip H.]

You don't see it in the user table?

Re-install the mod, then.

 

[dihuta]

Large user table. Alter it take my site down 30 minutes.
I will do this on today mid night.

 

[Mokonzi]

I reinstalled the product and the initial error has gone, and I'm not getting dihuta's error at all.