Addon causing a SQL 1024 error in Search

[izar74]

Ok... the good old method of "i'll try it all and see what happen.." is still the best way to go around the problems ;-)

the problem was in the

header_php.php (includes\modules\pages\advanced_search_results)

I just commented the line above and the problem was solved.

before:

} else {
// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER ia left blank
// for reverse, descending order use:
// $listing_sql .= " order by p.products_sort_order desc, pd.products_name";
$order_str .= " order by p.products_sort_order, pd.products_name";
break;
}
}

after:

} else {
// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER ia left blank
// for reverse, descending order use:
// $listing_sql .= " order by p.products_sort_order desc, pd.products_name";
// $order_str .= " order by p.products_sort_order, pd.products_name";
break;
}
}

If it's possible to change the title of the post with a [SOLVED] it may be of some help to someone else :-)

[CJPinder]

the problem was in the

header_php.php (includes\modules\pages\advanced_search_results)

I just commented the line above and the problem was solved.

Rather than hacking at core files I would suggest uploading a clean version of that file from the ZC 1.3.8a distribution and see if that fixes your problem.

Regards,
Christian.

[izar74]

It's not a Core file problem but a Mod problem. The above file was modified due to a Mod installed so a "clean" install would have disable the mod causing errors..
Modifing the file the way i wrote before solved the problem.