JaaMor

Hi there. I am getting this error when I try to view products when on the catalog and clicking a category, then a subcatagory: 1064 - You have an error in your SQL syntax near 'select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p' at line 1 select count(select p.products_image, 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, products_to_categories p2c left join specials s on p.products_id = s.products_id 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 = \'37\' order by pd.products_name) as total [TEP STOP] Can someone tell me where to find this error ( I believe it is admin/categories). Can someone also tell me what the error is? I have been trying to fix this for days now and am at my wits end. Thanks so much for any help. Right now, my site is snafu. www.jewelrycabin.com

Hi Strider. The download enabled is set to true. Anything else you can think of?

Does anyone have any suggestions on how to fix the above error? Thanks.

Ok. I would appear that I have managed to fix the admin/categories.php problem. I do still have this error when I try to view products in a sub-category. 1064 - You have an error in your SQL syntax near 'select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p' at line 1 select count(select p.products_image, 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, products_to_categories p2c left join specials s on p.products_id = s.products_id 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 = \'29\' order by pd.products_name) as total [TEP STOP] If someone could tell me where this error is located and what the error is, I would really appreciate it. I am close to tears now. Thanks.

Ok, I managed to fix the parse errror but I still have the SQL error. Also, now when I go to add a product, I no longer have the boxes to add title tag, products description tag, and product keywords. These are very important features I can't afford to lose. If anyone could help me with the sql error and wouldn't mind checking my admin/catagories file to see what I have messed up, I would be so thankful.

Hi Linda. I sure hope you see this soon as I have done something terribly wrong while installing this fabulous contribution and now my store is snafu lol. I had a real tough time modifying some files and am not surprised that I made a mistake (could be one of many). After reading through the forums and taking several looks at my code, I cannot spot the error. Here are the errors I am getting. When you click on a catagory in the catalog, you get this: 1064 - You have an error in your SQL syntax near 'select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p' at line 1 select count(select p.products_image, 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, products_to_categories p2c left join specials s on p.products_id = s.products_id 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 = \'32\' order by pd.products_name) as total [TEP STOP] Now does this mean that I messed up a table? If so, which one and where is the error. Here is the other error I am getting. When I click on store admin, and then catalog, this is what comes up: Parse error: parse error in /hsphere/local/home/jade2001/jewelrycabin.com/admin/categories.php on line 392 I do have your header tags controller contribution installed in categories.php, so I wanted to make sure that I didn't mess up that contribution. Had to modify this file manually. Line 392 is case 'new_product_preview': in the following piece of code. tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $categories_id . '&pID=' . $products_id)); break; case 'new_product_preview': // copy image only if modified $products_image = new upload('products_image'); $products_image->set_destination(DIR_FS_CATALOG_IMAGES); if ($products_image->parse() && $products_image->save()) { $products_image_name = $products_image->filename; } else { $products_image_name = (isset($HTTP_POST_VARS['products_previous_image']) ? $HTTP_POST_VARS['products_previous_image'] : ''); } break; } } // check if the catalog image directory exists if (is_dir(DIR_FS_CATALOG_IMAGES)) { if (!is_writeable(DIR_FS_CATALOG_IMAGES)) $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_NOT_WRITEABLE, 'error'); } else { $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_DOES_NOT_EXIST, 'error'); } ?> I cringe to think of what else I have done wrong. Any help you can give is greatlly appreciated. Thanks so much Linda.

Thanks for pointing me in the right direction. It was the checkout_process file. Now everything is queueing great. The link is in the e-mail and everything seems fine on that end. The problem I have just noticed is this: I have the gv weight set to 0. All other products do have weights attached to them, although I am using table rate. When I purchase JUST a gift voucher, no shipping is added, which is correct. When I purchase JUST a tangible product, the proper shipping is added. When I purchase a gv AND a tangible product, the shipping reflects the total order, not just the tangible product. I.E. My table rates are based on price. If total purchases equal $15.00, then shipping is $2.95. So when I purchase an item for $15.00 AND a gv for $50.00, I would still like the shipping cost to be $2.95 since only the tangible product is charged shipping. Right now, when you purchase a $15.00 item AND a $50.00 gv, since the total is now $65.00, the shipping reflects the higher total and charges $4.95 shipping. Is there any solution to this?

Hi VJ. I am still trying to get this contribution to work on my ms1 store. Here is my problem. Someone submits a link for consideration. I review the link and then click accept and then submit. Here is the warning I am getting: call to undefined function: tep_validate_email() in admin/links.php on line 83. Now I see where someone else was having this problem. I added the validations.php to my admin/includes (I had already done that). I then added the code you told that person to add in admin/includes/application_top.php. Now here are the warnings I am getting. Warning: file(includes/tld.txt): failed to open stream: No such file or directory in /hsphere/local/home/jade2001/jaamor.com/admin/includes/functions/validations.php on line 85 Warning: Variable passed to each() is not an array or object in /hsphere/local/home/jade2001/jaamor.com/admin/includes/functions/validations.php on line 86 Warning: eregi(): REG_EMPTY in /hsphere/local/home/jade2001/jaamor.com/admin/includes/functions/validations.php on line 97 Therefore, I took out the code that I had added to admin/includes/application.php (I much prefer one warning to three lol). Any suggestions on what to do about the call to undefined function: tep_validate_email() in admin/links.php on line 83 warning? Thanks VJ. I hope to get this up and running soon.

Hi Strider. No I don't have access to the gv after it is purchased.

Hi Strider. The configure code has been fixed. Thanks. As far as the gift voucher queue - My gift voucher model numbers are GIFT100, GIFT50, and GIFT25. I believe I have the models numbers fine so that is not the problem. Any other advice? Thanks Strider.

Anyone have any idea about what to do about my queue problem?

Ok. Unfortunately, I think we all knew I would be back lol. I have read all 77 pages of this topic and have not seen where there is a definite fix for the queueing problem. I have queues set to true. But after I purchase a gift voucher, nothing shows in the queue for me to ok. Because of this, I haven't gotten any further to see if everything goes ok after this fix. Any help would be greatly appreciated. Here is my sort order Discount Coupons 740 Gift Vouchers 760 Low Order Fee Shipping 2 Sub-Total 1 Tax 3 Total 900 Here are the other parameter settings: Display Total true Sort Order 760 Queue Purchases true Include Shipping true Include Tax true Re-calculate Tax None Tax Class --none-- Credit including Tax false

Ok. Actually, line 48 is this line ?> Entire block of code: // define our database connection define('DB_SERVER', ''); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', ''); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'osCommerce'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' ?> This has really messed up my site so I am desperately hoping someone can figure out why I am getting those warning messages. Thanks. Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /hsphere/local/home/jade2001/jewelrycabin.com/catalog/includes/configure.php:48) in /hsphere/local/home/jade2001/jewelrycabin.com/catalog/includes/functions/sessions.php on line 67 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /hsphere/local/home/jade2001/jewelrycabin.com/catalog/includes/configure.php:48) in /hsphere/local/home/jade2001/jewelrycabin.com/catalog/includes/functions/sessions.php on line 67

Thanks!! Between Strider and Fred, I was able to understand exactly what everything meant and I no longer have this on my front page. Warning: The downloadable products directory does not exist: /hsphere/local/home/jade2001/jewelrycabin.com/catalogdownload/. Downloadable products will not work until this directory is valid. Unfortunately, I must have messed something else up because I am still getting this error: Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /hsphere/local/home/jade2001/jewelrycabin.com/catalog/includes/configure.php:48) in /hsphere/local/home/jade2001/jewelrycabin.com/catalog/includes/functions/sessions.php on line 67 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /hsphere/local/home/jade2001/jewelrycabin.com/catalog/includes/configure.php:48) in /hsphere/local/home/jade2001/jewelrycabin.com/catalog/includes/functions/sessions.php on line 67 Here is where the error apparantly is (Line 48 is define('DB_SERVER_PASSWORD', ''); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'osCommerce'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' ?> Once I fix this error, I believe all will be well. Can anyone spot the problem. Thanks again!

Actually, here is the block of code that is giving me the above errors. define('DB_DATABASE', 'osCommerce'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' ?> The line in question is define('DB_DATABASE', 'osCommerce'); Can anyone see what is wrong here? I am at my wits end with all of this. Thanks.