Going Live with CVS -- what's the worst that could happen?

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
lodp
Registered User
Posts: 26
Joined: Thu Oct 05, 2006 8:42 pm

Re: Going Live with CVS -- what's the worst that could happen?

Post by lodp »

VinDuv wrote: When I upgraded my beta 2 install to beta 4, I had to dump the structure of the phpBB database tables, and compare them with the table creation file in install/ beta 4 directory, and write all SQL commands needed to do the conversion. It wasn't easy at all !
I spent many hours...


But for an update from today's CVS to RC1 (which is after all just around the corner :roll: ), you'd only have to do that on a much smaller scale, right?

joeroberts
Registered User
Posts: 3
Joined: Wed Apr 11, 2007 8:02 pm

Re: Going Live with CVS -- what's the worst that could happen?

Post by joeroberts »

easyest way to see the data base changes that I know of is to check the install or update data base.
you should be able to see the changes there as long as the keep up with them.

Code: Select all

// Only an example, but also commented out
$database_update_info = array(
	// Changes from 3.0.b5 to the next version
	'3.0.b5'			=> array(
		// Add the following columns
		'add_columns'		=> array(
			SEARCH_WORDLIST_TABLE	=> array(
				'word_count'			=> array('UINT', 0),
			),
		),
		// Change the following columns...
		'change_columns'	=> array(
			TOPICS_TABLE		=> array(
				'poll_title'		=> array('STEXT_UNI', ''),
			),
			SESSIONS_TABLE		=> array(
				'session_forwarded_for'	=> array('VCHAR:255', ''),
			),
		),
		// Remove the following keys
		'drop_keys'		=> array(
			USERS_TABLE		=> array(
				'username_clean',
			),
			STYLES_IMAGESET_TABLE	=> array(
				'imgset_nm',
			),
		),
		'add_index'			=> array(
			SEARCH_WORDLIST_TABLE	=> array(
				'wrd_cnt'			=> array('word_count'),
			),
			ACL_GROUPS_TABLE		=> array(
				'auth_role_id'		=> array('auth_role_id'),
			),
			ACL_USERS_TABLE			=> array(
				'auth_role_id'		=> array('auth_role_id'),
			),
			ACL_ROLES_DATA_TABLE	=> array(
				'ath_opt_id'		=> array('auth_option_id'),
			),
		),
		// Add the following unique indexes
		'add_unique_index'	=> array(
			SEARCH_WORDMATCH_TABLE	=> array(
				'unq_mtch'		=> array('word_id', 'post_id', 'title_match'),
			),
			USERS_TABLE				=> array(
				'username_clean'	=> array('username_clean'),
			),
		),
		// Add the following columns
		'drop_columns'		=> array(
			STYLES_IMAGESET_TABLE	=> array(
				'site_logo',
				'upload_bar',
				'poll_left',
				'poll_center',
				'poll_right',
				'icon_friend',
				'icon_foe',
				'forum_link',
				'forum_read',
				'forum_read_locked',
				'forum_read_subforum',
				'forum_unread',
				'forum_unread_locked',
				'forum_unread_subforum',
				'topic_moved',
				'topic_read',
				'topic_read_mine',
				'topic_read_hot',
				'topic_read_hot_mine',
				'topic_read_locked',
				'topic_read_locked_mine',
				'topic_unread',
				'topic_unread_mine',
				'topic_unread_hot',
				'topic_unread_hot_mine',
				'topic_unread_locked',
				'topic_unread_locked_mine',
				'sticky_read',
				'sticky_read_mine',
				'sticky_read_locked',
				'sticky_read_locked_mine',
				'sticky_unread',
				'sticky_unread_mine',
				'sticky_unread_locked',
				'sticky_unread_locked_mine',
				'announce_read',
				'announce_read_mine',
				'announce_read_locked',
				'announce_read_locked_mine',
				'announce_unread',
				'announce_unread_mine',
				'announce_unread_locked',
				'announce_unread_locked_mine',
				'global_read',
				'global_read_mine',
				'global_read_locked',
				'global_read_locked_mine',
				'global_unread',
				'global_unread_mine',
				'global_unread_locked',
				'global_unread_locked_mine',
				'pm_read',
				'pm_unread',
				'icon_contact_aim',
				'icon_contact_email',
				'icon_contact_icq',
				'icon_contact_jabber',
				'icon_contact_msnm',
				'icon_contact_pm',
				'icon_contact_yahoo',
				'icon_contact_www',
				'icon_post_delete',
				'icon_post_edit',
				'icon_post_info',
				'icon_post_quote',
				'icon_post_report',
				'icon_post_target',
				'icon_post_target_unread',
				'icon_topic_attach',
				'icon_topic_latest',
				'icon_topic_newest',
				'icon_topic_reported',
				'icon_topic_unapproved',
				'icon_user_online',
				'icon_user_offline',
				'icon_user_profile',
				'icon_user_search',
				'icon_user_warn',
				'button_pm_forward',
				'button_pm_new',
				'button_pm_reply',
				'button_topic_locked',
				'button_topic_new',
				'button_topic_reply',
				'user_icon1',
				'user_icon2',
				'user_icon3',
				'user_icon4',
				'user_icon5',
				'user_icon6',
				'user_icon7',
				'user_icon8',
				'user_icon9',
				'user_icon10'
			),
		),
	),
);

as you should see like TOPIC_TABLE, SESSIONS_TABLE, and so on.
it would take some reading and doing and not for the lite hearted I give you this.
My advice WAIT. by the time you get all your bugs out get it how you think it should be the RC1 well be out and you stell welll not have any help.
I have seen changes to allot they may be small thinks here and there but stell the same allot of changes.
and not just to the new style. Because of the new style they have had to make small changes to the base coding
and your talking about hunting down and changing all these little codes?
Dont do that to your self.

code reader
Registered User
Posts: 653
Joined: Wed Sep 21, 2005 3:01 pm

Re: Going Live with CVS -- what's the worst that could happen?

Post by code reader »

Black Antitoon wrote: By the way, how do you see what SQL changes have been made from a CVS to another one? Are they listed anywhere?
the actual changes are listed in the cvs (i am talking about the actual cvs repository, not the snapshots which many on this board mistakenly refer to as "the cvs").
the structure (aka schema) is contained in the files in the install/schemas directory.
so, let's say you want to compare the structure from march 12 to that of april 24:
you pick one of those files, let's say mysql_41_schema.sql, and you run this command:
% cvs -f diff -u6 -D 2007-03-12 -D 2007-04-24 install/schemas/mysql_41_schema.sql
(the "%" represents the console prompt. don't type it).
of course, this requires you actually use cvs.
if you don't, you can still find the changes, by comparing this file (install/schemas/mysql_41_schema.sql) from the two snapshots, using any file-comparison utility.

of course, one should use the schema file which is appropriate to one's installation.

please note that this is a purely theoretical discussion, and not support for actual use of cvs version. the person asking the question does not even have an installed cvs-version forum.

User avatar
Highway of Life
Registered User
Posts: 1399
Joined: Tue Feb 08, 2005 10:18 pm
Location: I'd love to change the World, but they won't give me the Source Code
Contact:

Re: Going Live with CVS -- what's the worst that could happen?

Post by Highway of Life »

Black Antitoon wrote: By the way, how do you see what SQL changes have been made from a CVS to another one? Are they listed anywhere?
There are some techniques that some of us use... for example, I pulled the changes and updated a database for someone from a Beta4 to an April CVS the other day in a matter of minutes (less than 10 minutes). But since I don’t like to update all of my databases on a daily basis (I play around with 5 or 6 various phpBB3 test boards every day) I usually use these methods.
If done right, you can upgrade a board in 30 minutes, and have 20 seconds of downtime.
lodp wrote: But for an update from today's CVS to RC1 (which is after all just around the corner :roll: ), you'd only have to do that on a much smaller scale, right?
Maybe. But there is never a guarantee. True there were bigger changes in the past (i.e. between B1->B2 and B2->B3) and the changes they make to the database now seem like small beans, it still all depends on...
A) How much time you are willing to devote to upgrading it
B) Are you are willing to sacrifice support
C) How skilled you are with manual PHP and Database editing.

Since before Beta1 was released, honestly the most difficult aspect of updating was updating a style (theme) that was created.
My advice would be to keep everything default, don’t modify anything, since the more you modify, the more difficult it will be to upgrade.
Image

User avatar
Highway of Life
Registered User
Posts: 1399
Joined: Tue Feb 08, 2005 10:18 pm
Location: I'd love to change the World, but they won't give me the Source Code
Contact:

Re: Going Live with CVS -- what's the worst that could happen?

Post by Highway of Life »

edit woops double post
Image

User avatar
Black Antitoon
Registered User
Posts: 93
Joined: Mon Apr 02, 2007 2:50 pm

Re: Going Live with CVS -- what's the worst that could happen?

Post by Black Antitoon »

I am not running a live CVS board, but I have two for testing. Thank you for your answers.

Post Reply