Field 'topic_last_poster_name' doesn't have a default value

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
davss
Registered User
Posts: 51
Joined: Fri Dec 14, 2007 12:24 pm
Contact:

Re: Field 'topic_last_poster_name' doesn't have a default value

Post by davss » Sat Aug 30, 2008 3:11 pm

Kevin Clark wrote:Just follow the KB article linked in the post 2 above yours
http://www.phpbb.com/kb/article/doesnt- ... ue-errors/

It'll output a page of SQL commands to automatically do the changes for you.

Many thanks for this link. I run it successfully but it didn't fix all the tables and had to do all manually in the end.

net83it
Registered User
Posts: 500
Joined: Sun Jan 15, 2006 2:42 pm
Location: Sicily
Contact:

Re: Field 'topic_last_poster_name' doesn't have a default value

Post by net83it » Tue Sep 02, 2008 7:50 am

today i have the same error when i try to split a topic

i'll follow the KB tutorial...

net83it
Registered User
Posts: 500
Joined: Sun Jan 15, 2006 2:42 pm
Location: Sicily
Contact:

Re: Field 'topic_last_poster_name' doesn't have a default value

Post by net83it » Tue Sep 02, 2008 8:17 am

i have an error


Errore
query SQL:

# 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 COLLATE utf8_unicode_ci,
MODIFY post_text mediumtext NOT NULL COLLATE utf8_bin,
MODIFY post_checksum varchar( 32 ) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_attachment tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL ,
MODIFY bbcode_bitfield varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY bbcode_uid varchar( 8 ) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_postcount tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL ,
MODIFY post_edit_time int( 11 ) UNSIGNED DEFAULT '0' NOT NULL ,
MODIFY post_edit_reason varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_edit_user mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL ,
MODIFY post_edit_count smallint( 4 ) UNSIGNED DEFAULT '0' NOT NULL ,
MODIFY post_edit_locked tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL ,
DEFAULT CHARSET = utf8 COLLATE = utf8_bin;



Messaggio di MySQL:

#1283 - Column 'post_text' cannot be part of FULLTEXT index

net83it
Registered User
Posts: 500
Joined: Sun Jan 15, 2006 2:42 pm
Location: Sicily
Contact:

Re: Field 'topic_last_poster_name' doesn't have a default value

Post by net83it » Tue Sep 02, 2008 8:23 am

i only run the sql query relative to phpbb_topics table and now i can split topics correctly

let me know if it is ok or i have to run all sql queries

thank you

Wert
Former Team Member
Posts: 3676
Joined: Tue Jul 03, 2001 8:33 pm
Location: Sacramento, CA
Name: Chris Aguilar

Re: Field 'topic_last_poster_name' doesn't have a default va

Post by Wert » Fri Mar 12, 2010 5:46 am

...
Chris Aguilar - AKA "Wert"

User avatar
engert
Registered User
Posts: 669
Joined: Mon May 19, 2003 11:24 am
Location: Home

Re: Field 'topic_last_poster_name' doesn't have a default va

Post by engert » Sat Nov 19, 2011 4:49 am

How do you activate the script mentioned in this KB ?

Do i change this:

Code: Select all

//
// Security message:
//
// This script is potentially dangerous.
// Remove or comment the next line (die(".... ) to enable this script.
// Do NOT FORGET to either remove this script or disable it after you have used it.
//
die("Please read the first lines of this script for instructions on how to enable it");
to this:

Code: Select all

(die(".... ) 
die("Please read the first lines of this script for instructions on how to enable it");

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Field 'topic_last_poster_name' doesn't have a default va

Post by Oyabun1 » Sat Nov 19, 2011 4:57 am

No, you replace

Code: Select all

die("Please read the first lines of this script for instructions on how to enable it");
with

Code: Select all

//die("Please read the first lines of this script for instructions on how to enable it");
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

Locked

Return to “[3.0.x] Support Forum”