1064 error!

[thinkmarsh]

Hi all,

 

Just been adding contributions....all gone fine until completing points reward system. on the points pages of catalog and admin i am getting 1064 errors:

e.g. this error in admin......

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 o.orders_id, o.customers_id, o.customers_name, o.customers_email_address, o.payment_method, o.date_purchased, o.orders_status, s.orders_status_name, ot.text as order_total, pp.unique_id, pp.points_pending, pp.points_comment, pp.points_status, pp.points_type from orders o, orders_total ot, orders_status s, customers_points_pending pp WHERE points_type = 'SP' AND pp.points_status = 1 AND (pp.orders_id = o.orders_id AND ot.class = 'ot_total' AND o.orders_id = ot.orders_id AND o.orders_status = s.orders_status_id) AND s.language_id = '1' ORDER BY o.orders_id DESC limit -20, 20

and this in the catalog main pages.......

 

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 unique_id, orders_id, points_pending, points_comment, date_added, points_status, points_type from customers_points_pending WHERE customer_id = '3' ORDER BY unique_id DESC limit -20, 20

 

 

I've tried looking for answers on the forums but I can't seem to find one that helps!?

Also when I try and delete a customer I get this error message:

Warning: reset() [function.reset]: Passed variable is not an array or object in ...\admin\includes\classes\object_info.php on line 17

 

Warning: Variable passed to each() is not an array or object in ....\admin\includes\classes\object_info.php on line 18

(this is the code in that file):

class objectInfo {

 

// class constructor

function objectInfo($object_array) {

reset($object_array); <---------------------------------------------------- Line 17

while (list($key, $value) = each($object_array)) { <--------------------- Line 18

$this->$key = tep_db_prepare_input($value);

}

}

}

 

For anyone that can help - I'll appreciate it sooo much!

Ben

[Jan Zonjee]

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

This was already addressed in the 2005 update of osC. Where the heck did you find that ancient version of osC. Update (the new download contains update instructions too) right away, since it also addresses a problem with spammers using the contact_us page.

[thinkmarsh]

This was already addressed in the 2005 update of osC. Where the heck did you find that ancient version of osC. Update (the new download contains update instructions too) right away, since it also addresses a problem with spammers using the contact_us page.

 

Is it is easy to upgrade? Eeek :'(

[thinkmarsh]

Is it is easy to upgrade? Eeek :'(

 

I'm on MS2 though, where is this new update? I can't find it!

 

Thanks for your help! :)