| 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
170
   |
Posted - 2013.06.27 05:16:00 -
[361] - Quote
I have pushed a change that should get Yapeal working again.
Update Yapeal (via hg pull or by downloading yapeal-latest.zip) and re-run install/createMySQLTables.php
This should be a non-destructive operation but you should backup your Yapeal data first if it is valuable.
Yapeal then should start to work once more.
I have NOT added the new "KillMails" API and will see if I can figure that out.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Zaepho
Phoenix Propulsion Labs
15
|
Posted - 2013.06.27 14:37:00 -
[362] - Quote
Looks great! I'm still having some problems with the char/ContactList API but haven't validated it against the schema yet to figure out what it's choking on. I'll post again when I have more solid info. Otherwise, thanks for stepping up! |
Zaepho
Phoenix Propulsion Labs
15
|
Posted - 2013.06.27 15:04:00 -
[363] - Quote
Looks like its an issue with one of the columns in the contactList rowset. Specifically inWatchlist is not being returned although the xsd expects it to always be there. Not sure if these contacts are actually in this character's watchlist or not.
ContactListee6d99d70ac508ff224aee720db4ebfb356475d2.xml:6: element row: Schemas validity error : Element 'row': The attribute 'inWatchlist' is required but missing.
ContactListee6d99d70ac508ff224aee720db4ebfb356475d2.xml:7: element row: Schemas validity error : Element 'row': The attribute 'inWatchlist' is required but missing.
ContactListee6d99d70ac508ff224aee720db4ebfb356475d2.xml fails to validate
flipping the Use attribute to Optional for this field and adding a default value of 0 to the field in the DB seems to fix the issue. |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.06.27 16:41:00 -
[364] - Quote
Hmm, so there are two types of ContactList row types: one that's used for personal contact lists, which should always have a watchlist attribute, and one which is used for corp and alliance contacts lists, which has no concept of a watchlist.
All the schemas appear to be set up to validate this concept correctly. I'll test it against more of my own keys but they seem to work.
I wonder if really old contacts didn't have a watchlist attribute. Will check into it.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.06.27 16:42:00 -
[365] - Quote
Nope, you're right. On at least one of my keys, no watchlist attribute shows up at all. API bug.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Zaepho
Phoenix Propulsion Labs
15
|
Posted - 2013.06.27 18:25:00 -
[366] - Quote
Somerset Mahm wrote:Nope, you're right. On at least one of my keys, no watchlist attribute shows up at all. API bug. I'm going to refrain from changing the Yapeal schemas just yet, because it is technically complying with the row headers that are sent.
I tweeted at PrismX to see if it's a known issue.
Is it essential that we get that attribute on every row? I was operating under the assumption that accepting the missing attribute and using a sane default (0) would be the desirable action.
Unless of course it's not being returned on any contacts.. then that would definitely be a bug.
Looking at my cache (granted not a huge sample but i KNOW it should have some instances of contacts on the watchlist) there are no instances of inWatchlist in any of the returns. So it looks like a bug in the API code. |
Eduardo'o
Reikoku
The Retirement Club
21
|
Posted - 2013.06.30 08:08:00 -
[367] - Quote
I have uploaded 4 account api's into yapeal.
For some reason, only 2 accounts fully expose the data. One account only shows 1 character and another account only exposes 2 accounts.
Is there anyway I can see any debug info?
Also for some reason I cannot see any contract data being downloaded.
Any help would be appreciated.
Ed |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.06.30 19:22:00 -
[368] - Quote
First, check the table accountAPIKeyInfo[/'b] nnd [b]accountCharacters to see what Yapeal thinks about the keys.
If the info there looks correct and you see 4 keys, next check utilRegistered* to make sure you haven't provided overrides to the masks and that the keys are set to active = 1.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Chian XinLian
Darwin's Contraptions
Imperial Research
2
|
Posted - 2013.07.01 11:00:00 -
[369] - Quote
Any help?
I've downloaded yapeal-latest, unpacked it on top of the old yapeal setup and ran install/createMySQLTables.php.. Still everytime yapeal runs, I get pile of errors like these:
2013-07-01 10:57:50.451
WARN: Caching invalid API XML for corp/WalletTransactions
File: /home/mydir/yapeal/class/YapealApiCache.php(192)
2013-07-01 10:58:00.010
WARN: Caching invalid API XML for corp/WalletJournal
File: /home/mydir/yapeal/class/YapealApiCache.php(192)
2013-07-01 10:58:00.360
WARN: Caching invalid API XML for corp/ContactList
File: /home/mydir/yapeal/class/YapealApiCache.php(192)
2013-07-01 10:58:14.631
WARN: Caching invalid API XML for char/ContactList
File: /home/mydir/yapeal/class/YapealApiCache.php(192)
2013-07-01 10:58:18.119
WARN: Caching invalid API XML for char/WalletJournal
File: /home/mydir/yapeal/class/YapealApiCache.php(192)
Kinda annoying since few of the most (to me) important api tables dont update now due these :( |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.07.01 17:22:00 -
[370] - Quote
Chian XinLian wrote:Any help?
I've downloaded yapeal-latest, unpacked it on top of the old yapeal setup and ran install/createMySQLTables.php.. Still everytime yapeal runs, I get pile of errors like these:
Those were definitely fixed in the latest download :) a couple things off the top of my head:
Are you sure you ran createMySQLTables and not createMySQLDatabase? Did it say it completed without errors?
Does the MySQL user that Yapeal runs under have permission to alter tables?
In the table corpWalletJournal, do the fields "owner1TypeID" and "owner2TypeID" exist?
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
|
|
Chian XinLian
Darwin's Contraptions
Imperial Research
2
|
Posted - 2013.07.01 19:42:00 -
[371] - Quote
Somerset Mahm wrote:Chian XinLian wrote:Any help?
I've downloaded yapeal-latest, unpacked it on top of the old yapeal setup and ran install/createMySQLTables.php.. Still everytime yapeal runs, I get pile of errors like these:
Those were definitely fixed in the latest download :) a couple things off the top of my head: Are you sure you ran createMySQLTables and not createMySQLDatabase? Did it say it completed without errors? Does the MySQL user that Yapeal runs under have permission to alter tables? In the table corpWalletJournal, do the fields "owner1TypeID" and "owner2TypeID" exist?
user@fudge:~/yapeal$ install/testForMySQLDatabasePrivs.php
user has the needed privileges on the eve database.
user@fudge:~/yapeal$ install/checkForRequirements.php
All tests passed!!!
user@fudge:~/yapeal$ install/createMySQLTables.php
All database tables have been installed or updated as needed.
user@fudge:~/yapeal$
But to the last question, I have to say 'no', those columns are missing from that table. :( |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.07.01 21:05:00 -
[372] - Quote
Hmm. I verified that createMySQLTables.php properly upgrades a database under my environment.
Last diagnostic question: In install/corp.xml, do you get any results if you search for "owner1TypeID"? (Ensuring that you didn't somehow get a bad download from Sourceforge)
If you get a result for that search, then you have the latest Yapeal version but Yapeal is not properly upgrading the table and that's beyond my current level of investigation. What versions of PHP and MySQL are you using?
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Chian XinLian
Darwin's Contraptions
Imperial Research
2
|
Posted - 2013.07.01 21:31:00 -
[373] - Quote
That was it \o/
For some reason, untarring the yapeal-latest on top of the old install, it didnt fix all the files and those xml's were from old version.. Cranked stuff manually and now it did update the tables correctly :)
Now just to wait and see when cache timers expire if I get fresh data populated into the db. |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.07.01 21:45:00 -
[374] - Quote
\o/
If you feel up to it, the best way to grab updated Yapeal is to set up Mercurial. Then whenever a new version comes out you can do "hg pull -u" and it'll update things automatically for you.
Hope it's all sorted now!
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.07.01 23:56:00 -
[375] - Quote
I'm working on support for the new KillMails API and will try to push a new release in the next day or two.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.07.02 22:52:00 -
[376] - Quote
Pushed a new version.
Yapeal Odyssey-1.0.12
* Added support for cURL compiled with NSS instead of OpenSSL support.
* Added KillMails API and removed KillLog API.
If you have old mails in the KillLog table, dump them to disk before upgrading as the KillLog API has been deprecated and will be removed when you upgrade your Yapeal db schema.
Download the latest Yapeal files (or use Mercurial, recommended!). After backing up your KillLog table, if desired, run install/createMySQLTables.php to upgrade your db schema.
If you get SSL errors, please let me know the output of curl --version on your machine.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Chian XinLian
Darwin's Contraptions
Imperial Research
2
|
Posted - 2013.07.03 12:15:00 -
[377] - Quote
Mmh.. Another problem.. Been watching a while my market orders page (which relies data on membertracking) and it's been empty.. Havent really bothered paying too much attention to it, but today I checked a bit of the corresponding tables in db.. And my corpMemberTracking table is empty :( Is this normal?-p |
Somerset Mahm
Cognitive Distortion
171
|
Posted - 2013.07.03 19:52:00 -
[378] - Quote
corpMemberTracking requires the MemberTrackingExtended permission. Currently MemberTrackingLimited is not supported.
Make sure your key provides this permission and that any bitfield set in utilRegisteredKey encompasses the proper bitmask.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Tiberius Zol
5
|
Posted - 2013.07.04 08:20:00 -
[379] - Quote
hey guys.
after the update to the new version i get an error with the yapeal.php
2013-07-04 08:15:11.959
FATAL: Uncaught exception in yapeal.php
File: D:\yapeal\yapeal.php(183)
2013-07-04 08:15:11.959
FATAL: The APIs: KillLog are unknown in section corp
Trace:
#0 D:\yapeal\class\ASection.php(100): AccessMask->apisToMask(Array, 'corp')
#1 D:\yapeal\class\SectionCorp.php(62): ASection->__construct()
#2 D:\yapeal\yapeal.php(163): SectionCorp->__construct()
#3 {main}
An idea, what i have to change to get it work again?
I am new to yapeal and only walked trough the beginnertutorial to add my accs and chars the last days.. |
Tiberius Zol
5
|
Posted - 2013.07.04 12:40:00 -
[380] - Quote
Ok fixed it myself.
just deleted the KillLog class files.
|
|
|
Tiberius Zol
6
|
Posted - 2013.07.04 13:23:00 -
[381] - Quote
Another question:
I didn't find the lastknownlocation information in the database. im not sure, but i think it should come with a full api with the characterinfo.xml
|
Somerset Mahm
Cognitive Distortion
171
|
Posted - 2013.07.04 18:31:00 -
[382] - Quote
CharacterSheet does not contain this info. Corp/MemberTrackingExtended does, but that's a corp key you need.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Tiberius Zol
6
|
Posted - 2013.07.04 22:29:00 -
[383] - Quote
I don't mean CharacterSheet, but CharacterInfo -> http://wiki.eve-id.net/APIv2_Eve_CharacterInfo_XML
It's in the eve group. |
Minerva Arbosa
Ore 4 You
4
|
Posted - 2013.07.09 04:25:00 -
[384] - Quote
Is there a way when setting up a Yapeal to import the database tables straight into the database via phpMyAdmin or another similar utility? Also, why is only PHP CLI supported? |
Somerset Mahm
Cognitive Distortion
171
|
Posted - 2013.07.09 04:54:00 -
[385] - Quote
PHP CLI is because Yapeal is meant to be run via cron.
I don't quite grok the first part of your question-- do you mean you need to create the db tables? If so, you can do this by running install/createMySQLTables.php
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Louis Vitton
Black Aces
Against ALL Authorities
36
|
Posted - 2013.07.09 05:02:00 -
[386] - Quote
If Somerset's idea doesnt work for you post again and i will upload a dump of the most recent database with no information in it so that you can then use phpmyadmin to install it. |
Dvorak Telemnar
Griffin Capsuleers
Ad-Astra
3
|
Posted - 2013.07.11 10:30:00 -
[387] - Quote
About to embark on my own steep learning curve in attempting to convert a google docs recruitment tool I wrote along time ago into PhP so been following this thread with earnest.
Somerset : May I suggest you start a new thread as the new maintainer of the project and link back to this one giving credit to all whose hard work has gone before? That way you will be able to maintain a change log and version info on the first post :) |
Tiberius Zol
6
|
Posted - 2013.07.11 12:58:00 -
[388] - Quote
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. |
Erica Northman
Phoenix Co.
0
|
Posted - 2013.07.14 18:57:00 -
[389] - Quote
WARN: Caching invalid API XML for corp/CorporationSheet
Im getting this error. Any idea how to fix this ? |
Somerset Mahm
Cognitive Distortion
172
|
Posted - 2013.07.14 20:03:00 -
[390] - Quote
Erica Northman wrote: WARN: Caching invalid API XML for corp/CorporationSheet
Im getting this error. Any idea how to fix this ?
Thanks for the report! I've committed a new Yapeal version. To upgrade:
Download the new version and replace your copy of Yapeal (or use Mercurial, recommended!)
Run install/createMySQLTables.php to update the table schema.
Changelog:
- Change CURLOPT_SSL_VERIFYHOST to 2 as the previous behavior has been deprecated in the latest versions of libcurl and PHP is now throwing a deprecation notice.
- Add new "FactionID" column to corp/corporationSheet. If a corporation participates in faction warfare, their chosen faction will be here.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
|
|
|
|
| |
|
| 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 |