F.A.Q. - Read it first! - Column count doesn't match value count at row 1
Matteo - 08-09-2010, 21:39 Temat postu: Column count doesn't match value count at row 1 When you try to write message on forum, you see error, like this:
Kod: | SQL Error : 1136 Column count doesn't match value count at row 1
INSERT INTO phpbb_shoutbox VALUES(0, 2, 'Your message', '1168347025')
Line : xxx
File : shoutbox_view.php |
Probably reason of this error is incompatibility shoutbox files and table phpbb_shoutbox in database.
Solution:
Delete files: shoutbox.php, shoutbox_view.php, shoutbox_view_body.tpl, shoutbox_body.tpl.
Do SQL query (if you have another prefix - change it):
Kod: | DROP TABLE phpbb_shoutbox |
Now overwrite files shoutbox.php, shoutbox_view.php, shoutbox_view_body.tpl, shoutbox_body.tpl from original, latest package, and do this query (if you have another prefix - change it):
Kod: | CREATE TABLE phpbb_shoutbox (
id int(11) NOT NULL auto_increment,
sb_user_id int(11) NOT NULL default '0',
msg text NOT NULL,
timestamp int(10) UNSIGNED NOT NULL default '0',
PRIMARY KEY (id),
KEY sb_user_id (sb_user_id),
KEY timestamp (timestamp)
); |
(original content)
|
|
|