• Welcome to Simple Machines Community Forum. Please login or sign up.
December 05, 2021, 04:20:26 PM

News:

SMF 2.0.18 has been released! Please update. Read more.


MiniBB to SMF Problem

Started by peter_anderson, November 23, 2008, 08:10:31 AM

Previous topic - Next topic

peter_anderson

November 23, 2008, 08:10:31 AM Last Edit: November 23, 2008, 08:14:15 AM by peter_anderson
Hi

I am trying to convert from MiniBB (which sucks, really) to SMF 1.1.7.

But I get teh following error after installing it, and going to convert.php:
"Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MiniBB 2.0. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: 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 '.TABLE PREFIX WAS HERE_users' at line 2"

They are on the same DB, and same user, but with different table prefixes. My SMF is in /forum and my MiniBB is in /forums.

Can anyone help?

Thanks

(I checked the sticky - none of that code is in the MiniBB convertor - I checked every line)

ThorstenE

your miniBB has a file named setup_options.php. can you check this and edit that file..

there should be a similar part in your setup_options.php (different dbusr, dbname, dbpwd)
$DB='mysql';

$DBhost='localhost';
$DBname='minibb';
$DBusr='root';
$DBpwd='root';

$Tf='minibbtable_forums';
$Tp='minibbtable_posts';
$Tt='minibbtable_topics';
$Tu='minibbtable_users';
$Ts='minibbtable_send_mails';
$Tb='minibbtable_banned';

is that file existing? you should also verify the pathes to both forums in convert.php

peter_anderson

November 23, 2008, 08:53:52 AM #2 Last Edit: November 23, 2008, 09:01:32 AM by peter_anderson
Quote from: TE on November 23, 2008, 08:39:29 AM
your miniBB has a file named setup_options.php. can you check this and edit that file..

there should be a similar part in your setup_options.php (different dbusr, dbname, dbpwd)
$DB='mysql';

$DBhost='localhost';
$DBname='minibb';
$DBusr='root';
$DBpwd='root';

$Tf='minibbtable_forums';
$Tp='minibbtable_posts';
$Tt='minibbtable_topics';
$Tu='minibbtable_users';
$Ts='minibbtable_send_mails';
$Tb='minibbtable_banned';

is that file existing? you should also verify the pathes to both forums in convert.php

Yeah, that's all set-up, as my forum is already live (the miniBB one)

EDIT: I tried again, and I get teh following error:
-
Notice: Undefined index: convert_script in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 810

Warning: Invalid argument supplied for foreach() in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 813

Notice: Undefined index: convert_script in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 825

Notice: Undefined index: convert_script in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 721
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1208

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1218

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1226

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1249

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1262

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1308

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1310

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1316

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1322

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1333

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1334

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1342

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1344

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1350

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1351

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1357

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1358

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1382

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1384

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1390

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1402

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1427

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1429

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1473

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1488

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1517

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1519

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1532

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1554

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1559

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1620

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1622

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1658

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1677

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1700

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 1701

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2408

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2408

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2236

Notice: Undefined variable: result in /home/***************/domains/hostvoxeo.com/public_html/forum/convert.php on line 2237
Successful.
--

(*** is where my username was)

ThorstenE

mhh, not sure but seems like the session has died..
place minibb_to_smf.sql and convert.php in your SMF directory. then call the convert.php from a webbrowser.

path for the miniBB is:
/home/***************/domains/hostvoxeo.com/public_html/forums
path for SMF is:
/home/***************/domains/hostvoxeo.com/public_html/forum

peter_anderson

November 23, 2008, 10:26:29 AM #4 Last Edit: November 23, 2008, 11:14:40 AM by peter_anderson
Quote from: TE on November 23, 2008, 09:18:11 AM
mhh, not sure but seems like the session has died..
place minibb_to_smf.sql and convert.php in your SMF directory. then call the convert.php from a webbrowser.

path for the miniBB is:
/home/***************/domains/hostvoxeo.com/public_html/forums
path for SMF is:
/home/***************/domains/hostvoxeo.com/public_html/forum

Tried again, and I get:

"Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MiniBB 2.0. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: 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 '.DB NAME WAS HERE_users' at line 2"




I now get "The converter detected that your host has open_basedir enabled on this server. Please ask your host to disable this setting or try moving the contents of your MiniBB 2.0 to the public html folder of your site."

ThorstenE

I don't know what this could be: ".DB NAME WAS HERE_users" .. normally it should be: databasename.prefix_users ..

have you changed the header or any other content from miniBB_to_smf.sql?

---~ settings: "/setup_options.php"
---~ from_prefix: "`$DBname`."
---~ globals: Tf, Tp, Tt, Tu, Ts, Tb, admin_usr
---~ table_test: "{$from_prefix}{$Tu}"

peter_anderson

Quote from: TE on November 23, 2008, 01:21:55 PM
I don't know what this could be: ".DB NAME WAS HERE_users" .. normally it should be: databasename.prefix_users ..

have you changed the header or any other content from miniBB_to_smf.sql?

---~ settings: "/setup_options.php"
---~ from_prefix: "`$DBname`."
---~ globals: Tf, Tp, Tt, Tu, Ts, Tb, admin_usr
---~ table_test: "{$from_prefix}{$Tu}"


No changes made to the .sql file.

ThorstenE

Any ideas about :DB NAME WAS HERE? Is this the name of your database or the table prefix form your miniBB tables? I don't have an idea at this time because this string is not part of convert.php, miniBB_to_smf.sql or the setup_options.php from miniBB..

can you please post the name of your database and the prefix all of your miniBB-tables? I can modify the miniBB_to_smf.sql for you so the error should no longer appear..

peter_anderson

November 23, 2008, 02:31:37 PM #8 Last Edit: November 23, 2008, 03:00:35 PM by peter_anderson
Quote from: TE on November 23, 2008, 02:27:07 PM
Any ideas about :DB NAME WAS HERE? Is this the name of your database or the table prefix form your miniBB tables? I don't have an idea at this time because this string is not part of convert.php, miniBB_to_smf.sql or the setup_options.php from miniBB..

can you please post the name of your database and the prefix all of your miniBB-tables? I can modify the miniBB_to_smf.sql for you so the error should no longer appear..

I'm going to PM you them, so I aint posting them out in public.

Thanks

(Cant wait to move to SMF - cant cope with the spam anymore!)




UPDATE: TE helped me, and my move over is completed :) Thanks!

Advertisement: