Issue: Find and repair any errors

[emanuele]

I'll be (unexpectedly) out for a couple of days, will come back when I'll be back. Sorry.

[InfoStrides]

I'll be (unexpectedly) out for a couple of days, will come back when I'll be back. Sorry.

OK. Thanks.

[emanuele]

Sorry if days are summing up...

* emanuele has been working a bit on 2.1... (that's a good excuse for a lot of things )

Seriously, I'll try to take a look at it tomorrow.

[InfoStrides]

Sorry if days are summing up...

* emanuele has been working a bit on 2.1... (that's a good excuse for a lot of things )

Seriously, I'll try to take a look at it tomorrow.

Not a problem. I understand and will wait for you. Thanks.

[emanuele]

I'm very sorry, but at that point I have to admit you will have to wait for a long time...

Maybe it's better if I move the topic to the support board, maybe someone can help you better than me...

[emanuele]

Recently, I had some issues with Google on some words. I had to remove all posts with such words from the database.

Did you remove the posts or the topics? Or both?

[InfoStrides]

Recently, I had some issues with Google on some words. I had to remove all posts with such words from the database.

Did you remove the posts or the topics? Or both?

Both.

[emanuele]

IT may or maynot help, but is the query I added to "Populate" (the script I use to generate posts in test forums) to fix the errors I encountered that were not fixed by the SMF maintenance task:

Code Select Expand

UPDATE {db_prefix}messages as mes, {db_prefix}topics as top
SET mes.id_board = top.id_board
WHERE mes.id_topic = top.id_topic
Of course replace {db_prefix} with the prefix you used for your SMF installation.
To run it you have to go to phpmyadmin.

[InfoStrides]

Thank you for your help. I did run the query with the following confirmation:

0 rows affected. ( Query took 0.7295 sec )

I check the issue, it was not resolved.

[emanuele]

Could you try that one too:

Code Select Expand

SELECT m.id_msg, m.id_topic
FROM {db_preifx}messages as m
LEFT OUTER JOIN {db_preifx}topics as t ON (m.id_topic = t.id_topic)
WHERE t.id_topic IS NULL

[InfoStrides]

Tried but no change yet. Here is the output message:

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.1520 sec )

[emanuele]

That query was just supposed to tell me if there were messages with a wrong id_topic...but apparently there isn't any, so the content of those two tables should be correct.

Okay, out of curiosity:

Code Select Expand

SELECT id_topic, id_board
FROM smf_topics
WHERE id_topic IN (4, 18, 122, 188, 234, 260, 262, 353, 369, 378, 403, 413, 433, 710, 733, 739, 762, 798, 880)

Code Select Expand

SELECT id_msg, id_topic, id_board
FROM smf_messages
WHERE id_topic IN (4, 18, 122, 188, 234, 260, 262, 353, 369, 378, 403, 413, 433, 710, 733, 739, 762, 798, 880)

[InfoStrides]

That query was just supposed to tell me if there were messages with a wrong id_topic...but apparently there isn't any, so the content of those two tables should be correct.

Okay, out of curiosity:

Code Select Expand

SELECT id_topic, id_board
FROM smf_topics
WHERE id_topic IN (4, 18, 122, 188, 234, 260, 262, 353, 369, 378, 403, 413, 433, 710, 733, 739, 762, 798, 880)

Code Select Expand

SELECT id_msg, id_topic, id_board
FROM smf_messages
WHERE id_topic IN (4, 18, 122, 188, 234, 260, 262, 353, 369, 378, 403, 413, 433, 710, 733, 739, 762, 798, 880)

Thank you.

Response from first query

Showing rows 0 - 18 ( 19 total, Query took 0.0005 sec)

Response from second query

Showing rows 0 - 29 ( 43 total, Query took 0.0016 sec)

[emanuele]

May you put the entire output of the query?
I used the IDs of the topics you posted a while back (assuming are those that always return) and I would like to understand where these topics are (i.e. if the id_board is "correct").

[InfoStrides]

May you put the entire output of the query?
I used the IDs of the topics you posted a while back (assuming are those that always return) and I would like to understand where these topics are (i.e. if the id_board is "correct").

Thank you for your efforts. I really appreciate.

Please find attached two files containing the output errors and sorted topic IDs.

[emanuele]

I meant the output of the two queries I wrote before.
For each of the queries when you run it in phpmyadmin you should obtain a table with two columns, please report the result of these two queries.

[InfoStrides]

I meant the output of the two queries I wrote before.
For each of the queries when you run it in phpmyadmin you should obtain a table with two columns, please report the result of these two queries.

First query:

id_topic   id_board
   4   142
   18   114
   122   114
   188   102
   234   114
   260   91
   262   129
   353   114
   369   143
   378   100
   403   114
   413   18
   433   129
   710   102
   733   133
   739   59
   762   15
   798   64
   880   85

Second Query:

id_msg   id_topic   id_board
   5563   4   142
   107   18   114
   297   18   114
   299   18   114
   300   18   114
   301   18   114
   302   18   114
   619   18   114
   7088   122   114
   21824   122   114
   2658   188   102
   2829   234   114
   408   260   91
   409   260   91
   412   260   91
   413   260   91
   414   260   91
   372   262   129
   14928   262   129
   7274   353   114
   20970   369   143
   888   378   100
   2630   403   114
   2638   403   114
   3621   403   114
   8663   403   114
   92932   413   18
   92921   413   18
   92911   413   18
   6855   433   129

[emanuele]

Do you have a recycle board enabled?

[InfoStrides]

Do you have a recycle board enabled?

No.

[emanuele]

So:
1) you have deleted (from the database, i.e. going to phpMyAdmin) these topics,
2) these topics are still there somehow, but not accessible,
3) every time you do a maintenance they come back and give you the error you posted about a wrong number of replies.
Did I say something wrong?