PunBB Forums — db_update.php

Re: db_update.php

null@example.com (fpouget) — Thu, 07 Feb 2008 09:10:11 +0000

Looks fine for me !
Thanks

Re: db_update.php

null@example.com (Rickard) — Wed, 06 Feb 2008 23:40:50 +0000

I discovered a bug in the charset conversion process. Could you give it a new go?

Re: db_update.php

null@example.com (fpouget) — Tue, 05 Feb 2008 12:54:17 +0000

Let's me see what can I do to give you access. Where Should I send this ?

Edit: Send to your email

Re: db_update.php

null@example.com (Rickard) — Tue, 05 Feb 2008 12:36:05 +0000

fpouget wrote:

You are right I did the check to quickly I got the same problem with posts subject, category and forum name. But is ok for the Username .
I did a test few weeks ago (before the beta 1400) the username wasn't OK but all the rest was fine.

I doubt that there would be any difference between usernames and any of the other fields. We process everything in exactly the same way.

I'd be interested in knowing a little bit more about your situation. What character set is used for the forum pages as well as in the database for the pre-1.3 install and stuff like that. Ideally, I would like to get access to a database dump so I can do testing locally, but I understand if you can't do that.

fpouget wrote:

Yes is linked with the UTF8 conversion
From Forums field Moderators
a:3:{s:5:"Bruno";i:9;s:12:"Pierre-Andr
the second username is cuted Pierre-André --> Pierre-Andr and there is nothing behind, is why I've the unserialize() issue .

You're absolutely right. I will fix it when I get back from work.

Re: db_update.php

null@example.com (fpouget) — Tue, 05 Feb 2008 10:54:17 +0000

Rickard wrote:

Hmm. It only affects forum names and category names? Usernames, posts, subject etc are converted correctly?

You are right I did the check to quickly I got the same problem with posts subject, category and forum name. But is ok for the Username .
I did a test few weeks ago (before the beta 1400) the username wasn't OK but all the rest was fine.

fpouget wrote:

I've too several mistakes on the index.php

Notice: unserialize() [function.unserialize]: Error at offset 7 of 21 bytes in /home/ftp/upload/www/forum2/index.php on line 189

Notice: unserialize() [function.unserialize]: Error at offset 23 of 38 bytes in /home/ftp/upload/www/forum2/index.php on line 189

may be is linked ?

Rickard wrote:

Not linked. The index.php error is because there's something wrong with your array of moderators. Have you had any mod installed that fiddles with the moderators?

Yes is linked with the UTF8 conversion

From Forums field Moderators

a:3:{s:5:"Bruno";i:9;s:12:"Pierre-Andr

the second username is cuted Pierre-André --> Pierre-Andr and there is nothing behind, is why I've the unserialize() issue .

Cheers

Re: db_update.php

null@example.com (Rickard) — Tue, 05 Feb 2008 09:00:12 +0000

fpouget wrote:

The special character are not converted properly the forum name on the forum table and the Category Name on the category table
Géomatique --> G

Hmm. It only affects forum names and category names? Usernames, posts, subject etc are converted correctly?

fpouget wrote:

I've too several mistakes on the index.php

Notice: unserialize() [function.unserialize]: Error at offset 7 of 21 bytes in /home/ftp/upload/www/forum2/index.php on line 189

Notice: unserialize() [function.unserialize]: Error at offset 23 of 38 bytes in /home/ftp/upload/www/forum2/index.php on line 189

may be is linked ?

Not linked. The index.php error is because there's something wrong with your array of moderators. Have you had any mod installed that fiddles with the moderators?

Re: db_update.php

null@example.com (fpouget) — Mon, 04 Feb 2008 20:54:07 +0000

db_update.php (build 1450)
The special character are not converted properly the forum name on the forum table and the Category Name on the category table

Géomatique --> G

I've too several mistakes on the index.php

Notice: unserialize() [function.unserialize]: Error at offset 7 of 21 bytes in /home/ftp/upload/www/forum2/index.php on line 189

Notice: unserialize() [function.unserialize]: Error at offset 23 of 38 bytes in /home/ftp/upload/www/forum2/index.php on line 189

may be is linked ?

Cheers

Re: db_update.php

null@example.com (qubertman) — Fri, 01 Feb 2008 19:15:56 +0000

Or you can download the latest db_update.php with the fix to give it a test drive.

Re: db_update.php

null@example.com (mat) — Fri, 01 Feb 2008 18:59:51 +0000

I just put a dumb (0 sized) file here:

[$pun_root]/skin_name/skin_name.php

not quite the nicest thing, but'll do the job...

Re: db_update.php

null@example.com (dilauro) — Fri, 01 Feb 2008 14:48:00 +0000

I ran into the same problem. My 1.2.16 system had a default style winter so when I ran the db_update, it failed at line 335 as stated in the first post.

1) Installed 1.3
2) Logon
3) Copy config.php from 1.2.16 to 1.3 system
4) Error in FUNCTION.php
5) Use the Config 1.3 Config
6) Run db_update and got the above message

Re: db_update.php

null@example.com (Smartys) — Thu, 31 Jan 2008 00:52:11 +0000

Well, the only time that situation would come up is when upgrading from 1.2 to 1.3, which means you should have 1.3's Oxygen in place. I'll just add a file_exists check.

Edit: Actually, this brings up some other issues. More discussion required!

db_update.php

null@example.com (qubertman) — Thu, 31 Jan 2008 00:42:20 +0000

Line 335:
require PUN_ROOT.'style/'.$pun_user['style'].'/'.$pun_user['style'].'.php';

In 1.2.16, we created our own style and made it the default style. When running db_updated.php, we got the error on line 335 because it was looking for the style in a directory that did not existed since 1.2.16 was not structured that way for styles. We had to change to Oxygen in the database before we could run db_updated.php