News:

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

Main Menu

vBull 3.8.3 to SMF 2.0 RC1.2

Started by Rick412, September 04, 2009, 10:47:58 PM

Previous topic - Next topic

Rick412

I wanting to convert my vBulletin 3.8.3 to the new SMF 2.0 RC1.2...is this conversion possiable and if so which converter do I use. I don't see a spicific converter for my app?
"If it ain't broke, fix it till it is!"

ThorstenE


Sansho

Parse error: syntax error, unexpected ';' in /data/apache/users/kilu.de/trinityhack/www/convert.php on line 2083

Norv

#3
Please in the convert.php file:
Code (find) Select

array('variable' => 'string', 'value' => 'string',

Code (replace) Select

array('variable' => 'string', 'value' => 'string'),

To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Sansho

Thx..

now is problem...

Converting members... Successful.
Converting administrators... Successful.
Converting categories...Wrong value type sent to the database. Integer expected. (can_collapse)

Norv

In vbulletin37_to_smf.sql please replace:
Code (find) Select

SELECT

forumid AS id_cat, SUBSTRING(title, 1, 255) AS name,

displayorder AS cat_order, '' AS can_collapse


Code (replace) Select

SELECT

forumid AS id_cat, SUBSTRING(title, 1, 255) AS name,

displayorder AS cat_order, 0 AS can_collapse



Please note though that our 2.0 converters are in beta stage yet, you may want to try using the stable one, the converter to 1.1.10, and once you have successfully converted to SMF, upgrade your 1.1.10 to 2.0 RC1.2 using the large upgrade package. As you wish, really.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Sansho

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:

    DELETE FROM `trinityhack@1-1`.smf_board_permissions
    WHERE id_board != 0;

Caused the error:

    Unknown column 'id_board' in 'where clause'

Norv

In vbulletin37_to_smf.sql:
Code (find) Select

DELETE FROM {$to_prefix}board_permissions

WHERE id_board != 0;

Code (replace) Select

DELETE FROM {$to_prefix}board_permissions
;
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Sansho

Converting polls...
Successful.
Converting poll options...Wrong value type sent to the database. Integer expected. (votes)

:-[

Norv

I'm not sure what can be done here, or rather, what can be done without missing data. In case you can accept that the poll choices are not very accurate for the moment (i.e., it "forgets" how many have voted for something), then please try:
Code (find) Select

SELECT pollid AS id_poll, options, votes

FROM {$from_prefix}poll;


SELECT pollid AS id_poll, options, 0

FROM {$from_prefix}poll;

You can always manually import them later, after this issue with the converter is fixed.

Alternatively, you can try the 1.1.10 converter, which shouldn't have such bugs. :)
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Sansho

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Notice: Undefined index: votes in /data/apache/users/kilu.de/trinityhack/www/convert.php(1242) : eval()'d code on line 5
Unknown column 'options' in 'field list'





Sry no englisch ^^ Germany ;)

Pls help agen :D

Norv

Argh. Sorry for the delay.
Please, instead of
Code (find) Select

SELECT pollid AS id_poll, options, 0

FROM {$from_prefix}poll;

Code (replace) Select

SELECT pollid AS id_poll, options as label, 0 as votes

FROM {$from_prefix}poll;
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Sansho


Norv

What is you SMF database prefix? (the prefix of the tables, that is)
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Sansho

Quote from: Norv on September 18, 2009, 02:59:23 AM
What is you SMF database prefix? (the prefix of the tables, that is)

No sry mom i hafe make a problem i can fix it MOM PLS..

Norv

It seems you deleted your post? I thought you had an error about a table which does not exist. :)

Either way, please feel free to let us know how it goes.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Sansho

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Notice: Undefined index: options in /data/apache/users/kilu.de/trinityhack/www/convert.php(1242) : eval()'d code on line 4

Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs-Db-mysql.php on line 629
The database value you're trying to insert does not exist: id_poll

Norv

We have two options here:
first option: please tell, are you using the code:

SELECT pollid AS id_poll, options as label, 0 as votes

FROM {$from_prefix}poll;

Also, can you please tell login in phpMyAdmin, in the database with vBulletin, and run the following SQL code in that database:

SHOW FULL COLUMNS FROM vbprefix_poll;

(replace "vbprefix_" with your vBulletin database prefix, if any)

Second option: might be a little faster if we gave up poll choices for now. How important are they right now for you?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Sansho

hmm i downt know  :(

down anderstand you :(

Can you help @ teamviewer ?  O:)

Norv

I'm afraid not, but I'll try to explain.
First option: try to solve the error. To do that, I need to know how that field looks like, that has an error, in the vbulletin database.
That is why I say to login in phpMyAdmin, and run a code, and tell the result.
Please check out: What is phpMyAdmin?
Normally you should have it installed by your host.

Second option: we can skip polls for now, and try to convert the rest.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Advertisement: