New install on localhost. When I click on the merchant the products list page gives this error:
{code saved}
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /var/www/html/pt/includes/database.php on line 43
Same error with a simple csv file.
Hi Kevin,
The error message indicates that your MySQL installation has a specific SQL mode configured that is incompatible with the style of summary / GROUP BY query used for performance optimisation in Price Tapestry (I am going to investigate this further and look at re-working the query in order to be compatible with this default whilst maintaining the same performance gain) however in the mean time, the mode can be reset as follows;
Edit includes/database.php and look for the following code at line 18:
mysqli_set_charset($database_link,"utf8");
...and REPLACE with:
mysqli_set_charset($database_link,"utf8");
mysqli_query($database_link,"SET SESSION sql_mode=''");
Cheers,
David.
--
PriceTapestry.com