To jest tylko wersja do druku, aby zobaczyć pełną wersję tematu, kliknij TUTAJ
phpBB2 by Przemo
Support forów phpBB2 modified by Przemo

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)



Powered by phpBB modified by Przemo © 2003 phpBB Group