vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/forumdisplay.php?f=105)
-   -   URGENT - NEED HELP Database Error (https://vborg.vbsupport.ru/showthread.php?t=124804)

Mattlab 08-24-2006 03:32 PM
URGENT - NEED HELP Database Error
 
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

Brandon Sheley 08-24-2006 03:35 PM
try adding the plugin and removing it again

Delphiprogrammi 08-24-2006 07:39 PM
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

turkforum 10-19-2006 12:43 PM
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.


All times are GMT. The time now is 11:18 AM.

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.00923 seconds
  • Memory Usage 1,719KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete