search

aaujon / Inventirap

Inventirap repository, a free and open source inventory application
5 stars 0 forks source link

Categorie/SousCategorie view/edit #95

Closed spapazog closed 12 years ago

spapazog commented 12 years ago

There is error when viewing/editing Categorie/SousCategorie:

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Materiel.sous_category_id' in 'field list'

SQL Query: SELECT `Materiel`.`id`, `Materiel`.`designation`, `Materiel`.`categorie_id`, `Materiel`.`sous_categorie_id`, `Materiel`.`numero_irap`, `Materiel`.`description`, `Materiel`.`organisme`, `Materiel`.`materiel_administratif`, `Materiel`.`materiel_technique`, `Materiel`.`status`, `Materiel`.`date_acquisition`, `Materiel`.`fournisseur`, `Materiel`.`prix_ht`, `Materiel`.`eotp`, `Materiel`.`numero_commande`, `Materiel`.`code_comptable`, `Materiel`.`numero_serie`, `Materiel`.`groupes_thematique_id`, `Materiel`.`groupes_travail_id`, `Materiel`.`ref_existante`, `Materiel`.`lieu_stockage`, `Materiel`.`lieu_detail`, `Materiel`.`nom_responsable`, `Materiel`.`email_responsable`, (CONCAT(lieu_stockage, "-", lieu_detail)) AS `Materiel__full_storage`, `Materiel`.`sous_category_id` 
FROM `mydb`.`materiels` AS `Materiel` 
WHERE `Materiel`.`sous_category_id` = (32)
spapazog commented 12 years ago

Problem with CakePHP based on english language... That was my problem at the first place, and that is why I didn't translated those 2 tables..! Trying to find a fix..