General Error

current version: 1.0.4.1
released: 11.07.2011

latest tested phpBB-Version: 3.0.10

General Error

Postby Alfredo Garcia » Tue Dec 06, 2011 8:36 am

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. :)
Alfredo Garcia
Posts < 10
Posts < 10
 
Posts: 3
Topics: 2
Joined: Tue Dec 06, 2011 8:33 am

Re: General Error

Postby nickvergessen » Wed Dec 07, 2011 9:04 pm

You didnt run the SQL statement:
Code: Select all
ALTER TABLE `phpbb_users` ADD `user_topics` mediumint(8) unsigned DEFAULT "0" NOT NULL;
cheers nickvergessen :geek:

Member of phpBB Development-Team
No Support via PM
User avatar
nickvergessen
Administrator
Administrator
 
Posts: 5753
Topics: 218
Images: 139
Joined: Mon Oct 15, 2007 4:15 pm
phpBB.de: nickvergessen
phpBB.com: nickvergessen

Re: General Error

Postby Alfredo Garcia » Thu Dec 08, 2011 7:53 am

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.
Alfredo Garcia
Posts < 10
Posts < 10
 
Posts: 3
Topics: 2
Joined: Tue Dec 06, 2011 8:33 am


Return to NV usertopics

Who is online

Users browsing this forum: No registered users and 1 guest