search

EVE-SECURE / joomla-in-eve

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

Skill queue frozen #42

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
I upgraded today to the latest version but the skill queue is still forzen in 
my installation.
It shows for all users a verry old skill they already had completed.
Any idea what I can do?

Thanks!

Original issue reported on code.google.com by Cube1...@googlemail.com on 5 Jul 2011 at 6:35

GoogleCodeExporter commented 9 years ago 
I'm having the same problem.

Original comment by sean.boe...@media-magic.co.uk on 17 Jul 2011 at 10:58

GoogleCodeExporter commented 9 years ago 
Ehm, would anyone mind to mail me a working API key? My subscription elapsed 
and it's hard to test stuff without one ;)

Original comment by koval...@gmail.com on 17 Jul 2011 at 10:29

GoogleCodeExporter commented 9 years ago 
I have sent you an api key by email.

Original comment by Cube1...@googlemail.com on 18 Jul 2011 at 8:15

GoogleCodeExporter commented 9 years ago 
Could not reproduce the bug :( Couple questions:

1. Is everything else (skills, attributes, certificates, roles, clone) in 
character sheet updated correctly?
2. What's the next scheduled time for char/CharacterSheet? (Administration -> 
Components -> Schedule)
3. Could you send me definition for jos_eve_skillqueue table? 
(phpmyadmin/similar tool -> database -> table -> export -> (only) structure)
4. Is there anything in #__eve_alecache table with path = "char/SkillQueue"?

Original comment by koval...@gmail.com on 21 Jul 2011 at 5:18

GoogleCodeExporter commented 9 years ago 
I have fixed the skills frozen problem but not sure what has happened as now a 
skill that should complete on 2nd august is showing Tuesday, 30 November 1999 
00:00:00 as the completion date and unfortunately i have no previous experience 
in time travel although im looking at training that skill to :)

Original comment by sean.boe...@media-magic.co.uk on 21 Jul 2011 at 10:18

GoogleCodeExporter commented 9 years ago 
Oh i fixed the frozen skill que by changing the schedule time in the database 
to the current time.

Original comment by sean.boe...@media-magic.co.uk on 21 Jul 2011 at 10:19

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Great could you please tell me where exactly the field is?

Original comment by Cube1...@googlemail.com on 22 Jul 2011 at 8:53

GoogleCodeExporter commented 9 years ago 
It's in the _eve_schedule table then change 'next' field to the current date 
and time if you only want to change the skill que match the time and date shown 
in joomla to the database :)

Original comment by sean.boe...@media-magic.co.uk on 22 Jul 2011 at 3:11

GoogleCodeExporter commented 9 years ago 
I have 395 entries in this table.
Do I have to change all of them?

Original comment by Cube1...@googlemail.com on 23 Jul 2011 at 11:37

GoogleCodeExporter commented 9 years ago 
try running these queries 

DELETE FROM `jos_eve_alecache` WHERE `path` IN ('char/CharacterSheet', 
'char/SkillQueue');
UPDATE jos_eve_schedule SET next=NOW() WHERE  apicall IN (SELECT id FROM 
jos_eve_apicalls WHERE `call` LIKE "CharacterSheet");

1st one will clear cache for CharacterSheet and SkillQueue and 2nd one will 
schedule CharacterSheet call to current date/time.

Original comment by koval...@gmail.com on 25 Jul 2011 at 9:17