Attachment problem

Well, apparently we have exceeded an internal limit on the number of attachment files that the database can hold. So right now anyone attempting to attach a file (photo, etc.) to their post will get a database error message.

Looking into this now. I may have to offload the images from the database table to a separate file folder on the server to bypass this limit.

But for now, please bear this in mind. It will especially impact those people wanting to attach images for the classified ads.

Just another day in paradise around here.....

Thanks for the heads up! Perhaps it would be more convenient if people used Photobucket or a similar service for now?

Well, that explains it. For the last hour I have been trying to load a screen shot into a BOI thread and it won't load. I have even taken it into Photoshop and resized it to where it should load with no problems. I wanted to load it that way so it would be there in years to come rather then host it somewhere else and put it up that way. I may delete it down the road sometime and then it would not appear in the thread. Anyway, hopefully it will get fixed soon. Thanks for the info, Rich. I was thinking I was doing something wrong.

Originally Posted by deborahbroadus

Thanks for the heads up! Perhaps it would be more convenient if people used Photobucket or a similar service for now?

I agree, its best to use outside image hosting while posting misc pics (like in the hell forum )...that way facetious pics aren't taking up any space. As far as the classifieds though, I think that unless the image is an attachment there will be no thumbnail displayed next to the ad.

Ah that explains the problem I will just try using photo bucket for now

Well, I just talked with my programmer and this might be a deeper problem then I thought. He asked me if I had a backup of the database, because there appears to be some corruption that likely took place during the last server move. Of course, the problem with backups is that you really don't know if they are any good till you REALLY need them.

Not sure when he is going to start working on this, but expect some downtime. Maybe some substantial downtime. And cross your fingers......

Well this would explain it, thanks!

Amanda

Well, things are looking pretty sticky with this problem. My programmer says that somehow the system was spreading the attachments among the database table and a folder. He didn't think it could do that, and doesn;t know how it happened, much less why it worked for a while like that. But fixing it may be a problem.

Compounding the problem is that my server admin did NOT set up the backup drive that was supposed to be taking backups of all the sites on the server every day. So it appears that the folder that contained some of those attachments may be gone and unrecoverable. No telling which ones might have been in there. Probably won't know till the dust settles. I know all the posts are saved, as I have taken it upon myself to run my own backup routine every night and then save those files to my local drive.

Expect some down time without warning and no idea of the duration. I hope my programmer isn't going to be charging me by the hour on this one......

Crossing my fingers and sending good juju to the server guy!!!

Ooph, good luck! I know how bad server problems can be.

I was wondering why I couldn't get pictures to load on the page. Thought there was something wrong on my end lol.