queries identificadas (error en base de datos)

16/02/2010 a las 10:21 #87624

Anónimo

Invitado

Hola amigos y amigas soy nuevo en la comunidad y seguramente me quedare mucho tiempo por acá. en esta Ocacion quiero pedirles su ayuda. Pues resulta que he instalado el componente de sh404SEF 1.0.16 beta sacado de este post
y tambien he instalado el componente de joomap2.06_beta2c.
El Sh404sef de primero y luego el joomap. El asunto es que no pude configurar el primero ya que me decia que no hay permisos de escritura hice todo lo necesario para dar permisos de escritura a los archivos y directorios necesuitaba el componente para que se instalara pero no se puedo seguia diciendo lo mismo asi que lo desinstale luego tambien desistale el joomap pero luego al recargar la pagina me doy cuenta de que algo sucedio. Mi frontpage se carga bien, es hasta abajo despues del footer que me sale este error o no se que sea porfavor quisiera que me ayudaran ya que es muy importante recuperar esta base de datos.
he instalado el sitio en local y he abierto la base de datos y he eliminado todas las tablas y todo lo que tenga que ver con los anteriores componentes. Pero sigue igual. Por favor Ayuda!!!!
he buscado en Googlel y he allado algunos sitios con el mismo problema.

———————————————————————
•Perfíl de la información•
Application afterLoad: 0.004 seconds, 0.28 MB
Application afterInitialise: 0.225 seconds, 3.07 MB
Application afterRoute: 0.251 seconds, 3.53 MB
Application afterDispatch: 0.790 seconds, 7.47 MB
Application afterRender: 1.797 seconds, 14.12 MB
•Memoria usada•
14909440
•44 queries identificadas•

1.
SELECT *
FROM y6z4i_session
WHERE session_id = ‘0ca516e40e052bdbec92729cffdd29cf’
2.
DELETE
FROM y6z4i_session
WHERE ( time < '1266297258' ) 3. SELECT * FROM y6z4i_session WHERE session_id = '0ca516e40e052bdbec92729cffdd29cf' 4. UPDATE `y6z4i_session` SET `time`='1266299658',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:"session.counter";i:2;s:19:"session.timer.start";i:1266299497;s:18:"session.timer.last";i:1266299497;s:17:"session.timer.now";i:1266299654;s:22:"session.client.browser";s:88:"Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:59:"C:\xampp\htdocs\soy\libraries\joomla\html\parameter\element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"9991622934284b876e157a13b01cf004";}' WHERE session_id='0ca516e40e052bdbec92729cffdd29cf' 5. SELECT * FROM y6z4i_components WHERE parent = 0 6. SELECT folder AS type, element AS name, params FROM y6z4i_plugins WHERE published >= 1
AND access <= 0 ORDER BY ordering 7. SELECT m.*, c.`option` AS component FROM y6z4i_menu AS m LEFT JOIN y6z4i_components AS c ON m.componentid = c.id WHERE m.published = 1 ORDER BY m.sublevel, m.parent, m.ordering 8. SELECT * FROM y6z4i_rokcandy WHERE published=1 9. SELECT template FROM y6z4i_templates_menu WHERE client_id = 0 AND (menuid = 0 OR menuid = 1) ORDER BY menuid DESC LIMIT 0, 1 10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering FROM y6z4i_content AS a INNER JOIN y6z4i_content_frontpage AS f ON f.content_id = a.id LEFT JOIN y6z4i_categories AS cc ON cc.id = a.catid LEFT JOIN y6z4i_sections AS s ON s.id = a.sectionid LEFT JOIN y6z4i_users AS u ON u.id = a.created_by LEFT JOIN y6z4i_groups AS g ON a.access = g.id WHERE 1 AND a.access <= 0 AND a.state = 1 AND (( cc.published = 1 AND s.published = 1 ) OR ( a.catid = 0 AND a.sectionid = 0 ) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-02-16 05:54:18' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= ‘2010-02-16 05:54:18’ )
ORDER BY f.ordering
LIMIT 0, 9
11.
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(‘:’, a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(“:”, cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM y6z4i_content AS a
INNER JOIN y6z4i_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN y6z4i_categories AS cc
ON cc.id = a.catid
LEFT JOIN y6z4i_sections AS s
ON s.id = a.sectionid
LEFT JOIN y6z4i_users AS u
ON u.id = a.created_by
LEFT JOIN y6z4i_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0 AND a.state = 1 AND (( cc.published = 1 AND s.published = 1 ) OR ( a.catid = 0 AND a.sectionid = 0 ) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-02-16 05:54:18' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= ‘2010-02-16 05:54:18’ )
ORDER BY f.ordering
12.
SELECT id, title, module, position, content, showtitle, control, params
FROM y6z4i_modules AS m
LEFT JOIN y6z4i_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 = 1 OR mm.menuid = 0 ) ORDER BY position, ordering 13. SELECT * FROM y6z4i_community_config WHERE name = 'config' 14. SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* FROM y6z4i_community_users AS a LEFT JOIN y6z4i_users u ON u.`id`=a.`userid` LEFT OUTER JOIN y6z4i_session s ON s.`userid`=a.`userid` AND s.client_id !='1' WHERE a.`userid`='0' 15. SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* FROM y6z4i_community_users AS a LEFT JOIN y6z4i_users u ON u.`id`=a.`userid` LEFT OUTER JOIN y6z4i_session s ON s.`userid`=a.`userid` AND s.client_id !='1' WHERE a.`userid`='66' 16. SELECT * FROM `y6z4i_users` AS a INNER JOIN `y6z4i_community_users` AS b ON a.`id` = b.`userid` WHERE a.`block` = '0' AND b.`avatar` != 'components/com_community/assets/default.jpg' ORDER BY a.`registerDate` DESC LIMIT 20 17. SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* FROM y6z4i_community_users AS a LEFT JOIN y6z4i_users u ON u.`id`=a.`userid` LEFT OUTER JOIN y6z4i_session s ON s.`userid`=a.`userid` WHERE a.`userid` IN (263,262,260,254,231,229,226,214,207,175,164,152,146,141,134,124,114,112,110,89) 18. SELECT id FROM y6z4i_menu WHERE `link` LIKE '%option=com_community&view=profile%' AND `published`=1 19. SELECT id FROM y6z4i_menu WHERE `link` = 'index.php?option=com_community&view=frontpage' AND `published`=1 20. SELECT id FROM y6z4i_menu WHERE `link` LIKE '%option=com_community&view=search%' AND `published`=1 21. SELECT COUNT(*) FROM y6z4i_vvisitcounter WHERE ip='127.0.0.1' AND (tm + '900') > ‘1266299659’
22.
SELECT MAX(id)
FROM y6z4i_vvisitcounter
23.
SELECT COUNT(*)
FROM y6z4i_vvisitcounter
WHERE tm >= ‘1266213600’
24.
SELECT COUNT(*)
FROM y6z4i_vvisitcounter
WHERE tm >= ‘1266127200’
AND tm < '1266213600' 25. SELECT COUNT(*) FROM y6z4i_vvisitcounter WHERE tm = '1266213600' 26. SELECT COUNT(*) FROM y6z4i_vvisitcounter WHERE tm >= ‘1265608800’
AND tm < '1266213600' 27. SELECT COUNT(*) FROM y6z4i_vvisitcounter WHERE tm >= ‘1265004000’
AND tm < '1266213600' 28. SELECT COUNT(*) FROM y6z4i_vvisitcounter WHERE tm >= ‘1262412000’
AND tm < '1265004000' 29. SELECT COUNT(*) FROM y6z4i_vvisitcounter WHERE tm >= ‘1266298459’
30.
SELECT id
FROM y6z4i_menu
WHERE `link` LIKE ‘%option=com_community&view=frontpage%’
AND `published`=1
31.
SELECT id
FROM y6z4i_menu
WHERE `link` LIKE ‘%option=com_community&view=register%’
AND `published`=1
32.
SELECT id
FROM y6z4i_menu
WHERE `link` LIKE ‘%option=com_community&view=connect%’
AND `published`=1
33.
SELECT a.*, TO_DAYS(‘2010-02-15 23:54:19’) – TO_DAYS( DATE_ADD(a.`created`, INTERVAL -6 HOUR ) ) AS ‘daydiff’
FROM y6z4i_community_activities AS a
WHERE `archived`=0
AND (a.`access` <= 10) ORDER BY a.`created` DESC LIMIT 80 34. SELECT name FROM y6z4i_plugins WHERE `element`='photos' 35. SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* FROM y6z4i_community_users AS a LEFT JOIN y6z4i_users u ON u.`id`=a.`userid` LEFT OUTER JOIN y6z4i_session s ON s.`userid`=a.`userid` AND s.client_id !='1' WHERE a.`userid`='62' 36. SELECT name FROM y6z4i_plugins WHERE `element`='profile' 37. SELECT name FROM y6z4i_plugins WHERE `element`='myblog' 38. SELECT name FROM y6z4i_plugins WHERE `element`='groups' 39. SELECT name FROM y6z4i_plugins WHERE `element`='photos' 40. SELECT name FROM y6z4i_plugins WHERE `element`='photos' 41. SELECT name FROM y6z4i_plugins WHERE `element`='profile' 42. 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.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug FROM y6z4i_content AS a INNER JOIN y6z4i_categories AS cc ON cc.id = a.catid INNER JOIN y6z4i_sections AS s ON s.id = a.sectionid WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-02-16 05:54:18' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= ‘2010-02-16 05:54:18’ )
AND s.id > 0
AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND (cc.id=13) AND (s.id=6) AND s.published = 1 AND cc.published = 1 ORDER BY a.id DESC LIMIT 0, 15 43. 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.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug FROM y6z4i_content AS a INNER JOIN y6z4i_categories AS cc ON cc.id = a.catid INNER JOIN y6z4i_sections AS s ON s.id = a.sectionid WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-02-16 05:54:18' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= ‘2010-02-16 05:54:18’ )
AND s.id > 0
AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND (cc.id=7) AND (s.id=6) AND s.published = 1 AND cc.published = 1 ORDER BY a.created ASC LIMIT 0, 15 44. 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.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug FROM y6z4i_content AS a INNER JOIN y6z4i_categories AS cc ON cc.id = a.catid INNER JOIN y6z4i_sections AS s ON s.id = a.sectionid WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-02-16 05:54:18' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= ‘2010-02-16 05:54:18’ )
AND s.id > 0
AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND (cc.id=3) AND (s.id=1) AND s.published = 1 AND cc.published = 1 ORDER BY a.ordering LIMIT 0, 6 •Archivos de idioma cargados• * C:xampphtdocssoylanguagees-ESes-ES.ini 1 * C:xampphtdocssoylanguagees-ESes-ES.plg_system_debug.ini 1 * C:xampphtdocssoylanguagees-ESes-ES.com_content.ini 1 * administratorlanguagees-ESes-ES.plg_content_jw_allvideos.ini * administratorlanguageen-GBen-GB.plg_content_jw_allvideos.ini 1 * C:xampphtdocssoylanguagees-ESes-ES.plg_content_pagebreak.ini 1 * C:xampphtdocssoylanguagees-ESes-ES.tpl_rt_iridium_j15.ini * C:xampphtdocssoylanguageen-GBen-GB.tpl_rt_iridium_j15.ini 1 * C:xampphtdocssoylanguagees-ESes-ES.mod_roknavmenu.ini * C:xampphtdocssoylanguageen-GBen-GB.mod_roknavmenu.ini 1 * C:xampphtdocssoylanguagees-ESes-ES.com_community.ini 1 * C:xampphtdocssoyadministratorlanguagees-ESes-ES.plg_roknavmenu_boost.ini * C:xampphtdocssoyadministratorlanguageen-GBen-GB.plg_roknavmenu_boost.ini 1 * C:xampphtdocssoyadministratorlanguagees-ESes-ES.plg_roknavmenu_extendedlink.ini * C:xampphtdocssoyadministratorlanguageen-GBen-GB.plg_roknavmenu_extendedlink.ini 1 * C:xampphtdocssoylanguagees-ESes-ES.mod_latestmembers.ini * C:xampphtdocssoylanguageen-GBen-GB.mod_latestmembers.ini 1 * C:xampphtdocssoylanguagees-ESes-ES.mod_vvisit_counter.ini * C:xampphtdocssoylanguageen-GBen-GB.mod_vvisit_counter.ini * C:xampphtdocssoylanguagees-ESes-ES.mod_hellome.ini * C:xampphtdocssoylanguageen-GBen-GB.mod_hellome.ini 1 * C:xampphtdocssoylanguagees-ESes-ES.mod_activitystream.ini * C:xampphtdocssoylanguageen-GBen-GB.mod_activitystream.ini * C:xampphtdocssoylanguagees-ESes-ES.mod_roktabs.ini * C:xampphtdocssoylanguageen-GBen-GB.mod_roktabs.ini * C:xampphtdocssoylanguagees-ESes-ES.mod_rokstories.ini 1 * C:xampphtdocssoylanguagees-ESes-ES.mod_rokajaxsearch.ini 1 * C:xampphtdocssoylanguagees-ESes-ES.mod_mainmenu.ini 1