SMF Support > IPB

[SMF Converter] IPB 2.0.x

<< < (6/8) > >>

SleePy:
Personally I would recommend any MySQL 5 version (I am using the latest 5.0 release which is 5.0.51 5.0.67 I believe) as it is supported by the MySQL AB team and has improvements over the older versions, but even having any version of MySQL 4 would be better than what you currently have.

If you are going to upgrade MySQL, please make sure to read the MySQL documentation on upgrading and have backups incase the worse happens.

sokoll:
Hi, I backup Data Base hosts  MySQL (3.23.58) and restored at localhost ( MySQL 5.0.45). Started converter and it caused an error

"Сonverting...
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)...Error in convert script - line 321!
Error in convert script - line 323!
Error in convert script - line 324!
Error in convert script - line 335!
Error in convert script - line 338!
Successful.
Converting topic notifications... Unsuccessful!
This query:
SELECT pm.ID_PM, m.mt_vid_folder AS folder
FROM `db_premacy`.smf_personal_messages AS pm
INNER JOIN `db_premacy`.ipb_message_topics AS m ON (m.mt_msg_id = pm.ID_PM)
WHERE m.mt_vid_folder = 'sent'
TRUNCATE `db_premacy`.smf_log_notify;
Caused the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUNCATE `db_premacy`.smf_log_notify' at line 5"

Please, give me some recommendations
 

SleePy:
Ooops forgot the closing ; on two queries.

sokoll:
Thank's, but it caused the next error:

"Converting...
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Unsuccessful!
This query:
INSERT INTO `db_premacy`.smf_membergroups
(ID_GROUP, groupName, maxMessages, onlineColor, stars)
VALUES
(7 + 3, SUBSTRING('Модераторы', 1, 255), 50, '', '');
Caused the error:

Duplicate entry '10' for key 1"

SleePy:
Alright, hopefully this one gets it.

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version