Advertisement:

Author Topic: Ip board 3.4.6 to smf Converting problem  (Read 8416 times)

Offline punjabizone

  • Semi-Newbie
  • *
  • Posts: 56
Ip board 3.4.6 to smf Converting problem
« 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 .

kat

  • Guest
Re: Ip board 3.4.6 to smf Converting problem
« Reply #1 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?

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,072
Re: Ip board 3.4.6 to smf Converting problem
« Reply #2 on: July 12, 2014, 06:09:06 AM »

Offline punjabizone

  • Semi-Newbie
  • *
  • Posts: 56
Re: Ip board 3.4.6 to smf Converting problem
« Reply #3 on: July 12, 2014, 01:03:47 PM »
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?

Offline punjabizone

  • Semi-Newbie
  • *
  • Posts: 56
Re: Ip board 3.4.6 to smf Converting problem
« Reply #4 on: July 12, 2014, 01:08:49 PM »
Thank you ILLori
i don't understand how i can fix this my host has cpnel
Quote
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

Offline punjabizone

  • Semi-Newbie
  • *
  • Posts: 56
Re: Ip board 3.4.6 to smf Converting problem
« Reply #5 on: July 13, 2014, 01:26:33 AM »
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'

Offline punjabizone

  • Semi-Newbie
  • *
  • Posts: 56
Re: Ip board 3.4.6 to smf Converting problem
« Reply #6 on: July 13, 2014, 10:54:56 AM »
Anyone plz help me to fix this error

Offline punjabizone

  • Semi-Newbie
  • *
  • Posts: 56
Re: Ip board 3.4.6 to smf Converting problem
« Reply #7 on: July 13, 2014, 01:07:10 PM »
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)