|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |

Slayerman
Caldari Freedom-Technologies
|
Posted - 2008.09.09 07:25:00 -
[1]
Hey guys,
I noticed an issue with the API download, a corp that use my tracker have an anchored offline pos.
When it tried to get the info from the api, as there were no rows for fuel, i was getting an SQL error when trying it tried to add, as $fuel['isotopes'] was not being set.
I got around this by altering the code slightly to check if the $isotopes var is null, if it was set $isotopes=0; this then worked fine.
Maybe it needs a check on the API section to check the <state> of the pos for anchored, offline, and online before it tries to add the POS.
I have also noticed a lot of the SQL statements are using 'NULL' as values, on strict SQL this is trying to set it as a string, when usually it is an INT, remove the '' from all the NULL's and again, fixed a lot of the errors i was getting.
Hope this is of some help.
Thanks. ---------
--------- CEO - Freedom-Technolgies |

Slayerman
Caldari Freedom-Technologies
|
Posted - 2008.09.09 10:00:00 -
[2]
Edited by: Slayerman on 09/09/2008 10:02:24
Quote: ERROR Failed to Add tower info ; Incorrect integer value: '' for column 'isotope' at row 1
The error is above, changes were made as above post in the posdetail function.
I added
Quote: if (is_null($isotope)) { $fuel["isotope"] = 0; } else { $fuel["isotope"] = $isotope; } if (is_null($oxygen)) { $fuel["oxygen"] = 0; } else { $fuel["oxygen"] = $oxygen; }
if (is_null($mechanical_parts)) { $fuel["mechanical_parts"] = 0; } else { $fuel["mechanical_parts"] = $mechanical_parts; } if (is_null($coolant)) { $fuel["coolant"] = 0; } else { $fuel["coolant"] = $coolant; } if (is_null($robotics)) { $fuel["robotics"] = 0; } else { $fuel["robotics"] = $robotics; } if (is_null($heavy_water)) { $fuel["heavy_water"] = 0; } else { $fuel["heavy_water"] = $heavy_water; } if (is_null($uranium)) { $fuel["uranium"] = 0; } else { $fuel["uranium"] = $uranium; } if (is_null($strontium)) { $fuel["strontium"] = 0; } else { $fuel["strontium"] = $strontium; } if (is_null($ozone)) { $fuel["ozone"] = 0; } else { $fuel["ozone"] = $ozone; } if (is_null($heavy_water)) { $fuel["heavy_water"] = 0; } else { $fuel["heavy_water"] = $heavy_water; } $fuel["charters"] = 0;
above return $fuel;
and this appears to work ---------
--------- CEO - Freedom-Technolgies |

Slayerman
Caldari Freedom-Technologies
|
Posted - 2008.09.16 13:06:00 -
[3]
Edited by: Slayerman on 16/09/2008 13:13:58 Hello again,
Another issue, if a tower is anchored (has no fuel and offline) I am still getting an e-mail.
This tower is purposely offline, and is set for future expansion if needed.
Would it be possible to have a flag to turn OFF e-mail alerts for a specific tower, on the request of the owner?
I am also getting all POS's viewable by people NOT in the owner corp.... weird one. ---------
--------- CEO - Freedom-Technolgies |

Slayerman
Caldari Freedom-Technologies
|
Posted - 2008.09.29 07:55:00 -
[4]
Are Charters built in to this release? Cant see them on the track screen? ---------
--------- CEO - Freedom-Technolgies |

Slayerman
Caldari Freedom-Technologies
|
Posted - 2008.09.30 10:09:00 -
[5]
Originally by: Johnathan Roark
Originally by: Slayerman Are Charters built in to this release? Cant see them on the track screen?
Yes, they are. Individual fuel types are never listed on the track page and never will be. It accounts for charters when it is calculating the lowest fuel type. You can see a detailed status of each fuel type on the viewpos page.
Apologies, I meant on the View POS page... ---------
--------- CEO - Freedom-Technolgies |

Slayerman
Caldari Freedom-Technologies
|
Posted - 2008.09.30 10:38:00 -
[6]
Yup, That fixed it :)
Now, when trying to delete a POS on my install i get
Originally by: 'Delete POS' Column 'eve_id' cannot be null: INSERT INTO pos2_update_log (id, eve_id, type_id, type, action, datetime) VALUES (NULL, NULL, '7', '1', 'Delete POS', '1222770997')
(Remember my SQL is in strict mode, and host will not change it) ---------
--------- CEO - Freedom-Technolgies |

Slayerman
Caldari Freedom-Technologies
|
Posted - 2008.10.01 08:00:00 -
[7]
Originally by: Johnathan Roark *SNIP*
Nope, your tower_info table should have a outpost_id and not a outpost_name column. Did you run the update script or install a fresh copy?
Yes i ran the upgrade, however, when i try to run the query manually it errors.
SQL query:
ALTER TABLE `pos2_tower_info` CHANGE `outpost_name` `outpost_id` BIGINT( 20 ) NOT NULL DEFAULT '0'
MySQL said: Documentation #1366 - Incorrect integer value: 'None' for column 'outpost_id' at row 1
If would appear the values that are already there ('None' in this case) is preventing changing to 'BIGINT'.
UPDATE `%prefix%tower_info` set `outpost_name`='0'; ALTER TABLE `%prefix%tower_info` CHANGE `outpost_name` `outpost_id` BIGINT( 20 ) NOT NULL DEFAULT '0';
Used this on my install, and it changed it ok then.
|

Slayerman
Caldari Freedom-Technologies
|
Posted - 2008.10.09 12:08:00 -
[8]
Originally by: Tai Ken Fatal error: Call to undefined function curl_init() in /XXX/pos3/includes/class.pos.php on line 3436
This happens if I put in my API-Key or if I try to update any alliance/souv-data.
Any clue what that can be?
thx
Is the Curl Module installed on your webserver? Curl is used to download the XML from the Eve API.
|

Slayerman
Caldari Freedom-Technologies
|
Posted - 2008.10.10 08:50:00 -
[9]
Originally by: Tai Ken
Originally by: Slayerman Is the Curl Module installed on your webserver? Curl is used to download the XML from the Eve API.
Installscript says: CURL: No (Will use fopen)
So I assume it will use fopen instead. Or I'm wrong?
The install does show that, I've taken a quick look at the code, and there is only code there for cURL as far as i can see, no fopen.
I'm guessing the guys will change that template on the next release.
Can a Dev please confirm this |

Slayerman
Caldari Freedom-Technologies
|
Posted - 2008.10.16 11:59:00 -
[10]
Originally by: Trisy A I've got Pos-Tracker3.0beta3.zip Uzipped it on php site. Installed. Now I see thing like
============= - POS MANAGER -
| Home | Login | Register | About |
If you are using the in-game browser, you must click the "Login" button! =============
I've registered with my e-mail and created some new password in in-game browser. BTW php site I'm using does not allow e-mail send/receive. Do I need it?
All I managed to do is to see "Welcome <char name> in ingame browser. And same login screen.
What next? Or what exactly should I do to be able to use it?
When you installed the tracker, you should have created an Admin user, You need to log in using that.
In the Admin section, you should see the list of users, and be able to add access to the the user you have signed up with ..
Hope this helps
|
|

Slayerman
Caldari Freedom-Technologies
|
Posted - 2008.10.20 07:41:00 -
[11]
Originally by: Johnathan Roark POS-Tracker 3.0.0 Beta 4 released. This is mostly bug fixes and miner improvements.
Two important notes about upgrading: config.php has changed so if you have made any changes to it you will need to make them to the new version. There are no database changes in beta 3 to beta 4 so using upgrade.php is not needed.
Any chance you can start to release a no-image package if images are not updated to save download/upload time... yes i know i could just not upload them, but I'm damn lazy :)
|

Slayerman
Caldari Freedom-Technologies
|
Posted - 2009.01.09 11:43:00 -
[12]
Remember me??? im the guy with MySQL in strict mode.
So, I had a good time trying to get this installed....
First problem was No Default Value errors when trying to add the admin user
the fields were:
alliance_id away Highly_trusted
Edited the table to set these values to zero
The next issue was when trying to add a tower using the API key.
ERROR Failed to Add tower info ; Incorrect integer value: 'None' for column 'outpost_id' at row 1
a quick search/replace is class_pos.php replaceing 'NULL' (in quotes) for NULL (no quotes) quickly resolved this.
The changes ive made will have zero impact on anyone elses install, and i remember having to make these changes on each beta i tried to use before.
Can these changes be made to the core files?
I also had to run some of the SQL files from the upgrade as the main SQL install file has not been edited to reflect the new changes, on a fresh install you should not need to do this.
Thanks |
|
|
|