Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > vbBux / vbPlaza
FIXED MySQL Error : Unknown column 'ebank' in 'field list' Details »»
FIXED MySQL Error : Unknown column 'ebank' in 'field list'
Version: , by kellyandmike kellyandmike is offline
Developer Last Online: Sep 2007 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 04-18-2006 Last Update: Never Installs: 0
 
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 04-18-2006, 02:16 PM
amykhar's Avatar
amykhar amykhar is offline
 
Join Date: Oct 2001
Location: PA
Posts: 4,438
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's related to the vbbux mod. You should probably seek help in the premium forum for that mod. I'll move this there.
Reply With Quote
  #3  
Old 04-18-2006, 05:22 PM
CMX_CMGSCCC CMX_CMGSCCC is offline
 
Join Date: Sep 2003
Posts: 1,218
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #4  
Old 04-19-2006, 12:15 AM
kellyandmike's Avatar
kellyandmike kellyandmike is offline
 
Join Date: Mar 2006
Posts: 116
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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/admin...p?do=edit&u=57
IP Address : 65.83.203.188
Username : Psalm23
Classname : vb_database
Reply With Quote
  #5  
Old 04-19-2006, 12:54 AM
CMX_CMGSCCC CMX_CMGSCCC is offline
 
Join Date: Sep 2003
Posts: 1,218
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #6  
Old 04-19-2006, 01:16 AM
kellyandmike's Avatar
kellyandmike kellyandmike is offline
 
Join Date: Mar 2006
Posts: 116
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah, there is only bitfield_itrader, bitfield_vbbuxplaza, bitfield_vbulletin
Reply With Quote
  #7  
Old 04-21-2006, 01:59 AM
kellyandmike's Avatar
kellyandmike kellyandmike is offline
 
Join Date: Mar 2006
Posts: 116
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can anyone help me pretty please???
Reply With Quote
  #8  
Old 04-24-2006, 12:24 PM
kellyandmike's Avatar
kellyandmike kellyandmike is offline
 
Join Date: Mar 2006
Posts: 116
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #9  
Old 04-30-2006, 07:07 PM
CMX_CMGSCCC CMX_CMGSCCC is offline
 
Join Date: Sep 2003
Posts: 1,218
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:24 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06984 seconds
  • Memory Usage 2,277KB
  • Queries Executed 22 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (8)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete