Hi people,
I have installed a previous version in the past and on another server and I didn't have any problems.
Now it seems that the seach box is not always working properly!
This is the result:
+++++++++++++++++++++++++++++++++++++++
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.p' at line 1
in:
[SELECT DISTINCT , p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter FROM mmzen_products p LEFT JOIN mmzen_manufacturers m USING(manufacturers_id), mmzen_products_description pd, mmzen_categories c, mmzen_products_to_categories p2c LEFT JOIN mmzen_meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%a%' OR p.products_model LIKE '%a%' OR m.manufacturers_name LIKE '%a%' OR (mtpd.metatags_keywords LIKE '%a%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%a%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%a%') ) order by pd.products_name limit 0, 10]
+++++++++++++++++++++++++++++++++++++++
I haven't installed any mods yet and I am using the default template.
Details of the server:
#######################
Zen Cart 1.3.0.1
Database Patch Level: 1.3.0.1
v1.3.0.1 [2006-05-12 13:39:35] (Fresh Installation)
Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.9-34.ELsmp
Database: MySQL 4.1.19-standard-log
PHP Version: 4.4.2 (Zend: 1.3.0)
HTTP Server: Apache/1.3.34 (Unix) PHP/4.4.2 mod_throttle/3.1.2 mod_psoft_traffic/0.1 mod_ssl/2.8.25 OpenSSL/0.9.7a FrontPage/5.0.2.2623
#######################
ANOTHER PROBLEM FOUND:
Orders in the admin panel appearing with double entries.
So far I haven't taken the cart Live but I need to to do it VERY soon.
If I compromise to leave those double entries, will this affect the systes when it goes line?
Is this fixable?
Are those bugs of the latest version and a patch will be released soon or shall I go back to the previous version?
Thank you in advance,
N
Bookmarks