VB 3.8.2 Convert error

[mkrayden]

i am using smf forum 1.1.11 and i have 3.8.2 Vbulletin databaseinsql format now when i upload convert.php in my fightingamers.com/conver.php and run this file it;s show me error

Which software are you using?
The converter did not find any conversion data files. Please check to see if the one you want is available for download at www.simplemachines.org. If it isn't, we may be able to write one for you - just ask us!
After you download it, simply upload it into the same folder as this convert.php file. If you're having any other problems with this converter, don't hesitate to look for help on our forum.

Try again

anyone please tell me how could i convert vb database into smf

[Norv]

Please download the entire package from this site's Downloads > Converters, which contains both a convert.php and a .sql file, and put them both in your SMF directory.

Then, note that the vbulletin database in sql format is not enough: import it in MySQL, then, create a file config.php like this one discussed here:
http://www.simplemachines.org/community/index.php?topic=336534.msg2280447#msg2280447
Modify it to have your actual database data, save it in vbulletin_directory/inc/ and then, run again convert.php.

[mkrayden]

i did but it's show me this error

Unable to find the settings for vBulletin 3. Please double check the path and try again.

and should i upload config.php on smf forum root and how do i import my vb forumsql database in mysql database

[Norv]

Please don't use the package for vbulletin 3 (that one is the oldest), but the package for vbulletin 3.7.

About config.php: I suggest you make a folder "inc" in SMF's forum root, and upload it there. Then, when the converter asks for the path to vbulletin, tell it the same path as for SMF.

About importing the database: if it's not very big, then using phpMyAdmin might be best. Usually hosts have it installed, and you can find it in your host's panel. Once you login in phpmyadmin, select the database (might be a database you make specially for vbulletin, or it might be SMF's database - I'd recommend to use the same database where SMF is) and select the "import" tab, where you can submit the sql file.

[mkrayden]

Please don't use the package for vbulletin 3 (that one is the oldest), but the package for vbulletin 3.7.

About config.php: I suggest you make a folder "inc" in SMF's forum root, and upload it there. Then, when the converter asks for the path to vbulletin, tell it the same path as for SMF.

i did above whatever you wrote

but  i already uploaded my vbulletin DB is already in fightingamers.com folders that is sql format that i can;t see my database in phpmyadmin and my database size 52 m.b whereas phpmyadmin max Max: 50 MiB) allowed and what i write in config.php 
it seems its impossible for me

[Norv]

but  i already uploaded my vbulletin DB is already in fightingamers.com folders that is sql format that i can;t see my database in phpmyadmin and my database size 52 m.b whereas phpmyadmin max Max: 50 MiB) allowed

Ah, I see. You could:
- ask your host to restore the sql file for you
- compress the file, making it a gz. archive (http://en.wikipedia.org/wiki/Gzip), then upload it in phpMyAdmin: it will be smaller, and phpMyAdmin will be allowed to upload it (and further process it).
- use other methods to restore the backup : How to backup&restore your forum in several different ways
You might want to take a look also at BigDump (http://www.ozerov.de/bigdump.php). Note however, that BigDump needs the sql file to be in a specific format (with no extended inserts).

and what i write in config.php 

Please write at least the following data: (like in the file attached to the post linked above)

Code Select Expand


<?php
    //    ****** DATABASE TYPE ******
    //    This is the type of the database server on which your vBulletin database is located.
$config['Database']['dbtype'] = 'mysql';

    //    ****** DATABASE NAME ******
    //    This is the name of the database where your vBulletin is located.
$config['Database']['dbname'] = 'vbulletin';

    //    ****** TABLE PREFIX ******
    //    Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';
?>


Please replace in the code above the database name with the name of your database where you will restore the backup sql file, and the table prefix with the real prefix of your vbulletin tables. That is, your vbulletin tables, once restored from the sql file, can be browsed around in phpMyAdmin, and you should see they have some prefix in front of the name. If you're not sure, then please post here the name of the first table(s), that you'll find after you restore the backup file into a database, and find the database in phpMyAdmin, and select it.

[mkrayden]

i found my vbulletin and then i upload it in  but it's show me error

MySQL said: Documentation
#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 'Rar!' at line 1

[Norv]

You get this error when importing the sql backup file?

What version of MySQL was the backup made on? What version of MySQL do you have now? You should be able to see the current version in phpMyAdmin too, on the 'Server' page. Did you make the backup on another server?

Also, please try to set "utf-8" or not "utf-8" correctly, when importing in phpMyAdmin: if your vbulletin database was an utf-8 database, and you made the backup with phpMyAdmin, you most likely have now a file (your sql backup file) utf-8 encoded. In that case, you need to tell phpMyAdmin, in the import page, that the file is utf-8. If not, then set the option to latin1.

[mkrayden]

You get this error when importing the sql backup file?
Yes
What version of MySQL was the backup made on?
i don't know may be MySQL version     5.0.87-
and i currently i have
MySQL version     5.0.87
Did you make the backup on another server?
no actually i am runing too site on one hosting i using  addon domain feature
Also, please try to set "utf-8" or not "utf-8" correctly,
in phpmyadmin there is utf8 available

[Norv]

The file is or not utf-8 encoded, that's what I mean: if it is, you should set "utf-8" in phpMyAdmin, if not, then not...
To know if the file is utf-8 encoded, it's a good bet that it is if the database itself was utf-8. Was it?

On a side note, are you sure you don't have anymore the original vbulletin database? If it was on the same server, was it deleted? Not the installation, the database itself.

Eventually, about the file import error: it may be useful to try pasting here (or copy paste) the entire error. (or screenshot?)

[mkrayden]

i have original vbulletin DB here is my vbulletin website www.mknexusonline.com i want to use my this site DB in my fightingamers.com website

and yes vbulletin in mysame fightingamers server i also upload hosting file manager from Cpanel and i also save that vbulletin Db in my Pc and i am importing VBulletin db from Pc to hosting by myphpadmin


see both file in atatchment

[Norv]

I'm not sure I understand: do you already have in phpMyAdmin, in that screenshot, the vb database of mknexusonline.com site? I don't mean the .sql file, I mean already the database, as used by the site, is it accessible right there, along with SMF's database?

[mkrayden]

I'm not sure I understand: do you already have in phpMyAdmin, in that screenshot, the vb database of mknexusonline.com site?

yes i already in myphpadmin

is it accessible right there, along with SMF's database?
that i don't know but in left side on myphpadmin is shpw me mknexusonline DB that i currently using on my mknexusonline website

but if i use same db there then my mknexusonline db won't work i want to run both with same Db

[Norv]

Option 1: different databases:
Please tell, you want to convert the mknexusonline database, right? So you don't need to import again the sql file, since you already have the database. Why doesn't it work?
Eventually, you could perhaps add the user of the SMF database to the vbulletin mknexusonline database, then the conversion should work just fine.

Option 2: trying to import: please try to post here the line with the error, to see what exactly doesn't MySQL like.

[mkrayden]

Please tell, you want to convert the mknexusonline database, right? So you don't need to import again the sql file, since you already have the database. Why doesn't it work?

but if convert mknexusonline Database then mknexusonline will work or not cause i want to same DB in both sites

Options error is below

Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:

then start
----BEGIN CUT----
then
something is encrypted error
----END RAW----
then
SQL query:
something is encrypted error
and then
MySQL said: Documentation
#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 'Rar!' at line 1
[ Back ]