若您的購物車後台出現
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 '-20, 20' at line 1
select c.customers_firstname, c.customers_lastname, sum(op.products_quantity * op.final_price) as ordersum from customers c, orders_products op, orders o where c.customers_id = o.customers_id and o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by ordersum DESC limit -20, 20
[TEP STOP]
解決的方法請參考
http://meta.homeunix.com/modules.php?op=modload&name=phpbb2&file=viewtopic.php&p=22
或是
http://www.oscommerce.com/community/bugs,1605/category,Database%2B%28General%29
這各問題通常發生在BIG5版本的OSC在MYSQL4.1的環境,基本上4.0的MYSQL不會出現這過狀況
米塔創意坊文章內容如下
一、編輯 /includes/classes/split_page_results.php
找
sql_query .= " limit " . $offset . ", " .
$this->number_of_rows_per_page;
(約在66行)
在上面插入if($offset <0 ) $offset = 0;
(所以是插在66行)
變成
$offset = ($this->number_of_rows_per_page * ($this->current_page_number - 1));
if ($offset < 0) $offset = 0;
$this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;
二、同樣的方法編輯
admin//includes/classes/split_page_results.php
找sql_query .= " limit " . $offset . ", " .
(約在38行)
一樣在上面插入if($offset <0 ) $offset = 0;
(所以是插在38行)
變成
$offset = ($max_rows_per_page *
($current_page_number - 1));
if ($offset < 0) $offset = 0;
$sql_query .= " limit " . $offset . ", " .
$max_rows_per_page;