FIXED MySQL Error : Unknown column 'ebank' in 'field list'

[kellyandmike]

Here is what I get when I try to add a new user. This just happened. We had not changed anything.

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO user
(salt, passworddate, password, options, usertitle, customtitle, username, email, languageid, homepage, birthday_search, birthday, showbirthday, icq, aim, yahoo, msn, skype, parentemail, posts, referrerid, ipaddress, usergroupid, reputationlevelid, reputation, pmpopup, autosubscribe, threadedmode, showvbcode, styleid, timezoneoffset, daysprune, joindate, lastactivity, lastpost, membergroupids, vbp_receivespoints, vbp_storeaccess, vbbux, ebank, vbp_nextbankinterest, vbp_genericperm, vbp_modperm, vbp_adminperm, vbp_nametextcolor, vbp_nameglowcolor, vbp_nameshadowcolor, vbp_titletextcolor, vbp_changealwaysitems, displaygroupid, lastvisit, maxposts, startofweek)
VALUES
('#gu', FROM_UNIXTIME(1145370408), '8375a5c697b1e10f444f5b95829c868c', 40007, 'Junior Member', 0, 'susanktz', 'susanktz@yahoo.com', 0, '', '', '', 0, '', '', '', '', '', '', 0, 0, '', 2, 5, 10, 0, -1, 0, 1, 0, '0', -1, 1145370360, 1145370360, -10801, '', 1, 1, 100, 0, 0, 0, 0, 0, '', '', '', '', '', '', 1145370408, -1, -1);

MySQL Error : Unknown column 'ebank' in 'field list'
Error Number : 1054
Date : Tuesday, April 18th 2006 @ 07:26:48 AM
Script : http://couponchix.com/feedback/admincp/user.php
Referrer : http://couponchix.com/feedback/admincp/user.php?do=add
IP Address : 68.154.45.154
Username : Psalm23
Classname : vb_database

[amykhar]

It's related to the vbbux mod. You should probably seek help in the premium forum for that mod. I'll move this there.

[CMX_CMGSCCC]

U must still have some ebux/estore files on ur server, please delete all ebux/estore/elottery files from your server via FTP and then Rebuild your Bitfields using Admin CP -> vbPlaza Maintenance -> Rebuild Bitfields.

-CMX

[kellyandmike]

I can't seem to find the files you are talking about. Where (directory) should I be looking??


It is now all over anytime I try and change users or add...

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE user SET
### Bitfield: user.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 16, options - 16, options),
options = IF(options & 256, options - 256, options),
options = IF(options & 512, options - 512, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 4, options, options + 4),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options - 128, options),
options = IF(options & 32768, options, options + 32768),
usertitle = 'Junior Member',
customtitle = 0,
username = 'Karin12482',
email = '',
languageid = 0,
homepage = '',
birthday_search = '1979-01-02',
birthday = '01-02-1979',
showbirthday = 1,
icq = '',
aim = '',
yahoo = 'bluesteyesinNY',
msn = '',
skype = '',
parentemail = '',
posts = 10,
referrerid = 0,
ipaddress = '',
usergroupid = 2,
reputationlevelid = 5,
reputation = 10,
pmpopup = 0,
autosubscribe = -1,
threadedmode = 0,
showvbcode = 1,
styleid = 0,
timezoneoffset = '0',
daysprune = -1,
joindate = 1144606200,
lastactivity = 1145397540,
lastpost = 1145306940,
membergroupids = '',
vbp_receivespoints = 1,
vbp_storeaccess = 1,
vbbux = 650.39,
ebank = 0,
vbp_nextbankinterest = 0,
vbp_genericperm = 0,
vbp_modperm = 0,
vbp_adminperm = 0,
vbp_nametextcolor = '',
vbp_nameglowcolor = '',
vbp_nameshadowcolor = '',
vbp_titletextcolor = '',
vbp_changealwaysitems = '',
### Bitfield: user.vbp_displayflags ###
vbp_displayflags = IF(vbp_displayflags & 1, vbp_displayflags - 1, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 2, vbp_displayflags - 2, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 4, vbp_displayflags - 4, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 8, vbp_displayflags - 8, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 16, vbp_displayflags - 16, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 32, vbp_displayflags - 32, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 64, vbp_displayflags - 64, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 128, vbp_displayflags - 128, vbp_displayflags),
### Bitfield: user.vbp_otherflags ###
vbp_otherflags = IF(vbp_otherflags & 1, vbp_otherflags - 1, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 2, vbp_otherflags - 2, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 4, vbp_otherflags - 4, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 8, vbp_otherflags - 8, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 16, vbp_otherflags - 16, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 32, vbp_otherflags - 32, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 64, vbp_otherflags - 64, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 256, vbp_otherflags - 256, vbp_otherflags),
### Bitfield: user.vbp_immunity ###
vbp_immunity = IF(vbp_immunity & 1, vbp_immunity - 1, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 2, vbp_immunity - 2, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 4, vbp_immunity - 4, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 8, vbp_immunity - 8, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 16, vbp_immunity - 16, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 32, vbp_immunity - 32, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 64, vbp_immunity - 64, vbp_immunity)
WHERE userid = 57;

MySQL Error : Unknown column 'ebank' in 'field list'
Error Number : 1054
Date : Tuesday, April 18th 2006 @ 06:07:51 PM
Script : http://couponchix.com/feedback/admincp/user.php
Referrer : http://couponchix.com/feedback/admincp/user.php?do=edit&u=57
IP Address : 65.83.203.188
Username : Psalm23
Classname : vb_database

[CMX_CMGSCCC]

Look inside ur forums root folder, /admincp and /includes/xml/ any files that have ebux or estore in them, delete it.. most likely the file is named... /includes/xml/bitfield_ebuxestore.xml I'm going to guess.

-CMX

[kellyandmike]

Yeah, there is only bitfield_itrader, bitfield_vbbuxplaza, bitfield_vbulletin

[kellyandmike]

Can anyone help me pretty please???

[kellyandmike]

Can someone help me? I cannot admin any users and am totally lost. I have searched for the file and it is NOT on my ftp.

www.couponchix.com/feedback is my board.

Nevermind. It was one simple setting in my vbplaza. I changed "ebank" to vbbux and haven't gotten an error since.

[CMX_CMGSCCC]

Edit your vbBux Settings from Admin CP -> vbBux -> Manage Settings -> What does it say for Bank Field Name? It should say vbbank

If it doesnt, change it to vbbank and the problem should be fixed.

-CMX