Advertisement:

Author Topic: Converting from IPB 3,.2 error help  (Read 4903 times)

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,048
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from IPB 3,.2 error help
« Reply #40 on: October 23, 2020, 05:20:36 PM »
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

Offline daveo1

  • Semi-Newbie
  • *
  • Posts: 69
Re: Converting from IPB 3,.2 error help
« Reply #41 on: October 23, 2020, 05:36:54 PM »
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, 'guest@example.com'), 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, 'guest@example.com'), 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'

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,048
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from IPB 3,.2 error help
« Reply #42 on: October 23, 2020, 06:05:19 PM »
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

Offline daveo1

  • Semi-Newbie
  • *
  • Posts: 69
Re: Converting from IPB 3,.2 error help
« Reply #43 on: October 25, 2020, 10:16:07 AM »
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, 'guest@example.com'), 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, 'guest@example.com'), 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'

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,048
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from IPB 3,.2 error help
« Reply #44 on: October 25, 2020, 12:23:14 PM »
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

Offline daveo1

  • Semi-Newbie
  • *
  • Posts: 69
Re: Converting from IPB 3,.2 error help
« Reply #45 on: October 26, 2020, 12:55:31 PM »
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

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,048
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from IPB 3,.2 error help
« Reply #46 on: October 26, 2020, 12:58:25 PM »
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

Offline daveo1

  • Semi-Newbie
  • *
  • Posts: 69
Re: Converting from IPB 3,.2 error help
« Reply #47 on: October 26, 2020, 01:12:29 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....

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,048
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from IPB 3,.2 error help
« Reply #48 on: October 26, 2020, 01:20:01 PM »
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

Offline daveo1

  • Semi-Newbie
  • *
  • Posts: 69
Re: Converting from IPB 3,.2 error help
« Reply #49 on: October 26, 2020, 01:26:11 PM »
Im sure I can :)

Thank you again for the help!

Offline daveo1

  • Semi-Newbie
  • *
  • Posts: 69
Re: Converting from IPB 3,.2 error help
« Reply #50 on: October 26, 2020, 01:51:57 PM »
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?


Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,048
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from IPB 3,.2 error help
« Reply #51 on: October 26, 2020, 01:54:02 PM »
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

Offline daveo1

  • Semi-Newbie
  • *
  • Posts: 69
Re: Converting from IPB 3,.2 error help
« Reply #52 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

Offline daveo1

  • Semi-Newbie
  • *
  • Posts: 69
Re: Converting from IPB 3,.2 error help
« Reply #53 on: October 26, 2020, 02:25:00 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....

Offline daveo1

  • Semi-Newbie
  • *
  • Posts: 69
Re: Converting from IPB 3,.2 error help
« Reply #54 on: October 26, 2020, 03:22:28 PM »
I did get it to go, most forums are still missing topics and posts. Im gona try and figure it out....