Simple Machines Community Forum
SMF Support => Converting to SMF => IPB => Topic started by: punjabizone on July 12, 2014, 01:49:23 AM
-
hello SMF support team i am trying to convert my board ip board 3.4.6 to SMF
i am using the lastest converter from this topic
http://www.simplemachines.org/community/index.php?topic=477019.0
i am getting this error !
"Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 3.2. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.
The error that was received from the Database was: SELECT command denied to user 'punjabi_forum'@'localhost' for table 'members'"
I am so frusted on this error i already search on this error i can't find solution please tell me what i have to do in order to fix it .
-
You've checked that you DO have permission? The database name/password you're using ARE correct?
-
please read the stickies.
http://www.simplemachines.org/community/index.php?topic=146192.0
-
thank you for reply what is DO permission how i can check this
yes i am using correrct database name and password
You've checked that you DO have permission? The database name/password you're using ARE correct?
-
Thank you ILLori
i don't understand how i can fix this my host has cpnel
Fix: If your host has cPanel you can add the SMF database user to Software X's database. If your host does not have cPanel you can contact them with regards on how to accomplish this. As well as a last resort, what you can do is reinstall SMF in the same database as Software X.
so its mean i have to install smf with same database and username that i am using on my old forum
please read the stickies.
http://www.simplemachines.org/community/index.php?topic=146192.0
-
okay now i already fix the above
now i am facing new error when i trying to convert members i got this error now
Converting...
Converting members... Unsuccessful!
This query:
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
m.title AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, '0001', m.bday_year), IF(m.bday_month = 0, '01', IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, '01', IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `punjabi_s`.members AS m
LEFT JOIN `punjabi_s`.pfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `punjabi_s`.profile_portal AS pp ON (pp.pp_member_id = m.member_id)
LIMIT 0, 500;
Caused the error:
Unknown column 'pc.field_3' in 'field list'
-
Anyone plz help me to fix this error
-
Any smf support specialist here I need help I am keep getting this erro when I converting to smf please help I did 5 times restart the converting still getting error anyone here to help me
Converting...
Converting members... Unsuccessful!
This query:
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, AS password_salt,
m.title AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, '0001', m.bday_year), IF(m.bday_month = 0, '01', IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, '01', IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `punjabi_s`.members AS m
LEFT JOIN `punjabi_s`.pfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `punjabi_s`.profile_portal AS pp ON (pp.pp_member_id = m.member_id)