CVS How To

[Migrated From Jforum.net]

Hi Guys!!!

I'm really not familiarized with CVS. I have Eclipse installed, but I already like to develop in Java with TextPad (a few advanced text editor)...

Certainly there are lots of differences between 2.1.4 and CVS version, and I would like to have the last one.

Where can I find some documentation about how to access CVS? From the zero! Username and password aren't enough for beginners

Do I really need to use Eclipse, or there is another way?

What do you suggest?

[ ]'s
[originally posted on jforum.net by leandro_salvador]

[Migrated From Jforum.net]

Reference to this post

https://coderanch.com/t/575547

You can download a copy of WinCVS at http://www.wincvs.org/download.html

After installation, go to the Admin->Command Line option & run this 2 line of instruction
cvs -d :pserver:[e-mail]:/cvs login
cvs -d :pserver:[e-mail]:/cvs checkout jforum

The downloading process will then begin.
[originally posted on jforum.net by munhin]

[Migrated From Jforum.net]

Well, I want to upgrade my current JForum and try to install 2.1.5 from CVS.
The "cvs" command asks for "CVS password'.
What is the password?
cvs -d :pserver:[e-mail]:/cvs login

What are the next steps? How to compile?
[originally posted on jforum.net by Evgeny]

[Migrated From Jforum.net]

The "cvs" command asks for "CVS password'.
What is the password?

there is no password, just hit return. You can then do a 'checkout' as mentioned above.

What are the next steps? How to compile?

once downloaded you need to run the 'ant' build script (build.xml) to compile the source and create the distribution files in the 'dist' directory - you can then deploy on your j2ee container.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

I compiled but cannot find the 'dist' directory. Where is the distribution located?
[originally posted on jforum.net by Evgeny]

[Migrated From Jforum.net]

Ok, I looked at the build.xml and run "ant init", which created the "dist". Hope I did as needed to create the distribution directory.
[originally posted on jforum.net by Evgeny]

[Migrated From Jforum.net]

Do I need to convert JForum 2.1.4 database to 2.1.5 or do anything specific to database? I run MySQL 3.23. Currently cannot start 2.1.5 because of some database problem ("Error while trying to start the database")...
[originally posted on jforum.net by Evgeny]

[Migrated From Jforum.net]

Have you updated the SystemGlobals.properties file, this should have your database conenction details.

you can do a 'diff' on the database creation scripts between 2.1.4 and 2.1.5. AFAIK you should be ok.

http://www.jforum.net/install_no_wizard.jsp details a manual build/install
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Also, please keep in mind that if you are upgrading JForum you need to take a look to see if a migration script exists. Look in the file named "Readme.txt" in the root directory to see.

from the i'nstall_no_wizard' page.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

I work on this. I already have a running 2.1.4 database, it would be not easy to convert to 2.1.5, if necessary, without a ready sql script.

What is the "www" directory under "dist" ("dist/www") ? Should I do there in www anything?
[originally posted on jforum.net by Evgeny]

[Migrated From Jforum.net]

looks like a dump of the jforum website - don't worry about it, just use it for reference ;)
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

There are many changes in the database structure. Many "tinyint" and "smallint" are now "int" and there are other changes.

I currently added required "user_biography" to jforum_users
ALTER TABLE jforum_users ADD user_biography text DEFAULT NULL AFTER user_interests;

and then get exception that another column "topic_vote_id" doesn't exists (it was "topic_vote"), and this saga may continue future.

Is anyone have a script to convert 2.1.4 database to 2.1.5 ???
[originally posted on jforum.net by Evgeny]

[Migrated From Jforum.net]

Here is how I updated the database.

What to do with jforum_roles and jforum_role_values tables???
Are any tables still not updated after these lines are executed???

ALTER TABLE jforum_roles DROP user_id;
ALTER TABLE jforum_roles DROP INDEX idx_user;
ALTER TABLE jforum_sessions ADD INDEX idx_sessions_users (session_user_id);
ALTER TABLE jforum_vote_desc MODIFY vote_text varchar(255) NOT NULL default '';
ALTER TABLE jforum_vote_desc MODIFY vote_start datetime NOT NULL;
ALTER TABLE jforum_vote_voters MODIFY vote_user_ip varchar(15) NOT NULL default '';
ALTER TABLE jforum_search_results CHANGE session session_id VARCHAR(50);
ALTER TABLE jforum_search_topics CHANGE session session_id varchar(50);

ALTER TABLE jforum_users ADD user_biography text DEFAULT NULL AFTER user_interests;
ALTER TABLE jforum_topics CHANGE topic_vote topic_vote_id INT NOT NULL default 0;
ALTER TABLE jforum_search_topics CHANGE topic_vote topic_vote_id INT NOT NULL default 0;
ALTER TABLE jforum_forums ADD INDEX idx_forums_cats (categories_id);

ALTER TABLE jforum_banlist MODIFY banlist_id INT NOT NULL auto_increment;
ALTER TABLE jforum_banlist MODIFY user_id INT NOT NULL default '0';
ALTER TABLE jforum_categories MODIFY categories_id INT NOT NULL auto_increment;
ALTER TABLE jforum_categories MODIFY display_order INT NOT NULL default '0';
ALTER TABLE jforum_forums MODIFY forum_id INT NOT NULL auto_increment;
ALTER TABLE jforum_forums MODIFY categories_id INT NOT NULL default '1';
ALTER TABLE jforum_forums MODIFY forum_order INT default '1';
ALTER TABLE jforum_forums MODIFY forum_topics INT NOT NULL default '0';
ALTER TABLE jforum_forums MODIFY forum_last_post_id INT NOT NULL default '0';
ALTER TABLE jforum_groups MODIFY group_id INT NOT NULL auto_increment;
ALTER TABLE jforum_groups MODIFY parent_id INT default '0';

ALTER TABLE jforum_roles MODIFY group_id INT default '0';
ALTER TABLE jforum_posts MODIFY post_id INT NOT NULL auto_increment;
ALTER TABLE jforum_posts MODIFY topic_id INT NOT NULL default '0';
ALTER TABLE jforum_posts MODIFY forum_id INT NOT NULL default '0';
ALTER TABLE jforum_posts MODIFY user_id INT NOT NULL default '0';
ALTER TABLE jforum_posts MODIFY post_edit_count INT NOT NULL default '0';
ALTER TABLE jforum_posts_text MODIFY post_id INT NOT NULL PRIMARY KEY;
ALTER TABLE jforum_privmsgs MODIFY privmsgs_id INT NOT NULL auto_increment;
ALTER TABLE jforum_privmsgs MODIFY privmsgs_from_userid INT NOT NULL default '0';
ALTER TABLE jforum_privmsgs MODIFY privmsgs_to_userid INT NOT NULL default '0';
ALTER TABLE jforum_privmsgs_text MODIFY privmsgs_id INT NOT NULL;
ALTER TABLE jforum_ranks MODIFY rank_id INT NOT NULL auto_increment;
ALTER TABLE jforum_ranks MODIFY rank_min INT NOT NULL default '0';

ALTER TABLE jforum_sessions MODIFY session_user_id INT NOT NULL default '0';
ALTER TABLE jforum_smilies MODIFY smilie_id INT NOT NULL auto_increment;
ALTER TABLE jforum_themes MODIFY themes_id INT NOT NULL auto_increment;
ALTER TABLE jforum_topics MODIFY topic_id INT NOT NULL auto_increment;
ALTER TABLE jforum_topics MODIFY forum_id INT NOT NULL default '0';
ALTER TABLE jforum_topics MODIFY user_id INT NOT NULL default '0';
ALTER TABLE jforum_topics MODIFY topic_views INT default '1';
ALTER TABLE jforum_topics MODIFY topic_replies INT default '0';
ALTER TABLE jforum_topics MODIFY topic_vote_id INT NOT NULL default '0';
ALTER TABLE jforum_topics MODIFY topic_first_post_id INT default '0';
ALTER TABLE jforum_topics MODIFY topic_last_post_id INT NOT NULL default '0';
ALTER TABLE jforum_topics_watch MODIFY topic_id INT NOT NULL default '0';
ALTER TABLE jforum_topics_watch MODIFY user_id INT NOT NULL default '0';
ALTER TABLE jforum_users MODIFY user_id INT NOT NULL auto_increment;
ALTER TABLE jforum_users MODIFY user_session_page INT NOT NULL default '0';
ALTER TABLE jforum_users MODIFY user_posts INT NOT NULL default '0';

ALTER TABLE jforum_users MODIFY user_new_privmsg INT NOT NULL default '0';
ALTER TABLE jforum_users MODIFY user_unread_privmsg INT NOT NULL default '0';
ALTER TABLE jforum_users MODIFY rank_id INT default '1';
ALTER TABLE jforum_users MODIFY user_website varchar(255) default NULL;
ALTER TABLE jforum_users MODIFY themes_id INT default NULL;
ALTER TABLE jforum_vote_desc MODIFY vote_id INT NOT NULL auto_increment;
ALTER TABLE jforum_vote_desc MODIFY topic_id INT NOT NULL default '0';
ALTER TABLE jforum_vote_results MODIFY vote_id INT NOT NULL default '0';
ALTER TABLE jforum_vote_voters MODIFY vote_id INT NOT NULL default '0';
ALTER TABLE jforum_vote_voters MODIFY vote_user_id INT NOT NULL default '0';
ALTER TABLE jforum_vote_voters MODIFY vote_user_ip varchar(15) NOT NULL default '';
ALTER TABLE jforum_words MODIFY word_id INT NOT NULL auto_increment;

ALTER TABLE jforum_search_topics MODIFY topic_id INT NOT NULL;
ALTER TABLE jforum_search_topics MODIFY forum_id INT NOT NULL default '0';
ALTER TABLE jforum_search_topics MODIFY user_id INT NOT NULL default '0';
ALTER TABLE jforum_search_topics MODIFY topic_views INT default '1';
ALTER TABLE jforum_search_topics MODIFY topic_replies INT default '0';
ALTER TABLE jforum_search_topics MODIFY topic_first_post_id INT default '0';
ALTER TABLE jforum_search_topics MODIFY topic_last_post_id INT NOT NULL default '0';
ALTER TABLE jforum_search_topics MODIFY moderated INT default '0';

DROP TABLE IF EXISTS jforum_banner;
CREATE TABLE jforum_banner (
banner_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
banner_name VARCHAR(90),
banner_placement INT NOT NULL DEFAULT '0',
banner_description VARCHAR(250),
banner_clicks INT NOT NULL DEFAULT '0',
banner_views INT NOT NULL DEFAULT '0',
banner_url VARCHAR(250),
banner_weight TINYINT(1) NOT NULL DEFAULT '50',
banner_active TINYINT(1) NOT NULL DEFAULT '0',
banner_comment VARCHAR(250),
banner_type INT NOT NULL DEFAULT '0',
banner_width INT NOT NULL DEFAULT '0',
banner_height INT NOT NULL DEFAULT '0',
KEY(banner_id)
) TYPE=InnoDB;


You may also want to
DELETE FROM jforum_smilies;
INSERT INTO jforum_smilies <all smiles>
[originally posted on jforum.net by Evgeny]

[Migrated From Jforum.net]

Oh my god.

We did it almost in the same time. If I knew you were going to post it here, I woulnd't spent 1 hour diffing the files

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Then I woudn't spend 13:55:23 - 11:48:04. How many seconds is it?
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

It was me :lol:
[originally posted on jforum.net by Evgeny]