1064 - You have an error in your SQL syntax;

[zaps]

When I tried to delete an order placed by a fictious customer called 'trest'. I got the following error:

 

1064 - You have an error in your SQL syntax;

 

Last Name First Name Account Created Action

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 '-30, 30' at line 1

 

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id where c.customers_lastname like '%trest%' or c.customers_firstname like '%trest%' or c.customers_email_address like '%trest%' order by c.customers_lastname, c.customers_firstname limit -30, 30

 

 

Then on top left side I get these comments:

 

Warning: reset(): Passed variable is not an array or object in /home/synan/public_html/site/admin/includes/classes/object_info.php on line 17

 

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

 

I have not edited this file nor this error was seen before.

Can anybody highlight what this error refers to.

[Guest]

Take a look here :P

 

Matti

[zaps]

Thank you Matti,

 

I appreciate your help. The solution has been the correct one. It worked like magic.

 

Zaps.

 

 

 

 

 

 

 

 

 

 

 

Take a look here  :P

 

Matti

<{POST_SNAPBACK}>

[zaps]

HI ,

 

Thank you for your help. I need another help, if you can.

 

When I print an Invoice, the Order Total looks like this :

 

 

Sub-Total: $9.95

Packaging & Delivery (($3.95 first item, $2.95 each additional)): $3.95

GST @12.5%: $1.24

Total: $15.14

 

The Order total does not calculate the tax on the freight and add it to the Total order value.

 

Instead it should be : ( Here, tax is charged on the freight charge also)

 

Sub-Total: $9.95

Packaging & Delivery (($3.95 first item, $2.95 each additional)): $3.95

GST @12.5%: $1.73 (=Total / 9 )

Total: $15.63 ( GST on the Packaging & Delivery should be added to the total )

 

How do I do that ?

 

Can you please help me.

 

Thanks in advance.