Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 [14] 15 16 17 18 .. 18 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Somerset Mahm
Cognitive Distortion
172
|
Posted - 2013.07.14 20:12:00 -
[391] - Quote
Tiberius Zol wrote:Hi.
Is there any possibility to run yapeal without PHP CLI? My provider doesn't support CLI despite the fact he allow to create cron jobs.
If you can create cron jobs, can you set yapeal to run as a cronjob?
Something like */1 * * * * /usr/bin/php53 /home/tiberius/yapeal/yapeal.php SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |
Tiberius Zol
6
|
Posted - 2013.07.15 12:02:00 -
[392] - Quote
had to comment out the "CLI-query" part in the yapeal.php to get it to work properly.
But after update, i can't run install/createMySQLTables.php
get Warning: fwrite(): supplied argument is not a valid stream resource in yapeal/install/createMySQLTables.php on line 186
|
Erica Northman
Phoenix Co.
0
|
Posted - 2013.07.15 20:39:00 -
[393] - Quote
I have the lasest hg.
2013-07-15 20:34:59.793 WARN: Insert/upsert failed for utilXmlCache File: /*yapeal/class/YapealQueryBuilder.php(493) 2013-07-15 20:34:59.796 WARN: mysqli error: [2006: MySQL server has gone away] in EXECUTE("truncate table `eveAllianceList`")
Code: 2006 Trace: #0 /*yapeal/ext/ADOdb/adodb.inc.php(1042): adodb_throw('mysqli', 'EXECUTE', 2006, 'MySQL server ha...', 'truncate table ...', false, Object(ADODB_mysqli)) #1 /*yapeal/ext/ADOdb/adodb.inc.php(1017): ADOConnection->_Execute('truncate table ...', false) #2 /*yapeal/class/api/eve/eveAllianceList.php(188): ADOConnection->Execute('truncate table ...') #3 /*yapeal/class/api/AApiRequest.php(112): eveAllianceList->prepareTables() #4 /*yapeal/class/SectionEve.php(113): AApiRequest->apiStore() #5 /*yapeal/yapeal.php(164): SectionEve->pullXML() #6 {main} --------- END TRACE ----------
File: /*yapeal/class/api/eve/eveAllianceList.php(195) 2013-07-15 20:34:59.796 WARN: Could not prepare eveAllianceList API tables to accept new data for 0 File: /*yapeal/class/api/AApiRequest.php(115) 2013-07-15 20:34:59.797 FATAL: Uncaught exception in yapeal.php File: /*/yapeal/yapeal.php(183) 2013-07-15 20:34:59.797 FATAL: Failed to get ADOFieldObjects for columns in YapealQueryBuilder Trace: #0 /*/yapeal/class/api/eve/eveAllianceList.php(84): YapealQueryBuilder->__construct('eveAllianceList', 'mysqli://fredri...') #1 /*/yapeal/class/api/AApiRequest.php(126): eveAllianceList->parserAPI() #2 /*/yapeal/class/SectionEve.php(113): AApiRequest->apiStore() #3 /*yapeal/yapeal.php(164): SectionEve->pullXML() #4 {main} --------- END TRACE ----------
File: /*/yapeal/yapeal.php(184)
|
Erica Northman
Phoenix Co.
0
|
Posted - 2013.07.15 20:39:00 -
[394] - Quote
Erica Northman wrote:I have the lasest hg.
2013-07-15 20:34:59.793 WARN: Insert/upsert failed for utilXmlCache File: /*yapeal/class/YapealQueryBuilder.php(493) 2013-07-15 20:34:59.796 WARN: mysqli error: [2006: MySQL server has gone away] in EXECUTE("truncate table `eveAllianceList`")
Code: 2006 Trace: #0 /*yapeal/ext/ADOdb/adodb.inc.php(1042): adodb_throw('mysqli', 'EXECUTE', 2006, 'MySQL server ha...', 'truncate table ...', false, Object(ADODB_mysqli)) #1 /*yapeal/ext/ADOdb/adodb.inc.php(1017): ADOConnection->_Execute('truncate table ...', false) #2 /*yapeal/class/api/eve/eveAllianceList.php(188): ADOConnection->Execute('truncate table ...') #3 /*yapeal/class/api/AApiRequest.php(112): eveAllianceList->prepareTables() #4 /*yapeal/class/SectionEve.php(113): AApiRequest->apiStore() #5 /*yapeal/yapeal.php(164): SectionEve->pullXML() #6 {main} --------- END TRACE ----------
File: /*yapeal/class/api/eve/eveAllianceList.php(195) 2013-07-15 20:34:59.796 WARN: Could not prepare eveAllianceList API tables to accept new data for 0 File: /*yapeal/class/api/AApiRequest.php(115) 2013-07-15 20:34:59.797 FATAL: Uncaught exception in yapeal.php File: /*/yapeal/yapeal.php(183) 2013-07-15 20:34:59.797 FATAL: Failed to get ADOFieldObjects for columns in YapealQueryBuilder Trace: #0 /*/yapeal/class/api/eve/eveAllianceList.php(84): YapealQueryBuilder->__construct('eveAllianceList', 'mysqli://fredri...') #1 /*/yapeal/class/api/AApiRequest.php(126): eveAllianceList->parserAPI() #2 /*/yapeal/class/SectionEve.php(113): AApiRequest->apiStore() #3 /*yapeal/yapeal.php(164): SectionEve->pullXML() #4 {main} --------- END TRACE ----------
File: /*/yapeal/yapeal.php(184)
Any idea why I get this ?
* = removed the home directory listing. |
Erica Northman
Phoenix Co.
0
|
Posted - 2013.07.15 20:41:00 -
[395] - Quote
Sorry alot of issues here.
I still have no rows in corpCorporationSheet. Uploaded and cleared cache. yapeal running every minute via cron.
log/yapeal_warning says this:
WARN: Caching invalid API XML for corp/CorporationSheet File: /*yapeal/class/YapealApiCache.php(192) 2013-07-15 16:05:22.371 WARN: Caching invalid API XML for corp/CorporationSheet File: /*/yapeal/class/YapealApiCache.php(192)
and I have updated via hg today. Did 3 changes or something. Also did the install/mysqlcreatetables. |
Somerset Mahm
Cognitive Distortion
172
|
Posted - 2013.07.15 22:53:00 -
[396] - Quote
You're getting an error that the "MySQL server has gone away", so something may be wrong with your config.
My first inclination would be to blow away your setup and try starting fresh, as when I do the steps from my dev environment everything seems to work and I get rows in corpCorporationSheet.
Sorry I can't be more help!
[somer ~]$ mysql --version mysql Ver 14.14 Distrib 5.5.31, for Linux (x86_64) using readline 5.1 [somer ~]$ php53 --version PHP 5.3.24 (cli) (built: Apr 25 2013 08:01:58) Copyright (c) 1997-2013 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2013 Zend Technologies with the ionCube PHP Loader v4.2.2, Copyright (c) 2002-2012, by ionCube Ltd. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |
Dragonaire
Here there be Dragons
50
|
Posted - 2013.07.16 03:11:00 -
[397] - Quote
Erica Northman - See post 330 on this thread about possible cause as it's the most common cause of your error especially in Windows.
Tiberius Zol - The error in line 186 is when the script is trying to tell you it has finished without errors and since you are NOT using CLI it doesn't understand it.
Yapeal was made for CLI only because the normal CGI version is missing things it needs but as you've found by modifying it a little it will often work just without some features but I will say except if your host provider has gone out of their way to compile PHP themselves and said not to build CLI it would have been built by default and the PHP CLI is probably available you'll just have to do a little digging around.
Somerset Mahm - Your doing a great job and keep up the good work. Finds camping stations from the inside much easier. Designer of Yapeal-á for Eve API. Check out the Yapeal PHP Library thread for more information. |
Erica Northman
Phoenix Co.
0
|
Posted - 2013.07.16 11:21:00 -
[398] - Quote
Dragonaire wrote:Erica Northman - See post 330 on this thread about possible cause as it's the most common cause of your error especially in Windows.
Not running Windows, but Centos 6.
max_allowed_packet fixed it :) ty.
It also fixed the corpCorporationSheet problem. |
Mintoko
Taedium In Perpetuam
22
|
Posted - 2013.07.19 10:34:00 -
[399] - Quote
I just noticed that I'm no longer getting downloads of the Corp WalletJournal. My last wallet download was 4/10/13, which means I've lost a lot of data.
Has there been a change in the api? I had been working with rev500 and have now updated to rev505, but there's no change. |
Somerset Mahm
Cognitive Distortion
182
|
Posted - 2013.07.19 17:33:00 -
[400] - Quote
I rely on corpWalletJournal heavily so it's probably my most-tested piece. The API has not changed for it in any way that I know, and I'm still receiving wallet data.
I would first make sure that your key's access mask is correct and that the key is still active in utilRegisteredKeys. Very rarely (every 2-3 months for me usually) the API has horked an error that causes Yapeal to think the key is no longer valid, which makes it deactivate it. You'll see this error in your logs as well. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |
|
Mintoko
Taedium In Perpetuam
22
|
Posted - 2013.07.20 01:20:00 -
[401] - Quote
Nothing was deactivated, but I noticed last night that the activeAPIMask in utilRegisteredKey was incorrect. I had never changed it, so I don't know what happened. I corrected it, but still could not get it to pull the data. I just now checked the activeAPIMask in utilRegisteredCorporation and found it to also be incorrect. It's been corrected and is now pulling data.
I'm going through the logs now.
Thank you |
Somerset Mahm
Cognitive Distortion
182
|
Posted - 2013.07.20 01:34:00 -
[402] - Quote
Yes, I think there is a feature somewhere that will deactivate single APIs if they throw certain errors that say you don't have permission (which is an API failure, not your fault or Yapeal's fault).
One of the ideas I have for Yapeal is a sort of status dashboard or heath check where you can quickly see what is working and when it was last updated. So that might help you in the future. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |
Drapko Nitzhonot
Abdera Logistics
10
|
Posted - 2013.07.20 11:06:00 -
[403] - Quote
I receive an email when keys are deactivated. I changed level value="info" to level value="warn" in logger.xml, line 124.
BTW, is there any news on char/ContactList? |
Somerset Mahm
Cognitive Distortion
182
|
Posted - 2013.07.20 17:49:00 -
[404] - Quote
Without a bug reporting system I was reduced to tweeting at PrismX and haven't gotten a reply. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |
Mintoko
Taedium In Perpetuam
22
|
Posted - 2013.07.21 01:24:00 -
[405] - Quote
What's the purpose of utilRegisteredUploader and utilUploadDestination?
Also, is there any benefit either way of storing the cache in the database vs a file? |
Louis Vitton
Black Aces Against ALL Authorities
38
|
Posted - 2013.07.21 02:00:00 -
[406] - Quote
You dont need to store the cache at all if you dont want to. There are two options provided and their main usage is for troubleshooting issues when they arise cause then you can check the XML returned from the eve online api and compare it to the yepeal database to see what is and what is not getting pulled and possibly why. It will also let you know if pulls are coming though for that api or not by been able to check the cache. If you have space limits on your host / provider you dont need to keep them at all. |
Riley Masterson
Mechanical Basterds
0
|
Posted - 2013.07.21 16:14:00 -
[407] - Quote
I'm getting the following 403 error. when running yapeal.php Any idea what I might need to look at to correct this one?
INFO: 403 Forbidden for API https://api.eveonline.com/account/APIKeyInfo.xml.aspx File: ~/yapeal/class/YapealNetworkConnection.php(103)
I've tried wiping out the whole install and setting it up from scratch. I kept my database, it appeared to upgrade fine |
Somerset Mahm
Cognitive Distortion
184
|
Posted - 2013.07.21 20:00:00 -
[408] - Quote
403 means your credentials are invalid or you sent a bad request. Did your API key expire? They normally have an expiry of a year. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |
Riley Masterson
Mechanical Basterds
0
|
Posted - 2013.07.21 22:20:00 -
[409] - Quote
It turns out it was expired credentials. Someone had removed their key and created a new one and the old key caused the error.
Thanks! |
Chian XinLian
Darwin's Contraptions Imperial Research
2
|
Posted - 2013.07.28 10:52:00 -
[410] - Quote
Any idea why when I'm running Yapeal, it doesnt update ME/PE/Copy corporation jobs correctly? And today it even seems to be failing even manufacturing jobs.. Invention jobs however still currently update correctly when finished..
There are no errors towards corpIndustryJobs api when Yapeal runs. |
|
Somerset Mahm
Cognitive Distortion
185
|
Posted - 2013.08.02 06:37:00 -
[411] - Quote
I use Yapeal to track almost 20 characters' worth of jobs. What kind of keys are you using to track the jobs? SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |
Erica Northman
Phoenix Co.
3
|
Posted - 2013.08.03 09:27:00 -
[412] - Quote
Somerset Mahm wrote:I use Yapeal to track almost 20 characters' worth of jobs. What kind of keys are you using to track the jobs?
Are there any restrictions of how many characters/corporations u can track with Yapeal? I theory could u track 1000 corporations? |
Louis Vitton
The Eighty Eight Brothers of Tangra
40
|
Posted - 2013.08.03 10:50:00 -
[413] - Quote
In theory there is no restriction i am aware of in the software. However CCP may or may not allow you to do this as you would put a heavy load on their server requesting that much data all the time. **Please note this is what i am aware of from my use of yapeal. |
Erica Northman
Phoenix Co.
3
|
Posted - 2013.08.03 11:05:00 -
[414] - Quote
Louis Vitton wrote:In theory there is no restriction i am aware of in the software. However CCP may or may not allow you to do this as you would put a heavy load on their server requesting that much data all the time. **Please note this is what i am aware of from my use of yapeal.
Buyt yapeal checks cache and does not query the API-server unnecessary? And how does EVE-KILL do it? They do alot of pulling requests. |
Louis Vitton
The Eighty Eight Brothers of Tangra
40
|
Posted - 2013.08.03 11:26:00 -
[415] - Quote
I believe it pauses between requests or groups of requests i am not sure if yapeal does this. |
Somerset Mahm
Cognitive Distortion
185
|
Posted - 2013.08.04 23:13:00 -
[416] - Quote
As long as you make valid requests CCP has no limiting in place. You only get in trouble if you make invalid requests like trying to scrape character names, etc. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |
Lara Masuka
Ministry of War Amarr Empire
0
|
Posted - 2013.08.05 22:23:00 -
[417] - Quote
Is there any chance that the CorporationSheet API is not working for corporations with no API key on file (CCP does deliver information on that API without API keys)?
I'm trying to pull information on a bunch of corporations and it works on one corp where I have an API key on file, but all remaining corps won't get an entry in the corpcorporationsheet table. I did register their corporation IDs though and they're all listed in utilregisteredcorporation. |
Somerset Mahm
Cognitive Distortion
186
|
Posted - 2013.08.07 04:20:00 -
[418] - Quote
I believe Yapeal only operates on the full-permissions CorporationSheet. I'll take another look. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |
Atomic Hedgehog
Starcade Group Elemental Tide
0
|
Posted - 2013.08.12 09:04:00 -
[419] - Quote
am I doing something wrong
php -f ./yapeal.php results in this
2013-08-12 08:54:06.376 INFO: No corporations for corp section File: /root/Downloads/yapeal/class/SectionCorp.php(82)
running this on centos 6.4 or trying to anyways.
the db is created and user has access |
Louis Vitton
The Eighty Eight Brothers of Tangra
40
|
Posted - 2013.08.12 09:15:00 -
[420] - Quote
Do you have a corp key in the database? If not thats why you get that Info message. |
|
|
|
|
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 [14] 15 16 17 18 .. 18 :: one page |
First page | Previous page | Next page | Last page |