Erreur SQL: [MySQL][ODBC 3.51 Driver][mysqld-5.5.15]Got error 28 from storage engine SELECT this.`_oid` AS this, this_k_1.result1 AS this_k_1_1, this.nom_client AS this_p_nom_client, this.accroche AS this_p_accroche, this_s_logo.width AS this_s_logo_p_width, this_s_logo.height AS this_s_logo_p_height, this_s_logo.frames AS this_s_logo_p_frames, this_s_logo.`_oid` AS this_s_logo, this_s_logo_z.filename AS this_s_logo_z_p_filename, this_s_logo_z.extension AS this_s_logo_z_p_extension, this_s_logo_z.label_fr AS this_s_logo_z_p_label_fr, this_s_logo_z.description_fr AS this_s_logo_z_p_description_fr FROM ((dm_card_fiches_references AS this INNER JOIN (ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.`_oid`) AND (this_z_s_ocsCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> ''))) LEFT JOIN (SELECT c0.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 FROM xrm_category AS this INNER JOIN ((dm_card_fiches_references AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> ''))) INNER JOIN ocs_card AS c0_z On ((c0.`_oid` = c0_z.`_oid`) AND (c0_z.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (310, 312)) GROUP BY c0.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin)) LEFT JOIN (alb_image AS this_s_logo INNER JOIN alb_resource AS this_s_logo_z On ((this_s_logo.`_oid` = this_s_logo_z.`_oid`) AND (this_s_logo_z.iso_sid <> ''))) On ((this.logo = this_s_logo.`_oid`) AND (this_s_logo.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (IF((this_z_s_ocsCatalog.useValidation = 1),this_z.ocsStatus,IF(((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)),this_z.ocsStatus,0)) = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = 'ref_hebergement') ORDER BY this_z.ocsModificationDate DESC

Aucune référence disponible pour le moment.

Pack

Créé & Hébergé par CIRCUM

Site propulsé par ISOTOOLS

Logo de la société "Sys-Dis"

Logo partenaires de la société "Isotools"