Board3

Your Portal Version: 1.02
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

This is a phpBB and not a Portal problem.
Please make your question on phpBB.com

EDIT:
The board3 portal also works with PHP5.
Here at board3.de is PHP5 installed.

Moved in "General phpBB3 Support"

Got it resolved... what a mess that was... glad i haven't seen a PHP6 on the horizon yet.