[Beta 1 -> 3, Beta 2 ->4] phpBB3 Beta to Beta upgrade script

[Handyman]

Hmm... looks like images aren't getting parsed either.
I'll have to do some phpBB3 Beta 3 parsing tests... it seems it's not dome the same way as Beta 2... even though I was going through some phpBB3 Beta 3 code and it looks the same.

I'll have to give it a few tests next week.

Edit: Exreaction made it work, so he's working on updating the script with the new code

[EXreaction]

I am working on fixing the BBCodes now.

[EXreaction]

Ok, I just committed my changes. Someone wanna give it some more testing?

Looks to me like it work, but I didnt test custom smilies.

[nesl247]

Gotta get this to upgrade to beta4 which was released.

[EXreaction]

[quote="nesl247":d7e64]
Gotta get this to upgrade to beta4 which was released.
[/quote:d7e64]

Well, luckly for us, B4 comes with a B3 to B4 updater.

We might make it upgrade directly to B4...but I doubt it...at least for now.

[Greynor]

@Exreaction: how to test your BBcode - fix? New installation/update?

[Bryan]

Howdy Gents!

Trying to go through the script and I'm getting the following error:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Column 'post_username' cannot be null [1048]

SQL

INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, icon_id, poster_ip, post_time, post_approved, post_reported, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_time, post_edit_reason, post_edit_user, post_edit_count, post_edit_locked) VALUES ('1', '1', '2', '2', '1', '127.0.0.1', '1150791046', '1', '0', '1', '1', '1', '1', NULL, 'Welcome to phpBB 3', 'This is an example post in your phpBB 3.0 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!', '5dd683b17f641daf84c040bfefc58ce9', '0', '', '', '1', '0', '', '0', '0', '0')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 132
CALL: dbal_mysql->sql_error()

FILE: upgrade/tables/posts.php
LINE: 69
CALL: dbal_mysql->sql_query()

FILE: upgrade/index.php
LINE: 95
CALL: include('upgrade/tables/posts.php')

Any ideas? Thanks a bunch in advance!!

[Greynor]

img and quote tags are still wrong
http://www.couch-fiction.org/phpBB3/vie ... p?f=2&t=39

smilies work

[Handyman]

Hey Bryan,

Instead of having you download a whole new zip file, let's do this.
Open upgrade/tables/posts.php

Find

Code: Select all

'post_username'        => $posts_row['post_username'],


REPLACE WITH

Code: Select all

'post_username'        => ($posts_row['post_username'] == NULL) ? '' : $posts_row['post_username'],


Then let us know how it works.

Zip has been updated.

[nesl247]

[quote="EXreaction":4e86e]
[quote="nesl247":4e86e]
Gotta get this to upgrade to beta4 which was released.
[/quote:4e86e]

Well, luckly for us, B4 comes with a B3 to B4 updater.

We might make it upgrade directly to B4...but I doubt it...at least for now.
[/quote:4e86e]

Didn't know.. I've probably got a screwed up board anyways because of the url parse errors you all talk about. And the fact that IIRC, the custom profile fields don't get properly transfered.