News:

Wondering if this will always be free?  See why free is better.

Main Menu

Ip board 3.4.6 to smf Converting problem

Started by punjabizone, July 12, 2014, 01:49:23 AM

Previous topic - Next topic

punjabizone

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 .

kat

You've checked that you DO have permission? The database name/password you're using ARE correct?


punjabizone

thank you for reply what is  DO permission how i can check this
yes i am using correrct database name and password
Quote from: K@ on July 12, 2014, 04:44:47 AM
You've checked that you DO have permission? The database name/password you're using ARE correct?

punjabizone

Thank you ILLori
i don't understand how i can fix this my host has cpnel
QuoteFix: 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
Quote from: Illori on July 12, 2014, 06:09:06 AM
please read the stickies.

http://www.simplemachines.org/community/index.php?topic=146192.0

punjabizone

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'

punjabizone


punjabizone

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)

Advertisement: