REGISTER or LOGIN to have the annoying ads removed.
Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
weird SQL error.
#1
I was upgrading some one from moderators to admin and then got this error.

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'remember' in 'field list'
Query:
UPDATE mybb_users SET `email`='[email protected]', `postnum`='1', `usergroup`='8', `additionalgroups`='', `displaygroup`='0', `usertitle`='I\'m Still Alive', `signature`='', `website`='', `icq`='0', `aim`='', `yahoo`='', `msn`='', `style`='16', `timezone`='5', `dateformat`='0', `timeformat`='0', `language`='', `allownotices`='1', `hideemail`='1', `subscriptionmethod`='0', `invisible`='0', `dstcorrection`='2', `threadmode`='linear', `showsigs`='1', `showavatars`='1', `showquickreply`='1', `remember`='', `receivepms`='1', `pmnotice`='1', `daysprune`='0', `showcodebuttons`='1', `pmnotify`='0', `showredirect`='1', `tpp`='0', `ppp`='0' WHERE uid='779'


then I tried to update some other members groups...and got the same error..
can anyone help me, I am using MyBB 1.6
Thanks in advance.
Reply
#2
you need to rebuild the templates
Reply
#3
Quote:you need to rebuild the templates
I tried what you said, but unfortunately this didn't worked.
Reply
#4
just goto your phpMyAdmin and execute the query:
Code:
ALTER TABLE `mybb_users` ADD `remember` TEXT NOT NULL AFTER `postnum`;

It doesnt appear to insert anything into it, so you could goto the php file and find where it's saying to update that and remove it, but this way is easier =]
Reply
#5
Quote:booher
Junior Member

Posts: 23
Joined: Oct 2009
Reputation: 0

RE: weird SQL error.
just goto your phpMyAdmin and execute the query:
Code:
ALTER TABLE `mybb_users` ADD `remember` TEXT NOT NULL AFTER `postnum`;

It doesnt appear to insert anything into it, so you could goto the php file and find where it's saying to update that and remove it, but this way is easier =]
Oh man....It really worked.
Thanks for the help <3
Reply
#6
Yep complete noob fuckin dickhead who is about to learn the fine art of trolling spammin and ultimately domain closure.
Yep fuck with me bitch!!
BRING IT YOU FUCKER!!!
FTW Forum <-- Home of the DAMNED!
I have a weird thing that happens to my sigs. Its call moderation lol
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  ERROR kaliser90 1 1,093 Jul 04, 2010, 11:14 AM
Last Post: !!* Alone Vampire *!!

Forum Jump:


Users browsing this thread: 1 Guest(s)