PDA

View Full Version : Error comes when new user created via ACP

kru89
08-17-2006, 11:08 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, 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
08-17-2006, 11:42 PM
What was the last module you installed?
________
vapir no2 (http://www.vaporshop.com/no2-vaporizer.html)
kru89
08-17-2006, 11:46 PM
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
08-17-2006, 11:48 PM
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 (http://www.mercedes-wiki.com/wiki/Paul_Daimler)
Ntfu2
08-18-2006, 12:21 AM
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
08-18-2006, 12:54 AM
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
08-20-2006, 08:00 PM
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

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
08-21-2006, 02:29 PM
remove AWS for 3.6 unless you are using the version specifically for 3.6 that was just released.
kru89
08-21-2006, 04:38 PM
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