EVE-SECURE / joomla-in-eve

Automatically exported from code.google.com/p/joomla-in-eve
0 stars 0 forks source link

All sub-components fail to find static dump tables #41

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Choosing any component except Eve component in Admin back-end
2. Uninstaling and reinstalling all components makes no difference
3.

What is the expected output? What do you see instead?
Expected output is no errors, I see this (in the Eve Character Tracking module 
as an example:

 Table `mapDenormalize` is missing
 Table `staStations` is missing
 Table `invTypes` is missing

Can you provide path and query segment URL of faulty page?
example: /index.php?option=com_eve&view=character&characterID=111111111:Cha
racter&Itemid=1 or
/alliance/c/222222222-Corporation/c/111111111-Character.html

What version of the product are you using? Please provide version of core
component (com_eve) and faulty component (com_...).
I'm using 0.6.256 for al components

Please provide any additional information below. Try turn on joomla debug
mode.

Joomla debug report below:

Profile Information

Application afterLoad: 0.006 seconds, 0.53 MB

Application afterInitialise: 0.107 seconds, 4.83 MB

Application afterRoute: 0.114 seconds, 4.83 MB

Application afterDispatch: 0.165 seconds, 6.06 MB

Application afterRender: 0.276 seconds, 8.80 MB

Memory Usage
9273288
20 queries logged.
1.
SELECT * 
  FROM jos_session 
  WHERE session_id = '<deleted>'

2.
DELETE 
  FROM jos_session 
  WHERE ( TIME < '1307176266' )

3.
SELECT * 
  FROM jos_session 
  WHERE session_id = '<deleted>'

4.
UPDATE `jos_session` 
  SET `time`='1307177166',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1',`data`='__default|a:8:{s:15:\"session.counter\";i:104;s:19:\"session.timer.start\";i:1307174058;s:18:\"session.timer.last\";i:1307177135;s:17:\"session.timer.now\";i:1307177150;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:7:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:11:\"application\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}s:10:\"com_cpanel\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:9:\"mtupgrade\";O:8:\"stdClass\":1:{s:7:\"checked\";b:1;}}}s:6:\"global\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";i:0;}}}s:13:\"com_installer\";a:1:{s:4:\"data\";O:8:\"stdClass\":2:{s:10:\"limitstart\";O:8:\"stdClass\":3:{s:9:\"component\";i:0;s:6:\"plugin\";i:0;s:6:\"module\";i:0;}s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"client\";s:2:\"-1\";}}}s:7:\"com_eve\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"edit\";O:8:\"stdClass\":1:{s:7:\"account\";O:8:\"stdClass\":2:{s:6:\"userID\";N;s:4:\"data\";N;}}}}s:9:\"com_menus\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:8:\"usermenu\";}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:19:\"<deleted>\";s:8:\"password\";s:65:\"<deeted>\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2011-05-25 12:14:44\";s:13:\"lastvisitDate\";s:19:\"2011-06-03 07:20:00\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:56:\"admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;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:112:\"/<deleted>\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":5:{s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:1:\"0\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"<deleted>\";}' 
  WHERE session_id='<deleted>'

5.
SELECT * 
  FROM jos_components 
  WHERE parent = 0

6.
SELECT folder AS TYPE, element AS name, params 
  FROM jos_plugins 
  WHERE published >= 1 
  AND access <= 2 
  ORDER BY ordering

7.
SELECT config 
  FROM jos_fua_config 
  WHERE id='fua' 
  LIMIT 1

8.
SELECT template 
  FROM jos_templates_menu 
  WHERE client_id = 1 
  AND menuid = 0

9.
SHOW TABLES LIKE 'mapDenormalize'

10.
SHOW TABLES LIKE 'mapDenormalize'

11.
SHOW TABLES LIKE 'staStations'

12.
SHOW TABLES LIKE 'staStations'

13.
SHOW TABLES LIKE 'invTypes'

14.
SHOW TABLES LIKE 'invTypes'

15.
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 <= 2 
  AND m.client_id = 1 
  ORDER BY POSITION, ordering

16.
SELECT a.name, a.admin_menu_link, a.admin_menu_img 
  FROM jos_components AS a 
  INNER JOIN jos_components AS b 
  ON b.id = a.parent 
  WHERE b.OPTION = 'com_evechartracking' 
  AND b.parent = 0 
  ORDER BY a.ordering ASC

17.
SELECT a.*, SUM(b.home) AS home 
  FROM jos_menu_types AS a 
  LEFT JOIN jos_menu AS b 
  ON b.menutype = a.menutype 
  GROUP BY a.id

18.
SELECT * 
  FROM jos_components 
  WHERE `option` <> "com_frontpage" 
  AND `option` <> "com_media" 
  AND enabled = 1 
  ORDER BY ordering, name

19.
SELECT COUNT(*) 
  FROM jos_messages 
  WHERE state = 0 
  AND user_id_to = 62

20.
SELECT COUNT( session_id ) 
  FROM jos_session 
  WHERE guest <> 1

Original issue reported on code.google.com by mattallu...@gmail.com on 4 Jun 2011 at 8:54