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

Home » FUDforum » FUDforum Installation Issues » phpBB to FUD conversion
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
phpBB to FUD conversion [message #27471] Fri, 09 September 2005 04:01 Go to next message
Crimson is currently offline  Crimson   United States
Messages: 51
Registered: June 2005
Location: Phoenix, AZ
Karma: 0
Member
add to buddy list
ignore all messages by this user
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 09: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
add to buddy list
ignore all messages by this user
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] Sun, 11 September 2005 22: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
add to buddy list
ignore all messages by this user
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] Sun, 11 September 2005 22: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
add to buddy list
ignore all messages by this user
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] Sun, 11 September 2005 22: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
add to buddy list
ignore all messages by this user
(/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 10: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
add to buddy list
ignore all messages by this user
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] Mon, 12 September 2005 23: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
add to buddy list
ignore all messages by this user
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 18: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
add to buddy list
ignore all messages by this user
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] Tue, 13 September 2005 22: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
add to buddy list
ignore all messages by this user
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 05:40 Go to previous messageGo to next message
deelay is currently offline  deelay   Germany
Messages: 4
Registered: March 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 11: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
add to buddy list
ignore all messages by this user
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 03:50 Go to previous messageGo to next message
deelay is currently offline  deelay   Germany
Messages: 4
Registered: March 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 13:05 Go to previous messageGo to next message
deelay is currently offline  deelay   Germany
Messages: 4
Registered: March 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 14:10 Go to previous 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
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Tue Jun 19 16:27:57 EDT 2018

Total time taken to generate the page: 0.00796 seconds