can't make new topics. :(

[Dasher]

I get an error when I got to make a new topic.

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()

 

[Nathan]

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.

 

[Dasher]

Umm, you wanna do that? Or tell me how via PM? 😵

 

[Nathan]

To do which one, remove all the instances or do the query?

 

[Dasher]

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. 🙁

 

[Nathan]

Run this SQL query in phpmyadmin.

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;

 

[Dasher]

Ok, I did that, and then what? Nothing happened with the site. Still not able to post new topics.

EDIT: Is there a way to just submit a query that will erase all instances of topic_attribute?

 

[Nathan]

Did you do it properly?

 

[Dasher]

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?

 

[Nathan]

Just un-do all your edits and it'll fix it.

 

[Dasher]

Okiedokie. XD

*takes the next 2 hours to fix it. 🙁*

 

[CyberFreak]

Ok, I did that, and then what? Nothing happened with the site. Still not able to post new topics.

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.

 

[Dasher]

It's fixed to my knowledge. I can create topics.