SMF Support > SMF 2.0.x Support

Issue: Find and repair any errors

<< < (6/11) > >>

emanuele:

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

--- End quote ---
Did you remove the posts or the topics? Or both?

InfoStrides:

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

--- End quote ---
Did you remove the posts or the topics? Or both?

--- End quote ---

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


--- Quote ---0 rows affected. ( Query took 0.7295 sec )
--- End quote ---

I check the issue, it was not resolved.

emanuele:
Could you try that one too:

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

Navigation

[0] Message Index

[#] Next page

[*] Previous page