**** Schema is frozen ****

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
User avatar
Pix
Registered User
Posts: 19
Joined: Thu Nov 15, 2001 1:19 am
Contact:

Post by Pix » Mon Nov 26, 2001 7:26 pm

So... :)

I have a phpbb 1.4 forum and would like to upgrade to the latest version of phpbb 2.

Is this a good guess as to how I go about it?

1. Backup data for my existing forums - :p
2. Rename my existing phpbb dir
3. extract latest phpbb from cvs to my local phpbb dir
4. Run install.php

I had a quick look and it looked as though it would upgrade my existing phpbb db - is this a correct assumption?

Thanks for all the work you lot have done - I really want to get it installed now :p
Frag Fest UK LAN Parties - Frag Not Lag
www.fragfestuk.com

AL
Registered User
Posts: 442
Joined: Tue Jul 03, 2001 10:21 pm
Location: Texas Ya'll

Post by AL » Mon Nov 26, 2001 8:01 pm

there will be an upgrade script for 1.4 -> 2.0 when the final is released.
"A nerd is someone whose life is focused on computers and technology, but a geek is someone whose life is focused on computers and technology and LIKES it that way."

User avatar
Pix
Registered User
Posts: 19
Joined: Thu Nov 15, 2001 1:19 am
Contact:

Post by Pix » Mon Nov 26, 2001 10:05 pm

But I'd like to use it now if possible.
Frag Fest UK LAN Parties - Frag Not Lag
www.fragfestuk.com

Shantra
Registered User
Posts: 59
Joined: Thu Jul 05, 2001 8:42 pm
Location: Norway

Post by Shantra » Mon Nov 26, 2001 11:50 pm

Pix,
I suggest STRONGLY that you upgrade if you use the 1.4. It is not very secure and can be hacked. Mine did!!!

User avatar
SHS`
Former Team Member
Posts: 6615
Joined: Wed Jul 04, 2001 9:13 am
Location: Yellow Beach, Nine Dragons, Hong Kong
Name: Jonathan Stanley
Contact:

Post by SHS` » Tue Nov 27, 2001 1:17 am

I've just updated from the CVS again since the initial "freeze" when the schemas were moved into the /db/schemas about this time last week and I've noticed the mysql one has had the phpbb_topics.topic_title reduced from a char(100) to char(60) at version 1.2. Is this for compatibility reasons with other DBMSes?

This doesn't seem to have effected the PM message title, where phpbb_privmsgs.privmsgs_subject is still a varchar(255).

I'd have probably missed this had not looked at some of the older posts which had some veeery long subjects (testing upgrade from phpBB1.x to phpBB2 at the mo).
Jonathan “SHS`” Stanley • 史德信
Image

User avatar
psoTFX
Former Team Member
Posts: 7425
Joined: Tue Jul 03, 2001 8:50 pm

Post by psoTFX » Tue Nov 27, 2001 1:39 am

No, no compatibility issues, mainly it's a preventative measure ...

User avatar
SHS`
Former Team Member
Posts: 6615
Joined: Wed Jul 04, 2001 9:13 am
Location: Yellow Beach, Nine Dragons, Hong Kong
Name: Jonathan Stanley
Contact:

Post by SHS` » Tue Nov 27, 2001 2:01 am

Wouldn't that impact on boards which use unicode (eg: Chinese)? I seem to remember all the characters got changed to their respectiive HTML entities and thus took up quite a lot of space, being of the format (off the top of my head without checking.....) &#hhhh;
Jonathan “SHS`” Stanley • 史德信
Image

User avatar
psoTFX
Former Team Member
Posts: 7425
Joined: Tue Jul 03, 2001 8:50 pm

Post by psoTFX » Tue Nov 27, 2001 2:07 am

So long as the character encoding is set correctly there will be no problem ... that's the theory anyway :D Besides, it's a simple task to modify the field length if absolutely essential.

User avatar
SHS`
Former Team Member
Posts: 6615
Joined: Wed Jul 04, 2001 9:13 am
Location: Yellow Beach, Nine Dragons, Hong Kong
Name: Jonathan Stanley
Contact:

Post by SHS` » Tue Nov 27, 2001 2:16 am

Yup. Seems reasonable enough.
Jonathan “SHS`” Stanley • 史德信
Image

User avatar
The Horta
Registered User
Posts: 43
Joined: Thu Aug 09, 2001 1:24 am
Location: Ahm fum Foat Wuth, Texas
Contact:

Post by The Horta » Tue Nov 27, 2001 3:01 am

Looking at the CVS schema for MySQL, the table phpbb_themes_name has a themes_id of smallint( 5 ), where every other _id is now mediumint( 8 ), including the same value in phpbb_themes.

Similar item in phpbb_forums, where forum_id is now a smallint( 8 ), where it appears it should be mediumint( 8 ).

Hope that's useful info.

Shantra
Registered User
Posts: 59
Joined: Thu Jul 05, 2001 8:42 pm
Location: Norway

Post by Shantra » Tue Nov 27, 2001 10:29 am

PhpBB,

It would be nice if you could release a new beta/test version that include the freezed db.

User avatar
psoTFX
Former Team Member
Posts: 7425
Joined: Tue Jul 03, 2001 8:50 pm

Post by psoTFX » Tue Nov 27, 2001 11:51 am

A new version, as noted in the phpBB 2.0 status thread will be forthcoming but is still a small ways off yet.

WebSnail
Registered User
Posts: 524
Joined: Sun Nov 11, 2001 2:20 pm
Location: South Yorkshire, UK
Contact:

Post by WebSnail » Tue Nov 27, 2001 12:12 pm

psoTFX wrote: So long as the character encoding is set correctly there will be no problem ... that's the theory anyway :D Besides, it's a simple task to modify the field length if absolutely essential.
I might be wrong but I believe text sets like Chinese are double byte characters so they will end up using double the number of characters at bare minimum. As I'm not chinese myself I can't confirm this 100% but I have worked with Asian character sets in html (under the correct character set) and it is more complex.

Anyone able to confirm/slap-me on this :)

User avatar
GamerZ
Registered User
Posts: 132
Joined: Thu Jul 19, 2001 11:13 am
Location: Singapore

Post by GamerZ » Tue Nov 27, 2001 2:42 pm

Blade wrote:
GamerZ wrote:
Blade wrote:
GamerZ wrote: i will wait for the next release before i use it. hope is a RC1

well, would be nice, but we will see what kind of version will be the next realse ;)

lets pray for a RC1
lolz


well, why not to have a party after the phpBB version 2 relase? ;) :!:
We will see, what is the next relase or? :?:
sure thing

Locked

Return to “2.0.x Support Forum”