General Error

[Alfredo Garcia]

Hi,

I just recently added this modification. I just wanted to point out that every time you reply to a topic(not create one) you get this error:

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'user_topics' in 'field list' [1054]

SQL

UPDATE phpbb_users SET user_lastpost_time = 1323153124, user_posts = user_posts + 1, user_topics = user_topics + 1 WHERE user_id = 2

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 2483
CALL: dbal_mysqli->sql_query()

FILE: posting.php
LINE: 1116
CALL: submit_post()


I just wanted to let you know. If you can please help me out here, that would be great.

[nickvergessen]

You didnt run the SQL statement:

Code: Select all

ALTER TABLE `phpbb_users` ADD `user_topics` mediumint(8) unsigned DEFAULT "0" NOT NULL;

[Alfredo Garcia]

Oh how utterly silly of me. I'm sorry, I didn't know there was a SQL bit to run and I didn't realize it. Sorry.