Shopping Cart Software
products in database but not on website
This is a discussion on products in database but not on website within the osCommerce 2.2 Discussion forums, part of the osCommerce 2.2 Forums category; i am having a problem with oscommerce. when i enter my admin area it shows 9k products as well as ...
| |||||||
 | Register | FAQ | Donate | Members List | Calendar | Mark Forums Read |
|
#1
06-27-2009, 12:26 PM
| |||
| |||
 products in database but not on website i am having a problem with oscommerce. when i enter my admin area it shows 9k products as well as on the frontend.. but yesterday we had 21k products there. i checked the phpmyadmin and under products table it still shows 21k products, so how come website is not extracting all the products from database? can u please help me sort this thing?? i really need help here. thanks alot. awaiting reply. bye      |
|
#2
06-27-2009, 01:29 PM
| ||||
| ||||
| Re: products in database but not on website It could be many things, check the mysql logs and php logs to see if it is timing out part way through. Also make sure that all products are assigned a category - look in the products to categories table and see if that table is correct.
__________________ Michael Sasek osCMax Developer *** Do not PM me requesting paid help. The only paid work I do is for AABox Web Hosting customers *** Stay Up To Date with everything osCMax: Free osCMax Newsletters - Security notices, New Releases, osCMax News osCMax on Twitter - Up to the minute info as it happens. Know it first. osCMax User Manual - osCMax Templates - Advanced Template Tutorial |
|
#3
06-27-2009, 01:42 PM
| |||
| |||
| Re: products in database but not on website i dont knw how to check the logs u specified.. but im sure about timing out.. its not at all timing out.. it just says that 9k products are there. ive also checked the phpMyAdmin.. all products do have been assigned a category. |
|
#4
06-27-2009, 01:51 PM
| ||||
| ||||
| Re: products in database but not on website If you are on shared hosting, contact their support and see if they can check for you regarding time outs of mysql or php. If the page takes too long to load, or uses too much ram it could stop loading.
__________________ Michael Sasek osCMax Developer *** Do not PM me requesting paid help. The only paid work I do is for AABox Web Hosting customers *** Stay Up To Date with everything osCMax: Free osCMax Newsletters - Security notices, New Releases, osCMax News osCMax on Twitter - Up to the minute info as it happens. Know it first. osCMax User Manual - osCMax Templates - Advanced Template Tutorial |
|
#5
06-27-2009, 01:54 PM
| |||
| |||
| Re: products in database but not on website we own our dedicated server and loadtime is set to max. we have 2 stores.. with approx same amount of products.. same settings and same oscommerce files (copied). the other store is working just fine. so it cant be ram issue or loadtime. |
|
#6
07-04-2009, 08:18 AM
| |||
| |||
| Re: products in database but not on website found out the issue.. the products were uploaded via easypopulate but for some reasons.. some of the products had availability date set as too much into past.. so they were not being displayed. i nulled the availability date in phpMyAdmin and they got back into the site. thanks for help guys RESOLVED! |
 |
« HELP Hear About Us mod database table not defined
|
Admin Member Edit - Where is password field? »
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Selling your products on your website? | Patrick21 | Off topic & Chit Chat | 1 | 12-30-2008 03:47 PM |
| Database error on all catagories/products? | Redeye_Joe | osCommerce 2.2 Discussion | 0 | 06-17-2008 09:24 AM |
| Eastpopulate products are in database but not in catalog | jchaters | osCommerce 2.2 Modification Help | 1 | 10-16-2004 08:33 PM |
| which add-on under this website? | laonux | osCommerce 2.2 Modification Help | 1 | 08-26-2003 09:34 PM |
| Bulk changes to "products" database problems... | omnigen | osCommerce 2.2 Modification Help | 0 | 03-02-2003 11:55 AM |
All times are GMT -8. The time now is 01:04 PM.