I'm trying to convert but I get the message
The error MySQL gave was: Access denied for user 'smf'@'192.168.0.%' to database 'phorum'
Both databases are on the same server
the MySQL user for both databases must be the same. SMF needs at least read access to your phorum database
Is the a simple patch/edit to overcome the need to have the same user on both databases.
My hosting company refuses to give one user access to both database "for security reasons"
You also can use the same database for SMF and Phorum without issues. All SMF tables use a table prefix (default is smf_) .
All looking good apart from the conversion of PM's which gives
Converting personal messages (step 1)... Unsuccessful!
This query:
SELECT
p.private_message_id AS ID_PM, p.from_user_id AS ID_MEMBER_FROM,
p.datestamp AS msgtime,
SUBSTRING(IFNULL(u.username, p.from_username), 1, 255) AS fromName,
SUBSTRING(p.subject, 1, 255) AS subject,
SUBSTRING(p.message, 1, 255) AS body, p.from_del_flag AS deletedBySender
FROM `phorum`.phorum_private_messages AS p
LEFT JOIN `phorum`.phorum_users AS u ON (u.user_id = p.from_user_id)
LIMIT 0, 500;
Caused the error:
Table 'phorum.phorum_private_messages' doesn't exist
Anyone seen this before?
I assume the answer is - find out the name of the table in Phorum version 5.1.15 and edit the convert.php file - unfortunately I don't know the first or how to do the second.
can you check your phorum database with phpMyAdmin? maybe there is a table named priv_messages or similar?
The relevant tables appear to be:
phorum_pm_messages
phorum_pm_buddies
phorum_pm_xref
phorum_pm_folders
there is also a phorum_messages
Our converter was developed for Phorum 5.
I guess they changed this in 5.1
On the phorum_pm_messages,
Could you click Structure.
Then post or pm the Table that you get.
This is how the table is setup. This way I can know if they just changed the table name, or also the column names (and/or complicated things more).
hi, sorry for my noob question but what happens when i run the convert.php? does it overwrite files or does it back up and create new files?
Our converter will copy the content (users, Posts, topics..) from your Phorum to a fresh installed SMF.
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
hi i got a problem while converting from phorum to smf
please help
heres the error log
Converting topics... Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO `forum`.smf_messages
(ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, SUBSTRING(m.subject, 1, 255), posterEmail, posterName, ID_BOARD, posterIP, body, modifiedName, icon)
VALUES ('1', '1', '1196379009', '0', 'Test Message', '', 'Phorum Installer', '2', '127.0.0.1', 'This is a test message.
then at the bottom of the error it says
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 'SUBSTRING(m.subject, 1, 255), posterEmail, posterName, ID_BOARD, posterIP, body,' at line 2
Try the attached file.
I tried this attachment because I ran into the same error. It gives the following result:
Converting...
Converting members...Unknown column 'memberName' in 'field list'
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Removing polls... Successful.
Converting personal messages (step 1)... Unsuccessful!
This query:
SELECT
p.pm_message_id AS id_pm, p.from_user_id AS id_member_from,
p.datestamp AS msgtime,
SUBSTRING(IFNULL(u.username, p.from_username), 1, 255) AS from_name,
SUBSTRING(p.subject, 1, 255) AS subject,
SUBSTRING(p.message, 1, 255) AS body, p.from_del_flag AS deleted_by_sender
FROM `CN20050958_rock`.phorum_pm_messages AS p
LEFT JOIN `CN20050958_rock`.phorum_users AS u ON (u.user_id = p.from_user_id)
LIMIT 0, 500;
Caused the error:
Unknown column 'p.from_user_id' in 'field list'
This error is the result of a completely different setup for the private messages tables. If anyone can help me out getting the phorum_to_smf.sql file setup correctly I would be most greatful.
Hans
If you can give us the structure of your table, we can probably get things sorted out for you.
phorum_pm_messages table
Veld Type Collatie AttributNullStandaar Extra
pm_message_id int(10) UNSIGNEDNee Geen AUTO_INCREMENT
user_id int(10) UNSIGNEDNee 0
author varchar(255utf8_general_ci Nee
subject varchar(100utf8_general_ci Nee
message text utf8_general_ci Nee Geen
datestamp int(10) UNSIGNEDNee 0
meta mediumtext utf8_general_ci Nee Geen
phorum_pm_xref table structure
Veld Type Collatie Attribut Null Standaar Extra
pm_xref_id int(10) UNSIGNEDNee Geen AUTO_INCREMENT
user_id int(10) UNSIGNEDNee 0
pm_folder_id int(10) UNSIGNEDNee 0
special_folder varchar(10) utf8_general_ci Ja NULL
pm_message_id int(10) UNSIGNEDNee 0
read_flag tinyint(1) Nee 0
reply_flag tinyint(1) Nee 0
porum_pm_folders table structure
Veld Type CollatiAttributNullStandaar Extra
pm_folder_idint(10) UNSIGNEDNee Geen AUTO_INCREMENT
user_id int(10) UNSIGNEDNee 0
phorum_pm_buddies table structure
Veld Type CollatieAttribut Null Standaar Extra
pm_buddy_id int(10) UNSIGNEDNee Geen AUTO_INCREMENT
user_id int(10) UNSIGNEDNee 0
buddy_user_id int(10) UNSIGNEDNee 0
Ok. Is the "xref" table the one that contains information about the person who sent the message?
I have look at the content in the tables and it seems to me to be like this:
phorum_pm_messages contains the messages, together with the sender id, (author id and author name). With the message_id you can lookup the rest of the information on the private message in the xref table, where the user_id signifies the receiver. Here read, reply and folder information is kept. So you need a join of these 2 tables to have all needed information to convert to smf.
Hope this helps,
Hans
Ok. Should be pretty easy to fix then. Which sql file were you using with convert.php?
I tried both the phorumtosmf.sql included with the converter package and the phorumtosmf.sql file included with this thread. Both give errors with wrong table names etc.
Thanks,
Hans
Here it is fixed version for converting
There are a lot of error in the table name for SMF itself in this file. Lots of tables have capitals for names which are lowercase and some have tableField where it should be table_field.
I have tried to correct the sql file for this, I now get this response:
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Removing polls... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)...Duplicate entry '653-6' for key 'PRIMARY'
Quote from: hhouwaard on October 29, 2011, 01:09:29 PM
There are a lot of error in the table name for SMF itself in this file. Lots of tables have capitals for names which are lowercase and some have tableField where it should be table_field.
I haven't receive any error when use this script. I work with clear installed versions of Phorum and SMF, possibly you have made changes in your tables. Or you use it with SMF version 2.0 instance of SMF 1.1.15
Quote from: hhouwaard on October 29, 2011, 01:09:29 PM
I have tried to correct the sql file for this, I now get this response:
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Removing polls... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)...Duplicate entry '653-6' for key 'PRIMARY'
This error is going from php file convert.php. They tried to recalculate some stats. But you can make this in smf.
After using this script I got all forums, messages and users in SMF.
I do use Phorum 5.2.15 and SMF 2. So that could explain it. I will go and see if all users and messages indeed made the transfer to SMF. Thanks for the help!
Hans
Please upgrade this converter to the last version of phorum!!! the current version dont works!
Wualala, which version of Phorum are you using, and what problems are you experiencing with the current converter?