Autore Topic: problema query usando il componente jmoodle (sso) joomla 1.7  (Letto 873 volte)

pippo30

  • Visitatore
SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle,

m.params, mm.menuid FROM jhost_modules AS m LEFT JOIN jhost_modules_menu

AS mm ON mm.moduleid = m.id LEFT JOIN jhost_extensions AS e ON e.element

= m.module AND e.client_id = m.client_id WHERE m.published = 1 AND

e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up

<= '2012-01-05 09:22:34') AND (m.publish_down = '0000-00-00 00:00:00' OR

m.publish_down >= '2012-01-05 09:22:34') AND m.access IN (1,1,2,3) AND

m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY

m.position, m.ordering

pippo30

  • Visitatore
Re:problema query usando il componente jmoodle (sso) joomla 1.7
« Risposta #1 il: 05 Gen 2012, 11:33:24 »
Errore nel caricamento del modulo MySQL server has gone away SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jhost_modules AS m LEFT JOIN jhost_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jhost_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-01-05 10:32:35') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-01-05 10:32:35') AND m.access IN (1,1,2,3) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering

 

Host

Torna su