Can't see the product in my Oscommerce site

aviscat · 1-1-05, 04:29 AM

At 1:30PM Pacific time 12/31/2004 all was well. Tonight at 1:00AM Central time I get an email from my client that he can't see the product on his shopping cart. The site is http://felinepharmacy.com//catsafratsrx/catalog and I checked the database and all the products and descriptions are there. They just don't show up in the product listing. When you click on a category all you get are prices. The new products on the bottom are listed correctly and the product names are listed in the What's New and Bestsellers boxes. I did no coding change that would affect this. Can you please advise me on how to fix this? My client is losing business as I write this.

--
Maria

stevel · 1-1-05, 10:49 AM

It has to be a coding change that affected the database query that fills in this data. There's no way to diagnose this by just looking at the site in a browser.

My guess is that you introduced an error into index.php, where it is determining which fields to select for the product list query. Compare your index.php against the stock one from the osCommerce distribution to see what you changed.

aviscat · 1-1-05, 11:54 AM

Quote:

Originally Posted by stevel

My guess is that you introduced an error into index.php, where it is determining which fields to select for the product list query. Compare your index.php against the stock one from the osCommerce distribution to see what you changed.

I haven't made any changes to index.php since mid November. I did just today try to replace the index.php with what I had on my hard drive to see if that was the problem but it is essentially the same file. I put it back to the way it was. This was working fine yesterday afternoon and is now not.

--
Maria

stevel · 1-1-05, 01:35 PM

Well, what did you change recently? If you would like me to take a look, you can send me FTP login info in a Private Message.

aviscat · 1-1-05, 01:57 PM

Quote:

Originally Posted by stevel

Well, what did you change recently? If you would like me to take a look, you can send me FTP login info in a Private Message.

Didn't change anything to that part of the program. I sent you an email (actually 2) because I don't know how to do a Private Message here.

--
Maria

stevel · 1-1-05, 02:39 PM

This was interesting. The real problem was in the configuration part of the database, which is set in the admin panel. There is a "Product Listing" panel where you specify which columns are to appear in the product listing and in which order. It isn't described too clearly - the text says "Enable" or "Disable", but what it wants is 0 if disabled, and a column number (1-whatever) if enabled. Somehow, for the product name entry, you had some text string instead of a number. Replacing that with a "1" fixed it.

I don't know how this got corrupted - it sort of looks as if you had typed in the values rather than just database corruption. I'm guessing that you came to this page and did not understand what the fields were for.

1-1-05, 04:29 AM	#1
aviscat Join Date: Nov 2004 Location: Texas Posts: 24 Reputation: 5	Can't see the product in my Oscommerce site At 1:30PM Pacific time 12/31/2004 all was well. Tonight at 1:00AM Central time I get an email from my client that he can't see the product on his shopping cart. The site is http://felinepharmacy.com//catsafratsrx/catalog and I checked the database and all the products and descriptions are there. They just don't show up in the product listing. When you click on a category all you get are prices. The new products on the bottom are listed correctly and the product names are listed in the What's New and Bestsellers boxes. I did no coding change that would affect this. Can you please advise me on how to fix this? My client is losing business as I write this. -- Maria

1-1-05, 10:49 AM	#2
stevel XPW Join Date: Jun 2002 Location: New Hampshire, USA Posts: 9,464 Reputation: 265	It has to be a coding change that affected the database query that fills in this data. There's no way to diagnose this by just looking at the site in a browser. My guess is that you introduced an error into index.php, where it is determining which fields to select for the product list query. Compare your index.php against the stock one from the osCommerce distribution to see what you changed. __________________ Steve

1-1-05, 01:35 PM	#4
stevel XPW Join Date: Jun 2002 Location: New Hampshire, USA Posts: 9,464 Reputation: 265	Well, what did you change recently? If you would like me to take a look, you can send me FTP login info in a Private Message. __________________ Steve

1-1-05, 02:39 PM	#6
stevel XPW Join Date: Jun 2002 Location: New Hampshire, USA Posts: 9,464 Reputation: 265	This was interesting. The real problem was in the configuration part of the database, which is set in the admin panel. There is a "Product Listing" panel where you specify which columns are to appear in the product listing and in which order. It isn't described too clearly - the text says "Enable" or "Disable", but what it wants is 0 if disabled, and a column number (1-whatever) if enabled. Somehow, for the product name entry, you had some text string instead of a number. Replacing that with a "1" fixed it. I don't know how this got corrupted - it sort of looks as if you had typed in the values rather than just database corruption. I'm guessing that you came to this page and did not understand what the fields were for. __________________ Steve

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search