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

Home » FUDforum » FUDforum Installation Issues » phpBB to FUD conversion
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
phpBB to FUD conversion [message #27471] Fri, 09 September 2005 08:01 Go to next message
Crimson is currently offline  Crimson   United States
Messages: 51
Registered: June 2005
Location: Phoenix, AZ
Karma: 0
Member
I'm converting another phpBB forum to FUD and the conversion is just not working. I tried recreating the forum in question and moving all the threads to it, but no dice. Where should I start in troubleshooting this?

(/htdocs/util_n00bstories/FUDforum/include/theme/default/db.inc:73<br />
/htdocs/util_n00bstories/FUDforum/include/theme/default/db.inc:40<br />
/htdocs/util_n00bstories/FUDforum/include/theme/default/imsg_edt.inc:506<br />
/htdocs/n00bstories.com/forums/phpBB2.php:522<br />
) 1146: Table 'n00bstories_FUD.fud_fl_10' doesn't exist<br />
Query: LOCK TABLES fud_fl_10 WRITE<br />
_POST: array (
  'frm_cat_id' =&gt; '8',
  'frm_name' =&gt; 'Archives',
  'frm_descr' =&gt; 'Posts from forums that have been removed, kept for posterity.',
  'frm_forum_opt' =&gt; 16,
  'frm_max_file_attachments' =&gt; 1,
  'frm_max_attach_size' =&gt; 1024,
)<br />
Server Version: 4.1.12-standard<br />
Re: phpBB to FUD conversion [message #27485 is a reply to message #27471] Fri, 09 September 2005 13:56 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
Apply this patch and it'll work:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7313


FUDforum Core Developer
Re: phpBB to FUD conversion [message #27541 is a reply to message #27471] Mon, 12 September 2005 02:04 Go to previous messageGo to next message
Crimson is currently offline  Crimson   United States
Messages: 51
Registered: June 2005
Location: Phoenix, AZ
Karma: 0
Member
Now the error is slightly changed...

(/htdocs/util_n00bstories/FUDforum/include/theme/default/db.inc:73<br />
/htdocs/n00bstories.com/forums/phpBB2.php:418<br />
) 1050: Table 'fud_fl_48' already exists<br />
Query: RENAME TABLE fud_fl_183 TO fud_fl_48<br />
_POST: array (
  'frm_cat_id' =&gt; '5',
  'frm_name' =&gt; 'Premium Accounts',
  'frm_descr' =&gt; 'Those with Premium Accounts can talk here without n00b interference!',
  'frm_forum_opt' =&gt; 16,
  'frm_max_file_attachments' =&gt; 1,
  'frm_max_attach_size' =&gt; 1024,
)<br />
Server Version: 4.1.12-standard<br />
Re: phpBB to FUD conversion [message #27542 is a reply to message #27471] Mon, 12 September 2005 02:06 Go to previous messageGo to next message
Crimson is currently offline  Crimson   United States
Messages: 51
Registered: June 2005
Location: Phoenix, AZ
Karma: 0
Member
Wait... I should reinstall fresh before I run the conversion again... probably an old table. Trying again...
Re: phpBB to FUD conversion [message #27543 is a reply to message #27471] Mon, 12 September 2005 02:20 Go to previous messageGo to next message
Crimson is currently offline  Crimson   United States
Messages: 51
Registered: June 2005
Location: Phoenix, AZ
Karma: 0
Member
(/htdocs/util_n00bstories/FUDforum/include/theme/default/db.inc:73<br />
/htdocs/util_n00bstories/FUDforum/include/theme/default/db.inc:40<br />
/htdocs/util_n00bstories/FUDforum/include/theme/default/imsg_edt.inc:506<br />
/htdocs/n00bstories.com/forums/phpBB2.php:523<br />
) 1146: Table 'n00bstories_FUD.fud_fl_10' doesn't exist<br />
Query: LOCK TABLES fud_fl_10 WRITE<br />
_POST: array (
  'frm_cat_id' =&gt; '8',
  'frm_name' =&gt; 'Archives',
  'frm_descr' =&gt; 'Posts from forums that have been removed, kept for posterity.',
  'frm_forum_opt' =&gt; 16,
  'frm_max_file_attachments' =&gt; 1,
  'frm_max_attach_size' =&gt; 1024,
)<br />
Server Version: 4.1.12-standard<br />


Fresh install, I think this is the same error...
Re: phpBB to FUD conversion [message #27550 is a reply to message #27543] Mon, 12 September 2005 14:13 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
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7323

This should do the trick.


FUDforum Core Developer
Re: phpBB to FUD conversion [message #27578 is a reply to message #27471] Tue, 13 September 2005 03:20 Go to previous messageGo to next message
Crimson is currently offline  Crimson   United States
Messages: 51
Registered: June 2005
Location: Phoenix, AZ
Karma: 0
Member
My forum is version 2.0.1 which is insanely old. I have been manually patching exploits on it. Of course I already know I'm a moron at this point for letting it get this bad. But I'm TRYING to improve to a forum written by someone who knows what they're doing.

I think the problems I am having are related to that... the database structure is probably not what your converter is expecting to see by now. The converter said it's for version 2.0.X so I thought it would be OK.

I think next I should try getting the current forum upgraded to the latest version and see if the mysql db changes allow your converter to do the trick. I didn't post this expecting you to change your software around... I believe this to be a problem with MY data being so old, not your software which worked perfectly on the other forum I moved away from the Dark Side.

Then again, maybe this error is easily fixed and the transformation will be complete.

Current error (once again after a fresh install of FUD):
<b>Notice</b>:  Undefined offset:  10 in <b>/htdocs/n00bstories.com/forums/phpBB2.php</b> on line <b>491</b><br />
(/htdocs/util_n00bstories/FUDforum/include/theme/default/db.inc:73<br />
/htdocs/n00bstories.com/forums/phpBB2.php:500<br />
) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
                        110,
                        110,
                        66,
                        3,
                        1000000000,
                        0,
                        1028524321<br />
Query: INSERT INTO fud_thread (
                        id, forum_id, root_msg_id, last_post_id, views, thread_opt, orderexpiry, moved_to, last_post_date,
                        replies
                        ) VALUES(
                        23,
                        ,
                        110,
                        110,
                        66,
                        3,
                        1000000000,
                        0,
                        1028524321,
                        0)
                <br />
_POST: array (
  'frm_cat_id' =&gt; '8',
  'frm_name' =&gt; 'Archives',
  'frm_descr' =&gt; 'Posts from forums that have been removed, kept for posterity.',
  'frm_forum_opt' =&gt; 16,
  'frm_max_file_attachments' =&gt; 1,
  'frm_max_attach_size' =&gt; 1024,
)<br />
Server Version: 4.1.12-standard<br />
Re: phpBB to FUD conversion [message #27588 is a reply to message #27578] Tue, 13 September 2005 22:06 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
Try this version, it has proper validation checks
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7328


FUDforum Core Developer
Re: phpBB to FUD conversion [message #27589 is a reply to message #27471] Wed, 14 September 2005 02:55 Go to previous messageGo to next message
Crimson is currently offline  Crimson   United States
Messages: 51
Registered: June 2005
Location: Phoenix, AZ
Karma: 0
Member
Conversion of phpBB2 to FUDforum2 has been completed
Time Taken: 2764 seconds

YAY! Thanks SO much!
Re: phpBB to FUD conversion [message #36235 is a reply to message #27471] Fri, 09 March 2007 10:40 Go to previous messageGo to next message
deelay is currently offline  deelay   Germany
Messages: 4
Registered: March 2007
Karma: 0
Junior Member
hey Wink

i installed successfully a fud forum and all is working fine !!! naow i like to convert my old phpbb into fud but i dont know how?

please can you tell me what i have to do with these scrips ?? how do i convert the mysql database?

thanks a lot for help !!!!!
Re: phpBB to FUD conversion [message #36259 is a reply to message #36235] Sun, 11 March 2007 15:01 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
You need to run the phpbb conversion script that you can find on the download page.

FUDforum Core Developer
Re: phpBB to FUD conversion [message #36282 is a reply to message #27471] Tue, 13 March 2007 07:50 Go to previous messageGo to next message
deelay is currently offline  deelay   Germany
Messages: 4
Registered: March 2007
Karma: 0
Junior Member
year, i know but the script isn´t working right. i allways get this massage:
Unable to open phpBB2 configuration at '/srv/www/vhosts/xxxxx.net/httpsdocs/config.php'.

i really don´t know whats wrong!? please can you help !

thanks
Re: phpBB to FUD conversion [message #36287 is a reply to message #27471] Tue, 13 March 2007 17:05 Go to previous messageGo to next message
deelay is currently offline  deelay   Germany
Messages: 4
Registered: March 2007
Karma: 0
Junior Member
sorry for double posting !!

i converted the phpbb local with xampp and all is working fine!!

but now i moved the fud to my webspace and changed the settings in GLOBALS.php but i´ve only a white site ... please can you tell me what files do i need to edit if i move the board to a new server.

do i have to chnage something in the mysqldb ???
Re: phpBB to FUD conversion [message #36346 is a reply to message #36287] Sun, 18 March 2007 18:10 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You need to update GLOBALS.php inside the include directory, make sure there are symlinks to this file inside the forum's web root and adm/ directories. The login as admin and rebuild the theme.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Fud forum in blank! Please help.
Next Topic: Warning: Division by zero in pmsg.php?
Goto Forum:
  

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

Current Time: Sat May 18 15:58:44 GMT 2024

Total time taken to generate the page: 0.03123 seconds