18 replies to this topic

[Brad]

Hey, excuse me if I am starting to annoy you with all these help posts. But I have some bad errors, and I'm sure its linked to my emoticons problem. When running the Rebuild Post Content tool. I had errors everywhere, I managed to get a screenshot of part of it.

Any help

http://img347.imageshack.us/img347/6993/parsee2rr.jpg

[Michael]

Do you recogize the URLs that it has there?  Are they associated with your site at all?

[Brad]

No, not that I know of. Never heard of them, they may be referring to an image upload or something??

[Michael]

Are the other errors you encountered just like this, referring to the same URLs from this ipowerweb host?

[Brad]

Yes, most of them.

EDIT: Would you like admin access fusoya so you can see for yourself?

Edited by Brad, 16 November 2005 - 06:27 PM.

[Michael]

Yeah, that'd be good.  If you have phpMyAdmin access too that would help a lot.  PM me the info to access that and I'll take a look.

[Michael]

I went to your site and ran this tool.  Found one of the posts that was causing this error and checked it out.  The problem is there is an image in that post that doesn't exist anymore and IPB was having trouble finding the image (obviously) in order to make the thumbnail image.  Nothing you can really do about that unless you found all of these missing images and replaced them.

Here's an example of one of those topics.

[Brad]

Thats practiacally impossible

Is there not a tool I can use to remove them instead? Either way, this needs to be fixed, if you can't help me (and your help is greatly appreciated) who should I turn to? Is it worth contacting IPB?

[Michael]

Well, they're not going to really cause any problems to the tool you're trying to run.  The best way I can suggest to do this is to run the tool, capture the URLs that it's referring to, and then the database can be queried to find those posts.

Say, for example, that you had an error come up in there referring to a broken image on yahoo.com.  You could run a query like this to find the topic number that post was in:

SQL

SELECT topic_id FROM ibf_posts WHERE post LIKE '%yahoo.com%'

You can then go to that topic, see the broken image in whatever post it's in, and edit it out.  It will be time consuming, unfortunately.

[Brad]

You sure thats the last resort, can I not run a query to totally remove ALL of the broken images?

[Michael]

No, because MySQL isn't going to be able to find broken images.  It's the PHP code in the rebuild tool that is trying to execute code on those images and failing that causes the errors.  I don't think a very reliable script could be made to deal with it either, because ideally you'd want to just delete the broken image, but it may be hard to tell exactly which characters in the database for the post make up the image.

[Brad]

So, if I remove all these ipb image problems, will my errors go away?.

[Michael]

Well, these particular errors, yes.

[Brad]

Ok, I expect this to take a VERY VERY long time. Topics that have reached their cut-off dates are still viewable.

This is going to be impossible

[Michael]

Done, only took an hour.

[Brad]

Done? Whats done?

[Michael]

They should all be fixed now.  I ran the rebuild tool, captured the errors, queried to find the topics, and removed the broken images.  Your rebuild tool should run fine now with no errors.

[Brad]

Wow!!

Thanks so much for the help!, I think I will donate for this

Edited by Brad, 17 November 2005 - 04:57 PM.

[Michael]

The issue this topic was opened for has now been resolved.  If you need further assistance, please open a new topic.  If this topic was closed prematurely, please contact me so I can re-open it.

Topic Closed