Diseño y Posicionamiento Web con Joomla › Foros › Joomla 1.7 › Componentes joomla 1.7 › los articulos de k2 y las categorias de kunena no se ven
- Este debate tiene 3 respuestas, 2 mensajes y ha sido actualizado por última vez el hace 13 años, 10 meses por
Moderador Foro.
-
AutorEntradas
-
-
23/09/2011 a las 09:30 #101873
Anónimo
Invitadohola a tod@s comparto unos problemas con la esperanza de que ayudéis
bueno he echo una migración de joomla 1.5 a 1.7 con jUpgrade.
1.en k2 están todos los artículos y categorías de el joomla 1.5 pero no se me ve
2.lo mismo ocurre con kunena instale la ultima versión y las categorías están pero me aparecen las que trae por defecto
3.me sale una lista de errores en toda la web son estos :
Profile Information
Application 0.006 seconds (+0.006); 0.66 MB (+0.659) – afterLoad
Application 0.145 seconds (+0.139); 3.91 MB (+3.247) – afterInitialise
Application 0.182 seconds (+0.037); 5.08 MB (+1.169) – afterRoute
Application 0.248 seconds (+0.065); 6.08 MB (+1.008) – afterDispatch
Application 0.348 seconds (+0.100); 7.24 MB (+1.153) – afterRender
Memory Usage
7.25 MB (7,599,568 Bytes)
6 Queries Logged
SELECT `data`
FROM `j17_session`
WHERE `session_id` = ‘616a7b27861c802b19d51a80c3cea132’
DELETE
FROM `j17_session`
WHERE `time` < 1316728503 SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is null THEN a.state ELSE 2 END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ‘ ‘ THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(‘:’, a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(“:”, c.id, c.alias) ELSE c.id END as catslug
FROM j17_content AS a
LEFT JOIN j17_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN j17_categories AS c
ON c.id = a.catid
LEFT JOIN j17_users AS ua
ON ua.id = a.created_by
LEFT JOIN j17_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j17_contact_details AS contact
on contact.user_id = a.created_by
LEFT JOIN j17_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j17_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM j17_categories AS cat JOIN j17_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = ‘com_content’
AND parent.published = 2
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,2,3)
AND CASE WHEN badcats.id is null THEN a.state ELSE 2 END = 2
AND (a.publish_up = ‘0000-00-00 00:00:00’ OR a.publish_up <= '2011-09-22 22:10:03') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= ‘2011-09-22 22:10:03’)
AND MONTH( a.created ) = 4
AND YEAR( a.created ) = 2010
ORDER BY a.created DESC , a.created DESC
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is null THEN a.state ELSE 2 END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ‘ ‘ THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(‘:’, a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(“:”, c.id, c.alias) ELSE c.id END as catslug
FROM j17_content AS a
LEFT JOIN j17_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN j17_categories AS c
ON c.id = a.catid
LEFT JOIN j17_users AS ua
ON ua.id = a.created_by
LEFT JOIN j17_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j17_contact_details AS contact
on contact.user_id = a.created_by
LEFT JOIN j17_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j17_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM j17_categories AS cat JOIN j17_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = ‘com_content’
AND parent.published = 2
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,2,3)
AND CASE WHEN badcats.id is null THEN a.state ELSE 2 END = 2
AND (a.publish_up = ‘0000-00-00 00:00:00’ OR a.publish_up <= '2011-09-22 22:10:03') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= ‘2011-09-22 22:10:03’)
AND MONTH( a.created ) = 4
AND YEAR( a.created ) = 2010
ORDER BY a.created DESC , a.created DESC
SELECT *
FROM j17_kunena_config
UPDATE `j17_session`
SET `data` = ‘__default|a:8:{s:15:”session.counter”;i:9;s:19:”session.timer.start”;i:1316729104;s:18:”session.timer.last”;i:1316729297;s:17:”session.timer.now”;i:1316729403;s:22:”session.client.browser”;s:106:”Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.186 Safari/535.1″;s:8:”registry”;O:9:”JRegistry”:1:{s:7:”
-