Host upgraded to PHP5 without telling me

Please post general support questions for the phpBB3 core system on phpBB.com!
Bitte allgemeine Supportanfragen zu phpBB3 auf phpBB.de stellen!
Forum rules
Please post general support questions for the phpBB3 core system on phpBB.com!
Bitte allgemeine Supportanfragen zu phpBB3 auf phpBB.de stellen!
Locked

Topic author
ROCOAFZ
Active Member
Posts: 3
Joined: 21. January 2009 05:17

Host upgraded to PHP5 without telling me

Post by ROCOAFZ »

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
User avatar

Christian_N
Former Team Member
Posts: 2266
Joined: 19. January 2008 01:17
phpBB.de User: Christian_N
phpBB.com User: Christian_N
Location: Frankfurt
Contact:

Re: Host upgraded to PHP5 without telling me

Post by Christian_N »

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"
Meine Projekte: Chantals - Fanpage .::. phpBB Projekt
No support via PM, email or messenger!

Topic author
ROCOAFZ
Active Member
Posts: 3
Joined: 21. January 2009 05:17

Re: Host upgraded to PHP5 without telling me

Post by ROCOAFZ »

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

Return to “General phpBB3 Support”