| Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Lillis85
Gallente
Dark Matter Coalition
   |
Posted - 2007.11.10 14:33:00 -
[1]
I'm having troubles importing the database using bigdump.
 Quote:
Error at the line 2001: SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) VALUES (40001884, 'Psasa III - Moon 15', 2, 8, 14);
Query: SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) VALUES (40001884, 'Psasa III - Moon 15', 2, 8, 14);
MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) V' at line 1
After trying to decrease the ammount of lines importing per cycle I get the same error but on another line. The error seems to appear on the second cycle every time, no matter how many lines I choose to import per cycle. I'm running everything on my local computer. What could be the cause of this?
|
Lillis85
Gallente
Dark Matter Coalition
|
Posted - 2007.11.11 21:16:00 -
[2]
I'm able to import the database with bigdump if I'm importing 2 lines per cycle. If I go to 5 it stops after the first cycle. This is really annoying. Anyone else having this problem?
|
Lillis85
Gallente
Dark Matter Coalition
|
Posted - 2007.12.31 11:25:00 -
[3]
I must say that this is a great tool! Very nice job to you guys! I have a problem though.
When I've added a POS with fuel and structures and then view it, it tells me that the sov status is hostile. It also looks like the fuel requirements are somewhat off. Looks like the bonus from the sov lvl is not kicking in and I can't figure out why the sov status is set to hostile when it shouldn't. The fuel requirements are perfect for our POSes in systems without sov. What could be the cause of this? I'm using the 2.0.94 version.
Thanks
|
Lillis85
Gallente
Dark Matter Coalition
|
Posted - 2008.01.01 12:12:00 -
[4]
Originally by: Johnathan Roark
Originally by: Lillis85
I must say that this is a great tool! Very nice job to you guys! I have a problem though.
When I've added a POS with fuel and structures and then view it, it tells me that the sov status is hostile. It also looks like the fuel requirements are somewhat off. Looks like the bonus from the sov lvl is not kicking in and I can't figure out why the sov status is set to hostile when it shouldn't. The fuel requirements are perfect for our POSes in systems without sov. What could be the cause of this? I'm using the 2.0.94 version.
Thanks
Did you add the tower or are you viewing the tower with a character other than the corp that actually has the tower? This includes the admin account?
Ah yes, I was logged in as admin. Now it's friendly again, but the problem with slightly off fuel requirements are still there. The POS is in a capital constellation and the sov lvl displayed on the page is 5. It's a regular Large Gallente Tower. I have double checked the structures and which ones are offlined and onlined.
The fuels that seem to missmatch is oxygen, isotopes, liquid ozone, heavy water and strontium. Strontium is way off showing only half the required amount then it actually is. Shows 140 when it should be 300.
|
Lillis85
Gallente
Dark Matter Coalition
|
Posted - 2008.01.01 22:34:00 -
[5]
Ah ok, still very nice work mate. Keep it up. Looking forward for new versions. Will try out the 2.1.0
|
Lillis85
Task Force Zener
Atlas Alliance
|
Posted - 2008.04.20 07:42:00 -
[6]
This might allready have been pointed out, but I couldn't find Complex Simple reactor arrays in the modules list and had to add these myself. Just a heads up for future release.
|
Lillis85
Task Force Zener
Atlas Alliance
|
Posted - 2008.04.20 17:14:00 -
[7]
Nvm what I said, I saw that they just have other names.
|
Lillis85
Task Force Zener
Atlas Alliance
|
Posted - 2008.04.21 07:10:00 -
[8]
I'm getting this error messages sometimes when I run the cron job
Warning: SimpleXMLElement::__construct() [function.SimpleXMLElement---construct]: Entity: line 21: parser error : Extra content at the end of the document in cron_updatepos.php on line 192
Warning: SimpleXMLElement::__construct() [function.SimpleXMLElement---construct]: </eveapi><html> in cron_updatepos.php on line 192
Warning: SimpleXMLElement::__construct() [function.SimpleXMLElement---construct]: ^ in cron_updatepos.php on line 192
Not a valid xml stringCould not get tower_info; Lost connection to MySQL server during query
Sometimes it gets through without errors though. Any idea what the cause could be? I'm running PHP 5.2.5 with CURL, simpleXML and hash installed.
|
Lillis85
Task Force Zener
Atlas Alliance
|
Posted - 2008.04.23 07:30:00 -
[9]
Originally by: Jake Hunington
I've just setup a new hosted instance of the tracker and I keep getting "You do not have access, ask your CEO for access!
If your access has been set, please relog back in to the website!", when I try to login after registering. Is there something else, after going into the database and manually setting the access value to 3, that's needed to get this first user to login?
Thanks,
Jake
Login as user admin with the password you set when you installed the tracker, then go to the admin page and set the user roles there. |
Lillis85
Task Force Zener
Atlas Alliance
|
Posted - 2008.04.24 16:27:00 -
[10]
Originally by: Apocalytica Insomnia
I today (after more then enough struggle, cause my Server runs an too old version of PHP) installed the SVN-Version of the POS tracker (i believe its 2.1). It works great and so far i found no real bugs yet.
However i have a question about the following feature i found in the Admin-pannel:
"Install/Uninstall Regional Moons"
What does it do ? It links back to ./install/install3.php
With it you can install (import) the regions with their data like systems, constellations and moons into your database. Having the sql data divided like this will prevent problems when importing files larger than 2mb.
I'm having troubles when I run the POS API script. Most of the time it gets through like it should, but sometimes I loose connection to the database.
Could not get tower_info; Lost connection to MySQL server during query
Could this be because it takes to long to execute the script? Sometimes I get other errors like I described here http://oldforums.eveonline.com/?a=topic&threadID=612970&page=11#324
Cheers
|
Lillis85
Task Force Zener
Atlas Alliance
|
Posted - 2008.04.27 12:24:00 -
[11]
I have a strange bug about optimal fuel levels on the editpos.php. The admin user can see the optimal levels with no problems, but other users sees the levels as 0 for all fuels for all our towers except faction towers. The towers we have are small and large gallente towers so I haven't been able to test this on amarr, minmatar or caldari towers though. Any idea why just the admin can see the optimal levels? I've been reading through the code but got stuck a bit.
|
Lillis85
Task Force Zener
Atlas Alliance
|
Posted - 2008.04.30 10:03:00 -
[12]
Anyone else having problems with the alert mails you should get? It looks like mail.php is an older version and needs to be changed to work with the new databas.
|
Lillis85
Task Force Zener
Atlas Alliance
|
Posted - 2008.05.15 12:14:00 -
[13]
What is the word on the low fuel warning mails the tracker should send out? I keep getting the error "No recipient addresses found in header" from the script. Have been trying to fix it, but can't see where the problem is. Any help please?
|
| |
|