SQL ERROR [ mysql4 ]

[marksalehouse]

SQL ERROR [ mysql4 ]

Field 'topic_last_post_subject' doesn't have a default value [1364]

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) VALUES (53, 1249299473, 1249299473, 23, 0, 1, 'PETER AND HIS MUM', 'ecdysis', '00AA00', 0, 0, 0)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1897
CALL: dbal_mysql->sql_query()

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

this error happened today completely out of the blue!

I did the SQL query from here - http://area51.phpbb.com/phpBB/viewto...p?f=71&t=30668

ALTER TABLE `phpbb_topics` ALTER `topic_last_post_subject` SET DEFAULT '';

Worked fine:

Your SQL query has been executed successfully (Query took 0.0039 sec)

M

[Anna M.]

please submit a ticket to the tech dept at https://whbsupport.com
and our tech team will gladly assist you
your main domain or cpanel username and the name of the server you are located on as well as the database name and full step be step instructions of what you did will be very helpful

[marksalehouse]

No No!

This problem is solved easily as shown above. It is just as a help to others.

Thank you anyway, I will always be in touch - YOU GUYS ROCK!

M

[carlobee]

No No!

This problem is solved easily as shown above. It is just as a help to others.

Thank you anyway, I will always be in touch - YOU GUYS ROCK!

M

Thank you for being that thoughtful to others! this is what makes this forum worth it.