search

EVE-SECURE / joomla-in-eve

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

EveCharSheet Issues #33

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Install evecharsheet
2. Attempt to access on Modules

What is the expected output? What do you see instead?

able `invTypes` is missing
Table `invGroups` is missing
Table `chrAttributes` is missing
Table `crtCertificates` is missing
Table `crtClasses` is missing
Table `crtCategories` is missing
Table `dgmAttributeTypes` is missing
Table `dgmTypeAttributes` is missing
Table `staStations` is missing

Can you provide path and query segment URL of faulty page?
http://myserver/administrator/index.php?option=com_evecharsheet

What version of the product are you using? EveCharSheet 0.6.256

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

Debug: 31 queries logged.

1.

          SELECT

              FROM jos_session WHERE session_id = '283d9811189f5820c56a9c599f3715a3' 

2.

        DELETE

            FROM jos_session WHERE ( time < '1289961598' ) 

3.

        SELECT

            FROM jos_session WHERE session_id = '283d9811189f5820c56a9c599f3715a3' 

    4.

        UPDATE jos_session

            SET time='1289962498',userid='62',usertype='Super Administrator',username='admin',gid='25',guest='0',client_id='1',data='default|a:8:{s:15:\"session.counter\";i:66;s:19:\"session.timer.start\";i:1289961329;s:18:\"session.timer.last\";i:1289962493;s:17:\"session.timer.now\";i:1289962494;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"defaultNameSpace\";s:7:\"session\";s:9:\"registry\";a:6:{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\";s:2:\"20\";}}}s:13:\"com_installer\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:10:\"limitstart\";O:8:\"stdClass\":2:{s:9:\"component\";i:0;s:6:\"plugin\";i:0;}}}s:7:\"com_eve\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"edit\";O:8:\"stdClass\":2:{s:9:\"character\";O:8:\"stdClass\":2:{s:11:\"characterID\";N;s:4:\"data\";N;}s:7:\"account\";O:8:\"stdClass\":2:{s:6:\"userID\";N;s:4:\"data\";N;}}}}}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:\"greghacke@gmail.com\";s:8:\"password\";s:32:\"134b655b02d8b7aef0c0eb35c3de448b\";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:\"2010-11-16 17:49:31\";s:13:\"lastvisitDate\";s:19:\"0000-00-00 00:00:00\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";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:78:\"/home/content/g/r/e/greghacke/html/eve/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:\"1fcc958fb22ee614c1bd17833e1678fb\";}' WHERE session_id='283d9811189f5820c56a9c599f3715a3' 

    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 template

            FROM jos_templates_menu WHERE client_id = 1 AND menuid = 0 

    8.

        SHOW TABLES LIKE 'invTypes' 

    9.

        SHOW TABLES LIKE 'invTypes' 

   1. .

          SHOW TABLES LIKE 'invGroups' 

   2. .

          SHOW TABLES LIKE 'invGroups' 

   3. .

          SHOW TABLES LIKE 'chrAttributes' 

   4. .

          SHOW TABLES LIKE 'chrAttributes' 

   5. .

          SHOW TABLES LIKE 'crtCertificates' 

   6. .

          SHOW TABLES LIKE 'crtCertificates' 

   7. .

          SHOW TABLES LIKE 'crtClasses' 

   8. .

          SHOW TABLES LIKE 'crtClasses' 

   9. .

          SHOW TABLES LIKE 'crtCategories' 

  10. .

          SHOW TABLES LIKE 'crtCategories' 

    20.

        SHOW TABLES LIKE 'dgmAttributeTypes' 

    21.

        SHOW TABLES LIKE 'dgmAttributeTypes' 

    22.

        SHOW TABLES LIKE 'dgmTypeAttributes' 

    23.

        SHOW TABLES LIKE 'dgmTypeAttributes' 

    24.

        SHOW TABLES LIKE 'staStations' 

    25.

        SHOW TABLES LIKE 'staStations' 

    26.

        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 

    27.

        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_evecharsheet' AND b.parent = 0 ORDER BY a.ordering ASC 

    28.

        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 

    29.

        SELECT

            FROM jos_components WHERE option <> "com_frontpage" AND option <> "com_media" AND enabled = 1 ORDER BY ordering, name 

    30.

        SELECT COUNT()

            FROM jos_messages WHERE state = 0 AND user_id_to = 62 

    31.

        SELECT COUNT( session_id )

            FROM jos_session WHERE guest <> 1

Original issue reported on code.google.com by gregha...@gmail.com on 17 Nov 2010 at 2:58

GoogleCodeExporter commented 9 years ago 
Hi.
You're missing eve db dump. Please have look at 
http://code.google.com/p/joomla-in-eve/wiki/EveCoreSetup#Static_Data_Dump

Original comment by koval...@gmail.com on 17 Nov 2010 at 8:46

GoogleCodeExporter commented 9 years ago 
Moments after submission, I spotted the error and could not retract this.
Of course, uploading the data times out before completion so it fails. Will 
have to build locally and upload in sections.

Original comment by gregha...@gmail.com on 17 Nov 2010 at 1:25

GoogleCodeExporter commented 9 years ago

Original comment by koval...@gmail.com on 17 Nov 2010 at 1:32