Back to top

Autore Topic: Caricamento template  (Letto 1242 volte)

Offline six73

  • Appassionato
  • ***
  • Post: 365
    • Mostra profilo
Caricamento template
« il: 10 Apr 2012, 14:50:40 »
Salve a tutti è da qualche giorno che ho seri problemi nel caricamento del template del sito, alcune volte lo carica alcune no, ho attivato il debug e ricevo dei messaggi.
Qualcuno ha gia a vuto questo problema?
Incollo gli errori
1.
SELECT template
  FROM jos_templates_menu
  WHERE client_id = 0
  AND (menuid = 0 OR menuid = 53)
  ORDER BY menuid DESC
  LIMIT 0, 1
2.
SELECT id, title, module, POSITION, content, showtitle, control, params
  FROM jos_modules AS m
  LEFT JOIN jos_modules_menu AS mm
  ON mm.moduleid = m.id
  WHERE m.published = 1
  AND m.access <= 0
  AND m.client_id = 0
  AND ( mm.menuid = 53 OR mm.menuid = 0 )
  ORDER BY POSITION, ordering
3.
SELECT *
  FROM jos_zoo_application
  WHERE id = 4
4.
SELECT a.*
  FROM jos_zoo_item AS a
  LEFT JOIN jos_zoo_category_item AS b
  ON a.id = b.item_id
  WHERE a.application_id = 4
  AND b.category_id  = 45
  AND a.access <= 0
  AND a.state = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-04-10 12:40:26')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-04-10 12:40:26')
  GROUP BY a.id
  ORDER BY a.priority DESC , a.created DESC
  LIMIT 0,10
5.
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug
  FROM jos_content AS a
  INNER JOIN jos_categories AS cc
  ON cc.id = a.catid
  INNER JOIN jos_sections AS s
  ON s.id = a.sectionid
  WHERE a.state = 1 
  AND a.access <= 0
  AND cc.access <= 0
  AND s.access <= 0
  AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2012-04-10 12:40:26" ) 
  AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2012-04-10 12:40:26" )
  AND cc.id = 333
  AND cc.SECTION = s.id
  AND cc.published = 1
  AND s.published = 1
  ORDER BY a.ordering
6.
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
  FROM jos_jf_content AS jf_content
 
  WHERE jf_content.language_id=2
         
  AND jf_content.published=1
   
  AND jf_content.reference_id IN(1251,1252,1253,1272,1254,1241)
   
  AND jf_content.reference_table='content'
7.
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug
  FROM jos_content AS a
  INNER JOIN jos_categories AS cc
  ON cc.id = a.catid
  INNER JOIN jos_sections AS s
  ON s.id = a.sectionid
  WHERE a.state = 1 
  AND a.access <= 0
  AND cc.access <= 0
  AND s.access <= 0
  AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2012-04-10 12:40:26" ) 
  AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2012-04-10 12:40:26" )
  AND cc.id = 223
  AND cc.SECTION = s.id
  AND cc.published = 1
  AND s.published = 1
  ORDER BY a.ordering
8.
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
  FROM jos_jf_content AS jf_content
 
  WHERE jf_content.language_id=2
         
  AND jf_content.published=1
   
  AND jf_content.reference_id IN(700,699,698,697)
   
  AND jf_content.reference_table='content'
9.
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug
  FROM jos_content AS a
  INNER JOIN jos_categories AS cc
  ON cc.id = a.catid
  INNER JOIN jos_sections AS s
  ON s.id = a.sectionid
  WHERE a.state = 1 
  AND a.access <= 0
  AND cc.access <= 0
  AND s.access <= 0
  AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2012-04-10 12:40:26" ) 
  AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2012-04-10 12:40:26" )
  AND cc.id = 333
  AND cc.SECTION = s.id
  AND cc.published = 1
  AND s.published = 1
  ORDER BY a.ordering
10.
SELECT *
  FROM jos_gwesys_mlmenu
  WHERE menuid IN (53)
 

Offline tomtomeight

  • Global Moderator
  • Fuori controllo
  • *****
  • Post: 32046
  • Sesso: Maschio
  • Gli automatismi aiutano ma non insegnano nulla.
    • Mostra profilo
Re:Caricamento template
« Risposta #1 il: 10 Apr 2012, 21:28:14 »
Cortesemente per tenere il forum ordinato e leggibile è opportuno, invece che inserirlo nel post, allegare il codice solo quando necessario  in un file .txt oppure inserire solo le poche righe interessate racchiudendolo fra il tag #, grazie se vorrai adeguarti.

Offline six73

  • Appassionato
  • ***
  • Post: 365
    • Mostra profilo
Re:Caricamento template
« Risposta #2 il: 10 Apr 2012, 23:16:29 »
Chiedo scusa tom ma non riuscivo ad allegare.. La prossima volta ci faro' più attenzione

 



Web Design Bolzano Kreatif