SMF Support > SMF 2.0.x Support

Issue: Find and repair any errors

<< < (7/11) > >>

InfoStrides:
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 )
--- End quote ---

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 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)
--- End code ---


--- Code: ---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)
--- End code ---

InfoStrides:

--- 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 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)
--- End code ---


--- Code: ---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)
--- End code ---

--- End quote ---

Thank you.

Response from first query


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

Response from second query


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

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:

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

--- End quote ---

Thank you for your efforts. I really appreciate.

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

Navigation

[0] Message Index

[#] Next page

[*] Previous page