| Migrating from egroupware to fudforum [message #21699] |
Sat, 11 December 2004 02:27  |
kennylam
Messages: 4
Registered: November 2004
Karma: 0
|
Junior Member |
|
|
|
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 21:21  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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 20:04 |
jean-baptiste
Messages: 13
Registered: September 2004
Location: Belgium
Karma: 0
|
Junior Member |
|
|
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 21:48] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Migrating from egroupware to fudforum [message #22533 is a reply to message #22522] |
Sun, 06 February 2005 18:39 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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 21:03 |
jean-baptiste
Messages: 13
Registered: September 2004
Location: Belgium
Karma: 0
|
Junior Member |
|
|
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 21:04] Report message to a moderator |
|
|
|
| Re: Migrating from egroupware to fudforum [message #22573 is a reply to message #22540] |
Mon, 07 February 2005 15:19 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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 #25964 is a reply to message #25960] |
Mon, 27 June 2005 20:38 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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 21:21 |
bigwavesurfer
Messages: 9
Registered: June 2005
Karma: 0
|
Junior Member |
|
|
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 21:28 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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 #26007 is a reply to message #26005] |
Wed, 29 June 2005 16:22 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]