mickmel
Tue 28th May '02, 9:23am
Here's the story: I include global.php on every page on my site. The reason is so I can determine how to display each page, based on who is viewing it. I've added new columns to the vB "user" table, and I can toggle things on and off for various users. One is for ads. If people pay me $20, they get the ads removed on every page on the site. Since I already call global, I can just look at that piece of info, see if it's a 1 or 0, and display (or not display) the ad. I also use it as a security measure for some of the protected areas of the site. I have another column in "user" that I can set to 1 or 0 which allows them to get in to certain areas of the site. Anyhow, all of that works wonderfully.
Here's the problem. I'll use our request list as an example. Using the list, people can request songs (guitar tabs, specifically) to be added to the site. I have a secure back area where I can view the request list, modify the entries, or delete them. The scripts back there are VERY simple and straightforward. Deleting the entries works fine. The problem is that when I modify an entry, I get a "page cannot be displayed" error about 25% of the time. Even when I get the error, though, the modification goes through successfully. I doubt it's a script error, because I have a lot of different scripts back there for various things, and on every one I only get the error when I'm modifying the database - not when I add to it, not when I delete from it, not when I read from it - only when I modify. Other users have reported this same problem.
I see three common things with each of these:
- The problem occurs randomly, and it has happened to various people.
- It's ONLY when I modify the database.
- It's ONLY when I submit a form to the page (the others are just plain text links to add/delete).
Sorry for the long post. ANY ideas?
Mickey
Here's the problem. I'll use our request list as an example. Using the list, people can request songs (guitar tabs, specifically) to be added to the site. I have a secure back area where I can view the request list, modify the entries, or delete them. The scripts back there are VERY simple and straightforward. Deleting the entries works fine. The problem is that when I modify an entry, I get a "page cannot be displayed" error about 25% of the time. Even when I get the error, though, the modification goes through successfully. I doubt it's a script error, because I have a lot of different scripts back there for various things, and on every one I only get the error when I'm modifying the database - not when I add to it, not when I delete from it, not when I read from it - only when I modify. Other users have reported this same problem.
I see three common things with each of these:
- The problem occurs randomly, and it has happened to various people.
- It's ONLY when I modify the database.
- It's ONLY when I submit a form to the page (the others are just plain text links to add/delete).
Sorry for the long post. ANY ideas?
Mickey