News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Converting from IPB 3,.2 error help

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

Previous topic - Next topic

vbgamer45

But which table is it saying the error now? you had it working on previous queries we had for topics.
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

Well it seems to depend on when I put that   ;   on the end of that last line.... DOESN'T make since does it?

vbgamer45

It could I guess depends on how it was coded and how it picks it up.
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 21, 2020, 02:57:42 PM
It could I guess depends on how it was coded and how it picks it up.

Let me try a couple things, see if I can figure something out. This thing is close, I hate to give up on it now ;D

vbgamer45

If you can post the file that you have right now I can review the .sql file.
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 21, 2020, 03:09:54 PM
If you can post the file that you have right now I can review the .sql file.

The converter file or the db file?



Here are the two errors, the first one with the  ;  The second error without the   ; on the end of the last line.

onverting...
Converting members...
Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    SELECT
    t.topic_id AS id_topic, t.topic_is_sticky AS is_sticky, t.forum_id AS id_board,
    t.user_id AS id_member_started, t.topic_last_poster_id AS id_member_updated,
    IFNULL(pl.pid,0) AS id_poll, t.topic_replies AS num_replies, t.topic_views AS num_views,
    MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg,
    t.topic_is_closed AS locked, approved
    FROM (`doording_ipbforumold`.ipbtopics AS t, `doording_ipbforumold`.ipbposts AS p)
    LEFT JOIN `doording_ipbforumold`.ipbpolls AS pl ON (pl.tid = t.topic_id)
    WHERE p.topic_id = t.topic_id
    GROUP BY t.topic_id
    HAVING id_first_msg != 0
    AND id_last_msg != 0
    LIMIT 0, 500;

Caused the error:

    1054

Converting...
Converting members...
Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Error in convert script - line 154!
Error in convert script - line 157!
Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:

    SELECT
    t.topic_id AS id_topic, t.topic_is_sticky AS is_sticky, t.forum_id AS id_board,
    t.user_id AS id_member_started, t.topic_last_poster_id AS id_member_updated,
    IFNULL(pl.pid,0) AS id_poll, t.topic_replies AS num_replies, t.topic_views AS num_views,
    MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg,
    t.topic_is_closed AS locked, approved
    FROM (`doording_ipbforumold`.ipbtopics AS t, `doording_ipbforumold`.ipbposts AS p)
    LEFT JOIN `doording_ipbforumold`.ipbpolls AS pl ON (pl.tid = t.topic_id)
    WHERE p.topic_id = t.topic_id
    GROUP BY t.topic_id
    HAVING id_first_msg != 0
    AND id_last_msg != 0
    TRUNCATE `doording_smf`.qza_messages;

Caused the error:

    1064




daveo1

Whatever its worth, the forum shows on all categories the topic count but zero posts...

vbgamer45

For the last part not showing posts. Is due to the conversion failing on the posts set.


Do these database tables exist: ? `doording_ipbforumold`.ipbtopics and doording_ipbforumold`.ipbposts

The database should be called doording_ipbforumold
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

Well, its complicated...

That database is there ipbforumold.

ibposts is there

ibtopics only exists because I renamed fbbtopics to ibtopics, but it seemed to work. Maybe not a good idea, but there was no ibtopics.


daveo1

To add to that, I ran it both ways, with Fbbtopics or renamed to ipbtopics. No difference....

vbgamer45

What happens when you run this query manually via mysql or phpmyadmin


    SELECT
    t.topic_id AS id_topic, t.topic_is_sticky AS is_sticky, t.forum_id AS id_board,
    t.user_id AS id_member_started, t.topic_last_poster_id AS id_member_updated,
    IFNULL(pl.pid,0) AS id_poll, t.topic_replies AS num_replies, t.topic_views AS num_views,
    MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg,
    t.topic_is_closed AS locked, approved
    FROM (`doording_ipbforumold`.ipbtopics AS t, `doording_ipbforumold`.ipbposts AS p)
    LEFT JOIN `doording_ipbforumold`.ipbpolls AS pl ON (pl.tid = t.topic_id)
    WHERE p.topic_id = t.topic_id
    GROUP BY t.topic_id
    HAVING id_first_msg != 0
    AND id_last_msg != 0
    LIMIT 0, 500;

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

Error

SQL query: Documentation

SELECT
    t.topic_id AS id_topic, t.topic_is_sticky AS is_sticky, t.forum_id AS id_board,
    t.user_id AS id_member_started, t.topic_last_poster_id AS id_member_updated,
    IFNULL(pl.pid,0) AS id_poll, t.topic_replies AS num_replies, t.topic_views AS num_views,
    MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg,
    t.topic_is_closed AS locked, approved
    FROM (`doording_ipbforumold`.ipbtopics AS t, `doording_ipbforumold`.ipbposts AS p)
    LEFT JOIN `doording_ipbforumold`.ipbpolls AS pl ON (pl.tid = t.topic_id)
    WHERE p.topic_id = t.topic_id
    GROUP BY t.topic_id
    HAVING id_first_msg != 0
    AND id_last_msg != 0
    LIMIT 0, 500

MySQL said: Documentation
#1054 - Unknown column 'approved' in 'field list'

vbgamer45

Take out this part of the query
Change
, approved
To
, 1 as approved

Or if not remove , approved
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'll give it a shot later today! Thanks!

daveo1

Same error both ways...

Converting boards... Successful.
Converting topics...Error in convert script - line 154!
Error in convert script - line 157!
Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:

    SELECT
    t.topic_id AS id_topic, t.topic_is_sticky AS is_sticky, t.forum_id AS id_board,
    t.user_id AS id_member_started, t.topic_last_poster_id AS id_member_updated,
    IFNULL(pl.pid,0) AS id_poll, t.topic_replies AS num_replies, t.topic_views AS num_views,
    MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg,
    t.topic_is_closed AS locked,
    FROM (`doording_ipbforumold`.ipbtopics AS t, `doording_ipbforumold`.ipbposts AS p)
    LEFT JOIN `doording_ipbforumold`.ipbpolls AS pl ON (pl.tid = t.topic_id)
    WHERE p.topic_id = t.topic_id
    GROUP BY t.topic_id
    HAVING id_first_msg != 0
    AND id_last_msg != 0
    TRUNCATE `doording_smf`.qza_messages;

Caused the error:

    1064


vbgamer45

Make sure to add ;
after   AND id_last_msg != 0

If it fails again run that query on phpmyadmin and see what it returns
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

This and I'm going to add another in a few...

Error

Static analysis:

1 errors were found during analysis.

    An expression was expected. (near "FROM" at position 367)

SQL query: Documentation

SELECT t.topic_id AS id_topic, t.topic_is_sticky AS is_sticky, t.forum_id AS id_board, t.user_id AS id_member_started, t.topic_last_poster_id AS id_member_updated, IFNULL(pl.pid,0) AS id_poll, t.topic_replies AS num_replies, t.topic_views AS num_views, MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg, t.topic_is_closed AS locked, FROM (`doording_ipbforumold`.ipbtopics AS t, `doording_ipbforumold`.ipbposts AS p) LEFT JOIN `doording_ipbforumold`.ipbpolls AS pl ON (pl.tid = t.topic_id) WHERE p.topic_id = t.topic_id GROUP BY t.topic_id HAVING id_first_msg != 0 AND id_last_msg != 0 LIMIT 0, 500

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM (`doording_ipbforumold`.ipbtopics AS t, `doording_ipbforumold`.ipbposts AS ' at line 7

daveo1

Static analysis:

1 errors were found during analysis.

    An expression was expected. (near "FROM" at position 367)

SQL query: Documentation

SELECT t.topic_id AS id_topic, t.topic_is_sticky AS is_sticky, t.forum_id AS id_board, t.user_id AS id_member_started, t.topic_last_poster_id AS id_member_updated, IFNULL(pl.pid,0) AS id_poll, t.topic_replies AS num_replies, t.topic_views AS num_views, MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg, t.topic_is_closed AS locked, FROM (`doording_ipbforumold`.ipbtopics AS t, `doording_ipbforumold`.ipbposts AS p) LEFT JOIN `doording_ipbforumold`.ipbpolls AS pl ON (pl.tid = t.topic_id) WHERE p.topic_id = t.topic_id GROUP BY t.topic_id HAVING id_first_msg != 0 AND id_last_msg != 0 LIMIT 0, 500

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM (`doording_ipbforumold`.ipbtopics AS t, `doording_ipbforumold`.ipbposts AS ' at line 7

Advertisement: