I messed it up. Real bad. (i think)
Basically what i did was get the update from 3.0.3 to 3.0.4 (thinking that it will work) and updated (files and database). After deleting the install folder, the forum index (and every other page) was treating me with a nice error from the functions_contents.php if i can recall well.
I decided to get a fresh copy of 3.0.4 and upload it, keeping it connected to the old database. After doing that, it all seemed to be ok, the forum was working well and all, i could surf the forums, post replies but when trying to start a new thread i only got this beautiful error message (see attachement)
I ran a database update, and it said database was fine. Still, when trying to get a new topic, same result.
Has anyone ever confronted with such thing? Any ideas on how to fix?
Upgrade from 3.0.RC5 to 3.0.4
Forum rules
Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Upgrade from 3.0.RC5 to 3.0.4
- Attachments
-
- phpbb.jpg
- (94.74 KiB) Downloaded 162 times
Re: Upgrade from 3.0.RC5 to 3.0.4
Jim Mossing Holsteyn - Moderator Team Member
Knowledge Base | Documentation | Board rules
No support here on Area51, please visit the Support forums over at phpBB.com
Knowledge Base | Documentation | Board rules
No support here on Area51, please visit the Support forums over at phpBB.com
Re: Upgrade from 3.0.RC5 to 3.0.4
Problem persists. I noticed that the topic_last_post_subject field is BLOB and i've read on another forum that it should be varchar 255.
Could that be a problem?
Could that be a problem?
- Kevin Clark
- Support Team
- Posts: 751
- Joined: Thu Feb 10, 2005 5:34 pm
- Location: UK
- Contact:
Re: Upgrade from 3.0.RC5 to 3.0.4
Yes, i commented the "die" line and browsed the file. It seemed ok.
Last edited by rady on Tue Feb 10, 2009 8:34 pm, edited 2 times in total.
- Kevin Clark
- Support Team
- Posts: 751
- Joined: Thu Feb 10, 2005 5:34 pm
- Location: UK
- Contact:
Re: Upgrade from 3.0.RC5 to 3.0.4
No. That just shows you the results.
You need to run those results in the database.
You need to run those results in the database.
This will cause the script to scan your database and then provide the correct schema for your MySQL version. As such it will output a list of SQL queries which can
* Be run all in one go via phpmyadmin
* Or run via the MySQL console
* Or given to the host to run.
Re: Upgrade from 3.0.RC5 to 3.0.4
i misunderstood what i had to do. i ran the sql querry and got this error:
MySQL said: Documentation
#1283 - Column 'post_text' cannot be part of FULLTEXT index
MySQL said: Documentation
#1283 - Column 'post_text' cannot be part of FULLTEXT index
- Kevin Clark
- Support Team
- Posts: 751
- Joined: Thu Feb 10, 2005 5:34 pm
- Location: UK
- Contact:
Re: Upgrade from 3.0.RC5 to 3.0.4
IT WORKED!!
The forum was saved !
Thanks a million!!
The forum was saved !
Thanks a million!!