Hello,
the mysql version on server has changed from 4 to 5.
Now i got an mysql error. You need to update queries to make them work in mysql 5
<code>
——————————————————
{
case ‘options’:
$sql = “SELECT a.id as basket_id, a.keep as basket_keep, a.priority as basket_priority, b.*, $optionCountStr “.
“FROM basket a, $category[main_table] b “.
“LEFT JOIN container c ON a.category_id = c.category_id AND a.product_id = c.product_id AND c.IsWeb=1 “.
“AND c.UnlockTime < NOW() AND c.Ordered=0 AND c.Blocked=0 “.
“WHERE a.member_id = $memberID AND a.category_id = $category[category_id] AND a.product_id = b.idnum “.
“GROUP BY a.id ORDER BY $category[BasketSort]”;
break;
case ‘single’:
$sql = “SELECT a.id as basket_id, a.keep as basket_keep, a.priority as basket_priority, b.*, sum(ifnull(Quantity, 0)) as items_available “.
“FROM basket a, $category[main_table] b “.
“LEFT JOIN container c ON a.category_id = c.category_id AND a.product_id = c.product_id AND c.IsWeb=1 “.
“AND c.UnlockTime < NOW() AND c.Ordered=0 AND c.Blocked=0 “.
“WHERE a.member_id = $memberID AND a.category_id = $category[category_id] AND a.product_id = b.idnum “.
“GROUP BY a.id ORDER BY $category[BasketSort]”;
break;
case ‘container’:
$sql = “SELECT a.id as basket_id, a.keep as basket_keep, a.priority as basket_priority, b.*, “.
“sum(if(Type=’rent’, Quantity, 0)) as rents_available, sum(if(Type=’buynew’, Quantity, 0)) as new_available, “.
“sum(if(Type=’buyused’, Quantity, 0)) as used_available “.
“FROM basket a, $category[main_table] b “.
“LEFT JOIN container c ON a.category_id = c.category_id AND a.product_id = c.product_id AND c.IsWeb=1 “.
“AND c.UnlockTime < NOW() AND c.Ordered=0 AND c.Blocked=0 “.
“WHERE a.member_id = $memberID AND a.category_id = $category[category_id] AND a.product_id = b.idnum “.
“GROUP BY a.id ORDER BY $category[BasketSort]”;
break;
default:
die(“Unknown category type ‘$category[Type]'”);
}
if (($products[$category[‘alias’]] = dbSelect($sql)) === false) user_error(dbError().” (SQL: $sql)”, ERROR);
$productsCount += count($products[$category[‘alias’]]);
}
——————————————————
$sql = “SELECT dt.deliverytime_id, dt.deliverytime_starttime, dt.deliverytime_endtime, “.
“dt.deliverytime_price, dt.deliverytime_night “.
“FROM delivery_times dt, container c “.
“LEFT JOIN delivery_ahead_times dat ON “.
“dat.deliveryahead_zip = ‘$zip’ “.
“AND dt.deliverytime_starttime >= dat.deliveryahead_starttime “.
“AND dt.deliverytime_starttime < dat.deliveryahead_endtime “.
“WHERE c.category_id = -1 AND c.UnlockTime < NOW() AND c.Ordered != 1 “.
“AND c.product_id = dt.deliverytime_id AND dt.delivery_id = $deliveryID “.
“AND MATCH(dt.deliverytime_zips) AGAINST (‘$zip’ IN BOOLEAN MODE) “.
“AND dt.deliverytime_date = ‘$date’ “.
“AND TIME_TO_SEC(dt.deliverytime_starttime) > TIME_TO_SEC(CURTIME()) + 60 * ifnull(dat.deliveryahead_value, 0) “.
“GROUP BY dt.deliverytime_id “.
“HAVING sum(c.Quantity) > 0 “.
“ORDER BY dt.deliverytime_starttime “;
——————————————————
$sql = “SELECT a.*, b.*, c.idnum as personal_id, if(unlock_time >= NOW(), c.personal_name, ”) as locker_name “.
“FROM order_container a, members b “.
“LEFT JOIN personal c ON c.idnum = -a.locker_id “.
“WHERE a.member_id = b.member_id AND a.order_container_id = $orderID”;
——————————————————
$sql = ‘SELECT t.*, p.personal_name, if(t.tour_start, 1, 0) as $tour_start, if(t.tour_end, 1, 0) as $tour_end ‘.
‘FROM tours t LEFT JOIN personal p ON t.tour_driver = p.idnum ‘;
if (count($cond) > 0) $sql .= ‘ WHERE ‘.join(‘ AND ‘, $cond);
$sql .= ‘ ORDER BY t.tour_name, t.tour_start’;
——————————————————
$sql = “SELECT t.*, sum(oc.order_totalsum) as \$tour_sum FROM tours t “.
“LEFT JOIN order_container oc ON t.tour_name = oc.order_tour_name WHERE “;
——————————————————
$sql = “SELECT dt.*, sum(ifnull(c.Quantity, 0)) as deliverytime_available “.
“FROM delivery_times dt LEFT JOIN container c ON c.category_id = -1 AND c.product_id = dt.deliverytime_id “.
“AND c.Ordered = 0 AND c.UnlockTime < NOW() “.
“WHERE dt.delivery_id = $id GROUP BY dt.deliverytime_id “.
“ORDER BY dt.deliverytime_date, dt.deliverytime_starttime”;
——————————————————
$sql = “select dt.ID from DeliveryTemplates dt “.
“left join Delivery d on d.TemplateID = dt.ID “.
“where d.ID is null”;
——————————————————
</code>
