vBulletin 3.5 converter errors

[emanuele]

From phpmyadmin, export ONLY the structure of the tables. Be careful, only the structure, not the data!
You can select what you want to export from phpmyadmin by clicking "custom" in the export screen.
If you are unsure send it to me by PM.

[emanuele]

Wait scratch that.

Here there is the solution (I hope):
http://www.simplemachines.org/community/index.php?topic=216076.msg2506124;topicseen#msg2506124

[B3aker]

Got a different error this time.

Converting poll votes...
Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Unsuccessful!
This query:

    WHERE pm.folderid != '-1'
    LIMIT 0, 500;

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 'WHERE pm.folderid != '-1'
    LIMIT 0, 500' at line 1

[B3aker]

Tried to run the converter again. Still same issue. emanuelle, want to see the structure of my tables? Let me know and I'll PM it to you. Thanks!

[emanuele]

It seems you removed part of the query or added some semi colon somewhere in the query.

Sorry for the late answer, I was not frequently on-line these days...

[B3aker]

It seems you removed part of the query or added some semi colon somewhere in the query.

Sorry for the late answer, I was not frequently on-line these days...

Wait. I'm confused. I'm not a programmer. Dunno where I could have messed up (the code is all greek to me though I am slowly learning ). This is the code from the SQL file for Step 2.

/******************************************************************************/
--- Converting personal messages (step 2)...
/******************************************************************************/

TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
SELECT
   pm.pmid AS id_pm, pm.userid AS id_member,
   '-1' AS labels
FROM {$from_prefix}pm AS pm;
WHERE pm.folderid != '-1';
---*

[emanuele]

Yep, remove the semicolon at the end of this line:

Code Select Expand

FROM {$from_prefix}pm AS pm;

The final code should look like:

Code Select Expand

/******************************************************************************/
--- Converting personal messages (step 2)...
/******************************************************************************/

TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
SELECT
   pm.pmid AS id_pm, pm.userid AS id_member,
   '-1' AS labels
FROM {$from_prefix}pm AS pm
WHERE pm.folderid != '-1';
---*

[B3aker]

Aha. Success....sorta. Got past the personal messages. Now have this error

Converting personal messages (step 1)...
Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting smileys...
Parse error: syntax error, unexpected T_STRING, expecting ')' in /home/content/79/11133879/html/forum/convert.php(1091) : eval()'d code on line 35

[emanuele]

OMFG this converter is quite broken... >_<

Code Select Expand

$rows[] = array($code, $name . '.gif, $name, $count);

should be:

Code Select Expand

$rows[] = array($code, $name . '.gif', $name, $count);


Can't see any other syntax error, let's hope everything else is fine.
When we finish I'll collect all the changes and at least post the file somewhere.

[B3aker]

This one is weird. What does this mean? Never had this before.

Converting topics...
Incorrect key file for table '/tmp/mysqltmp/#sql_1339_0.MYI'; try to repair it

[emanuele]

This one is a mysql error, and it seems you have some problem on one of the tables.

Converting topics, so it means one of those involved in the conversion of...topics obviously.
Now, I have no idea if it is vb side or smf side, so you should check all of them and try a repair.

On vb side it may be one of:
* thread
* post
* user
on smf side is topics (I omitted all the prefixes).

To repair you can use phpmyadmin on the page where all the tables are listed, you can selec some (or all, usually is faster ) and from the dropdown box at the bottom select "repair".

[B3aker]

Went past topics now getting the same error on posts

Converting posts (this may take some time)...
Incorrect key file for table '/tmp/mysqltmp/#sql_1339_0.MYI'; try to repair it

[emanuele]

Are you working on a "live" database (i.e. the vb one is the one your forum is actively using)?
If so it may be some problem with the multiple accesses to tables and maybe a spike of traffic.
In any case you should work on a "backup" for testing and do the conversion of the live site only when you want to move and putting the site in some kind of maintenance mode (dunno the vb equivalent) in order to avoid changes in the db while converting (that would cause inconsistency of the data).

[B3aker]

Are you working on a "live" database (i.e. the vb one is the one your forum is actively using)?
If so it may be some problem with the multiple accesses to tables and maybe a spike of traffic.
In any case you should work on a "backup" for testing and do the conversion of the live site only when you want to move and putting the site in some kind of maintenance mode (dunno the vb equivalent) in order to avoid changes in the db while converting (that would cause inconsistency of the data).

I'm using a completely different database that is not live. What I did is copy the vbulletin folder (was mydomain.com/forums) and renamed the duplicate folder forums2 and have been using that for the conversion process. I then used an older SQL (the one the original owner of the site gave me) file and imported it in a completely different database. I then installed the SMF forum to a new name (named it forum). The vBulletin forum that is currently live has been corrupted (database and tables are a mess) since I assumed ownership so I decided to start from scratch for the conversion on a new database that is not active with the original database. The plan is to then redirect to the new SMF board. We'll lose a month or two worth of posts but the site doesn't get that much traffic so it really isn't a big deal. If any of this makes sense 

[emanuele]

Then it seems that the copy is being corrupted as well. :-S
And that is not very good *at all*...

At that point, I'd be a bit afraid of using the live database for further tests (and to be completely honest I'd have some doubts on using the host for my site as well). What I would do is use a "local" (i.e. on your computer) server to continue the test. You can install xampp or alternatives (see "localhost webservers" in the first message of this topic) and have everything ready with just a couple of clicks.
Then, when you are sure the converter works, you can do the conversion "live", so data won't be broken.

[B3aker]

I downloaded xampp. While I was waiting for it to download and install, for the heck of it, I ran the convert.php again just to see if the error popped up again with mysql. Went right through without a problem (perhaps it could have been a hiccup with GoDaddy?). I hit this error. What are your thoughts? Should I just go ahead with xampp?

Converting topic notifications...
Successful.
Converting board notifications... Successful.
Converting smileys...
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /home/content/79/11133879/html/forum/Sources/Subs-Db-mysql.php on line 627
The database value you're trying to insert does not exist: variable

[emanuele]

sigh...

Find this line:

Code Select Expand

convert_insert('smileys', array('variable', 'value'), $rows, 'replace');


and change it to:

Code Select Expand

convert_insert('smileys', array('code', 'filename', 'description', 'smiley_order'), $rows, 'replace');


[B3aker]

sigh...

Look on the bright side. I've had every error known to man for vBulletin. Should be able to help out anyone who has any type of problem

Anyway, got a lot further this time. Looks like I'm toward the end. Got this error when converting avatars.

Converting attachments...
Successful.
Converting avatars...The database value you're trying to insert does not exist: filename

[emanuele]

Good news is the last step. YAY!

Not so good news, I'm not sure why it returns this error...

Can you check the vb database, table customavatar and verify if a column "filename" exists?

[B3aker]

Good news is the last step. YAY!

Not so good news, I'm not sure why it returns this error...

Can you check the vb database, table customavatar and verify if a column "filename" exists?

I see a column that is named filename. It then says in order from right to left, type "varchar(100)", collation "latin1_swedish_ci", attributes nothing listed, Null "Yes", Default "NULL". Hope that helps