NicScraps Posted September 30, 2006 Posted September 30, 2006 Hi - About one month ago, I started working on my osCommerce website. My web hosting is via dot5 hosting, and they "support" the use of the osCommerce shopping cart. Unfortunately, I am finding that their version of "support" is one step below useless, for both dot5 issues and osCommerce issues. :'( One big reason I chose to go with osCommerce rather than other options is because of the osCommerce community. When I researched shopping carts, I was very impressed with the size of this support community and the large number of contribution add-ons available to customize the site. Yes, I have read tons of osCommerce help docs, and tried to find answers to my problems on my own, but I am really stuck right now. So, I am appealing to you for some help after many, many setbacks and frustrations. I have plenty of computer experience, and some programming experience, but I have never done any web design. So, I have zero previous experience with PHP and osCommerce, and very little experience with HTML. I have learned a tremendous amount in recent weeks, but I still am not at the level where I can effectively de-bug new problems when they arrive. I initially installed the osCommerce software through dot5 using their web administrative panel (vDeck). They have an automatic installer for osCommerce. The installed version of osCommerce is 2.2.2 . If I look under the osCommerce Admin panel, it tells me the that my server is using PHP Version 4.4.1 (Zend: 1.3.0), and this is the Apache info: Apache/1.3.33 (Unix) mod_log_bytes/0.3 FrontPage/5.0.2.2635 PHP/4.4.1 mod_ssl/2.8.22 OpenSSL/0.9.7g . All this doesn't mean a lot to me, but I understand that these variables can be important when trying to debug errors that show up with osCommerce. Since the time I installed the basic version 2.2.2, I have done the following in terms of customization: - edited the stylesheet.css to alter colors - used the "Square Corners" contribution to make info box corners square (I re-colored them in GIMP) - changed the look of my header to a wide graphic that I created - modified the text of my home page, the shipping page, the privacy notice page, and the conditions page - removed the default graphic images using the "Remove Default Images" contribution (this contrib actually just replaces the image content with a transparent single pixel, but keeps image names the same so you only replace the image files and do not have to edit the PHP) - used the "Fixed Width" contribution All of the above changes are currently working fine, and they are all basically conservative edits that involve little or no edits to the PHP content. Other customizations from the Admin panel: - added a tax zone - removed height info from Images settings so thumbnails would be proportional to original images - set min, max, customer details and such So, I moved on to more adventurous changes... - I installed new shipping modules (RFQ version 1.3 and Store Pickup version 1.4), which are add-on modules from the contributions area - I edited the Flat shipping module text because I am using this module for Priority Mail at a flat rate - I edited the Table Rate module text slightly These installs seemed to be working fine, so I - created a new shipping module called "Gift certificate only," from the Flat shipping module; just copied to a new file name and made small edits (worked with the files at /catalog/includes/modules/shipping and also the file at catalog/includes/languages/english/modules/shipping) - created a new shipping module called "Gift certificate only via e-mail" which is based on the Store Pickup module - created a new payment module to redeem gift certificate when GC is more than order total (so total due is zero); this module is based on the "Request for Quote" RFQ2 payment module that basically has the person pay nothing at the time of checkout (payment is manually completed) After doing all this, I placed a few practice orders last night. I thought they were processed correctly, but this morning I discovered that no order information e-mail was sent to the e-mail address that is supposed to receive notice of a placed order. ??? So, I go to the Admin panel, and under Configuration, My Store, I add an e-mail address to the "Send Extra Order E-mails to" field. I place another test order, and still NO e-mail about the order goes to either e-mail address. I tried changing the extra order e-mail address to a different e-mail address, and when I go back into osCOmmerce to place one more test order, and I click on one of my product categories (that was working fine last night), I get the following: Products Products Displaying 1 to 1 (of 1 products) Result Pages: 1 1030 - Got error 12 from table handler select p.products_image, p.products_quantity, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '36' order by pd.products_name limit 0, 20 [TEP STOP] Yikes! I don't have a clue what that message means. I get something very similar if I go into the Admin module and try to click on any product category name (to view the list of products in that category). 1030 - Got error 12 from table handler select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '1' order by pd.products_name [TEP STOP] But wait...there's more! Sometime in the last week or so I started getting some RED highlighted error messages when I am in the admin module. If I click on the link to backup my database, I get Error: Backup directory is not writeable. If I click on the link for Catalog - Categories/Products, I get a similar message about the /images/ directory not being writeable. So, this seems like a permissions problem to me. My permissions for the admin/backup directory and the catalog/images directory have always been set to 755 up until now. This is what dot5 set them to when it did the install. I've never received those "not writeable" messages until several days ago. I went ahead and changed the permissions on the images directory to 777, and that made the "not writeable" message go away (but why in the world did I start getting that error after already successfully entering 300 products and their photos into my catalog with the images permissions set at 755??). I also was finally able to backup the database from the Admin panel by changing my permissions from 755 to 777 for the /backup/ directory. Then, I changed them back to 755. (I tried to change them to 644, but a dot5 hosting error message warned me that I should keep it at 755.) BUT, I was able to do the backup previously from the Admin panel with those permissions set to 755. Why do I have to use 777 now??? At least half of the contributions I've tried to install in the past month have caused the program to crash or behave unexpectedly, so I've ended up discarding them and going to a backup. These are all contribs that are running successfully for others. In every case, I'm never sure if the problem is an environment issue specific to me, or a mistake I've made in following the install directions (sometimes because I'm not 100% sure what the instructions are telling me to do...). I initially scheduled one month of time for my website customization tasks, and I had expected my site to go live within the next week. I thought I was basically ready to publish, until I discovered all these new problems this morning. Yes, I have a zillion backups, but at this point I feel like I'm not really sure what point to backup to, to be sure it's BEFORE I screwed things up. Unless I go back to a totally clean install and start from scratch...(this thought totally depresses me). I've entered 300 products into my product catalog already, with long product descriptions. Is there a way for me to start over but restore a backup database (I'll download one to my local PC) so I can at least salvage my catalog contents? I just have no clue whatsoever what I've done to "really break it good" all of a sudden. I appreciate any gentle and very detailed assistance you can give me. Thanks - Nicole
NicScraps Posted September 30, 2006 Author Posted September 30, 2006 I remembered something else I changed last night. I updated the tax class information and added this updated tax class to a few of my products. I have "display prices with tax" set to false, so it will add tax at the end (most of my orders will not be taxable). After making these changs last night, when I was on the product modify screen, I noticed that the bottom price that is shown *changed* to reflect what it would be with the tax added. So, some of my prices changed in my database last night. Could this be related to the error 12 table handler issue? Nicole
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.