FRESH INSTALL: Search facility is not working properly?

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

1. I can't duplicate the search error you reported, using a fresh install.
   However, it looks like you've disabled several columns from a product listing or something in order for it to be skipping fields in the SQL query. Perhaps your settings in the admin area need to be revisited.

Or at least list here the exact steps you're taking to produce the error you reported.

2. You should not be seeing double orders.
   What exactly do you mean by "double"?

• are they the same order NUMBER? or 2 orders with same details?
• what payment module are you using?
• what other addons/contributions are installed?

Hi there and thank you for replying.

I have disabled most of the sideboxes. I only have
categories
ez-pages
search_header and
shopping_cart

I surely did some basic fine tunning on the admin area but I can't remember what I've changed. It's been several days now that I'm trying to figure out why is this happening.

Is there a way to reset all those settings without doing a fresh install again?

===

2. I have found the problem however I cannot fix it as I'm not a programmer.
   I'm using the Barclays ePDQ module that was posted to me from jenweir (the creator) about a year ago. With the previous version it was working fine.
   Now it's creating double orders with the same number.
   Even when I login as the customer I can see those double order.

Further more on a processed order it says that the payment way was "Discount coupon"... and not the proper text.

Obviously it's not compatible.
I do not know whether there is an updated version of that module since the Downloads section is off on the zencart site :(

I cannot put the shopping cart live without that module...

No other modules installed.
Any suggestions?

Many thanks,

Netizen

DrByte:

1. I can't duplicate the search error you reported, using a fresh install.
   However, it looks like you've disabled several columns from a product listing or something in order for it to be skipping fields in the SQL query. Perhaps your settings in the admin area need to be revisited.

Or at least list here the exact steps you're taking to produce the error you reported.

2. You should not be seeing double orders.
   What exactly do you mean by "double"?

• are they the same order NUMBER? or 2 orders with same details?
• what payment module are you using?
• what other addons/contributions are installed?

netizen:

Is there a way to reset all those settings without doing a fresh install again?Not easily.

I'll often set up a second install of Zen Cart in a separate folder+database for testing things. This lets you try out new settings, etc. even backup/wipe/install-fresh the database, etc.

Hi All;

1. I get the same error on the search function. This was a fress intall using the latest full releaes, with no changes made. I am using MySql 5.x. I'm looking over some code I'll let you know if I find anything. In the mean time search for "p.product*" on this forum. There is a quick Fix for 1.3 that may help out.

Ryan

v1.3.0.1 contains all the quickfixes/bugfixes for 1.3.0

the download link is at the top of this page ("Get Zen Cart")

DrByte:

v1.3.0.1 contains all the quickfixes/bugfixes for 1.3.0

the download link is at the top of this page ("Get Zen Cart")

Hi i got the same error:

:down:

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.p
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 zen_products p LEFT JOIN zen_manufacturers m USING(manufacturers_id), zen_products_description pd, zen_categories c, zen_products_to_categories p2c LEFT JOIN zen_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 '%foxy%' OR p.products_model LIKE '%foxy%' OR m.manufacturers_name LIKE '%foxy%' OR (mtpd.metatags_keywords LIKE '%foxy%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%foxy%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%foxy%') ) order by pd.products_name limit 0, 10]
:huh:

We disabled almost all column boxes the switched "ON" are...

sideboxes/categories.php
sideboxes/music_genres.php
sideboxes/search_header.php

we tested in a OS X server and a windows 2003 server and got the same message, both installs are fresh.

we appreciate any help.

thanks

When you've both mentioned "fresh" install, was that with or without demo products?
Are there any products in your database?

New installation with the demo products as well as my own products.

DrByte:

When you've both mentioned "fresh" install, was that with or without demo products?
Are there any products in your database?

I suspect you've made some changes to your admin layout settings to show or not show certain columns of information. The search-results area is designed to pick up those fields and include/exclude them dynamically.

What's the URL?

I get the same SQL error when I set 'Display Product Image' to 0, setting it back to 1 makes the search function work again.

Willem

aha ! a key !

Okay -- I can duplicate that on v1.3.0.1, but not in the next version being developed.

Gonna have to hunt to see what fixed it.

Moved this post to the Bug Reports area.

I think I have a solution:

includes/modules/pages/advanced_search_result/header.php
starting at line 176:php // always add quantity regardless of whether or not it is in the listing for add to cart buttons if (PRODUCT_LIST_QUANTITY < 1) { $select_column_list .= ', p.products_quantity '; } replace with:```php
// always add quantity regardless of whether or not it is in the listing for add to cart buttons
if (PRODUCT_LIST_QUANTITY < 1) {
if (empty($select_column_list)) {
$select_column_list .= ' p.products_quantity ';
} else {
$select_column_list .= ', p.products_quantity ';
}
}