vBull 3.8.3 to SMF 2.0 RC1.2

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

Previous topic - Next topic
Print
Go Down Pages1 2 All
User actions

Rick412

September 04, 2009, 10:47:58 PM
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

#1
September 05, 2009, 03:26:05 AM
please try the attached files..
Converting to SMF

Sansho

#2
September 17, 2009, 12:38:00 PM
Parse error: syntax error, unexpected ';' in /data/apache/users/kilu.de/trinityhack/www/convert.php on line 2083

Norv

#3
September 17, 2009, 01:44:05 PM Last Edit: September 18, 2009, 05:29:04 AM by Norv
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

#4
September 17, 2009, 02:33:11 PM
Thx..

now is problem...

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

Norv

#5
September 17, 2009, 03:22:29 PM
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

#6
September 17, 2009, 04:05:48 PM
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

#7
September 17, 2009, 04:10:10 PM
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

#8
September 17, 2009, 04:12:42 PM
Converting polls...
Successful.
Converting poll options...Wrong value type sent to the database. Integer expected. (votes)

:-[

Norv

#9
September 17, 2009, 04:41:20 PM
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;

Code Select

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

#10
September 17, 2009, 05:11:18 PM
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

#11
September 17, 2009, 11:56:27 PM
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

#12
September 18, 2009, 02:58:09 AM
ok thx i test it...

Norv

#13
September 18, 2009, 02:59:23 AM
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

#14
September 18, 2009, 03:00:07 AM
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

#15
September 18, 2009, 03:04:38 AM
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

#16
September 18, 2009, 03:27:20 AM
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

#17
September 18, 2009, 03:59:40 AM
We have two options here:
first option: please tell, are you using the code:
Code Select

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:
Code Select

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

#18
September 18, 2009, 04:08:04 AM
hmm i downt know  :(

down anderstand you :(

Can you help @ teamviewer ?  O:)

Norv

#19
September 18, 2009, 04:15:59 AM
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

Norv

#20
September 18, 2009, 04:31:00 AM
Please make sure you have a FULL BACKUP of the database of vBulletin before doing anything.
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

#21
September 18, 2009, 04:40:32 AM
I hafe all backups...


Second option pls :)

O:)

Norv

#22
September 18, 2009, 04:48:55 AM
Please find in vbulletin37_to_smf.sql
Code (find) Select

---* {$to_prefix}poll_choices

Code (replace) Select

/*
---* {$to_prefix}poll_choices

and also
Code (find) Select

---* {$to_prefix}log_polls

Code (replace) Select

/*
---* {$to_prefix}log_polls
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

#23
September 18, 2009, 04:56:28 AM
Error in convert script - line 276!
Error in convert script - line 277!
Error in convert script - line 296!
Converting personal messages (step 2)...
Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting avatars...
Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

Notice: Undefined index: attachmentUploadDir in /data/apache/users/kilu.de/trinityhack/www/smf/Sources/Subs.php on line 3518

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_member

Norv

#24
September 18, 2009, 05:24:14 AM Last Edit: September 18, 2009, 05:32:22 AM by Norv
Oh okay.
Please use instead of the converter script the attached convert.php file, and vbulletin37_to_smf.sql file.

NOTE: please note that this is still the SMF.2.0 converter. You might want to use the SMF 1.1.10 converter instead, it is a stable working version.
The SMF 2.0 converter is still buggy, as you can see :( . It's in beta stage.
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

#25
September 18, 2009, 05:45:23 AM Last Edit: September 18, 2009, 05:53:08 AM by Sansho
Converting members... Successful.
Converting administrators... Successful.
Converting categories...Wrong value type sent to the database. Integer expected. (can_collapse)


Hmm i can not login now in mein Forum  :(

Norv

#26
September 18, 2009, 06:02:20 AM
Please use the attached file.
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

Norv

#27
September 18, 2009, 06:09:23 AM
On another note: can you please consider to make an "Export" of the structure of the vBulletin database (or another backup, any you wish,structure-only, no need for data), and send it to me?
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

#28
September 18, 2009, 06:22:18 AM
Quote from: Norv on September 18, 2009, 06:09:23 AM
On another note: can you please consider to make an "Export" of the structure of the vBulletin database (or another backup, any you wish,structure-only, no need for data), and send it to me?


i send you my Backup from Vbulletin ?

Norv

#29
September 18, 2009, 06:24:10 AM
If you want, yes.
I'll PM you an account to use, in this case. :)
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

Baross

#30
September 29, 2009, 02:49:32 AM Last Edit: September 29, 2009, 03:09:22 AM by Baross
Hi. I`ve installed both forums on a local PC Wamp server to see if this converter works...i want to convert my online vbulletin to smf too, but first I wanted to try it.

So far so good but still some issues... I have done all the changes in convert.php and vbulletin37_to_smf.sql I could find here and it went like this:

QuoteConverting 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... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting avatars... Successful.
Recalculating forum statistics... The database value you're trying to insert does not exist: value

So, there s no statistics..can those be imported too?

Norv

#31
September 29, 2009, 06:10:04 AM
Yes, they should.
Can you please tell what versions of vBulletin / SMF are you using, and eventually what converter files?
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

Baross

#32
September 29, 2009, 06:42:54 AM
Vbulletin 3.8.1 and smf 2.0 RC 1.2 . The converter and sql file are those attached in the beginning of this thread, and I`ve made some of the changes described here. As far as I browsed the converted smf it looks like its working fine...except those stats.

Norv

#33
September 29, 2009, 06:52:59 AM
Can you please try using the attached convert script instead.
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

Baross

#34
September 29, 2009, 07:26:00 AM
No use...same thing:

QuoteRecalculating forum statistics... The database value you're trying to insert does not exist: value

These stats can be added manually in the database? Or any piece of code somewhere?

Norv

#35
September 29, 2009, 10:19:05 AM
They could, but there are quite a number of queries. They're mostly cleanup/re-calculating properly a number of fields.

Perhaps you can check your SMF folder, for a file named convert_error_log. Please attach it here.

It seems the problem might be here:
Code Select

$smcFunc['db_insert']('replace',
'{db_prefix}settings',
array('variable' => 'string', 'value' => 'string',),
array(
array('latest_member', $row['latest_member']),
array('latest_real_name', $row['latest_real_name']),
array('total_members', $row['total_members']),
array('total_messages', $row['total_messages']),
array('max_msg_id', $row['max_msg_id']),
array('total_topics', $row['total_topics']),
array('disable_hash_time', time() + 7776000),
),
array('name')
);

This piece of code could be avoided, and the rest run, then handle it separately.
Code (replace) Select

/*
$smcFunc['db_insert']('replace',
'{db_prefix}settings',
array('variable' => 'string', 'value' => 'string',),
array(
array('latest_member', $row['latest_member']),
array('latest_real_name', $row['latest_real_name']),
array('total_members', $row['total_members']),
array('total_messages', $row['total_messages']),
array('max_msg_id', $row['max_msg_id']),
array('total_topics', $row['total_topics']),
array('disable_hash_time', time() + 7776000),
),
array('name')
);
*/
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

Baross

#36
September 30, 2009, 07:46:30 AM
Here s the error log.

Norv

#37
October 03, 2009, 06:29:39 AM
Sorry for the delay.
Can you please try using the attached file?

Post all messages you get on the screen.
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
Print
Go Up Pages1 2 All
User actions
Advertisement: