I am administering a website, and one of the pages is not reading the database. Everything is in perfect condition from the back end, and the initial link shows all that needs to be shown. However when you click the link nothing is displayed, no images, no text.

Well, you didn't ask a question, but I'm assuming you are seeking help in solviong your problem. But, you are not providing enough information.

What type of database?
What type of technology (PHP, ASP, etc.)?
How is the page connecting to the database (some code)?
Are you getting errors? What are they?
What debugging have you done so far and what were the results?

Michael J

PHP. No error message at all. I've checked it out from the database and everything is as I inserted it.

(http://www.thenaturalshoestore.com/index.php?m=catalogue&a=vw_prod&cat=0&sec=0&opr_oprid=909)

if you search for 'cow' it shows what you are supposed to see, but when you click on the link for more detail, nothing shows up. Every other link is working.

Thanks.

It appears that the info for the "cow" boot is in the database, as you can access it via other routes and if you click on "Add to Basket" the item name and price are added to the basket. Most likely the code for that link (clicking on the image of the boot on the page returned when you search for 'cow') has a typo.

You or someone will have to look into the PHP code. Hopefully there is a log file to use.

My point is, I don't think it's a database problem, but the link code or the php code that reads from the database is messed up.

Well, it appears to me that the problem is with that particular product (or some products), but not all the products.

If you do a search for "SANITA" you get that same product and many more. When I click on some of the other products, their description pages showed up fine, but that one did not. My guess would be that there is a database entry for that product, but not all the information is present.

But, there's no way for anyone to tell what the exact problem is w/o access to the database and files to debug.

Michael J

Thanks for the responses guys, I've reported the problem to the website developers.

They responded with the following:

The problem with the page was that a new fabric had been added to the system that hadn't synced up to the website. Currently we have a way for you to synchronise the character based lookup table but not the numeric lookup table (which the fabrics are in). We will look to add the ability for you to syncronise that table in the same was as you do the character table. For now we have syncronised it up manually, if there are any others that need doing please let us know.