News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Converting from IPB 3,.2 error help

Started by daveo1, October 19, 2020, 12:45:14 PM

Previous topic - Next topic

vbgamer45

You need to remove the , after locked
locked,
To
locked
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

daveo1

New one, Converting posts (this may take some time)... Unsuccessful!
This query:

    SELECT
    p.pid AS id_msg, p.topic_id AS id_topic, p.post_date AS poster_time,
    CASE WHEN p.author_name = '' THEN 0 ELSE p.author_id END AS id_member, SUBSTRING(t.title, 1, 255) AS subject,
    SUBSTRING(p.author_name, 1, 255) AS poster_name,
    SUBSTRING(p.ip_address, 1, 255) AS poster_ip, p.use_emo AS smileys_enabled,
    IFNULL(p.edit_time, 0) AS modified_time, SUBSTRING(p.edit_name, 1, 255) AS modified_name,
    t.forum_id AS id_board, REPLACE(p.post, '<br />', '') AS body,
    SUBSTRING(IFNULL(m.email, '[email protected]'), 1, 255) AS poster_email, 'xx' AS icon
    FROM `doording_ipbforumold`.ipbposts AS p
    LEFT JOIN `doording_ipbforumold`.ipbtopics AS t ON (t.tid = p.topic_id)
    LEFT JOIN `doording_ipbforumold`.ipbmembers AS m ON (m.member_id = p.author_id)
    WHERE t.forum_id IS NOT NULL
    LIMIT 0, 500;

Caused the error:

    1054

Ran thru mysql

Error

SQL query: Documentation

SELECT
p.pid AS id_msg, p.topic_id AS id_topic, p.post_date AS poster_time,
CASE WHEN p.author_name = '' THEN 0 ELSE p.author_id END AS id_member, SUBSTRING(t.title, 1, 255) AS subject,
SUBSTRING(p.author_name, 1, 255) AS poster_name,
SUBSTRING(p.ip_address, 1, 255) AS poster_ip, p.use_emo AS smileys_enabled,
IFNULL(p.edit_time, 0) AS modified_time, SUBSTRING(p.edit_name, 1, 255) AS modified_name,
t.forum_id AS id_board, REPLACE(p.post, '<br />', '') AS body,
SUBSTRING(IFNULL(m.email, '[email protected]'), 1, 255) AS poster_email, 'xx' AS icon
FROM `doording_ipbforumold`.ipbposts AS p
LEFT JOIN `doording_ipbforumold`.ipbtopics AS t ON (t.tid = p.topic_id)
LEFT JOIN `doording_ipbforumold`.ipbmembers AS m ON (m.member_id = p.author_id)
WHERE t.forum_id IS NOT NULL
LIMIT 0, 500

MySQL said: Documentation
#1054 - Unknown column 't.title' in 'field list'

vbgamer45

Replace t.title in the query with
t.topic_subject
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

daveo1

Another, I keep thinking this converter is going to take off anytime ;D

SELECT
p.pid AS id_msg, p.topic_id AS id_topic, p.post_date AS poster_time,
CASE WHEN p.author_name = '' THEN 0 ELSE p.author_id END AS id_member, SUBSTRING(t.topic_subject, 1, 255) AS subject,
SUBSTRING(p.author_name, 1, 255) AS poster_name,
SUBSTRING(p.ip_address, 1, 255) AS poster_ip, p.use_emo AS smileys_enabled,
IFNULL(p.edit_time, 0) AS modified_time, SUBSTRING(p.edit_name, 1, 255) AS modified_name,
t.forum_id AS id_board, REPLACE(p.post, '<br />', '') AS body,
SUBSTRING(IFNULL(m.email, '[email protected]'), 1, 255) AS poster_email, 'xx' AS icon
FROM `doording_ipbforumold`.ipbposts AS p
LEFT JOIN `doording_ipbforumold`.ipbtopics AS t ON (t.tid = p.topic_id)
LEFT JOIN `doording_ipbforumold`.ipbmembers AS m ON (m.member_id = p.author_id)
WHERE t.forum_id IS NOT NULL
LIMIT 0, 500;

Thru mysql

SQL query: Documentation

SELECT
p.pid AS id_msg, p.topic_id AS id_topic, p.post_date AS poster_time,
CASE WHEN p.author_name = '' THEN 0 ELSE p.author_id END AS id_member, SUBSTRING(t.topic_subject, 1, 255) AS subject,
SUBSTRING(p.author_name, 1, 255) AS poster_name,
SUBSTRING(p.ip_address, 1, 255) AS poster_ip, p.use_emo AS smileys_enabled,
IFNULL(p.edit_time, 0) AS modified_time, SUBSTRING(p.edit_name, 1, 255) AS modified_name,
t.forum_id AS id_board, REPLACE(p.post, '<br />', '') AS body,
SUBSTRING(IFNULL(m.email, '[email protected]'), 1, 255) AS poster_email, 'xx' AS icon
FROM `doording_ipbforumold`.ipbposts AS p
LEFT JOIN `doording_ipbforumold`.ipbtopics AS t ON (t.tid = p.topic_id)
LEFT JOIN `doording_ipbforumold`.ipbmembers AS m ON (m.member_id = p.author_id)
WHERE t.forum_id IS NOT NULL
LIMIT 0, 500

MySQL said: Documentation
#1054 - Unknown column 't.tid' in 'on clause'

vbgamer45

Change
ipbtopics AS t ON (t.tid = p.topic_id)
To
ipbtopics AS t ON (t.topic_id = p.topic_id)

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

daveo1

ALMOST there
I searched, this table it is looking for does not exist....Anyway around it?

Converting...
Converting posts (this may take some time)...
Successful.
Recounting post counts... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Unsuccessful!
This query:

    SELECT pl.pid AS id_poll, v.member_id AS id_member
    FROM `doording_ipbforumold`.ipbvoters AS v
    LEFT JOIN `doording_ipbforumold`.ipbpolls AS pl ON (pl.tid = v.tid)
    WHERE v.member_id != 0
    LIMIT 0, 500;

Caused the error:

    1146

Thru MYSQL

Error

SQL query: Documentation

SELECT pl.pid AS id_poll, v.member_id AS id_member
    FROM `doording_ipbforumold`.ipbvoters AS v
    LEFT JOIN `doording_ipbforumold`.ipbpolls AS pl ON (pl.tid = v.tid)
    WHERE v.member_id != 0
    LIMIT 0, 500

MySQL said: Documentation
#1146 - Table 'doording_ipbforumold.ipbvoters' doesn't exist

vbgamer45

Can you  copy over the  fbb_topics as `doording_ipbforumold`.ipbtopics if it doesn't exist...
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

daveo1

Quote from: vbgamer45 on October 26, 2020, 12:58:25 PM
Can you  copy over the  fbb_topics as `doording_ipbforumold`.ipbtopics if it doesn't exist...

You mean ipbvoters? I have no table whatsoever that has voters in it....

vbgamer45

Sorry missed where it said voters thought we we were still on topics
You can remove the poll step then from .sql file if we don't have anything like that just means polls won't have vote history
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

daveo1

Im sure I can :)

Thank you again for the help!

daveo1

OK, Its says complete! So I made myself the ADMIN, go to Admin, Forum Maintenance to run Find and fix any errors. It starts to run, gets to this screen ( I uploaded with this post) Then goes and asks for my password. I enter it, then it says. "Session verification failed. Please try logging out and back in again, and then try again."

I have tried several times, no luck. Any ideas?


vbgamer45

Are you on the latest SMF version for 2.0?
I would also check another browser in case.

Anything else still broken or off?
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

daveo1

I will try another browser.

SOME, post and topics are visible and there. MOST of them  say 0 posts 0 topics. I was thinking this was normal until I ran that utility to find and fix errors.

Im running SMF 2.0.17

daveo1

Quote from: daveo1 on October 26, 2020, 02:04:39 PM
I will try another browser.

SOME, post and topics are visible and there. MOST of them  say 0 posts 0 topics. I was thinking this was normal until I ran that utility to find and fix errors.

Im running SMF 2.0.17

Same thing in two other browsers....

daveo1

I did get it to go, most forums are still missing topics and posts. Im gona try and figure it out....

Advertisement: