Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: SamRudd on October 14, 2015, 03:33:48 PM

Title: wowbb to smf
Post by: SamRudd 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?
Title: Re: wowbb to smf
Post by: Illori on October 14, 2015, 03:38:43 PM
what errors are you getting?
Title: Re: wowbb to smf
Post by: SamRudd 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'
Title: Re: wowbb to smf
Post by: margarett 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');
}
Title: Re: wowbb to smf
Post by: SamRudd 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?
Title: Re: wowbb to smf
Post by: margarett 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 ;)
Title: Re: wowbb to smf
Post by: SamRudd 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?
Title: Re: wowbb to smf
Post by: margarett on October 19, 2015, 01:50:25 PM
Yes, that's a key point ;)
Title: Re: wowbb to smf
Post by: SamRudd 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?
Title: Re: wowbb to smf
Post by: SamRudd 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'
Title: Re: wowbb to smf
Post by: SamRudd 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
Title: Re: wowbb to smf
Post by: margarett 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...
Title: Re: wowbb to smf
Post by: margarett 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.
Title: Re: wowbb to smf
Post by: SamRudd 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)
Title: Re: wowbb to smf
Post by: SamRudd 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.
Title: Re: wowbb to smf
Post by: margarett on October 19, 2015, 08:20:50 PM
Which converter are you using? Can you attach it?
Title: Re: wowbb to smf
Post by: SamRudd on October 19, 2015, 08:21:40 PM
im using this one, is the wowbb 1.7 to smf converter.
Title: Re: wowbb to smf
Post by: margarett 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);
Title: Re: wowbb to smf
Post by: SamRudd 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.
Title: Re: wowbb to smf
Post by: SamRudd 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
Title: Re: wowbb to smf
Post by: margarett on October 19, 2015, 09:05:51 PM
Sorry, I have no idea why these errors occur.

Did the conversion finish? If so, you can try to login to your converted forum? If your password doesn't work you can restore it easily with this wiki article --> http://wiki.simplemachines.org/smf/I_accidentally_lost_my_admin_account!_What_can_I_do (especially last point)

Then run the maintenance tasks (recount totals, find and repair errors) and see if all content is there ;)
Title: Re: wowbb to smf
Post by: SamRudd on October 19, 2015, 09:07:32 PM
how do i recount totals? looks like all content is there :) its just that in the latest posts i have a few blanks
Title: Re: wowbb to smf
Post by: SamRudd on October 19, 2015, 09:12:43 PM
seems like its all ok for now, all photos and everything seems to be there. i am just waiting for a second opinion. thanks again for your help. just a quick question if i have to import again can i just use the same script and will is just re import?
Title: Re: wowbb to smf
Post by: margarett on October 19, 2015, 09:18:00 PM
Yes ;)

Although you probably have to put back that code for the creation of the temporary column in the membergroups table.
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 10:54:13 AM
Converting personal messages (step 2)...Wrong value type sent to the database. Integer expected. (bcc)

why do i get this?
Title: Re: wowbb to smf
Post by: margarett on October 24, 2015, 01:03:10 PM
It seems that the field "pm_cc" from your original database has any values, other than integers as expected by SMF's database.

Find this (in your .sql file)
Code: [Select]
TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
And replace with this
Code: [Select]
TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
---{
$row['bcc'] = (int)$row['bcc'];
---}
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 01:09:57 PM
Converting smileys...
Notice: Undefined index: newfilename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 36

Warning: array_combine(): Both parameters should have an equal number of elements in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/Sources/Subs-Db-mysql.php on line 649
The database value you're trying to insert does not exist: string

this is what i got next
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 01:11:58 PM
although it says its imported attachments i cant see that it has
Title: Re: wowbb to smf
Post by: margarett on October 24, 2015, 01:17:47 PM
About smileys: I see this line near the end of the converter
Code: [Select]
array($row['code'], $row['newfilename'], $row['description'], 1), 'ignore'But $row['newfilename'] isn't defined anywhere so it was probably a typpo ( :P )
Replace $row['newfilename'] with $row['filename']

About attachments, check your smf_attachments table, check if something was added
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 01:25:00 PM
i get this now, getting closer

Converting avatars...
Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Notice: Undefined variable: physical_filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5

Warning: copy(): The second argument to copy() function cannot be a directory in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 5
Successful.
Converting attachments ... Successful.
Converting board notifications... Successful.
Converting smileys...
Warning: array_combine(): Both parameters should have an equal number of elements in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/Sources/Subs-Db-mysql.php on line 649
The database value you're trying to insert does not exist: string
Title: Re: wowbb to smf
Post by: margarett on October 24, 2015, 02:19:07 PM
No, something is weird because you were already in smileys (which is the converter's last operation) and now you have issues in avatars :o

Again, an undefined variable: $physical_filename
I have no idea what this is expected to have, let's try this. Find:
Code: [Select]
$file_hash = 'avatar_' . $row['id_member'] . strrchr($row['user_avatar'], '.');Replace with:
Code: [Select]
$file_hash = getAttachmentFilename($filename, $id_attach, null, true);
$physical_filename = $id_attach . '_' . $file_hash;
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 02:32:23 PM
ive had a little more progress but i still get these errors popping up.

Converting avatars...
Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Undefined index: filename in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11
The database value you're trying to insert does not exist: filename
Title: Re: wowbb to smf
Post by: margarett on October 24, 2015, 02:51:37 PM
Yeah, around line 725, you find this
Code: [Select]
'filename' => $row['filename'],Replace with
Code: [Select]
'filename' => $filename,
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 02:57:48 PM
i have done this:

Converting avatars...
Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11

Notice: Use of undefined constant filename - assumed 'filename' in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/convert.php(1240) : eval()'d code on line 11
Successful.
Converting attachments ... Successful.
Converting board notifications... Successful.
Converting smileys...
Warning: array_combine(): Both parameters should have an equal number of elements in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/Sources/Subs-Db-mysql.php on line 649
The database value you're trying to insert does not exist: string
Title: Re: wowbb to smf
Post by: margarett on October 24, 2015, 03:04:15 PM
Make sure you did
Code: [Select]
'filename' => $filename,And not
Code: [Select]
'filename' => filename,
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 03:07:47 PM
my bad, this is the next error

Converting smileys...
Warning: array_combine(): Both parameters should have an equal number of elements in /var/sites/m/modelrail.devonwebs.uk/public_html/forum/Sources/Subs-Db-mysql.php on line 649
The database value you're trying to insert does not exist: string
Title: Re: wowbb to smf
Post by: margarett on October 24, 2015, 03:21:49 PM
It seems convert_insert only wants the column name, not the data type.

So find
Code: [Select]
convert_insert('settings', array('variable' => 'string', 'value' => 'string'),
array('smiley_enable', '1'), 'ignore'
);
Replace with
Code: [Select]
convert_insert('settings', array('variable', 'value'),
array('smiley_enable', '1'), 'ignore'
);

Find
Code: [Select]
convert_insert('smileys', array('code' => 'string', 'filename' => 'string', 'description' => 'string', 'hidden' => 'int'),
array($row['code'], $row['filename'], $row['description'], 1), 'ignore'
);
Replace with
Code: [Select]
convert_insert('smileys', array('code', 'filename', 'description', 'hidden'),
array($row['code'], $row['filename'], $row['description'], 1), 'ignore'
);
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 03:29:05 PM
the only thing im still missing is the attachments but i do believe everything else has worked.

Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.

 Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)

Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the wowBB 1.7 installation.

We hope you had a smooth transition!
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 03:41:04 PM
this is all i have, but there are so many more attachments and avatars than that

Total Attachments:70
Total Avatars:22
Total Size of Attachment Directory:37813.73 kB
Title: Re: wowbb to smf
Post by: margarett on October 24, 2015, 03:46:45 PM
Check the attachments table. How many records are there?

Don't forget to run the maintenance tasks in SMF ;)
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 03:53:27 PM
attachments only go upto id 92 but there are hundreds more that should be there
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 04:00:28 PM
checking through the database from wowbb, i find that the attachments table go to 92 but in ultra_gallery there are hundreds. how can we import them as thats where the attachments are?
Title: Re: wowbb to smf
Post by: margarett on October 24, 2015, 04:45:53 PM
I honestly don't know. I've never seen wowbb, I'm not even sure that the converter ever worked properly (considering how many bugs it had and we fixed) and, last but not least, I have no idea about your files, etc.

At this point, I need access to your files/database, etc. I can't really debug why the attachments aren't converted without looking into it...
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 05:40:18 PM
its all sorted now, can i ask a few questions.

how can i add extra links to the menu bar in the bluez theme.

i am also struggling to restrict a standard user viewing an admin board and the wiki posts ive read about permissions are confusing me.
Title: Re: wowbb to smf
Post by: margarett on October 24, 2015, 05:45:23 PM
About the menu:
How do I add buttons to SMF 2.0? (http://wiki.simplemachines.org/smf/How_do_I_add_buttons_to_SMF_2.0)

About the permissions, I suggest that you create a new topic in 2.0 support boards, describing what you want to do and what are you struggling with.

Because this is about the converter, can you please tell us how did you fix the attachments issues? For future reference ;)
Title: Re: wowbb to smf
Post by: SamRudd on October 24, 2015, 05:50:01 PM
as all of the attachments were uploaded through a gallery addon for wowbb all i did was clone the gallery folder over to the root dir of the smf and all worked fine.

thank you for all your help and continued support.

regards,
Sam