SQL errors in admin

[tobyj21]

I've got a heavily modified site, which is just getting ready to launch on a new windows server. It's worked fine on the old server, and hosted locally on my computer (though these ran earlier php / sql versions), yet I'm having a lot of problems with admin on the new server.

 

When I try to add new products, I get this error on clicking insert:

 

1264 - Out of range value adjusted for column 'products_quantity' at row 1

insert into products (products_quantity, products_model, products_price, products_price1, products_price2, products_price1_qty, products_price2_qty, products_qty_blocks, products_rrp, products_sale, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_date_added) values ('', '', '', '', '', '', '', '1', '', '', null, '', '1', '0', '', now())

[TEP STOP]

When I browse the products table in mySQL, this error appears at the top. No idea what it means...

Notice: Undefined offset: 246 in D:\SWSoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\libraries\dbi\mysqli.dbi.lib.php on line 281

 

Also, when creating categories I get:

1264 - Out of range value adjusted for column 'sort_order' at row 1

insert into categories (sort_order, parent_id, date_added) values ('', '83', now())

[TEP STOP]

 

 

Oh and another one I've noticed in the catalogue side, when you open order history:

 

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

select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '7' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' order by orders_id DESC limit -10, 10

[TEP STOP]

 

 

Any help with these would be much appreciated

 

 

PHP version 4.4.3

MySQL version 5.0.27