News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

wowbb to smf

Started by SamRudd, October 14, 2015, 03:33:48 PM

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

SamRudd

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?

Illori

#1
October 14, 2015, 03:38:43 PM
what errors are you getting?

SamRudd

#2
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'

margarett

#3
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

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

SamRudd

#4
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?

margarett

#5
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

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

SamRudd

#6
October 19, 2015, 01:17:44 PM
and just one more thing, does both of the databases need to be on the same server?

margarett

#7
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

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

SamRudd

#8
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?

SamRudd

#9
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'

SamRudd

#10
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

margarett

#11
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:
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

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

margarett

#12
October 19, 2015, 08:03:54 PM
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
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

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

SamRudd

#13
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)

SamRudd

#14
October 19, 2015, 08:18:37 PM
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:
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.

margarett

#15
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

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

SamRudd

#16
October 19, 2015, 08:21:40 PM
im using this one, is the wowbb 1.7 to smf converter.

margarett

#17
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

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

SamRudd

#18
October 19, 2015, 08:35:31 PM
everything seems to be importing now, fingers crossed. thanks for all your help and support so far.

SamRudd

#19
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

margarett

#20
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 ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

SamRudd

#21
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

SamRudd

#22
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?

margarett

#23
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.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

SamRudd

#24
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?

margarett

#25
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'];
---}
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

SamRudd

#26
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

SamRudd

#27
October 24, 2015, 01:11:58 PM
although it says its imported attachments i cant see that it has

margarett

#28
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
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

SamRudd

#29
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

margarett

#30
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;
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

SamRudd

#31
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

margarett

#32
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,
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

SamRudd

#33
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

margarett

#34
October 24, 2015, 03:04:15 PM
Make sure you did
Code Select
'filename' => $filename,
And not
Code Select
'filename' => filename,
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

SamRudd

#35
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

margarett

#36
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'
);

Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

SamRudd

#37
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!

SamRudd

#38
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

margarett

#39
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 ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

SamRudd

#40
October 24, 2015, 03:53:27 PM
attachments only go upto id 92 but there are hundreds more that should be there

SamRudd

#41
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?

margarett

#42
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...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

SamRudd

#43
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.

margarett

#44
October 24, 2015, 05:45:23 PM
About the menu:
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 ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

SamRudd

#45
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
Print
Go Up Pages1 2 3 All
User actions
Advertisement: