Jump to content

Edit History

Abo Anas

Abo Anas

Hello All :

many thanks in advance for who help or trying

i have system{ not prestashop system but its made individually } that contain customers and categories and subcategories and products now i try to go to presta and migrate database i did script to get fields from old database to the prestashop like

in category tables 

$sql="insert into {$this->pprefex}category (id_parent, id_shop_default, level_depth, nleft, nright, active, date_add, date_upd, `position`, is_root_category) values (2, 1, 2, 2, 2, 1, '{$create_time}','{$update_time}', 0, 1)";

$this->dbp->query($sql);$newcust=$this->dbp->lastInsertID();
$sql="insert into {$this->pprefex}category_lang values ({$newcust}, 1, 1, '{$name_en}', '', '', '', '', '')";
$this->dbp->query($sql);

BTW im using the primary keys ids from the old system

in its get inserted successfully

but when  i try to edit the the category it gives me

The object cannot be loaded (or found)

thats in all inserted data product / customers / categories

can anyone tell me what i missed while inserting data ?

 

 

Abo Anas

Abo Anas

Hello All :

many thanks as advance for who help or trying

i have system{ not prestashop system but its made individually } that contain customers and categories and subcategories and products now i try to go to presta and migrate database i did script to get fields from old database to the prestashop like

in category tables 

$sql="insert into {$this->pprefex}category (id_parent, id_shop_default, level_depth, nleft, nright, active, date_add, date_upd, `position`, is_root_category) values (2, 1, 2, 2, 2, 1, '{$create_time}','{$update_time}', 0, 1)";

$this->dbp->query($sql);$newcust=$this->dbp->lastInsertID();
$sql="insert into {$this->pprefex}category_lang values ({$newcust}, 1, 1, '{$name_en}', '', '', '', '', '')";
$this->dbp->query($sql);

BTW im using the primary keys ids from the old system

in its get inserted succssessfully

but when  i try to edit the the category it gives me

The object cannot be loaded (or found)

thats in all inserted data product / customers / categories

can anyone tell me what i missed while inserting data ?

 

 

Abo Anas

Abo Anas

Hello All :

many thanks as advance for who help or trying

i have system{ not prestashop system but its made individually } that contain customers and categories and subcategories and products now i try to go to presta and migrate database i did script to get fields from old database to the prestashop like

in category tables

 $sql="insert into {$this->pprefex}category (id_parent, id_shop_default, level_depth, nleft, nright, active, date_add, date_upd, `position`, is_root_category) values (2, 1, 2, 2, 2, 1, '{$create_time}','{$update_time}', 0, 1)";

$this->dbp->query($sql);$newcust=$this->dbp->lastInsertID();
$sql="insert into {$this->pprefex}category_lang values ({$newcust}, 1, 1, '{$name_en}', '', '', '', '', '')";
$this->dbp->query($sql);

 

 

 

×
×
  • Create New...