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?
what errors are you getting?
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'
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:
// 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');
}
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?
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 ;)
and just one more thing, does both of the databases need to be on the same server?
Yes, that's a key point ;)
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?
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'
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
Please don't do several things at once, it will just make things worse.
So...
QuoteConverting 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:
UNIX_TIMESTAMP(u.user_joined) AS date_registered, '' AS last_login,Replace with:
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...
Quote from: 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!
(...)
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
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.
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)
Quote from: margarett on October 19, 2015, 07:57:58 PM
Please don't do several things at once, it will just make things worse.
So...
QuoteConverting 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:
UNIX_TIMESTAMP(u.user_joined) AS date_registered, '' AS last_login,
Replace with:
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.
Which converter are you using? Can you attach it?
im using this one, is the wowbb 1.7 to smf converter.
That code does exist in that file. Here
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);
everything seems to be importing now, fingers crossed. thanks for all your help and support so far.
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
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 ;)
how do i recount totals? looks like all content is there :) its just that in the latest posts i have a few blanks
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?
Yes ;)
Although you probably have to put back that code for the creation of the temporary column in the membergroups table.
Converting personal messages (step 2)...Wrong value type sent to the database. Integer expected. (bcc)
why do i get this?
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)
TRUNCATE {$to_prefix}pm_recipients;
---* {$to_prefix}pm_recipients
And replace with this
TRUNCATE {$to_prefix}pm_recipients;
---* {$to_prefix}pm_recipients
---{
$row['bcc'] = (int)$row['bcc'];
---}
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
although it says its imported attachments i cant see that it has
About smileys: I see this line near the end of the converter
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
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
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:
$file_hash = 'avatar_' . $row['id_member'] . strrchr($row['user_avatar'], '.');
Replace with:
$file_hash = getAttachmentFilename($filename, $id_attach, null, true);
$physical_filename = $id_attach . '_' . $file_hash;
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
Yeah, around line 725, you find this
'filename' => $row['filename'],
Replace with
'filename' => $filename,
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
Make sure you did
'filename' => $filename,
And not
'filename' => filename,
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
It seems convert_insert only wants the column name, not the data type.
So find
convert_insert('settings', array('variable' => 'string', 'value' => 'string'),
array('smiley_enable', '1'), 'ignore'
);
Replace with
convert_insert('settings', array('variable', 'value'),
array('smiley_enable', '1'), 'ignore'
);
Find
convert_insert('smileys', array('code' => 'string', 'filename' => 'string', 'description' => 'string', 'hidden' => 'int'),
array($row['code'], $row['filename'], $row['description'], 1), 'ignore'
);
Replace with
convert_insert('smileys', array('code', 'filename', 'description', 'hidden'),
array($row['code'], $row['filename'], $row['description'], 1), 'ignore'
);
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!
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
Check the attachments table. How many records are there?
Don't forget to run the maintenance tasks in SMF ;)
attachments only go upto id 92 but there are hundreds more that should be there
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?
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...
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.
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 ;)
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