Converting from IPB 3,.2 error help

[daveo1]

Im helping a friend convert a forum and I ran into this while going thru topics. It really doesnt give too many details on it. Another non working forum!

Converting...
Converting topics...
Unsuccessful!
This query:

    SELECT
    t.tid AS id_topic, t.pinned AS is_sticky, t.forum_id AS id_board,
    t.starter_id AS id_member_started, t.last_poster_id AS id_member_updated,
    IFNULL(pl.pid,0) AS id_poll, t.posts AS num_replies, t.views AS num_views,
    MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg,
    t.state = '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.tid)
    WHERE p.topic_id = t.tid
    GROUP BY t.tid
    HAVING id_first_msg != 0
    AND id_last_msg != 0
    LIMIT 0, 500;

Caused the error:

    1146

[vbgamer45]

It means a table does not exist.
Try to run that query manually to get the full error message via phpmyadmin or mysql command prompt

[daveo1]

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

Damnit, Im looking thru his back ups now

[daveo1]

Some "genius" converted the forum from fusionbb to IPB and the topics table that is in there was rigged somehow to work with IBP. Its the only one rigged to work. I renamed it to the correct table and it spits up another error. I guess cause the structure is different....Im not so sure I can make this table work.

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

[vbgamer45]

Do a mysql below and post back
show create table doording_ipbforumold.ipbtopics;

[daveo1]

Thank you again! Does this help?


Your SQL query has been executed successfully.
show create table doording_ipbforumold.ipbtopics
Profiling [Edit inline] [ Edit ] [ Create PHP code ] [ Refresh]
+ Options
Table    Create Table    
ipbtopics    CREATE TABLE `ipbtopics` (
`topic_id` mediumint(...

[daveo1]

    SELECT
    t.tid AS id_topic, t.pinned AS is_sticky, t.forum_id AS id_board,
    t.starter_id AS id_member_started, t.last_poster_id AS id_member_updated,
    IFNULL(pl.pid,0) AS id_poll, t.posts AS num_replies, t.views AS num_views,
    MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg,
    t.state = '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.tid)
    WHERE p.topic_id = t.tid
    GROUP BY t.tid
    HAVING id_first_msg != 0
    AND id_last_msg != 0
    LIMIT 0, 500;

Caused the error:

    1054

[vbgamer45]

Thank you again! Does this help?


Your SQL query has been executed successfully.
show create table doording_ipbforumold.ipbtopics
Profiling [Edit inline] [ Edit ] [ Create PHP code ] [ Refresh]
+ Options
Table    Create Table    
ipbtopics    CREATE TABLE `ipbtopics` (
`topic_id` mediumint(...

close but need to see beyond the ...

[daveo1]

This?

CREATE TABLE `ipbtopics` (
`topic_id` mediumint( unsigned NOT NULL AUTO_INCREMENT,
`forum_id` mediumint( unsigned NOT NULL DEFAULT '0',
`user_id` mediumint( unsigned NOT NULL DEFAULT '0',
`topic_username` varchar(100) NOT NULL DEFAULT '',
`topic_name_color` varchar(15) NOT NULL DEFAULT '',
`topic_group_flag` varchar(30) NOT NULL DEFAULT '',
`topic_subject` varchar(255) DEFAULT NULL,
`topic_prefix` varchar(100) NOT NULL DEFAULT '',
`topic_replies` mediumint(4) unsigned DEFAULT '0',
`topic_views` mediumint( unsigned DEFAULT '0',
`topic_first_post_id` mediumint( unsigned NOT NULL DEFAULT '0',
`topic_first_post_time` int(11) unsigned DEFAULT NULL,
`topic_last_post_id` mediumint( NOT NULL DEFAULT '0',
`topic_last_post_time` int(11) unsigned NOT NULL DEFAULT '0',
`topic_last_poster` varchar(100) NOT NULL DEFAULT '',
`topic_is_sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
`topic_is_closed` tinyint(1) unsigned NOT NULL DEFAULT '0',
`topic_icon` varchar(50) DEFAULT NULL,
`topic_files` tinyint(4) unsigned DEFAULT '0',
`topic_polls` tinyint(4) unsigned DEFAULT '0',
`topic_thumb` varchar(150) DEFAULT NULL,
`topic_moved` mediumint( NOT NULL DEFAULT '0',
`topic_preview` varchar(200) DEFAULT NULL,
`topic_in_portal` tinyint(1) unsigned NOT NULL DEFAULT '0',
`import_insert_id` int(11) DEFAULT NULL,
`topic_event` mediumint( unsigned NOT NULL DEFAULT '0',
`topic_event_start` int(11) unsigned NOT NULL DEFAULT '0',
`topic_event_end` int(11) unsigned NOT NULL DEFAULT '0',
`is_moderated` tinyint(1) NOT NULL DEFAULT '0',
`rating` int(3) NOT NULL DEFAULT '0',
`topic_meta_desc` text NOT NULL,
`topic_meta_kywd` text NOT NULL,
`topic_announcement` tinyint(1) NOT NULL DEFAULT '0',
`topic_last_poster_id` mediumint( NOT NULL,
PRIMARY KEY (`topic_id`),
KEY `user_index` (`user_id`),
KEY `last_poster_index` (`topic_last_poster`),
KEY `username_index` (`topic_username`),
KEY `forum_index` (`forum_id`,`topic_is_sticky`,`topic_last_post_time`),
KEY `moved_ndx` (`topic_moved`),
KEY `topic_thumb_index` (`topic_thumb`),
FULLTEXT KEY `topic_subject` (`topic_subject`)
) ENGINE=MyISAM AUTO_INCREMENT=74667 DEFAULT CHARSET=latin1

[vbgamer45]

Change

Code Select Expand


    SELECT
    t.tid AS id_topic, t.pinned AS is_sticky, t.forum_id AS id_board,
    t.starter_id AS id_member_started, t.last_poster_id AS id_member_updated,
    IFNULL(pl.pid,0) AS id_poll, t.posts AS num_replies, t.views AS num_views,
    MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg,
    t.state = '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.tid)
    WHERE p.topic_id = t.tid
    GROUP BY t.tid
    HAVING id_first_msg != 0
    AND id_last_msg != 0
    LIMIT 0, 500;


To

Code Select Expand


    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.opic_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;


[daveo1]

That fixed it! I got another

Here is the error...
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.opic_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

Here is the table in the db

CREATE TABLE `ipbposts` (
`pid` int(10) NOT NULL AUTO_INCREMENT,
`append_edit` tinyint(1) DEFAULT '0',
`edit_time` int(10) DEFAULT NULL,
`author_id` mediumint( NOT NULL DEFAULT '0',
`author_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`use_sig` tinyint(1) NOT NULL DEFAULT '0',
`use_emo` tinyint(1) NOT NULL DEFAULT '0',
`ip_address` varchar(46) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`post_date` int(10) DEFAULT NULL,
`post` mediumtext COLLATE utf8mb4_unicode_ci,
`queued` tinyint(1) NOT NULL DEFAULT '0',
`topic_id` int(10) NOT NULL DEFAULT '0',
`new_topic` tinyint(1) DEFAULT '0',
`edit_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`post_key` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`post_htmlstate` smallint(1) NOT NULL DEFAULT '0',
`post_edit_reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`post_bwoptions` int(10) unsigned NOT NULL DEFAULT '0',
`pdelete_time` int(11) NOT NULL DEFAULT '0',
`post_field_int` int(10) NOT NULL DEFAULT '0',
`post_field_t1` text COLLATE utf8mb4_unicode_ci,
`post_field_t2` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`pid`),
KEY `topic_id` (`topic_id`,`queued`,`pid`,`post_date`),
KEY `author_id` (`author_id`,`post_date`,`queued`),
KEY `post_date` (`post_date`),
KEY `ip_address` (`ip_address`),
KEY `post_key` (`post_key`),
KEY `queued` (`queued`,`pdelete_time`),
FULLTEXT KEY `post` (`post`)
) ENGINE=MyISAM AUTO_INCREMENT=359789 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

[daveo1]

Script from the converter

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 {$from_prefix}posts AS p
   LEFT JOIN {$from_prefix}topics AS t ON (t.tid = p.topic_id)
   LEFT JOIN {$from_prefix}members AS m ON (m.member_id = p.author_id)
WHERE t.forum_id IS NOT NULL;
---*

[vbgamer45]

That fixed it! I got another

Here is the error...
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.opic_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

Here is the table in the db

CREATE TABLE `ipbposts` (
`pid` int(10) NOT NULL AUTO_INCREMENT,
`append_edit` tinyint(1) DEFAULT '0',
`edit_time` int(10) DEFAULT NULL,
`author_id` mediumint( NOT NULL DEFAULT '0',
`author_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`use_sig` tinyint(1) NOT NULL DEFAULT '0',
`use_emo` tinyint(1) NOT NULL DEFAULT '0',
`ip_address` varchar(46) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`post_date` int(10) DEFAULT NULL,
`post` mediumtext COLLATE utf8mb4_unicode_ci,
`queued` tinyint(1) NOT NULL DEFAULT '0',
`topic_id` int(10) NOT NULL DEFAULT '0',
`new_topic` tinyint(1) DEFAULT '0',
`edit_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`post_key` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`post_htmlstate` smallint(1) NOT NULL DEFAULT '0',
`post_edit_reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`post_bwoptions` int(10) unsigned NOT NULL DEFAULT '0',
`pdelete_time` int(11) NOT NULL DEFAULT '0',
`post_field_int` int(10) NOT NULL DEFAULT '0',
`post_field_t1` text COLLATE utf8mb4_unicode_ci,
`post_field_t2` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`pid`),
KEY `topic_id` (`topic_id`,`queued`,`pid`,`post_date`),
KEY `author_id` (`author_id`,`post_date`,`queued`),
KEY `post_date` (`post_date`),
KEY `ip_address` (`ip_address`),
KEY `post_key` (`post_key`),
KEY `queued` (`queued`,`pdelete_time`),
FULLTEXT KEY `post` (`post`)
) ENGINE=MyISAM AUTO_INCREMENT=359789 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Minor change for first one

Code Select Expand


    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


[daveo1]

Thank you! I'll be messing with it again tomorrow afternoon. Beer time right now, I cant mess with this and drink! Lol...I hope I can get it, and not waste a bunch of your time!

Thank you again!

[daveo1]

Got a little further!

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

[vbgamer45]

There should be a ; after
AND id_last_msg != 0

Since those are two different queries

[daveo1]

There should be a ; after
AND id_last_msg != 0

Since those are two different queries

I think I tried that, but I'm going to do it again to rule it out.

[daveo1]

I did and this is the error now....

Converting...
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:

    1146

[vbgamer45]

1146 is table does not exist. Try running the query manually and see what the full error message is

[daveo1]

It doesnt exist, like I said in the begging, some genius that originally converted the forum from Fusion to IPB, somehow used the fbb_topics table and made it work with IPB. No idea why, I'm sure there was a good reason or maybe not 

[vbgamer45]

But which table is it saying the error now? you had it working on previous queries we had for topics.

[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.

[daveo1]

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

[vbgamer45]

If you can post the file that you have right now I can review the .sql file.

[daveo1]

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]

This?

[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

[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

Code Select Expand



    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;



[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

[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

[daveo1]

On it!

[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

[vbgamer45]

You need to remove the , after locked
locked,
To
locked

[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

[daveo1]

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

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)

[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...

[daveo1]

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

[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?

[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]

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....