News:

SMF 2.1.6 has been released! Take it for a spin! Read more.

Main Menu

Conversion problems

Started by HellzB, August 01, 2009, 11:25:06 PM

Previous topic - Next topic

HellzB

Converting members... Unsuccessful!
This query:

    SELECT value
    FROM `GIIPBBoard`.smf_settings
    WHERE variable = 'attachmentUploadDir'
    LIMIT 1;

Caused the error:

    Table 'GIIPBBoard.smf_settings' doesn't exist



I don't really know what to do. I've tried everything I know how to. If you want to help via TeamViewer of MSN my MSN is "[email protected]".

Thanks.

ThorstenE

Table 'GIIPBBoard.smf_settings' doesn't exist
the settings table from SMF is missing..
You should install  /re-install SMF before you start the conversion.
Converting to SMF

HellzB

#2
Wow I feel dumb. I was install IPB thinking I was instaling SMF. Got past that part now I'm getting:

Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1249237634),
    ("conversion_from", "invision23_to_smf.sql");

Caused the error:

    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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1249237634)' at line 1




Edit: Ya I don't know what I did but some how it's saying IPB but at the bottom it says powered by SMF. hxxp:www.globalinfection.net/indexblah [nonactive]

HellzB

Well thanks for the help. Everything seems to have converted fine but I get this:

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-4.png) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-5.jpg) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-19.jpg) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-31.jpg) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-44.jpg) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-47.gif) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-60.png) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-75.jpg) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-107.png) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-132.gif) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-271.jpg) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-330.jpg) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 58

Warning: copy(/av-387.jpg) [function.copy]: failed to open stream: No such file or directory in /home/content/g/l/o/globalinfect/html/forum/convert.php(1109) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1249318538),
    ("conversion_from", "invision23_to_smf.sql");

Caused the error:

    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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1249318538)' at line 1



Anything to worry about?

Advertisement: