Failed to upsert data from Eve API eve/CharacterInfo for 93133983 {"exception":"[object] (PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\\xE2\\x98\\xBC 10...' for column 'shipName' at row 1 at /htdocs/eve/yapealneu/lib/Database/ValuesDatabasePreserver.php:217)"} []

[2014-09-05 10:15:38] yapeal.DEBUG: Started XSD validating [] []
[2014-09-05 10:15:38] yapeal.INFO: Have 61 row(s) to upsert into charMarketOrders table [] []
[2014-09-05 10:15:38] yapeal.INFO: INSERT INTO "eve"."yp2_charMarketOrders" ("ownerID","orderID","charID","stationID","volEntered","volRemaining","minVolume","orderState","typeID","range","accountKey","duration","escrow","price","bid","issued") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),... ON DUPLICATE KEY UPDATE "ownerID"=VALUES("ownerID"),"orderID"=VALUES("orderID"),"charID"=VALUES("charID"),"stationID"=VALUES("stationID"),"volEntered"=VALUES("volEntered"),"volRemaining"=VALUES("volRemaining"),"minVolume"=VALUES("minVolume"),"orderState"=VALUES("orderState"),"typeID"=VALUES("typeID"),"range"=VALUES("range"),"accountKey"=VALUES("accountKey"),"duration"=VALUES("duration"),"escrow"=VALUES("escrow"),"price"=VALUES("price"),"bid"=VALUES("bid"),"issued"=VALUES("issued") [] []
[2014-09-05 10:15:38] yapeal.DEBUG: 93116526,3730101725,93116526,60003760,1,0,1,2,17718,32767,1000,30,0.00,179389999.88,0,2014-08-29 15:13:35,93116526,3730101840,93116526,60003760,1,0,1,2,11978,32767,1000,30,0.00,150499989.85,0,2014-08-29 13:21:27,93116526,3730269563,93116526,60003760,305,0 [] []
[2014-09-05 10:15:38] yapeal.DEBUG: Checking if cache expired on table charMarketOrders for ownerID = 93133983 [] []

include( $PLUGIN_ROOT. 'includes/yapeal/bin/UtilRegisterKey.php' );
include( $PLUGIN_ROOT. 'includes/yapeal/lib/Database/CommonSqlQueries.php' );
include( $PLUGIN_ROOT. 'includes/yapeal/lib/Database/Account/APIKeyInfo.php');

$pdo = new PDO("mysql:host=localhost;dbname=".API_DB_NAME, API_DB_USER, API_DB_PASS);

$csq = new CommonSqlQueries(eve, '');

$urk = new UtilRegisterKey($pdo, $csq);
$urk->setKeyID(123456);
$urk->setVCode('Cx8j1mG6NQP56v3fxRigQW5rhZVsx8j1mG6NQP56v3fxRigQW5rhZVs');
$urk->setIsActive(1);
$urk->setActiveAPIMask(268435455);
$urk->save();

/**
* @param string $tableName
* @param array $columnNameList
* @param string $rowCount
*
* @return string
*/
public function getUpsert($tableName, array $columnNameList, $rowCount)
{
$columns = implode('","', $columnNameList);
$rowPrototype =
'(' . implode(',', array_fill(0, count($columnNameList), '?'))
. ')';
$rows = implode(',', array_fill(0, $rowCount, $rowPrototype));
$updates = [];
foreach ($columnNameList as $column) {
$updates[] = '"' . $column . '"=VALUES("' . $column . '")';
}
$updates = implode(',', $updates);
$sql = sprintf(
'INSERT INTO "%1$s"."%2$s%3$s" ("%4$s") VALUES %5$s ON DUPLICATE KEY UPDATE %6$s',
$this->databaseName,
$this->tablePrefix,
$tableName,
$columns,
$rows,
$updates
);
echo $sql;
return $sql;
}

[2014-09-12 12:37:41] yapeal.DEBUG: Started network retrieve for corp/CorporationSheet [] []
[2014-09-12 12:37:41] yapeal.DEBUG: Started XSD validating [] []
[2014-09-12 12:37:41] yapeal.DEBUG: Element 'allianceName': This element is not expected. Expected is one of ( factionName, taxRate ). [] []
[2014-09-12 12:37:41] yapeal.WARNING: The data retrieved from Eve API corp/CorporationSheet for 98067338 is invalid [] []

url http://www.turaagaq.de /url
allianceID 99003170 /allianceID
factionID 0 /factionID
allianceName GANOR INC. /allianceName
taxRate 2.5 /taxRate

Base way as an application programmer is to look at it is you have a database that just magically always has the most up to date data possible. You are right in that to make that happen you do need to have Yapeal running in a crontab which is outlined in one of the Wiki pages. I don't have direct instructions for Windows because you usually do it through the GUI which is much harder to explain without a lot of screen shots etc. Also each version of Windows is a little different and I'm not going to take the time to try figuring it out with each of them. Most people will use Yapeal on a Linux server anyway so I don't expect that to be much of a problem since they have crontab.

As to how often Yapeal should run in the background I'm always very clear about that. Yapeal should run every single minute to insure the lowest server load on both ends and the most up to date data. Yapeal internally manages which APIs are ready for refreshing from the Eve API servers and trying to second guess it on that just causes you more load and problems NOT less like everybody seems to think.

How to use Yapeal for things like site signup etc does take a little more work but not much as I made a utility class you can use to add the API key info into the right table which you can find in bin/UtilRegisterKey.php. After that or possibly before you can also use any of the API classes you'll find in lib/Database/*/ directories directly just like the main Yapeal class does or even just extend from it. You'll find it in lib/Yapeal.php. You can just ignore the AutoMagic() method or override it to do what you need. The code is the best documents you will ever find in any project on how something works so don't be afraid to poke around in it a little.

Just an additional hint for things like signups etc is to use the oneShot() method in the lib/Database/Account/APIKeyInfo class. It'll put the EVE API result info into the account database tables where you can check the mask and get the character and corp info you might need.

Hope this helps you get going or at least gives you some idea where to find out some more about some of the stuff. Remember the database is the interface everything else is just setup to make it work