Topic: Update issues : 1.2.21 > 1.4

Hi,

We have an issue upgrading from 1.2.21 to 1.4.
After running the update script, it seems that the upgrade is not performed completely.

An error was encountered

Your PunBB database is out-of-date and must be upgraded in order to continue.
Please run db_update.php in order to complete the upgrade process.

When we go on db_update.php :

An error was encountered

Your database is already as up-to-date as this script can make it.

Any idea ?

Re: Update issues : 1.2.21 > 1.4

Some updates have been done on the database, as using the 1.2.21 again is showing errors when trying to access users or topics.

Re: Update issues : 1.2.21 > 1.4

Check server logs for errors.
Check that forum db user have rights for alter table.

Re: Update issues : 1.2.21 > 1.4

Hi there.

As I don't have full access on the server, I recreated a test environment at home.

There is nothing in the error logs :
127.0.0.1 - - [06/Dec/2011:20:21:34 -0500] "GET /forum/admin/db_update.php HTTP/1.1" 503 395

That's the only thing I can see.

There is nothing either on the mysql logs.

I'm now using the root mysql user, with all privileges, and the problem is the same.

It's quite strange...

Re: Update issues : 1.2.21 > 1.4

By the way, it is a quite large forum.
365,141 posts in the database. Just in case.

Re: Update issues : 1.2.21 > 1.4

Its line from access logs.
Check error logs for error description.

Re: Update issues : 1.2.21 > 1.4

I just did.
I had that error, which is not relevant.

[Wed Dec 07 20:03:48 2011] [error] [client 127.0.0.1] File does not exist: C:/Program Files (x86)/EasyPHP-5.3.8.1/www/favicon.ico

Any idea ?

Re: Update issues : 1.2.21 > 1.4

I am under the impression that the update script itself detects that the update was done (not sure what it checks), and says it's up to date, but the forum itself sees that the update is not done.
Are those 2 checking the same thing ?

Re: Update issues : 1.2.21 > 1.4

I tried with using the 1.4.1, same issue, even if it seemed to be doing some stuff for a while.

10 (edited by Tetert 2011-12-11 17:59)

Re: Update issues : 1.2.21 > 1.4

Hi there.
After some troubleshooting on my side, I managed to find out a couple of things.

  • If I disable the version check from essentials.php, my forum is accessible again.

  • The UTF-8 conversion might have been the problem there. There was a huge number of posts to convert, and it probably timed-out.

  • Now, on my posts, there is no UTF-8 conversion. For exemple "Du 06 au 13 Août 2012" should be read "Du 06 au 13 Août 2012". But for exemple, it worked on the users profiles.

Any idea how to solve this ?

11

Re: Update issues : 1.2.21 > 1.4

OK, so I finally got it working.
I had to manually import back my data in my MySQL server to be able to convert to UTF8, and then to run a full install of 1.4 to get a working config.php, and then to use it in the fixed forum.
It was a bit epic, but it is finally working.

12

Re: Update issues : 1.2.21 > 1.4

On this upgrade, and the UTF-8 thing, read this excellent workaround.
http://punbb.informer.com/forums/post/140765/#p140765

New Friendly web-shop! • SO happy with PunBB! • Now punBB 1.4.x on ALL forums (won't tell how many or their addresses to avoid spam-regs)