Gossamer Forum
Home : Products : DBMan : Discussions :

Internal Server Error unless db file blank

Quote Reply
Internal Server Error unless db file blank
I've had dbman running trouble-free for quite a while. Recently I had to delete files and reupload them. Everything works fine until I add the old data back in to my db file, and then try adding a new record. (Infamous 500 Internal Server Error).

When I replace it with a blank file, I can add records without a problem.
Quote Reply
Re: [subgang] Internal Server Error unless db file blank In reply to
The first thing I would check is the file permission on your .db file (666).

I would also if you have MSExcel to open up the databse in there just to check it out and make sure all the fields are in the correct locations.

What size is your database? Is it over a meg? Does your host provider have a limit to the size of files you can upload and run on the server?

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Quote Reply
Re: [LoisC] Internal Server Error unless db file blank In reply to
Permissions are definitely ok, set at 666.
Also tried deleting files and fully replacing/resetting permissions.
Examined rows in Excel, they all line up perfectly. In every case, when I use a blank file it is ok, as soon as any existing rows are added, it fails...I still haven't found a solution...
Quote Reply
Re: [subgang] Internal Server Error unless db file blank In reply to
The problem is now fixed! I went through the file row by row and removed some duplicates that had been dropped in there during testing. Odd that they only became a problem when merging the new data, however.

Thanks to any who have puzzled over this....