Search problem - grid layout maybe?

[dhamilton51]

Hey, Im getting the following error when searching for a product on my site. Im wondering if its linked to the grid layout modification which I made? any help would be amazing!

1054 Unknown column 'cd.categories_namecd.categories_description' in 'field list'
in:
[SELECT DISTINCT c.categories_image, cd.categories_namecd.categories_description, cd.categories_id, c.parent_id from zen_categories_description cd, zen_categories c where cd.categories_id = c.categories_id and cd.language_id = '1' AND ((cd.categories_name LIKE '%plant%' OR cd.categories_description LIKE '%plant%') ) order by cd.categories_name]

[kuroi]

Posting the same question over and over is frowned upon in this forum. Please read the About Posting guide.

[FrilansReklam]

Maybe I missed the answer somewere in the forum. So you can move this to the proper place. (this answer is not a version specific answer).

You got this error message if some column is missing in a database table.

Example:
1054 Unknown column 'cd.categories_namecd.categories_description' in 'field list'
in:
[SELECT DISTINCT c.categories_image, cd.categories_namecd.categories_description, cd.categories_id, c.parent_id from zen_categories_description cd, zen_categories c where cd.categories_id = c.categories_id and cd.language_id = '1' AND ((cd.categories_name LIKE '%plant%' OR cd.categories_description LIKE '%plant%') ) order by cd.categories_name]

Whats wrong?:
here you call for two fields that are missing. categories_name and categories_description. the cd. are pointing to the table zen_categories_description where it say it is cd before the coma.

This problem is always common when you manualy translate osc database to Zen Cart so if you cant use the translate script you have to compare both database.

Sometimes you made changes in some file to the database call for some contributions and when you made some new changes it overrun this or overwrite this changes. so it is always important to have a proper backup of the files so you can compare them and manually change it.

[TKPope]

Here is a fix to the problem in Advanced Search Plus:

Go to line 45 of advanced_search_categories.php, it looks like this:
$select_str_cat = "SELECT DISTINCT " . $select_column_list . "cd.categories_description, cd.categories_id, c.parent_id ";

Add a comma and space before cd.categories_description:
$select_str_cat = "SELECT DISTINCT " . $select_column_list . ", cd.categories_description, cd.categories_id, c.parent_id ";

Voila - fixed!

[WaterSlide]

Forgive my poor formatting, I'm still new at this type of thing. I had a similar issue with the code where the switch would add an extra ", " and it would throw a MySQL error:

"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 ' cd.categories_description, cd.categories_id, c.parent_id from categories_descr' at line 1"

The Fix:

In advanced_search_categories:

for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
if (zen_not_null($select_column_list)) {
$select_column_list .= ', ';
}

Changed to (added "-1" to reduce the iterations of the FOR) :

for ($col=0, $n=sizeof($column_list)-1; $col<$n; $col++) {
if (zen_not_null($select_column_list)) {
$select_column_list .= ', ';
}