Pages: 1 2 3 4 5 6 7 8 9 10 [11] 12 13 14 15 16 17 18 19 20 .. 24 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2009.09.06 17:45:00 -
[301]
Originally by: Elnar Khad Let me say, thank you to everyone who has worked on this project. It is very well thought out and will be very useful. I'm coming up against a wall during setup of the scripts. I have followed the windows version of the setup and most things seem to be working. It is correctly pulling down server, map and alliance information, and pulling the characters out of my accounts correctly. The only things that are not getting put into the database are the items that I put into the "ActiveAPI" fields in the utilregisteredcharacter and utilregisteredcorporation tables. Per the instructions, it should be "char" or "corp" and then the name of the api, so I'm putting in items like: Quote: charAccountBalance charAssetList charCharacterSheet charIndustryJobs charKillLog charMarketOrders charSkillInTraining charSkillQueue charStandings charWalletJournal charWalletTransactions corpAccountBalance corpAssetList corpCorporationSheet corpDivisions corpWalletDivisions corpLogo corpIndustryJobs corpKillLog corpAttackers corpItems corpVictim corpMarketOrders corpMemberTracking corpStandings corpStarbaseDetail corpCombatSettings corpFuel corpGeneralSettings corpStarbaseList corpWalletJournal corpWalletTransactions
I am not seeing any errors in the logs, and the yapeal/cache/char and corp folders are not getting xml documents.
I've been staring at this for days and I don't see what I'm doing wrong. Any ideas? Thanks, Elnar
It looks like your mixing the character and corporation apis. Corporation apis need to be in utilRegisteredCorporation and character apis need to be in utilRegisteredCharacter
Quantum Industries is recruiting! |
Elnar Khad
Minmatar Deathadder Coalition
|
Posted - 2009.09.06 17:58:00 -
[302]
Sorry I wasn't clear when I made that post. I do have them split appropriately. I just copy/pasted both sets into the forum for review. Am I putting the wrong capitalization/spelling in there? Like I said, I know the api's are pulling appropriate information since I'm getting the character lists in accountcharacters and I did get an error message the other day when I let one of the accounts lapse and had to reactivate it. I'm stumped. Thanks again for the help.
|
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.09.06 19:03:00 -
[303]
The problem is the docs haven't caught up the the code it seems, sorry about that. Try putting the API names in without adding "char" or "corp" to them that was a change that was made when updating to use utilSections table etc. that just was done a couple weeks ago. I'll look through the docs again and try to get them updated as it seems I missed that. Maybe a little while as I was just up until 5am re-doing Linux on my development machine after making mistake of trying the bleeding edge version of my desktop and still trying to get everything setup right again . -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
Elnar Khad
Minmatar Deathadder Coalition
|
Posted - 2009.09.06 20:08:00 -
[304]
It was the "Getting Started" guide on http://code.google.com/p/yapeal/wiki/GettingStarted
I'll try it out and see if that gets it. Thanks for the quick replies! Elnar
|
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.09.06 20:40:00 -
[305]
Guess you missed this: Deprecated - Use web installer
I've updated it to: WARNING Deprecated - Use web installer
but I did update the part about adding APIs to reflect the setting for ActiveAPI also while I was at it. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
Pricecheckinaisle Amarr
|
Posted - 2009.09.08 13:24:00 -
[306]
I did miss that, although even using the web installer, a person would still need to put their API information and the items in the "ActiveAPI" field by hand. Unless there is a different web installer I don't know about.
|
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.09.08 18:09:00 -
[307]
In install/setup.php it does have a test character section to it after the basic config but it only does one char and corp. It wasn't made as a full application just something to help people try it out before building their own app around it
We are working on adding some wrapper classes around the utilRegistered* table to make it a bit easier for anyone using it to work with them. They are in alpha testing now and should be done within a couple weeks. Also just started on some per char/corp on-demand style API classes that should be useful for apps that don't want, need, or can't use crontab for some reason. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
Elnar Khad
Minmatar Deathadder Coalition
|
Posted - 2009.09.08 18:12:00 -
[308]
My web host apparently did not install the CLI version for PHP (only the CGI) I'm paid up through the year, so I don't want to switch hosts yet. Any idea if I can get this working? Thanks, Elnar
|
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.09.08 18:19:00 -
[309]
I know some people have had some luck using Yapeal with CGI instead but it's not something I've done. From what I understand of it you may be able to just use it directly but not sure. Have a look in the issues and wiki for some pointers that might help. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
|
Posted - 2009.09.14 15:15:00 -
[310]
My table serverServerStatus still shows the last known good API pull rather than a status of the API being offline. Is this something addressed in a newer version I don't have? |
|
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.09.14 16:49:00 -
[311]
When they take the API servers off line like that there's no way to get a new status so it doesn't update it again until a new one is available. If you want to know if it's stale also look at the date/time and if it's more then say 15 minutes old it's probably not being updated. Once again this is something to be handled in the application being developed it's not Yapeal's place to be deciding if it should return something other than what the API servers tell it as that would be beyond it's function which is to only return the most complete and current data as possible in a useful format for you to use.
Quote: In computer science, a library is a collection of subroutines or classes used to develop software. Libraries contain code and data that provide services to independent programs.
from Wikipedia
You are the programmer for the 'independent program' that uses it but Yapeal isn't the program it just makes it easier to write one IMHO anyway -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
|
Posted - 2009.09.15 15:57:00 -
[312]
I know. Was just checking to see if you had put any timeouts to grab an error value or something in newer versions before I wrote it myself ;)
Thanks for the feedback though.
|
Scribbly
|
Posted - 2009.09.17 02:13:00 -
[313]
Hi guys,
This looks very promising and I hope I can get it to work correctly as have loads of ideas for it. I have been able to get it to pull data from the API as I now have assets, transactions etc. However it does not seem to be updating my characters account balance. I do see the following message
[2009-09-17 01:15:04.070] NOTICE: Message: Upserting 1 records for charAccountBalance File: /xxx/yapeal/class/YapealDBConnection.php Line: 240
and should I be concerned about the following message?
[2009-09-17 01:15:10.686] NOTICE: Message: Peak memory used:2621440 File: /xxx/yapeal.php Line: 200
|
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.09.17 05:30:00 -
[314]
The peak memory use is nothing to worry about that is just there as it says as a notice. If you ever see one larger than about 12 MB do let me know as I've been trying to reduce that and in my testing it's not going over about 12 MB now.
Do you see a record in the charAccountBalance table? If not then there might be a problem. First make sure you've activated that API both in the utilSections->char->activeAPI setting and in the utilRegisteredCharacter. You might also try deleting the record and see if it reappears if it does it's being updated but the API isn't changing which is an issue for CCP to solve -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2009.09.17 09:45:00 -
[315]
Originally by: Dragonaire The peak memory use is nothing to worry about that is just there as it says as a notice. If you ever see one larger than about 12 MB do let me know as I've been trying to reduce that and in my testing it's not going over about 12 MB now.
Do you see a record in the charAccountBalance table? If not then there might be a problem. First make sure you've activated that API both in the utilSections->char->activeAPI setting and in the utilRegisteredCharacter. You might also try deleting the record and see if it reappears if it does it's being updated but the API isn't changing which is an issue for CCP to solve
I would also check the utilCachedUntil table to see if it has an entry for charAccountBalance.
Quantum Industries is recruiting! |
Scribbly
|
Posted - 2009.09.18 02:53:00 -
[316]
ok I have it working!!! This is the coolest thing since sliced bread!
Whats the chances of finding/getting a table with all the eve items in it? Will let me match up transactions, assets etc
|
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.09.18 04:37:00 -
[317]
For that check out the stickys about the static data dump which you can get in MySQL format and look at the invTypes table. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.09.19 17:38:00 -
[318]
Ok someone has found an error in the charMarketOrders and corpMarketOrders tables that is cause duplicate records to be created. You can read more about it at http://code.google.com/p/yapeal/issues/detail?id=21 and find the fix at http://code.google.com/p/yapeal/wiki/Issue21fix
I'll be releasing an update in a couple days for Yapeal but because of the nature of the error the above instructions MUST be used first or running install/setup.php again will either fail or end up deleting all you data which could be a bad thing on a production application with real data you'd like to keep. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
Scribbly
|
Posted - 2009.09.21 01:31:00 -
[319]
Originally by: Dragonaire For that check out the stickys about the static data dump which you can get in MySQL format and look at the invTypes table.
Do you know if any of these dump table names would clash with Yapeal? Would like to know so I can import it all into the same database to keep the complexities of the queries down
|
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2009.09.21 05:23:00 -
[320]
Originally by: Scribbly
Originally by: Dragonaire For that check out the stickys about the static data dump which you can get in MySQL format and look at the invTypes table.
Do you know if any of these dump table names would clash with Yapeal? Would like to know so I can import it all into the same database to keep the complexities of the queries down
nope, and you can set table prefixes for yapeal tables
Quantum Industries is recruiting! |
|
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.09.21 16:13:00 -
[321]
Ok I've deployed the fix for issue 21 to trunk all existing users please make sure to look at http://code.google.com/p/yapeal/wiki/Issue21fix before updating as this revision could cause you problems like lost of data. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
ChriztaneE
|
Posted - 2009.09.27 10:06:00 -
[322]
Edited by: ChriztaneE on 27/09/2009 10:11:52 Hi. I have a problem with Yapeal, when everything is installed and the setup is finished. Going to the CONFIG menu it keeps asking to update the database, and everytime I UPDATE it takes me to the config menu, but it only sends me back to the update menu again, when hitting any buttons..
Also hitting the command prompt xxx\php5.3.0\php.exe -f xxx\yapeal.ph gives an error in common_backend.php on line 62 <- maybe these problems is connected?
|
ChriztaneE
|
Posted - 2009.09.27 10:39:00 -
[323]
Originally by: ChriztaneE Edited by: ChriztaneE on 27/09/2009 10:11:52 Hi. I have a problem with Yapeal, when everything is installed and the setup is finished. Going to the CONFIG menu it keeps asking to update the database, and everytime I UPDATE it takes me to the config menu, but it only sends me back to the update menu again, when hitting any buttons..
Also hitting the command prompt xxx\php5.3.0\php.exe -f xxx\yapeal.ph gives an error in common_backend.php on line 62 <- maybe these problems is connected?
Found out it has to do with the date in yapeal.ini.. Tried to change this from $Date:: 2009-08-28 19:31:54 #$ to Date .. Then cmd says im missing all elements in yapeal.ini (Cahce, Databse and Loggin)
|
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.09.27 19:47:00 -
[324]
Sound like you maybe try to use an yapeal.ini file from before the latest changes to it's format. I would suggest backing it up and then deleting it and try running setup again and see if it doesn't work better for you. The installer should have been able to update it for you but not sure how well that was tested.
On a related note look for Yapeal to be moving to a totally new and different installation and configuration system soon(tm). It will have a multi-platform GUI and CLI installer instead of the current drop into web directory and configure system. The current system will be kept in place for now but long term it will need to either be rewritten or just dropped if it is determined that it isn't needed anymore. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
Zebullon
Gallente Pulsar Inc. Tau Ceti Federation
|
Posted - 2009.10.03 12:16:00 -
[325]
I have the same problem as ChriztaneE and I can't resolve it... The problem is certainly with the date or the release version...
The error message when I run the yapeal.php: Notice: Yapeal version 898 (beta) 2009-09-21 18:06:41 in xxx\inc\common_backend.php on line 62
In my yapeal.ini file, I have this data : date="$Date:: 2009-09-02 17:59:29 #$" version="$Revision: 849 $"
If I change the date and version whith the data in error message, it's the same think. When I delete yapeal.ini and run setup.php, it's again the false data...
I think it's OK for the data base (70 tables created), and I've filled the table correctly...
could you help me ?
|
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2009.10.03 12:48:00 -
[326]
Originally by: Zebullon I have the same problem as ChriztaneE and I can't resolve it... The problem is certainly with the date or the release version...
The error message when I run the yapeal.php: Notice: Yapeal version 898 (beta) 2009-09-21 18:06:41 in xxx\inc\common_backend.php on line 62
It always throws that notice, if there are no other problems and your getting data into the database, do not worry about it. Its just to let you know it has ran.
Quantum Industries is recruiting! |
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.10.03 19:13:00 -
[327]
Notice: Talks about something that someone may find interest to look at
Warning: Something probably went wrong but the program could continue to run. Can mean an bug in the program or just some bad input and output (GIGO)
Error: Something went wrong and the program stopped running. Usually a bug in the program that needs fixed. Can be cause by either logic error or getting unexpected data that wasn't taken into consideration by programmer in program which probably needs to be fixed also.
Exception: Similar to a warning and usually used to handle something that might cause an error if it hadn't been caught by the programmer and handled in some way.
Uncaught exception: This is a exception that happens when the programmer some how missed handling an exception but was smart enough to add something to let him know he missed it.
From the above the only ones that normally need to be worried about are warnings, errors, and uncaught exception and be reported as they will need to be fixed or at least figured out why they have happened. Notices and exception are mostly use to help figure out where something want wrong or right, or just so you know something is really happening -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
Zebullon
Gallente Pulsar Inc. Tau Ceti Federation
|
Posted - 2009.10.04 06:59:00 -
[328]
OK, thanks form the explication. My configuration should be OK because the file TranquilityapiseverServerStatus.xml is correctly downloaded... But I have any other file... (I have any notice for the other files in logs)
I have certainly misinformed the rows in Database, but I don't now why... In the table utilregistereduser : I have filled the full and limited api and userid correctly, and isActive=1. In the table utilregisteredcorporation : I've only filled AccountBalance in activeAPI for the test, characterID and corporationID are filled and isActive=1. Do I filled the field proxy ? with "http://api.eve-online.com/%2$s/%1$s.xml.aspx" ? In the table utilregisteredcharacter : I've only filled WalletJournal in activeAPI for the test, corporationName, name, userID, characterID and corporationID are filled and isActive=1. Do I filled the field proxy ? with "http://api.eve-online.com/%2$s/%1$s.xml.aspx" ? In the table utilconfig : fields charAPIs and corpAPIs are null... is it normal ?
|
Dragonaire
Caldari Corax. New Eden Retail Federation
|
Posted - 2009.10.04 16:58:00 -
[329]
The proxy can be left blank except if you want/need to use one. The default is to use the normal API servers if not set.
Quote: In the table utilconfig : fields charAPIs and corpAPIs are null... is it normal ?
If you didn't run the config/install that would be normal and that table isn't use by anything but it and can be ignored.
Do make sure in the utilSections table you've add the APIs to activeAPI that you want to get for each section as they act as an admin override to what utilRegisteredCharacter/Corporation are allowed to do and of course isActive needs to be set in it too. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
ChillingEchos
|
Posted - 2009.10.04 17:53:00 -
[330]
Was wondering if anyone happened to have the solution to working around the killLogs flag field being set to zero except when its drones or cargo bay?
Found in : /char/KillLog.xml.aspx
Results : <rowset name="items" columns="typeID,flag,qtyDropped,qtyDestroyed"> <row typeID="3520" flag="0" qtyDropped="3" qtyDestroyed="1" /> <row typeID="12076" flag="0" qtyDropped="0" qtyDestroyed="1"> <rowset name="items" columns="typeID,flag,qtyDropped,qtyDestroyed"> <row typeID="12259" flag="0" qtyDropped="0" qtyDestroyed="1" /> <row typeID="1236" flag="0" qtyDropped="2" qtyDestroyed="1" /> <row typeID="2032" flag="0" qtyDropped="1" qtyDestroyed="1" /> </rowset>
Notice how all the flags are 0. in the more broad list there are only flag number 87 and 5 of which are drones and cargo bay items.
Not sure if I have a glitch somewhere or maybe everyone else has found the work around? Or, perhaps like most of my related troubles it is something literally staring me in the face and I just dont see it.
While I'm at it. The yapeal sql for kill data uses the 'lft' 'lvl' 'rgt' fields to show the items. I may need to see if anyone can help me understand the intended use. I really cant help but to think that I may be having a glitch in my Yapeal install cause there are no "apparent" order to the results a couple will be ok and right in terms of how they were fitted on the ship then viola, gets scattered all over the place.
I could use a bail me out our if anyone got a minute and knows what I am doin wrong and can maybe help me figure out what to do with the flags ( god knows having to manually install slots of each item would be awful )
Any help appreciated, and on BIG round of applause to yapeal crew, brilliant work!
Cheers
|
|
|
|
|
Pages: 1 2 3 4 5 6 7 8 9 10 [11] 12 13 14 15 16 17 18 19 20 .. 24 :: one page |
First page | Previous page | Next page | Last page |