|Migrating from Fudforum 2.3.8 to Egw's Fudforum [message #19822]
||Tue, 07 September 2004 04:45
Hallo and first of all, sorry for my english.|
I use Fudforum 2.3.8 and I would like to insert it in Egw 1.0.0.004, keeping the same users and accounts.
I know that Egw requires Fudforum 2.6.0 and then I upgraded my Fud version. Then I installed Egw. Through here everything worked fine.
I modified manually the fud23_users table to obtain the one in Egw called phpgw_accounts considering the following equivalences:
fud23_users---> phpgw_accounts default value for all lines
id ---> account_id
login ---> account_lid
passwd ---> account_pwd
name ---> account_firstname
account_lastname <--- NULL
account_lastlogin <--- NULL
account_lastloginfrom <--- NULL
account_lastpwd_change <--- NULL
account_status <--- 'A'
account_expires <--- -1
account_type <--- 'u'
person_id <--- 0
account_primary_group <--- 2
email ---> account_email
and imported it inside egroupware db.
Now, in Egw I have 350 accounts, everyone with its original password. Through here everything worked fine.
I logged-in in Egw and then in Fudforum inside Egw, automatically all accounts were tranferred in phpgw_fud_users, but alfabetically according login value.
In order to keep the consistency between the posts with the users as in our "old" Fudfourum, I deleted the table automatically created by Egw and substituted it with fud23_users, substituting "sq" in "egw_id" ("egw_id"="account_id" of phpgw_accounts table).
Now I can login in Egw and Egw's Fud with every account.
I imported all data of "old" Fud inside Egw's Fud i.e.
- /var/forum/messages/msg_1 --> /var/egroupware/fudforum/3777400789/messages/msg_1
- /var/forum/files/* --> /var/egroupware/fudforum/3777400789/files/*
- 48 db tables (all exept fud23_users).
Now, I login as any user in both Egw and Fudforum and surf in topics and posts, but it works only for one session.
Infact, the second login gives me back the following error message while I attempt to get inside fudforum:
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /var/wssl/egroupware3/fudforum/3777400789/index.php on line 71
I tried to work it out and discovered the following:
- phpgw_fud_ses table contains:
| id | ses_id | sys_id | user_id | action | forum_id | time_sec | data | returnto |
| 4 | a3dffa82ebf13f3751aa0890f3bc3500 | 5e9dd7544d795744ece7298ead0eabb7 | 2131678313 | Sfoglia l'<a href="https://22.214.171.124/forum2/index.php?t=index">elenco dei forum</a> | 0 | 1091714979 | NULL |t=index&c=0:0:0:0:0:0:0:01:07:06:02:0:01:00:01:08:0:0:0:0:03:02:08:06: 0:05:09:0:02:01:00:0:09:0:0:09:0:06:0:0:0:06:09:0:03:02:08:00:0:0_17:16:0_1 5:1_10:11:0_19:11:00:02:0:0_7:1_6:1_4:1:0:0_3:11:04:01:0:03:06:0:03:05:01:0 :02:0_26:18:07:08:01:07:0_21:17:03: |
| 5 | 846a769a0947000253dd71a28c46ed3b | 0 | 353 | Sfoglia l'<a href="https://126.96.36.199/egroupware3/fudforum/3777400789/index.php?t=index" class="GenLink">elenco dei forum</a> | 0 | 1094544325 | NULL |
- I emptied phpgw_fud_ses table to login again, I checked error log viewer in Fudforum Admin Control Panel and last line was:
Tue Sep 7 8:05:47 GMT 2004 (/var/wssl/egroupware3/fudforum/3777400789/index.php:131
) 1062: Duplicate entry '353' for key 3
Query: INSERT INTO phpgw_fud_ses (user_id, ses_id, time_sec) VALUES(353, '14102694e49a32ced77e80378b44ecfe', 1094544347)
Server Version: 3.23.58
[Referring Page] https://188.8.131.52/egroupware3/index.php?date=20040907&menuaction=calen dar.uicalendar.day.
I stopped here and don't know how to go on!
I don't know if the description is sufficiently clear.
Thanks in advance,any help will be appreciated!