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:
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]]>schst2005-07-11T17:16:48-00:00Re: phpBB2 converter does not work
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=26233&th=5341#msg_26233
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.
]]>Ilia2005-07-11T17:34:21-00:00Re: phpBB2 converter does not work
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=26237&th=5341#msg_26237
Stephan]]>schst2005-07-11T17:52:47-00:00Re: phpBB2 converter does not work
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=26238&th=5341#msg_26238
If you still get the SQL query failure, could you see what the following query returns:
show tables like 'fud26_fl_%']]>Ilia2005-07-11T17:55:21-00:00Re: phpBB2 converter does not work
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=26244&th=5341#msg_26244
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
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]]>schst2005-07-11T21:28:00-00:00Re: phpBB2 converter does not work
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=26245&th=5341#msg_26245
Ilia2005-07-11T21:34:42-00:00