MyBB Community Forums

Full Version: mySQL error: 1136
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
hi i just got back recently from class. and i noticed while entering my forum i got some error? the error looks like this. im not too sure on how i can fix this. but maybe you guys can help me out with this? to view the error you can go here forums so far all im able to access is the admin panel.

Quote:mySQL error: 1136
Column count doesn't match value count at row 1
Query: INSERT INTO mybb_online VAlUES ('1', '68.237.22.18', '1108671461', '/forums/index.php')
I did some digging and I *think* I got a fix for your problem. Go into PHPMyAdmin and back up the table 'mybb_online'. Then drop that table and execute this sql query by clicking the "SQL" tab on phpmyadmin

CREATE TABLE mybb_online (
  uid smallint(6) NOT NULL default '0',
  ip varchar(40) NOT NULL default '',
  time bigint(30) NOT NULL default '0',
  location varchar(150) NOT NULL default ''
);

and click go. It will create a fresh new set of mybb_online table so all of your online statistics will be gone (like most users and some other stuff...)
thank you what you told me todo worked. Smile
repair tables works also in this case