can't make new topics. :(

Dasher

Seasoned Veteran
Joined
Sep 22, 2009
Messages
2,611
Reaction score
0
FP$
6
I get an error when I got to make a new topic.


Code:
SQL ERROR [ mysqli ]

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

SQL

INSERT INTO phpbb_topics (topic_poster, topic_time, topic_last_view_time, forum_id, icon_id, topic_approved, topic_title, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment, topic_attribute) VALUES (51, 1263949141, 1263949141, 6, 0, 1, 'test', 'Dasher', 'CC0000', 0, 0, 0, '')

BACKTRACE

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

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

FILE: posting.php
LINE: 1108
CALL: submit_post()
 
Unknown column 'topic_attribute' in 'field list' [1054]

There's your problem. If you've got the attribute mod working then you need to run the SQL/installer, if not then remove all instances of queries that call the "topic_attribute" field.
 
The query to uninstall it. XD Either that or I have to go through manually and delete all the mod edits which will take forever. 🙁
 
Run this SQL query in phpmyadmin.

Code:
CREATE TABLE phpbb_topics_attr (
  attr_id INT(11) AUTO_INCREMENT NOT NULL,
  attr_type TINYINT(1) DEFAULT '0' NOT NULL,
  attr_name VARCHAR(255) COLLATE utf8_bin NOT NULL,
  left_id MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
  right_id MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
  attr_img VARCHAR(255) COLLATE utf8_bin NOT NULL,
  attr_date VARCHAR(25) COLLATE utf8_bin DEFAULT NULL,
  attr_colour VARCHAR(6) COLLATE utf8_bin NOT NULL,
  attr_user_colour TINYINT(1) default '0' NOT NULL,
  PRIMARY KEY (attr_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
 
Ok, I did that, and then what? Nothing happened with the site. Still not able to post new topics. :cry:

EDIT: Is there a way to just submit a query that will erase all instances of topic_attribute?
 
I took out the code in the posting.php to see if it would help. Is there a way to insert the forums users and whatnot into a new database?
 
Dasher said:
Ok, I did that, and then what? Nothing happened with the site. Still not able to post new topics. :cry:

EDIT: Is there a way to just submit a query that will erase all instances of topic_attribute?
Is the table prefix of your forums tables phpbb_ ?

If not you needed to edit the prefix of the query given.
 
Back
Top Bottom