Author Topic: Issue: Find and repair any errors (Read 9320 times)

InfoStrides · « **on:** June 30, 2012, 02:17:09 AM »

I have an issue with my forum "Find and repair any errors". Anytime, I attempt to use it, it shows lots of errors fouling up my forum. I did fix them but to my surprise, nothing happened. Because if run "Find and repair any errors", the same sets of errors show up.

I have searched the forum for similar issue if exist but could not find any. Please help! Thankss.

K@ · « **Reply #1 on:** June 30, 2012, 09:17:28 AM »

I tried the zillions of links that you have under your avatar and in your sig, to see if I could figure-out which version of SMF you're using, so that I could move this to the relevant support board.

I gave up after the first two thousand, or so.

emanuele · « **Reply #2 on:** June 30, 2012, 12:00:41 PM »

Also the type of the errors you are getting could help.

InfoStrides · « **Reply #3 on:** July 01, 2012, 10:46:59 AM »

Quote from: K@ on June 30, 2012, 09:17:28 AM

I tried the zillions of links that you have under your avatar and in your sig, to see if I could figure-out which version of SMF you're using, so that I could move this to the relevant support board.

I gave up after the first two thousand, or so.

I use SMF 2.0.2 (http://www.theinfostrides.com/index.php?action=credits).

Quote from: emanuele on June 30, 2012, 12:00:41 PM

Also the type of the errors you are getting could help.

1. When I go to Forum Maintenance ---> Find and Repair any errors ---> Run task now.

2. Several lines of errors shown up such as mission subject, topic non-existence etc...

3. I fixed the errors

4. To my surprise, similar set of errors re-occur. At times, they won't show but at times they show.

K@ · « **Reply #4 on:** July 01, 2012, 12:07:51 PM »

Can you paste a few?

InfoStrides · « **Reply #5 on:** July 01, 2012, 12:42:27 PM »

Quote from: K@ on July 01, 2012, 12:07:51 PM

Can you paste a few?

I will post it when it re-occur. The error is somehow intermittent. Thanks.

emanuele · « **Reply #6 on:** July 01, 2012, 12:59:17 PM »

Quote from: InfoStrides on July 01, 2012, 10:46:59 AM

4. To my surprise, similar set of errors re-occur. At times, they won't show but at times they show.

That's the worst type of bugs: the random ones.

Let's wait for more details as soon as the errors show up again.

InfoStrides · « **Reply #7 on:** July 01, 2012, 05:33:01 PM »

Quote from: emanuele on July 01, 2012, 12:59:17 PM

Quote from: InfoStrides on July 01, 2012, 10:46:59 AM
4. To my surprise, similar set of errors re-occur. At times, they won't show but at times they show.
That's the worst type of bugs: the random ones.

Let's wait for more details as soon as the errors show up again.

You are right! That was why I kept watching it before making this post. I will update as soon as it re-occur. Thanks.

InfoStrides · « **Reply #8 on:** July 03, 2012, 11:07:32 AM »

The errors resurfaced again. about 720 lines of them. Please see the first 20 below:

Quote

The following errors are fouling up your forum:
Topic #4 has the wrong number of replies, 0.
Topic #18 has the wrong number of replies, 6.
Topic #122 has the wrong number of replies, 1.
Topic #188 has the wrong number of replies, 0.
Topic #234 has the wrong number of replies, 0.
Topic #260 has the wrong number of replies, 4.
Topic #262 has the wrong number of replies, 1.
Topic #353 has the wrong number of replies, 0.
Topic #369 has the wrong number of replies, 0.
Topic #378 has the wrong number of replies, 0.
Topic #403 has the wrong number of replies, 3.
Topic #413 has the wrong number of replies, 2.
Topic #433 has the wrong number of replies, 1.
Topic #710 has the wrong number of replies, 0.
Topic #733 has the wrong number of replies, 3.
Topic #739 has the wrong number of replies, 0.
Topic #762 has the wrong number of replies, 0.
Topic #798 has the wrong number of replies, 2.
Topic #880 has the wrong number of replies, 1.

emanuele · « **Reply #9 on:** July 03, 2012, 11:08:56 AM »

So, you repaired them and then you checked again (just after the repair) and there are still there?
Or the repair is done, but after a while the appear again?

InfoStrides · « **Reply #10 on:** July 03, 2012, 12:36:16 PM »

Quote from: emanuele on July 03, 2012, 11:08:56 AM

So, you repaired them and then you checked again (just after the repair) and there are still there?
Or the repair is done, but after a while the appear again?

The repair was done successfully but after a while when the process is run, the same errors shown.

K@ · « **Reply #11 on:** July 03, 2012, 12:41:13 PM »

Humour me, would you?

I seriously doubt this, I have to confess. But, can you try emptying your forum's cache and try killing those errors, again?

I'm wondering if your forum's pulling that crap from the cache, somehow.

Although, I could be talking total bollox.

emanuele · « **Reply #12 on:** July 03, 2012, 12:59:30 PM »

Can you list all the mods you have installed?

InfoStrides · « **Reply #13 on:** July 03, 2012, 01:32:54 PM »

Quote from: K@ on July 03, 2012, 12:41:13 PM

Humour me, would you?

I seriously doubt this, I have to confess. But, can you try emptying your forum's cache and try killing those errors, again?

I'm wondering if your forum's pulling that crap from the cache, somehow.

Although, I could be talking total bollox.

I did clear the cache and confirmed from the folder. The errors still surfaced.

InfoStrides · « **Reply #14 on:** July 03, 2012, 01:35:52 PM »

Quote from: emanuele on July 03, 2012, 12:59:30 PM

Can you list all the mods you have installed?

1.   Social Login Pro    2.0
2.   IFS MashableMenu Mod    3.0
3.   Childboards as Dropdown    2.0.3
4.   RedirectPage    2.6
5.   SMFShop    3.2
7.   SMF Downloads Directory    1.1.5
8.   More Spiders    1.2
9.   SMF Featured Content Slider for IFS    1.0
10.   Tagging System    2.4.2
12.   Titled Links    1.2
13.   Pretty URLs    1.0
14.   Google Tagged    1.5
15.   SimplePortal    2.3.5
16.   SimpleAds    1.0.1
17.   Online status on login    1.7
18.   Contact Page    3.0
19.   Custom Links and Downloads Directory    1.0
20.   Pretty URLs Reverter    1.0
21.   Tynt-SMF Tracer Mod    3.0
22.   Remember Position After Login/Logout    1.0.0
23.   Related Topics    1.401
24.   SMF Links Directory    2.2.2
25.   InfoStrides Sitemap 1.0    1.0
26.   Float BBCODE    1.0.2
28.   Register At Post View v.1.1    1.1
29.   Twitter and Facebook Publisher mod    2.13
30.   VB Style - Poster Info On Top    1.1.1
31.   Separate the sticky topics    1.0.0
32.   PageDropdown    1.4
33.   vBulletin Style Meta Tags    1.1
34.   Prevent Adding Signature Images And Links    2.0
35.   Extended Help    1.0
37.   Pretty URLs Extras    1.0
38.   Social Buttons    1.0
39.   Buddies List    1.0.1
40.   RSS Feed Icon    1.1
41.   Integration Hooks Report    1.4
42.   Wireless/RSS amount displayed    1.2.1
43.   RSS Feeder    1.1.5
44.   Double Check your Email in Registration by SmfSimple.com    1.0

emanuele · « **Reply #15 on:** July 03, 2012, 02:34:08 PM »

I feel it's something related to some mod, from here to find which one it's a bit more difficult...

Do these topics exists?
The link to your forum is the one in your profile?

K@ · « **Reply #16 on:** July 03, 2012, 03:00:34 PM »

* K@ suspects the "Pretty" thing...

InfoStrides · « **Reply #17 on:** July 04, 2012, 05:03:02 PM »

Quote from: emanuele on July 03, 2012, 02:34:08 PM

I feel it's something related to some mod, from here to find which one it's a bit more difficult...

Do these topics exists?
The link to your forum is the one in your profile?

The topics do not exist. I deleted most of them from the database through PHPMyAdmin. Could that be responsible for the issue?

Link: http://www.theinfostrides.com/

Quote from: K@ on July 03, 2012, 03:00:34 PM

* K@ suspects the "Pretty" thing...

"Pretty" though installed but was not activated.

emanuele · « **Reply #18 on:** July 05, 2012, 02:35:09 AM »

Quote from: InfoStrides on July 04, 2012, 05:03:02 PM

The topics do not exist. I deleted most of them from the database through PHPMyAdmin. Could that be responsible for the issue?

Ohh, you have most likely found the issue.

If you have deleted only the topics (and the messages) you have missed several other places where topics informations are kept and that most likely foul the maintenance task.

Out of curiosity: why did you delete the topics from the database instead of use the tools provided by SMF?

InfoStrides · « **Reply #19 on:** July 05, 2012, 06:50:37 PM »

Quote from: emanuele on July 05, 2012, 02:35:09 AM

Quote from: InfoStrides on July 04, 2012, 05:03:02 PM
The topics do not exist. I deleted most of them from the database through PHPMyAdmin. Could that be responsible for the issue?
Ohh, you have most likely found the issue.

If you have deleted only the topics (and the messages) you have missed several other places where topics informations are kept and that most likely foul the maintenance task.

Out of curiosity: why did you delete the topics from the database instead of use the tools provided by SMF?

What can I do to resolve the issues?

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

emanuele · « **Reply #20 on:** July 07, 2012, 04:24:07 AM »

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

InfoStrides · « **Reply #21 on:** July 15, 2012, 05:53:36 PM »

Quote from: emanuele on July 07, 2012, 04:24:07 AM

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

OK. Thanks.

emanuele · « **Reply #22 on:** July 15, 2012, 06:41:57 PM »

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 · « **Reply #23 on:** July 22, 2012, 09:44:44 AM »

Quote from: emanuele on July 15, 2012, 06:41:57 PM

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 · « **Reply #24 on:** July 22, 2012, 09:48:50 AM »

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 · « **Reply #25 on:** July 25, 2012, 07:49:29 AM »

Quote from: InfoStrides on July 05, 2012, 06:50:37 PM

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 · « **Reply #26 on:** July 28, 2012, 08:49:31 AM »

Quote from: emanuele on July 25, 2012, 07:49:29 AM

Quote from: InfoStrides on July 05, 2012, 06:50:37 PM
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 · « **Reply #27 on:** July 28, 2012, 09:54:52 AM »

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]

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 · « **Reply #28 on:** July 30, 2012, 09:11:46 AM »

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

Quote

0 rows affected. ( Query took 0.7295 sec )

I check the issue, it was not resolved.

emanuele · « **Reply #29 on:** July 30, 2012, 10:56:42 AM »

Could you try that one too:

Code: [Select]

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 · « **Reply #30 on:** August 01, 2012, 09:51:46 AM »

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

Quote

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

emanuele · « **Reply #31 on:** August 01, 2012, 11:36:02 AM »

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]

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]

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 · « **Reply #32 on:** August 06, 2012, 12:01:24 AM »

Quote from: emanuele on August 01, 2012, 11:36:02 AM

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

Quote

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

Response from second query

Quote

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

emanuele · « **Reply #33 on:** August 06, 2012, 03:11:33 AM »

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 · « **Reply #34 on:** August 06, 2012, 05:40:56 AM »

Quote from: emanuele on August 06, 2012, 03:11:33 AM

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 · « **Reply #35 on:** August 06, 2012, 07:38:10 AM »

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 · « **Reply #36 on:** August 06, 2012, 09:07:58 AM »

Quote from: emanuele on August 06, 2012, 07:38:10 AM

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:

Quote

   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:

Quote

   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 · « **Reply #37 on:** August 06, 2012, 09:23:43 AM »

Do you have a recycle board enabled?

InfoStrides · « **Reply #38 on:** August 06, 2012, 05:58:41 PM »

Quote from: emanuele on August 06, 2012, 09:23:43 AM

Do you have a recycle board enabled?

No.

emanuele · « **Reply #39 on:** August 06, 2012, 06:18:26 PM »

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?

InfoStrides · « **Reply #40 on:** August 07, 2012, 01:03:50 AM »

Quote from: emanuele on August 06, 2012, 06:18:26 PM

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

emanuele · « **Reply #41 on:** August 07, 2012, 07:21:53 AM »

Quote from: InfoStrides on August 07, 2012, 01:03:50 AM

Quote from: emanuele on August 06, 2012, 06:18:26 PM
2) these topics are still there somehow, but not accessible,
Beyond my knowledge

That was more a sort of "deduction". If I try http://www.theinfostrides.com/index.php?topic=4.0 I get "This topic doesn't exist on this board.". Though according to the results of the queries I posted it *exists* and it is in that board:

Quote

id_topic id_board
4 142

and

Quote

id_msg id_topic id_board
5563 4 142

Do you have any mod that can mess up with topics?

InfoStrides · « **Reply #42 on:** August 08, 2012, 09:53:17 AM »

Quote

Do you have any mod that can mess up with topics?

These are the list of all my current mods:

Quote

1.   Social Login Pro    2.0
2.   IFS MashableMenu Mod    3.0
3.   Childboards as Dropdown    2.0.3
4.   RedirectPage    2.6
5.   SMFShop    3.2
7.   SMF Downloads Directory    1.1.5
8.   More Spiders    1.2
9.   SMF Featured Content Slider for IFS    1.0
10.   Tagging System    2.4.2
13.   Titled Links    1.2
14.   Pretty URLs    1.0
15.   Google Tagged    1.5
16.   SimplePortal    2.3.5
17.   SimpleAds    1.0.1
18.   Online status on login    1.7
19.   Contact Page    3.0
20.   Custom Links and Downloads Directory    1.0
22.   Tynt-SMF Tracer Mod    3.0
23.   Remember Position After Login/Logout    1.0.0
24.   Related Topics    1.401
25.   SMF Links Directory    2.2.2
26.   InfoStrides Sitemap 1.0    1.0
27.   Float BBCODE    1.0.2
29.   Register At Post View v.1.1    1.1
30.   Twitter and Facebook Publisher mod    2.13
31.   VB Style - Poster Info On Top    1.1.1
32.   Separate the sticky topics    1.0.0
33.   PageDropdown    1.4
34.   vBulletin Style Meta Tags    1.1
35.   Prevent Adding Signature Images And Links    2.0
36.   Extended Help    1.0
37.   Add Social Media Icons To Profiles    1.0.5
39.   Pretty URLs Extras    1.0
40.   Social Buttons    1.0
41.   Admin Toolbox    1.0
42.   Buddies List    1.0.1
43.   RSS Feed Icon    1.1
44.   Integration Hooks Report    1.4
45.   Wireless/RSS amount displayed    1.2.1
46.   RSS Feeder    1.1.5
47.   Double Check your Email in Registration by SmfSimple.com    1.0

emanuele · « **Reply #43 on:** August 11, 2012, 06:15:24 AM »

Okay, that's a nice list...

I can't think of anything wrong at the moment, I'm not sure either what is failing here.

Anyway better move this to support to see if someone has any idea...

InfoStrides · « **Reply #44 on:** August 11, 2012, 05:33:20 PM »

Quote from: emanuele on August 11, 2012, 06:15:24 AM

Okay, that's a nice list...

I can't think of anything wrong at the moment, I'm not sure either what is failing here.

Anyway better move this to support to see if someone has any idea...

Thank you for your time and help. How do I move it to support? No permission to do so.

emanuele · « **Reply #45 on:** August 11, 2012, 06:52:43 PM »

I already moved it this morning!

InfoStrides · « **Reply #46 on:** August 14, 2012, 06:06:34 AM »

Quote from: emanuele on August 11, 2012, 06:52:43 PM

I already moved it this morning!

Thanks.

K@ · « **Reply #47 on:** September 05, 2012, 04:26:44 PM »

Humour me, here, would you?

Disable PrettyURLs and see if the errors vanish, or stay away, after a repair.

InfoStrides · « **Reply #48 on:** September 13, 2012, 10:49:50 AM »

Quote from: K@ on September 05, 2012, 04:26:44 PM

Humour me, here, would you?

Disable PrettyURLs and see if the errors vanish, or stay away, after a repair.

PrettyURLs was already disabled. I uninstalled it and ran maintenance task again but NO LUCK yet.

K@ · « **Reply #49 on:** October 10, 2012, 05:21:12 AM »

Apologies for forgetting about this one!!!

Had any luck?

InfoStrides · « **Reply #50 on:** **Yesterday** at 12:10:26 PM »

Quote from: K@ on October 10, 2012, 05:21:12 AM

Apologies for forgetting about this one!!!

Had any luck?

No luck yet! Thank you.

News:

Author Topic: Issue: Find and repair any errors (Read 9320 times)