PDA

View Full Version : URGENT - NEED HELP Database Error


Mattlab
08-24-2006, 03:32 PM
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
How do I fix this? I got it only after removing the hack for VB 3.6

Thanks,
Mattlab


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
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.