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

Home » General » FUDforum in eGroupWare » Migrating from Fudforum 2.3.8 to Egw's 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 Fudforum 2.3.8 to Egw's Fudforum [message #19822] Tue, 07 September 2004 04:45 Go to next message
maramao is currently offline  maramao   Italy
Messages: 6
Registered: September 2004
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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:
Quota:

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://89.1.0.116/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://89.1.0.117/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
/var/wssl/egroupware3/fudforum/3777400789/index.php:205
/var/wssl/egroupware3/fudforum/3777400789/index.php:274
/var/wssl/egroupware3/fudforum/3777400789/index.php:392
) 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://89.1.0.117/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!
Re: Migrating from Fudforum 2.3.8 to Egw's Fudforum [message #19884 is a reply to message #19822] Wed, 15 September 2004 01:23 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
try clearing out the sessions table of fudforum.

FUDforum Core Developer
Re: Migrating from Fudforum 2.3.8 to Egw's Fudforum [message #19910 is a reply to message #19884] Thu, 16 September 2004 03:49 Go to previous messageGo to next message
maramao is currently offline  maramao   Italy
Messages: 6
Registered: September 2004
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
The sessions table of fudforum is "phpgw_fud_ses"?
If so, I have already tried to clear it out. Sad

Cleared phpgw_fud_ses, Egw's Fudforum allow me to login only once for each account.
While I attempt to login for the second time (for each account) gives me back the following error message:
Quota:

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.e. I'm in Egw but can't get in Fudforum.

The only way to be able to login again in Fud is to clear out the phpgw_fud_ses table. Here we're again!!!
Re: Migrating from Fudforum 2.3.8 to Egw's Fudforum [message #19942 is a reply to message #19910] Thu, 16 September 2004 22:11 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
Aha I think I see the problem.

Inside the users table you have a theme field, you need to ensure that all users have a valid theme id in there.

Themes are stored inside the phpgw_fud_themes table
you want a theme where the theme_opts is 3 (2|1) meaning enabled & default theme.


FUDforum Core Developer
Re: Migrating from Fudforum 2.3.8 to Egw's Fudforum [message #24310 is a reply to message #19942] Fri, 22 April 2005 09:51 Go to previous message
maramao is currently offline  maramao   Italy
Messages: 6
Registered: September 2004
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi Ilia,
I'm back again, sorry for long time passed since last message... setting up 3 new server, I hope you understand Sad
I'll come to write you back as soon as our testing on egroupware starts again
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: 404 Error
Next Topic: Fudforum not working after upgrade 1.0.0.007
Goto Forum:
  

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

Current Time: Sat Oct 21 08:19:25 EDT 2017

Total time taken to generate the page: 0.00676 seconds