FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum Development » Bug Reports » phpBB2 converter does not work
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
phpBB2 converter does not work [message #26232] Mon, 11 July 2005 17:16 Go to next message
schst is currently offline  schst   Germany
Messages: 7
Registered: July 2005
Karma: 0
Junior Member
When converting my old phpBB2 based forum using the supplied converter, I'm getting the following error messages:

Beginning Conversion Process
Reading phpBB2 config
Done: Reading phpBB2 config
Importing Smilies: 42
Finished Importing Smilies
Importing Avatar Galleries
from: /var/www/schst/forum-old.php-tools.net/htdoc/images/avatars/gallery/
Finished Importing Avatar Galleries, 0 avatars improted
Importing Users 307

Notice: Undefined variable: dest in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 354

Notice: Undefined variable: im in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 354
(/home/httpd/schst/forum.php-tools.net/FUDforum/include/theme/default/db.in c:123
/home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php:355
) 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 ' users_opt=(users_opt & ~ 4194304)|8388608, avatar_loc='
Query: UPDATE fud26_users SET avatar=, users_opt=(users_opt & ~ 4194304)|8388608, avatar_loc='<img src="" >' WHERE id=6
Server Version: 4.0.24_Debian-10-log

If I modify the script so it ignores the missing avatars, it still won't work:

Beginning Conversion Process
Reading phpBB2 config
Done: Reading phpBB2 config
Importing Smilies: 42
Finished Importing Smilies
Importing Avatar Galleries
from: /var/www/schst/forum-old.php-tools.net/htdoc/images/avatars/gallery/
Finished Importing Avatar Galleries, 0 avatars improted
Importing Users 307

Notice: Undefined variable: dest in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 355

Notice: Undefined variable: im in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 355

Notice: Undefined variable: dest in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 355

Notice: Undefined variable: im in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 355
user: topdog
WARNING: missing avatar file: /var/www/schst/forum-old.php-tools.net/htdoc/images/avatars/13641177584072b 4a36b08c.gif

Notice: Undefined variable: dest in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 355

Notice: Undefined variable: im in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 355

Notice: Undefined variable: dest in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 355

Notice: Undefined variable: im in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 355

Notice: Undefined variable: dest in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 355

Notice: Undefined variable: im in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 355
user: Caelian
WARNING: missing avatar file: /var/www/schst/forum-old.php-tools.net/htdoc/images/avatars/20155208641abc7 579492f.png
Finished Importing Users
Importing Categories 2
Finished Importing Categories
Importing Forums 11
Finished Importing Forums
Importing Moderators
Finished Importing Moderators
Importing Topics 441
Finished Importing Topics
Importing Messages 1265
(/home/httpd/schst/forum.php-tools.net/FUDforum/include/theme/default/db.in c:123
/home/httpd/schst/forum.php-tools.net/FUDforum/include/theme/default/db.inc :90
/home/httpd/schst/forum.php-tools.net/FUDforum/include/theme/default/imsg_e dt.inc:507
/home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php:503
) 1146: Table 'php-tools-fudforum.fud26_fl_2' doesn't exist
Query: LOCK TABLES fud26_fl_2 WRITE
_POST: frm_cat_id=2&frm_name=Other patTools&frm_descr=This board can be used to ask questions related to all our other tools.&frm_forum_opt=16&frm_max_file_attachments=1&frm_max_atta ch_size=1024&
Server Version: 4.0.24_Debian-10-log

Stephan

Report message to a moderator

Re: phpBB2 converter does not work [message #26233 is a reply to message #26232] Mon, 11 July 2005 17:34 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
Hi Stephan, the forum import problem has already been fixed in later version of the phpBB converter you download right now from the download page.

The avatar problem, seems to be caused by the unknown (as far as FUDforum goes) avatar type, which was left un handled. I've added a fix for it in the attached conversion script.
  • Attachment: phpBB2.php
    (Size: 27.59KB, Downloaded 804 times)


FUDforum Core Developer

Report message to a moderator

Re: phpBB2 converter does not work [message #26237 is a reply to message #26233] Mon, 11 July 2005 17:52 Go to previous messageGo to next message
schst is currently offline  schst   Germany
Messages: 7
Registered: July 2005
Karma: 0
Junior Member
I downloaded the converter script about 60 minutes ago, did you publish a new version again?

Stephan

Report message to a moderator

Re: phpBB2 converter does not work [message #26238 is a reply to message #26237] Mon, 11 July 2005 17:55 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
No, that should've been find regarding the forum error you've seen. Ca you non-the-less try the newer script I've attached and see what errors do you get.

If you still get the SQL query failure, could you see what the following query returns:

show tables like 'fud26_fl_%'

FUDforum Core Developer

Report message to a moderator

Re: phpBB2 converter does not work [message #26244 is a reply to message #26232] Mon, 11 July 2005 21:28 Go to previous messageGo to next message
schst is currently offline  schst   Germany
Messages: 7
Registered: July 2005
Karma: 0
Junior Member
With the attached version I get:

Beginning Conversion Process
Reading phpBB2 config
Done: Reading phpBB2 config
Importing Smilies: 42
Finished Importing Smilies
Importing Avatar Galleries
from: /var/www/schst/forum-old.php-tools.net/htdoc/images/avatars/gallery/
Finished Importing Avatar Galleries, 0 avatars improted
Importing Users 307

Notice: Undefined variable: dest in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 358

Notice: Undefined variable: im in /home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php on line 358
(/home/httpd/schst/forum.php-tools.net/FUDforum/include/theme/default/db.in c:123
/home/httpd/schst/forum.php-tools.net/htdoc/phpBB2.php:359
) 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 ' users_opt=(users_opt & ~ 4194304)|8388608, avatar_loc='
Query: UPDATE fud26_users SET avatar=, users_opt=(users_opt & ~ 4194304)|8388608, avatar_loc='<img src="" >' WHERE id=6
Server Version: 4.0.24_Debian-10-log

And the SQL query returns:

fud26_fl_1
fud26_fl_11
fud26_fl_12
fud26_fl_13
fud26_fl_14
fud26_fl_15
fud26_fl_16
fud26_fl_17
fud26_fl_18
fud26_fl_19
fud26_fl_20
fud26_fl_21
fud26_fl_22
fud26_fl_23
fud26_fl_24
fud26_fl_25
fud26_fl_26
fud26_fl_27
fud26_fl_28
fud26_fl_29
fud26_fl_3
fud26_fl_30
fud26_fl_31
fud26_fl_32
fud26_fl_33
fud26_fl_34
fud26_fl_35
fud26_fl_36
fud26_fl_37
fud26_fl_38
fud26_fl_39
fud26_fl_40
fud26_fl_41
fud26_fl_pm

But I do not have that much forums in my old installation. If you want to, I could make the DB dump of the phpBB installation available.

Stephan

Report message to a moderator

Re: phpBB2 converter does not work [message #26245 is a reply to message #26244] Mon, 11 July 2005 21:34 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
If you can send me the dump and I'll try the conversion script tonight and see why things are going wrong.

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Smilies in [code] boxes
Next Topic: Quirk while upgrading from 2.6.0 to 2.6.14
Goto Forum:
  

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

Current Time: Sun Nov 24 05:03:54 GMT 2024

Total time taken to generate the page: 0.02537 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software