Can't add-remove product!

[grdev]

Hello i am new here and i have tried prestashop, its best and free thank you for that!

 

I installed prestashop 1.6 with default theme and haven't installed any modules or themes.

today i added 100 categories and then deleted the default products.

 

When i tried to add a new product i got this error:

 

Duplicate entry '0' for key 'PRIMARY'

INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '2', '0', '0', '0', '0', '1', '0', '0', '', '0', '0', '0', '0', '0', '1', '404', '0', '1', '0000-00-00', 'new', '1', '0', 'both', '0', '0', '2015-06-15 22:35:51', '2015-06-15 22:35:51', '3')

then i see the product there but i can't delete it, when trying i see this errors:

2 errors

1. The object cannot be loaded (the identifier is missing or invalid)
2. An error occurred while deleting the object. product (cannot load object)

However i was able to delete it from ps_product database but still the problem is here can't do anything

 

after a while i tried to enter the ps_product i got error message something about zend_db and now i can't even login to my database or my plesk! i get this error: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)

 

What happened did i destroy the server with corrupted prestashop databse or something?

 

 

EDIT: nevermind i installed it again. Couldn't find solution

Edited June 15, 2015 by grdev (see edit history)