Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > Advanced Warning System (AWS)
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
URGENT - NEED HELP Database Error Details »»
URGENT - NEED HELP Database Error
Version: , by Mattlab Mattlab is offline
Developer Last Online: Jul 2016 Show Printable Version Email this Page

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

Quote:
Database error in vBulletin 3.6.0:

Invalid SQL:
INSERT INTO user
(salt, passworddate, password, options, adminoptions, usertitle, customtitle, username, email, languageid, homepage, birthday_search, birthday, showbirthday, icq, aim, yahoo, msn, skype, parentemail, referrerid, ipaddress, posts, usergroupid, reputationlevelid, reputation, warnings, infractions, ipoints, pmpopup, autosubscribe, threadedmode, showvbcode, styleid, timezoneoffset, daysprune, joindate, lastactivity, lastpost, membergroupids, displaygroupid, lastvisit, maxposts, startofweek)
VALUES
('$vp', FROM_UNIXTIME(1156436967), '5c42177bd427539187839e4fe9b16b5e', 7255, 0, 'Registered User', 0, 'testuser123121', '', 0, '', '', '', 0, '', '', '', '', '', '', 0, '', 0, 2, 5, 10, 0, 0, 0, 1, 2, 0, 2, 0, '0', -1, 1156436940, 1156436940, -1, '', '', 1156436967, -1, -1);

MySQL Error : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date : Thursday, August 24th 2006 @ 12:29:28 PM
Script :
Referrer :
IP Address :
Username :
Classname :
How do I fix this? I got it only after removing the hack for VB 3.6

Thanks,
Mattlab

Show Your Support

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

Comments
  #2  
Old 08-24-2006, 03:35 PM
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Location: Google Kansas
Posts: 4,678
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

try adding the plugin and removing it again
Reply With Quote
  #3  
Old 08-24-2006, 07:39 PM
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Location: Landen(Belgium)
Posts: 1,335
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Mattlab
How do I fix this? I got it only after removing the hack for VB 3.6

Thanks,
Mattlab
Code:
ALTER TABLE user ADD COLUMN warnings INT UNSIGNED NOT NULL DEFAULT '0';
you removed the 3.5.x version of this hack which will delete the warnings field the 3.6.x infraction system uses run the query and you should be ok
Reply With Quote
  #4  
Old 10-19-2006, 12:43 PM
turkforum turkforum is offline
 
Join Date: Oct 2004
Posts: 88
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Delphiprogrammi
Code:
ALTER TABLE user ADD COLUMN warnings INT UNSIGNED NOT NULL DEFAULT '0';
Thanks for the advice
This solved my problem I had the same problem when i uninstall Aws from the manage products section.
Reply With Quote
Reply


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 04:06 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07750 seconds
  • Memory Usage 2,231KB
  • Queries Executed 19 (?)
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
  • (2)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (3)postbit
  • (4)postbit_onlinestatus
  • (4)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_postinfo_query
  • fetch_postinfo
  • 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