Error comes when new user created via ACP

[kru89]

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, caninvite, invites, usergroupid, reputationlevelid, reputation, warnings, infractions, ipoints, pmpopup, autosubscribe, threadedmode, showvbcode, styleid, timezoneoffset, daysprune, joindate, lastactivity, lastpost, membergroupids, displaygroupid, lastvisit, maxposts, startofweek)
VALUES

('*`{', FROM_UNIXTIME(1155750486), '678c11f6f269bcb4f6317be6d8aa3702', 3399, 0, '!!-DS -l- Newbie-!!', 0, 'D-SNewsBot', 'xyz@xyz.com', 0, '', '', '', 0, '', '', '', '', '', '', 0, '', 0, 0, 0, 2, 5, 10, 0, 0, 0, 1, -1, 0, 1, 0, '0', -1, 1155750420, 1155750420, -3601, '', '', 1155750486, -1, -1);


MySQL Error : Unknown column 'warnings' in 'field list'

[Shazz]

What was the last module you installed?
________
vapir no2

[kru89]

i installed AWS (Advanced Warning system in VB 3.5.4) thn i forgot to remove before i upgrade..and the latest module i installed is Arcade system...

[Shazz]

Originally Posted by kru89

i installed AWS (Advanced Warning system in VB 3.5.4) thn i forgot to remove before i upgrade..and the latest module i installed is Arcade system...

When i had this problem i couldn't do anything with Users"
I turned GZIP HTML Output Off. (admincp>vboptions>Cookies and HTTP Header Options )
Then put it on safe mode.
It acted a little werid. But it fixed the problem =\
________
Paul Daimler

[Ntfu2]

No you are missing the warnings SQL information, try running this query to solve the problem, from your adminCP -> Execute Query

ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';

if you have a table prefix (which it doesnt look like you do) you'll need to add it to the user part above.

[Paul M]

Originally Posted by kru89

i installed AWS (Advanced Warning system in VB 3.5.4) thn i forgot to remove before i upgrade....

When you uninstalled the AWS, it removed a column that vb now uses, you must add it back using the query posted above.

[kru89]

Originally Posted by Ntfu2

No you are missing the warnings SQL information, try running this query to solve the problem, from your adminCP -> Execute Query

ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';

if you have a table prefix (which it doesnt look like you do) you'll need to add it to the user part above.

hey i execute the following query but i have new error coming ( i did manual query)

Fatal error: Call to a member function on a non-object in /home/hari1031/public_html/forumz/includes/class_dm_user.php(2390) : eval()'d code on line 7

Originally Posted by Paul M

When you uninstalled the AWS, it removed a column that vb now uses, you must add it back using the query posted above.

i didn't remove the warning system..i installed it back for 3.6 i thought it would solve my problem..

[Ntfu2]

remove AWS for 3.6 unless you are using the version specifically for 3.6 that was just released.

[kru89]

Originally Posted by Ntfu2

remove AWS for 3.6 unless you are using the version specifically for 3.6 that was just released.

i installed for vb 3.6