Advertisement:

Author Topic: wowbb to smf  (Read 11260 times)

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
wowbb to smf
« on: October 14, 2015, 03:33:48 PM »
Hi All,

I've been trying to convert wowbb 1.7 to the latest SMF but im stuck and keep getting errors can anyone help?

Offline Illori

  • Lead Support Specialist
  • SMF Legend
  • *
  • Posts: 52,811
Re: wowbb to smf
« Reply #1 on: October 14, 2015, 03:38:43 PM »
what errors are you getting?

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: wowbb to smf
« Reply #2 on: October 14, 2015, 04:06:15 PM »
Notice: Undefined variable: HTTP_SERVER_VARS in /var/sites/d/dev.devonwebs.uk/public_html/modelrail/config.php on line 23

Notice: Undefined variable: HTTP_SERVER_VARS in /var/sites/d/dev.devonwebs.uk/public_html/modelrail/config.php on line 23

Notice: Undefined variable: HTTP_COOKIE_VARS in /var/sites/d/dev.devonwebs.uk/public_html/modelrail/config.php on line 30
Unknown system variable 'SQL_MAX_JOIN_SIZE'

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,759
  • Gender: Male
Re: wowbb to smf
« Reply #3 on: October 17, 2015, 07:42:05 PM »
The "notices" I have no idea what they are but I assume it's something missing from your original config file because wowbb isn't being called as supposed. You can probably ignore these.

The last error is caused by recent MySQL versions (and the converters age...). Open convert.php, find and comment or remove this:
Code: [Select]
// Attempt to allow big selects, only for mysql so far though.
if ($smcFunc['db_title'] == 'MySQL')
{
$results = $smcFunc['db_query']('', "SELECT @@SQL_BIG_SELECTS, @@SQL_MAX_JOIN_SIZE", 'security_override');
list($big_selects, $sql_max_join) = $smcFunc['db_fetch_row']($results);

// Only waste a query if its worth it.
if (empty($big_selects) || ($big_selects != 1 && $big_selects != '1'))
$smcFunc['db_query']('', "SET @@SQL_BIG_SELECTS = 1", 'security_override');

// Lets set MAX_JOIN_SIZE to something we should
if (empty($sql_max_join) || ($sql_max_join == '18446744073709551615' && $sql_max_join == '18446744073709551615'))
$smcFunc['db_query']('', "SET @@SQL_MAX_JOIN_SIZE = 18446744073709551615", 'security_override');
}
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: wowbb to smf
« Reply #4 on: October 18, 2015, 06:21:22 AM »
just to clarify the convert.php has to be in the simple machine directory? and does both databases need to same username and password for both smf and wowbb?

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,759
  • Gender: Male
Re: wowbb to smf
« Reply #5 on: October 18, 2015, 07:01:16 AM »
Yes, the converter needs to be in the same folder as SMF (where SSI.php is)
About the database: it's not mandatory that both databases use the same user/pass. The user associated to SMF's database needs to have access to your wowbb's database. If it's the same user in both, then that's easier, sure ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: wowbb to smf
« Reply #6 on: October 19, 2015, 01:17:44 PM »
and just one more thing, does both of the databases need to be on the same server?

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,759
  • Gender: Male
Re: wowbb to smf
« Reply #7 on: October 19, 2015, 01:50:25 PM »
Yes, that's a key point ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: wowbb to smf
« Reply #8 on: October 19, 2015, 07:26:52 PM »
ok ive done all this and now all i get is:

Converting Membergroups... Successful.
Converting group access... Successful.
Converting members...Wrong value type sent to the database. Integer expected. (last_login)

what is the issue?

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: wowbb to smf
« Reply #9 on: October 19, 2015, 07:37:00 PM »
after clicking the dump error log file and trying again i get this

Converting Membergroups... Unsuccessful!
This query:
ALTER TABLE `devdevon_ohmpc`.oxmg_membergroups
ADD COLUMN temp_id varchar(32),
ADD INDEX temp_id (temp_id(32));
Caused the error:
Duplicate column name 'temp_id'

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: wowbb to smf
« Reply #10 on: October 19, 2015, 07:41:16 PM »
i also have these at the top still


Notice: Undefined variable: HTTP_SERVER_VARS in /var/sites/d/dev.devonwebs.uk/public_html/modelrail/config.php on line 23
Notice: Undefined variable: HTTP_SERVER_VARS in /var/sites/d/dev.devonwebs.uk/public_html/modelrail/config.php on line 23
Notice: Undefined variable: HTTP_COOKIE_VARS in /var/sites/d/dev.devonwebs.uk/public_html/modelrail/config.php on line 30

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,759
  • Gender: Male
Re: wowbb to smf
« Reply #11 on: October 19, 2015, 07:57:58 PM »
Please don't do several things at once, it will just make things worse.

So...
Quote
Converting members...Wrong value type sent to the database. Integer expected. (last_login)
This is caused by a wrong type in the converter. Open your .sql file, and find:
Code: [Select]
UNIX_TIMESTAMP(u.user_joined) AS date_registered, '' AS last_login,Replace with:
Code: [Select]
UNIX_TIMESTAMP(u.user_joined) AS date_registered, 0 AS last_login,
It is likely that other similar problems arise, it has been quite some time since the converter was written and the database requirements for default field types changed a lot...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,759
  • Gender: Male
Re: wowbb to smf
« Reply #12 on: October 19, 2015, 08:03:54 PM »
after clicking the dump error log file and trying again i get this

Converting Membergroups... Unsuccessful!
(...)
Duplicate column name 'temp_id'
This happened because the converter already created a temporary column which wasn't removed (because it failed to complete correctly). When you run it again, it tries to create the column again and it tells you it's a duplicate. So you need to either:
a) go to phpmyadmin, table oxmg_membergroups and delete the column "temp_id" before you restart the converter
or
b) edit the .sql file and remove this
Code: [Select]
ALTER TABLE {$to_prefix}membergroups
ADD COLUMN temp_id varchar(32),
ADD INDEX temp_id (temp_id(32));

About the notice, I think that it's safe for you to ignore it.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: wowbb to smf
« Reply #13 on: October 19, 2015, 08:14:22 PM »
thank you i did this and now i get

Converting Membergroups... Successful.
Converting group access... Successful.
Converting members...Wrong value type sent to the database. Integer expected. (last_login)

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: wowbb to smf
« Reply #14 on: October 19, 2015, 08:18:37 PM »
Please don't do several things at once, it will just make things worse.

So...
Quote
Converting members...Wrong value type sent to the database. Integer expected. (last_login)
This is caused by a wrong type in the converter. Open your .sql file, and find:
Code: [Select]
UNIX_TIMESTAMP(u.user_joined) AS date_registered, '' AS last_login,Replace with:
Code: [Select]
UNIX_TIMESTAMP(u.user_joined) AS date_registered, 0 AS last_login,
It is likely that other similar problems arise, it has been quite some time since the converter was written and the database requirements for default field types changed a lot...

i tried looking for UNIX_TIMESTAMP(u.user_joined) AS date_registered, " AS last_login,

but it isnt in the sql file.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,759
  • Gender: Male
Re: wowbb to smf
« Reply #15 on: October 19, 2015, 08:20:50 PM »
Which converter are you using? Can you attach it?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: wowbb to smf
« Reply #16 on: October 19, 2015, 08:21:40 PM »
im using this one, is the wowbb 1.7 to smf converter.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,759
  • Gender: Male
Re: wowbb to smf
« Reply #17 on: October 19, 2015, 08:24:18 PM »
That code does exist in that file. Here
Code: [Select]
CASE u.user_group_id
WHEN '1' THEN '1'
WHEN '2' THEN '0'
WHEN '3' THEN '0'
WHEN '4' THEN '0'
WHEN '5' THEN '2'
WHEN '6' THEN '1'
ELSE m.id_group
END AS id_group,
-------->>>>>>>>>>>>>> UNIX_TIMESTAMP(u.user_joined) AS date_registered, '' AS last_login,        <<<<<<<<<<<<<<<<<<-------------------------
u.user_avatar AS avatar, IF(u.user_invisible = '1', 0, 1) AS show_online,
IF(u.user_view_email = '1', 0, 1) AS hide_email, u.user_posts AS posts, 0 AS gender,
u.user_birthday AS birthdate, IF (u.user_activation_key != '', 0, 1) AS is_activated,
u.user_activation_key AS validation_code,
SUBSTRING(u.user_signature, 1, 65534) AS signature
FROM {$from_prefix}users AS u
LEFT JOIN {$to_prefix}membergroups AS m ON (u.user_group_id = m.temp_id);
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: wowbb to smf
« Reply #18 on: October 19, 2015, 08:35:31 PM »
everything seems to be importing now, fingers crossed. thanks for all your help and support so far.

Offline SamRudd

  • Semi-Newbie
  • *
  • Posts: 42
Re: wowbb to smf
« Reply #19 on: October 19, 2015, 08:38:51 PM »
Notice: Undefined index: convert_script in /var/sites/d/dev.devonwebs.uk/public_html/smfmrg/convert.php on line 958

Warning: Invalid argument supplied for foreach() in /var/sites/d/dev.devonwebs.uk/public_html/smfmrg/convert.php on line 961

Notice: Undefined index: convert_script in /var/sites/d/dev.devonwebs.uk/public_html/smfmrg/convert.php on line 973
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /var/sites/d/dev.devonwebs.uk/public_html/smfmrg/convert.php on line 2480

Notice: Undefined variable: result in /var/sites/d/dev.devonwebs.uk/public_html/smfmrg/convert.php on line 2481

Notice: Undefined index: db_fetch_assoc in /var/sites/d/dev.devonwebs.uk/public_html/smfmrg/convert.php on line 1372

Fatal error: Function name must be a string in /var/sites/d/dev.devonwebs.uk/public_html/smfmrg/convert.php on line 1372