Error when updating

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)
Locked
pauls115pdtdi
Registered User
Posts: 72
Joined: Sun Jan 06, 2008 2:07 pm

Error when updating

Post by pauls115pdtdi »

Support Request Template
What version of phpBB are you using? I Don't Know
What is your board's URL? http://www.volksgirls.co.uk
Who do you host your board with? Unsure
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Fresh Install
Do you have any MODs installed? No
Is registration required to reproduce this issue? Yes
What styles do you currently have installed? Customised Prosilver
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 4 / MySQL 5 is what the forum is showing
What is your level of experience? Comfortable with PHP and phpBB
What username can be used to view this issue? No answer given
What password can be used to view this issue? No answer given
When did your problem begin? When updating the database
Please describe your problem. I'm trying to update our board to be on the latest version (3.0.8), but when trying to do the database update part, it's saying:
Notice: Undefined index: MYSQL_SCHEMA_UPDATE_REQUIRED in /home/volksgir/public_html/forum/install/database_update.php on line 283

Our board shows that we are on 3.0.6, but the database thinks that we're on 3.0.7-PL1, which I'm not sure if that's causing the problem.
I've tried the update package for both 3.0.6 and 3.0.7-PL1, and neither of them seem to work, they both give the same error
Generated by SRT Generator ($Rev: 4778 $)

EDIT: Just tried posting, and I'm not getting an error message saying:
General Error
SQL ERROR [ mysql4 ]

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

SQL

INSERT INTO phpbb3_topics (topic_poster, topic_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 (155, 1298930624, 13, 0, 1, 'New Website', 'Paul', 'FF3366', 0, 0, 0)

BACKTRACE

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

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

FILE: posting.php
LINE: 1002
CALL: submit_post()
Thanks
Paul

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10359
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: Error when updating

Post by Noxwizard »

Follow the instructions in this article: Doesn't have a default value errors
Run the one for 3.0.6, execute the queries it gives you, then run /install/database_update.php again.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.

Locked

Return to “[3.0.x] Support Forum”