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

Home » FUDforum Development » Converters » Trouble Converting from Phorum
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Trouble Converting from Phorum [message #4164] Wed, 17 July 2002 12:49 Go to next message
Arawak is currently offline  Arawak   Canada
Messages: 7
Registered: July 2002
Location: London, Canada
Karma: 0
Junior Member

Hi....

I'm in the process of setting up FUD so we can play and hopefully switch over from Phorum. We just switched from PHPBB not that long ago, so another switch would have to be painless to our users or there will be much complaining <grin>.

I dumped the Phorum db and loaded it into a spare database (mysql) and made a copy of the Phorum setting directory with the appropriate changes to reference the new db.

The install went okay, but I'm having problems converting.

--------SNIP----------
Warning: Failed opening '/home/ryansgate/www/forum/include/theme/default/static/glob.inc' for inclusion (include_path='') in /home/ryansgate/www/forum/include/core.inc on line 54

query failed: %( DELETE FROM cat )% because %( Table 'phpBB3.cat' doesn't exist )%

--------SNIP----------

The actual problem seems to lie in permissions. FUD is pretty aggressive with permissions and I am basically locked out as all the important directories now belong to the webserver user and group. This is on an ISP's server and I have no root access (makes me feel kinda naked, really) to change permissions.

As a result, I think the script can't get at the MYSQL_TBL_PREFIX and thus can't find the tables it wants.

The file manager is somewhat helpful, but I can't fix the permissions in the settings dir in my home directory with it.

I've seen some else somewhere here mention this permissions trouble.

Any ideas?

Arawak





Re: Trouble Converting from Phorum [message #4165 is a reply to message #4164] Wed, 17 July 2002 13:48 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
Few questions that I hope you can supply me answers with.

1) Are you running the conversion script from the web or shell?
(you should be running it from the web).
If you want to run it via the shell then you need to:
to to admin control panel and use the File Lock/Unlock admin panel to unlock files 1st.
2) Is the conversion script located inside forum's main web dir?
(if not move it there).
3) What FUDforum version are you using?


FUDforum Core Developer
Re: Trouble Converting from Phorum [message #4166 is a reply to message #4165] Wed, 17 July 2002 14:19 Go to previous messageGo to next message
Arawak is currently offline  Arawak   Canada
Messages: 7
Registered: July 2002
Location: London, Canada
Karma: 0
Junior Member

Thanks for your reply!

1) Running it from the web

2) yes

3) I think it's FUDforum 2.2.3 - I just downloaded it yesterday

Arawak
Re: Trouble Converting from Phorum [message #4167 is a reply to message #4166] Wed, 17 July 2002 15:12 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
The upgrade script attached should work fine.
  • Attachment: phorum.php
    (Size: 12.70KB, Downloaded 1027 times)


FUDforum Core Developer
Re: Trouble Converting from Phorum [message #4168 is a reply to message #4167] Wed, 17 July 2002 15:31 Go to previous messageGo to next message
Arawak is currently offline  Arawak   Canada
Messages: 7
Registered: July 2002
Location: London, Canada
Karma: 0
Junior Member

Well, it went further....

--------SNIP----------
Importing Categories
Finished Importing (1) Categories
Importing Forums 0
Cricket Talk
General Chitty Chat
Admin Forum
Caribbean Cricket Crew
Finished Importing Forums
Unknown column 'login' in 'group statement'
--------SNIP----------

I've attached a schema dump, if that helps.

Arawak
  • Attachment: cc_phorum.txt
    (Size: 7.89KB, Downloaded 1086 times)
Re: Trouble Converting from Phorum [message #4171 is a reply to message #4168] Wed, 17 July 2002 17:15 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
Which version of Phorum is this?

FUDforum Core Developer
Re: Trouble Converting from Phorum [message #4172 is a reply to message #4171] Wed, 17 July 2002 18:53 Go to previous messageGo to next message
Arawak is currently offline  Arawak   Canada
Messages: 7
Registered: July 2002
Location: London, Canada
Karma: 0
Junior Member

It's 3.3.2a..... I just noticed that there is now 3.3.2b3.

Perhaps the schema has changed??? I can always upgrade Phorum and try again.

Arawak
Re: Trouble Converting from Phorum [message #4173 is a reply to message #4172] Wed, 17 July 2002 19:04 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
The upgrade script is known to work with 3.3.3 release, for which it has been written by me. It should work from that release fine.
If you can it would be better if you could upgrade to that release and try the upgrade script I've included in my previous message.


FUDforum Core Developer
Re: Trouble Converting from Phorum [message #4174 is a reply to message #4173] Wed, 17 July 2002 19:13 Go to previous messageGo to next message
Arawak is currently offline  Arawak   Canada
Messages: 7
Registered: July 2002
Location: London, Canada
Karma: 0
Junior Member

Er.... 3.3.3????

the latest shown on http://phorum.org/download.php is Phorum Version 3.3.2c.

Arawak
Re: Trouble Converting from Phorum [message #4175 is a reply to message #4174] Wed, 17 July 2002 19: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
Oops my mistake that is what I ment, sorry Sad

FUDforum Core Developer
Re: Trouble Converting from Phorum [message #4176 is a reply to message #4175] Wed, 17 July 2002 19:22 Go to previous messageGo to next message
Arawak is currently offline  Arawak   Canada
Messages: 7
Registered: July 2002
Location: London, Canada
Karma: 0
Junior Member

No problem, man.... thanks for all your help, I'll let you know how I make out.

Arawak
Re: Trouble Converting from Phorum [message #4230 is a reply to message #4176] Thu, 18 July 2002 17:15 Go to previous message
Arawak is currently offline  Arawak   Canada
Messages: 7
Registered: July 2002
Location: London, Canada
Karma: 0
Junior Member

Nah... no luck.

Dumped the test DB and then reloaded a copy of the real board. Got a copy of everything all working.

Converted to phorum-3.3.2c successfully. (logged in, posted, etc)

Ran phorum.php (via http) and got the same thing:

-------------SNIP-------------
Importing Categories
Finished Importing (1) Categories
Importing Forums 0
West Indies Cricket Talk
General Chitty Chat
Admin Forum
Caribbean Cricket Crew
Finished Importing Forums
Unknown column 'login' in 'group statement'
-------------SNIP-------------

Unfortunately I have exhausted about all the time I have to spend on this so we'll just have to stick with Phorum for now.

Nonetheless, I appreciate the help you've given me.... perhaps if I come back to it in the future I can impose upon you again....

Arawak
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: phorum2fud???
Next Topic: help me!
Goto Forum:
  

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

Current Time: Sun Nov 24 01:52:59 GMT 2024

Total time taken to generate the page: 0.02724 seconds