FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » FUDforum in eGroupWare » Migrating from egroupware to fudforum
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Migrating from egroupware to fudforum [message #21699] Fri, 10 December 2004 21:27 Go to next message
kennylam is currently offline  kennylam   Hong Kong
Messages: 4
Registered: November 2004
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I'm trying to migrate the egroupware fudforum to a standalone fudforum. However, when I try to Make forum datadump in egroupware, I found that the "admdump.php" file doesn't exist. I've tried to download that from the egroupware web cvs directory and still couldn't find one. Could anybody help me? Thanks a lot!
Re: Migrating from egroupware to fudforum [message #21705 is a reply to message #21699] Sat, 11 December 2004 16:21 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Perform this migration is a bit tricky, and is best performed manually bu dumping the sql structure and copying the messages/ and files/ directories. Then import this data into a installed forum 2.6.0 and run the upgrade script.

FUDforum Core Developer
Re: Migrating from egroupware to fudforum [message #22487 is a reply to message #21699] Fri, 04 February 2005 15:04 Go to previous messageGo to next message
jean-baptiste is currently offline  jean-baptiste   Belgium
Messages: 13
Registered: September 2004
Location: Belgium
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I'm trying to do the same thing, but i have an error when i install a forum 2.6.0.

After the step 5 of 5, i receive this message:
"No source for date_formats.tmpl"

Could anybody help me ? Thanks a lot!

Edit: this problem was resolved by cleaning my Forum Data Root.

Ilia wrote on Sat, 11 December 2004 22:21

Perform this migration is a bit tricky, and is best performed manually bu dumping the sql structure and copying the messages/ and files/ directories. Then import this data into a installed forum 2.6.0 and run the upgrade script.


Import this data ? you mean with the function in the Admin Control Panel > Forum Data Management > Import forum data ?

It don't seem to work and if i overwrite the directories and the sql data, i have SQL error.

Could anybody give me more details on this tricky migration ?

[Updated on: Fri, 04 February 2005 16:48]

Report message to a moderator

Re: Migrating from egroupware to fudforum [message #22490 is a reply to message #22487] Fri, 04 February 2005 17:29 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
After dumping the data run the upgrade script.

FUDforum Core Developer
Re: Migrating from egroupware to fudforum [message #22522 is a reply to message #22490] Sat, 05 February 2005 18:06 Go to previous messageGo to next message
jean-baptiste is currently offline  jean-baptiste   Belgium
Messages: 13
Registered: September 2004
Location: Belgium
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Ok but the update script ask me the "login & password of the administration account". When i try to enter the lofin-password of my egroupare's fudforum admin account, it doesn't work.

Can I put a new admin account directly in the sql to be able to do this update ?

Thanks !
Re: Migrating from egroupware to fudforum [message #22533 is a reply to message #22522] Sun, 06 February 2005 13:39 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Erhm...

If you are upgrading FUDforum, the upgrade tool is ONLY and ONLY going to work with a standalone FUDforum. So if you want to move from egroupware's fudforum to fudforum (standalone) you first need to import the data into the forum.


FUDforum Core Developer
Re: Migrating from egroupware to fudforum [message #22540 is a reply to message #22533] Sun, 06 February 2005 16:03 Go to previous messageGo to next message
jean-baptiste is currently offline  jean-baptiste   Belgium
Messages: 13
Registered: September 2004
Location: Belgium
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
When i try to use the import data function with my egroupware sql dump in a fresh installed Fudforum 2.6.0, i receive this error

(c:\program files\easyphp1-7\FUDforum\include\theme\default\db.inc:114
c:\program files\easyphp1-7\www\fudforum\adm\admimport.php:179
) 1146: La table 'fudforum.phpgw_fud_ses' n'existe pas
Query: DELETE FROM phpgw_fud_ses
Server Version: 4.0.15-max-debug
[Referring Page] http://127.0.0.1/fudforum/adm/admimport.php?rid=2&S=a370a4bc0181b35b030d3fc6c8d92232&SQ=6a630811874f75777e8965854ae1fd4f


After that my fudforum db is empty.

I don't really know what to do.

Thanks

[Updated on: Sun, 06 February 2005 16:04]

Report message to a moderator

Re: Migrating from egroupware to fudforum [message #22573 is a reply to message #22540] Mon, 07 February 2005 10:19 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Here is what you need to do get get your current data into standalone forum:

1) Install FUDforum 2.6.0
2) Manually (via mysqldump) backup and import forum's data tables.
3) Copy over files/ and messages/ directory.
4) Now run the upgrade script on the forum.


FUDforum Core Developer
Re: Migrating from egroupware to fudforum [message #25960 is a reply to message #22573] Mon, 27 June 2005 15:49 Go to previous messageGo to next message
bigwavesurfer is currently offline  bigwavesurfer   Germany
Messages: 9
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Ok, i have the same Problem.

>1) Install FUDforum 2.6.0
ok - it´s on a new server with a new database and the forum works.
>2) Manually (via mysqldump) backup and import forum's data tables.
Dumped all phpgw_fud_* tables with mysqldump and imported them into a new database with mysql...
>3) Copy over files/ and messages/ directory.
ok
>4) Now run the upgrade script on the forum.
doesn´t work, because I can´t login with my old Admin account

If I want to login to the new forum without upgrading it, i get <Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /homepages/26/d32713671/htdocs/sorf.wish.de/index.php on line 49>

So what to do?

Thx, Tobi
Re: Migrating from egroupware to fudforum [message #25964 is a reply to message #25960] Mon, 27 June 2005 16:38 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Check what was the error, it can be found inside the sql_errors file found inside the errors/ directory. Keep in mind that the error message is base64 encoded, so you will need to decode it 1st using PHP's base64_decode() function.

FUDforum Core Developer
Re: Migrating from egroupware to fudforum [message #25977 is a reply to message #25964] Mon, 27 June 2005 17:21 Go to previous messageGo to next message
bigwavesurfer is currently offline  bigwavesurfer   Germany
Messages: 9
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Log output:

with IE 6:

(/homepages/26/d32713671/htdocs/sorf.wish.de/index.php:286
/homepages/26/d32713671/htdocs/sorf.wish.de/index.php:374
/homepages/26/d32713671/htdocs/sorf.wish.de/index.php:434
/homepages/26/d32713671/htdocs/sorf.wish.de/index.php:1111
) 1054: Unknown column 'sys_id' in 'field list'
Query:
Server Version: 4.0.24-standard-log

with Firefox:

(/homepages/26/d32713671/htdocs/sorf.wish.de/index.php:117
/homepages/26/d32713671/htdocs/sorf.wish.de/index.php:262
/homepages/26/d32713671/htdocs/sorf.wish.de/index.php:347
/homepages/26/d32713671/htdocs/sorf.wish.de/index.php:432
/homepages/26/d32713671/htdocs/sorf.wish.de/index.php:1111
) 1054: Unknown column 's.sys_id' in 'field list'
Query: SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt, u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq FROM phpgw_fud_ses s INNER JOIN phpgw_fud_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) INNER JOIN phpgw_fud_themes t ON t.id=u.theme WHERE s.ses_id='db8cae5604a6774a5d5640c0696ab8ed'
Server Version: 4.0.24-standard-log


Tobi
Re: Migrating from egroupware to fudforum [message #25978 is a reply to message #25977] Mon, 27 June 2005 17:28 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You need to add this column, the forum's SQL structure is found inside sql/ dir.

One thing you can try doing, which will probably work is running an upgrade script. It through the course of it's operation automatically adds any missing column names.


FUDforum Core Developer
Re: Migrating from egroupware to fudforum [message #25980 is a reply to message #21699] Mon, 27 June 2005 17:37 Go to previous messageGo to next message
bigwavesurfer is currently offline  bigwavesurfer   Germany
Messages: 9
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I tried to run the upgrade scipt on the new fudforum, but i can´t login with the old admin account from the egwfud.
How can I add an new admin account manually into the sql database?

Thx for helping!
Re: Migrating from egroupware to fudforum [message #25981 is a reply to message #25980] Mon, 27 June 2005 17:41 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
It's simpler to make an existing user an admin, to do this simply set the users_opt for that user to
users_opt = users_opt | 1048576


FUDforum Core Developer
Re: Migrating from egroupware to fudforum [message #25990 is a reply to message #21699] Tue, 28 June 2005 09:15 Go to previous messageGo to next message
bigwavesurfer is currently offline  bigwavesurfer   Germany
Messages: 9
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Ok, the new forum works now. Only one problem left: The text in the messages is completely mixed up and the last posts are empty...
I transfered the old messages file to the new fud, but it seems that the text was assigned to the wrong postings. Sometimes the content of originally one posting is now spread over 2 or 3...

Any idea?

Tobi
Re: Migrating from egroupware to fudforum [message #26005 is a reply to message #21699] Wed, 29 June 2005 10:40 Go to previous messageGo to next message
bigwavesurfer is currently offline  bigwavesurfer   Germany
Messages: 9
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I compared the old and new message file and the msg table. There are no differences. What else can it be?

Tobi
Re: Migrating from egroupware to fudforum [message #26007 is a reply to message #26005] Wed, 29 June 2005 12:22 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Looks like the offset values indicating where the bodies of the message got corrupted.

Can you compare the foff,length values of the message table inside eGW and new FUDforum and see how do they differ?


FUDforum Core Developer
Re: Migrating from egroupware to fudforum [message #28716 is a reply to message #21699] Sun, 06 November 2005 15:56 Go to previous messageGo to next message
bigwavesurfer is currently offline  bigwavesurfer   Germany
Messages: 9
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi Ilia

I got a break, but now i´m once again trying to go on the migration egw->fud.
I compared the offset values foff and length in the egw forum and the new fudforum, but there are no differences. the message file didn´t get corrupted either.
It seems that every message is a little bit too long and takes over some content from the next posting.

any idea?

thx, TObi
Re: Migrating from egroupware to fudforum [message #28725 is a reply to message #21699] Mon, 07 November 2005 10:46 Go to previous messageGo to next message
bigwavesurfer is currently offline  bigwavesurfer   Germany
Messages: 9
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi

Oh finally I got it running, but there is still one problem left. The reaction of the forum is very slow. Not the Administration page, or the private Messages. Only the Categories, Threads and Postings are slow.

Tobi
Re: Migrating from egroupware to fudforum [message #28727 is a reply to message #28725] Mon, 07 November 2005 10:49 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Germany
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Did you run consistency checker? What version of the forum are you running and on what database backend?

FUDforum Core Developer
Re: Migrating from egroupware to fudforum [message #28730 is a reply to message #21699] Mon, 07 November 2005 11:11 Go to previous messageGo to next message
bigwavesurfer is currently offline  bigwavesurfer   Germany
Messages: 9
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I ran the Consistency checker and made every possible check available.

I updated fud from 2.6.0 to 2.7.3, Running on MySQL 4.0.23 and Apache/1.3.27.

THX, Tobi
Re: Migrating from egroupware to fudforum [message #28740 is a reply to message #21699] Tue, 08 November 2005 08:31 Go to previous message
bigwavesurfer is currently offline  bigwavesurfer   Germany
Messages: 9
Registered: June 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hey!

I think the speed problem was the fault of my provider - today everything is normal.

Thank you for helping and if someone needs assistance in extracting fud from egw -> ask me... Smile

Tobi
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Private Messages Counter Not Working
Next Topic: Création de sous-catégorie et/ou sous forum (Creation of subcategory and/or subforum)
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 18 15:38:20 EST 2017

Total time taken to generate the page: 0.01068 seconds