Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Basic Knowledge
Boardlink: http://www.attackforcez.com
PHP Version: 5.0
What have you done before the problem was there?
Nothing
What have you already tryed to solve the problem?
Followed these instructions
http://www.phpbb.com/kb/article/doesnt- ... ue-errors/
Description and Message
My host moved our server to one with PHP5 from one that had PHP4
This resulted in this error everytime someone posts
General Error
SQL ERROR [ mysql4 ]
Field 'post_edit_reason' doesn't have a default value [1364]
SQL
INSERT INTO phpbb_posts (forum_id, poster_id, icon_id, poster_ip, post_time, post_approved, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_locked, topic_id) VALUES (57, 2, 0, '141.158.155.181', 1232511329, 1, 1, 1, 1, 1, '', 'Re: Cell , Rap70r, and SmalltownMafia', 'testing board', '8d2ac811f876bfd3424050a622c53c08', 0, '', '377lqs7c', 1, 0, 2257)
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/functions_posting.php
LINE: 1871
CALL: dbal_mysql->sql_query()
FILE: posting.php
LINE: 1001
CALL: submit_post()
I followed these instructions but when running the SQL i get this...
SQL query:
# Table: 'phpbb_posts' ALTER TABLE phpbb_posts MODIFY post_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poster_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY post_username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_subject varchar(255) DEFAULT '' NOT NULL C[...]
MySQL said:
#1283 - Column 'post_text' cannot be part of FULLTEXT index
On phpbb they said that if it doesn't work and you have a modded forum to check where you got the mod. I am wondering if there is a change or something i'm missing because of Board3 or if someone can point me to a fix.
Thanks
Site admin @attackforceZ.com
