open All Channels
seplocked EVE Technology Lab
blankseplocked Yapeal PHP API library (revision 1203 branches/keys/)
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: first : previous : ... 15 16 17 18 [19] 20 21 22 23 ... : last (24)

Author Topic

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.06.01 16:57:00 - [541]
 

Just a quick update for anyone that was having problems with the Alpha release not finding extensions I've released new fixed version. It also has some of the new APIs added to it but most of them you'll have to manually activate as I didn't update the instiller yet to let you select them. Once I've got them all working I plan to look into how the installer comes up with the list and see if I can't make it smarter and just maybe do something about the formating while I'm at it Wink

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.06.03 00:32:00 - [542]
 

Quick update I've added outpost stuff to the alpha builds in downloads you'll have to activate them manually in the util* tables but they are ready to have someone try them out and let me know about any problems. I'm now looking into updating installer but it may be a while before I have a update for it.

KtoJest
Minmatar
Silkroad Partners
Posted - 2010.06.04 10:21:00 - [543]
 

here is a weird one.

yapeal has stopped collecting data as of 30.05.2010 06:00

it had been running flawlessly before then.

/cache/log has nothing in it.

system log shows cron executing yapeal.php
i've run it manually to no avail

anyone see something like this before?

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.06.05 04:02:00 - [544]
 

There were some changes done to several of the APIs for Tyrannis that will probably break older versions. Can I get some more information about which APIs you are using and which version of Yapeal etc?

KtoJest
Minmatar
Silkroad Partners
Posted - 2010.06.05 07:18:00 - [545]
 

yapeal: revision 561 (as found in yapeal.php)

api's: corp and character
wallet transactions, journals and assets.

character training is working.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.06.05 10:11:00 - [546]
 

KtoJest - If you are looking at the line that reads
* @since      revision 561
that isn't the version for Yapeal the actual version information is in the revision.php file. If you don't have a revision.php file then you are running a very old version and that could explain why it broke Wink The latest version from the trunk/ (main code line) is 1073 and is the version with the changes for Tyrannis. There wasn't any changes directly to wallet transactions, journals, or assets but CCP did fix a long standing bug dealing with walking records on journals. It shouldn't have broke anything but it can have the effect of greatly decreasing the number of API errors reported by Yapeal which you may have been use to seeing from before. You should also look at the log_level= ... line in your config/yapeal.ini file and if it isn't set to E_ALL try setting it to that and you should start seeing a lot of information in the log/yapeal_notice.log every time it runs. It's off by default as it can easily reach several 100 MBs per day depending how many char/corps you have added to Yapeal Shocked

A couple more questions is how did you install/ update Yapeal last time? Did you use an installer from the project downloads or get it from SVN directly? Also when was the last time you do so?

KtoJest
Minmatar
Silkroad Partners
Posted - 2010.06.06 19:05:00 - [547]
 

just to let you know, i've read the msg. and will respond in a day or two. rl calls. :)


KtoJest
Minmatar
Silkroad Partners
Posted - 2010.06.10 16:16:00 - [548]
 

hi-

i'm working with rev 894.

it was manually installed SVN. probably in october of 2009.

i've set the logging to ERR_ALL.

when i run yapeal.php, i can see the router send-light blink a couple of times and the receive-light blink a couple of times. (if that means anything. usually they have a longer conversation. :)

nothing records in the log files.

i've also installed ver 1075, assuming the table structures are the same. changed the .ini file, even downloaded new api keys.

nothing records in the log file.

tables are not updated.

seems like a commo problem???

there was a way of viewing a log of hits on an account but i can't remember how to do it. :(


any ideas? :)






KtoJest
Minmatar
Silkroad Partners
Posted - 2010.06.11 08:18:00 - [549]
 

problem solved :)

this a.m. i tried to use the installer and one of the first things it tells me is the php curl module is not installed.

i had forgotten to install it when moving to opensuse 11.2.
so now rev 849 works, i'll be moving into rev. 1075 as soon as i quit celebrating. lol




Rottw Adleweh
Posted - 2010.06.14 08:34:00 - [550]
 

erm, how hard would making an Mac os x installer be?

btw I still plan to contact you about the postgre soonish, but too busy to get on it yet.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.06.15 03:50:00 - [551]
 

A Mac version could be done as the install builder used can make them but I have no way to test them and you've been the first to ask for one Wink

Rottw Adleweh
Posted - 2010.06.15 13:11:00 - [552]
 

I wouldn't mind providing some test results.

Rottw Adleweh
Posted - 2010.06.22 09:58:00 - [553]
 

Could you post a Mac installer with the downloads?
I'll take it for a spin this week if you do.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.06.22 14:36:00 - [554]
 

Rottw Adleweh - I need you to contact me through my G-Mail account and see if we can get on IM because there's some things I'll need to go over with you before I can even try building one for Mac. Just E-mail the project owner @ gmail.com and we'll work out some details from there.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.06.29 16:42:00 - [555]
 

Just a quick note. Anyone that has had problems with the installer not working with their website hosts in the past if you could please try the new alpha installer and let me know if it now works for you it would be great. I'm trying a different approach that I'm hope will work better with less privilege problems.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.07.14 20:10:00 - [556]
 

Hi all just a quick update. I've added some new targets for building Yapeal to the Phing config file so it should be more streamlined to make the Alpha test builds. In the process I've add archive (zip, tar.bz2) versions to the Alpha for those that prefer them over the full installer versions. You can find them all along with the main trunk Beta builds in downloads. I've been thinking about moving the Alpha stuff into the trunk/ soon so for any of you that haven't tried it and depend on it in your own projects please test it and let me know about any bugs as I want to make all the new APIs available and get the fixes for the memory issues that are solve by using xmlReader into trunk/ soon. I've also done some changes to the scripts used during instill that should help with many of the past database issues that have been reported on some web hosting services.

On another note I've been doing some testing on Amazon's Web Service with Yapeal and was wondering if anyone would be interested in having a special Yapeal Instance for it or maybe just something to use with Xen? or maybe something for VMware but not sure I can make one for it without buying VMware. Let me know if you're interested in one of more of those.

I've also been toying with idea of offering an Yapeal hosting service of some kind. Not sure if it could really be done securely or exactly how to set it up but if there was some interest in something like that I would look into it. I'd like to hear from anyone that has ideas on how to make something like that work or what they would like to see it do. I've kicked this idea around off and on for a year or more but never really came up with anything solid enough to even try.

Let me know if you have any other ideas about anything I've wrote above or if you have an idea for something you'd like to see changed or added to Yapeal.

Kiara Kwea
Posted - 2010.07.24 08:46:00 - [557]
 

Alrighty, I have been working on this for some time now, and I can't seem to figure out what the issue is.

Firstly, I couldn't use an installer as since I use a shared host that does not allow me SSH access. So I built the database on my local machine, exported from my box and imported to the host (this was issue one as my mysql settings on my box were not set to allow creation of tables with mixed case. I modified the my.ini and did it again, this time with the correct table names.)

Ok so now I have a working database, no more errors abut inability to find specific tables. So I add some API keys to the `yapeal_utilRegisteredUser` table make sure to have an API Key in the `activeAPI` column and `isActive` is in fact set to true (1), and `userID`,`limitedApiKey` have the correct values in them.

I was also sure to enable the API calls I want from the `yapeal_utilSections` table. In fact for testing purposes I just enabled them all.

So we're ready to go! I fire up the yapeal.php file and I get no errors, however I get no population of tables based on the API keys I have in `yapeal_utilRegisteredUser`.

However I do in fact get everything else to populate i.e server status, sov status etc.

So I must be missing something easy here, but If I include and enable API Keys in `yapeal_utilRegisteredUser` shouldn't that fire the population?

I read the whole wiki and can't seem to get a clear, or otherwise direct grasp on the relationship of the until tables. Do I need to mannualy resolve out charIDs and CorpIDs and instead of using `yapeal_utilRegisteredUser` use `yapeal_utilRegisteredCharacter`?

Anyway, its obviously working as it pulls everything but information reguarding the API keys I provided. And I did check to make sure they were valid API keys. There is no error response.

Any help would be appreciated! Thanks! Smile

Kiara Kwea
Posted - 2010.07.24 09:12:00 - [558]
 

Ahh nevermind, I got it sorted, I ignored a post on the wiki because it said "WARNING Deprecated" (http://code.google.com/p/yapeal/wiki/GettingStarted)

Which told me exactly what the column 'ActiveAPI is for'

So now, I'm all set ;) ...

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.07.24 13:26:00 - [559]
 

Yeah that file has been deprecated but a complete reference for the util* tables is available in http://code.google.com/p/yapeal/wiki/UtilDatabaseTableDependences. There is also a link in it to other wiki page describing some utility classes that make managing them easier in your application.

Somerset Mahm
Somer's Omnibus Exploration and Reclamation
Cognitive Distortion
Posted - 2010.07.30 04:21:00 - [560]
 

I was trying to add Yapeal entries for my other directors so that I could effectively pull wallet journals more than once every hour. However, corpID is a unique key in utilRegisteredCorporations. Any way around this?

I want to update the same corp wallet using several characters.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.07.30 16:13:00 - [561]
 

It wouldn't do what you think it would even if you could do that. Once one of them pulls the data the API servers continue to use the same cached data for all of them. You can try running multiple copies on several different computers with different public IPs and see if you get different data but I'm fairly sure it wouldn't get you any more data any faster than the cachedUntil time.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.08.12 17:33:00 - [562]
 

Hi all thought I'd let everyone know what's been going on lately with Yapeal and ask for some help. My new job seems to keep me busier than my old one and some other changes that have happened/are expected to happen soon in RL means I'm not going to have the time to work on Yapeal like I use to. In addition to that the other couple developers/friends that helped with some of the coding/test in the background have also faded away at least for a time Sad So what I'm looking to do is find one or two programmers to help out and keep things moving forward. I'll still be coding but would like to have others involved and be able to just work as QA for parts of it.

I'll try to list what I think is important to work on Yapeal:
  • Input and new ideas are always welcome and really expected by all Yapeal developers but I do make the finally call on things based on my vision of Yapeal and feedback from the people using it

  • Think Yapeal is really cool and want to be a part in making it better

  • Able to work with others

  • Able to work by self on tasks

  • Able to take hearing things like "That code looks like s**t" once in a great while and understand it might be true and ask why and how to make it better not get p***ed off. This doesn't happen often but even I have an off day and put things a bit harshly Wink

  • Some programming experience even if PHP is somewhat new to you. I don't mind you using Yapeal as a learning tool and helping you learn to become a better programmer as I've done the same thing myself. If you are new to PHP and write bad code you'll not likely to ever hear comments like above they are reserved for people that really should know better and me having a very off day Razz

  • Understand that Yapeal is important to the Eve development community and take pride in do your best for it with your work on Yapeal

  • Have fun because if you aren't enjoying do this for free why would you what to do it?


Don't take the list as complete or anything it's a quick off the top of my head in two minutes thing based on some past stuff. If I haven't sared you off with stuff in the above list let me know via my Gmail, this thread, etc.

Fashadow1
Posted - 2010.08.28 07:14:00 - [563]
 

I downloaded this and after installing it on my Linux host it just sat there it had no way of seeing a data base or any way of inserting the data base into the mysql area there was not a .sql file for me to manually import neither I am stuck on how to get this to work.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.08.29 02:11:00 - [564]
 

Which file did you download? If one of the installers you'll need to make sure it is mode 07xx for user you are trying to run it as. If you got one of the archives or from SVN you'll have to manual run several of the scripts from install/ to add the DB and/or tables. You'll need to check inc/common_paths.php and change the paths to match where you put stuff. You'll also need to copy config/yapeal-example.ini to config/yapeal.ini and change the stuff in it to match your install. After doing that you can just run yapeal.php and it should start filling you DB with data. I strongly suggest using the installer as it make installing much easier.

Zeta Zhul
Caldari
Preemptive Paranoia
Posted - 2010.09.08 04:13:00 - [565]
 

Edited by: Zeta Zhul on 08/09/2010 04:14:17
Hmmm.

Ok. I'm reading through 19 pages of discussion but I have a fairly simple situation:

1. I tried installing Yapeal using the installer (windows) but it keeps on getting to the point where I've entered in the information to access the local MySQL server, press "Next" and then I get an error dialog with "" as the message. E.g. blank.

So I went with the zip archive and a manual install.

2. Going with the zip archive and a manual install *of the beta version* now I've gotten the archive unzipped and positioned in the desired directory ... but there is no "Setup.php" script anywhere to be found. Does this script exist somewhere I can download it?

I've gotten the "createMySQLTables.php" to run correctly but I don't see where anybody lists the actual steps necessary to get this thing working when doing a manual install.

3. No offense intended to anybody but the whole database part would be much simpler if you'd just include a straight up SQL file with the DDL statements. That would allow you to bypass the whole XML part in the install.

Any help with this would be greatly appreciated.

edit: added note of using the beta version of the zip archive.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.09.08 05:22:00 - [566]
 

Yeah somehow the Windows installer has broken in a very bad way and I haven't figured out how to fix it but been working on a rewrite for it. I've just finished moving in RL and hope to start having a bit more time to work on stuff again. I would actually suggest trying the Alpha builds as they will soon be replacing the current Beta stuff as they have several improvements and bug fixes in them. As to what you need to do to have the tables added to your DB try running install/createMySQLTables.php first without any parameters to find out what you need to use then with the required ones. It should run without any problems for you and it will also leave the SQL it used to make the tables in cache/*.sql files for you to look at if something goes wrong or you decide you need them for something else. I'd also suggest take a look at the website Wiki and issues both current and closed for some tips that might help with install problems. I'm currently working on a couple of issues with how Yapeal handles it's connections to the API servers that have come up in the Alpha and once I have them fixed and tested a little I'll have them up to be downloaded as well.

Zeta Zhul
Caldari
Preemptive Paranoia
Posted - 2010.09.08 14:41:00 - [567]
 

Hi there!

1. First I want to say thanks for all the work you put into the project. From working on software myself I know how much time something like this can take.

2. I didn't think much about them before but I notice you included scripts such as "addTestUser.php". I'll look at these scripts for some clues while I rewind my back through this thread and read the online wiki.

Thanks for your quick response!

Zeta Zhul
Caldari
Preemptive Paranoia
Posted - 2010.09.20 04:31:00 - [568]
 

Edited by: Zeta Zhul on 20/09/2010 04:58:38
Edited by: Zeta Zhul on 20/09/2010 04:53:57
Edited by: Zeta Zhul on 20/09/2010 04:31:26
Hmmm.

Using the Alpha zip archive version with a manual install Yapeal revision 1075.

1. I'm getting a MySQL error code 1292 and traced the issue to `yapeal`.`charMarketOrders`.`changed`

Basically the problem is that the column `changed` is defined as "`changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,". So if the `changed` is NULL then the insert fails with an error. It has been a little while for me with MySQL but I believe if you're going to set a DEFAULT then it should not also have a NOT NULL. This is because a NOT NULL requires data to be provided while a DEFAULT clause predefines an acceptable alternative to data not being there.

Now the problem I'm running into is that the SQL being generated is trying to put 'CURRENT_TIMESTAMP' into the `changed` column. This is failing because MySQL is trying to treat 'CURRENT_TIMESTAMP' as *text* and not a function call. To fix this the 'CURRENT_TIMESTAMP' has to be changed in the php scripts to CURRENT_TIMESTAMP so MySQL will treat it as a proper function call and not text.

Now I need to find the php file with the appropriate sql and modify that.


2. I'm also getting a MySQL error code 1366:

Message: mysqli error: [1366: Incorrect decimal value: '' for column 'taxAmount' at row 1] in adodb_throw(insert into `charWalletJournal`

Is the problem somewhere in YapealQueryBuilder.php?

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.09.20 17:04:00 - [569]
 

If 'changed' is NULL it'll use CURRENT_TIMESTAMP to fill it which is what it's suppose to do.
Quote:
Now I need to find the php file with the appropriate sql and modify that.
Can't be done really since that SQL is gen in a common method from a class that is used for all upserts.

Quote:
2. I'm also getting a MySQL error code 1366:
That looks like a problem from trying to upgrade an old version of the data to the new and it didn't convert correctly.

Try running the installer with a empty (no tables) DB and you shouldn't have any problems. I know I'm probably going to have to write a special upgrade SQL for going from the older tables in trunk to the newer ones but if you know a little bit about SQL you can usually look at the 2 versions and put something together to transfer the data. There should only be a few tables that will need extra attention.
Also make sure you are using at least version 5.x of MySQL and 5.1 is better.

Zeta Zhul
Caldari
Preemptive Paranoia
Posted - 2010.09.20 17:20:00 - [570]
 

Edited by: Zeta Zhul on 20/09/2010 17:23:10
Hola!

1. "If 'changed' is NULL it'll use CURRENT_TIMESTAMP to fill it which is what it's suppose to do."

Nope. The column is marked as "NOT NULL" which means the insert/update is rejected prior to any application of a DEFAULT value.

2. "Can't be done really since that SQL is gen in a common method from a class that is used for all upserts."

I think a small modification of the YapealQueryBuilder.php: starting at line 186 might do it.

From:
case 'T':
case 'D':
case 'C':
case 'N':
case 'X':
// Quote all text, decimal, date type fields.
$set[] = $this->con->qstr($data[$field]);
break;


To:
case 'T':
if ($data[$field] == "CURRENT_TIMESTAMP") {
$set[] = (string)$data[$field];
} else {
$set[] = $this->con->qstr($data[$field]);
};
break;
case 'D':
case 'C':
case 'N':
case 'X':
// Quote all text, decimal, date type fields.
$set[] = $this->con->qstr($data[$field]);
break;

It's just that the process retrieves the column types, where a Date/Datetime/Timestamp = 'T', and then retrieves default values if any. Then it goes to the AddRow() function where it loops through the columns for each row and attempts to add quote marks. It's the quote marks that causes the problems when the the column value = CURRENT_TIMESTAMP.

I try it out and see if it works. It's been a fairly long time since I last did anything serious in php though so don't laugh if I've screwed something up. Very Happy

edit: alternatively, but ugly, is to do a string replace post SQL build but prior to applying the SQL to the MySQL database.

3. "That looks like a problem from trying to upgrade an old version of the data to the new and it didn't convert correctly."

I used the latest revision 1075 to build the database and set everything up. I'll doublecheck the wiki and see if I'm missing anything.


Pages: first : previous : ... 15 16 17 18 [19] 20 21 22 23 ... : last (24)

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only