|
|
Re: Migrating from egroupware to fudforum [message #22487 is a reply to message #21699] |
Fri, 04 February 2005 15:04   |
jean-baptiste
 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 #22540 is a reply to message #22533] |
Sun, 06 February 2005 16:03   |
jean-baptiste
 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 #25960 is a reply to message #22573] |
Mon, 27 June 2005 15:49   |
|
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 #25977 is a reply to message #25964] |
Mon, 27 June 2005 17:21   |
|
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 #25990 is a reply to message #21699] |
Tue, 28 June 2005 09:15   |
|
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 #28716 is a reply to message #21699] |
Sun, 06 November 2005 15:56   |
|
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
|
|
|
|
|
|
|