| Pages: 1 2 [3] 4 5 6 7 8 9 10 11 12 13 14 .. 14 :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Mestoth
Minmatar
Ars ex Discordia
GoonSwarm
   |
Posted - 2007.11.09 09:55:00 -
[61]
"Error at the line 3001: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
Query: pID`, `typeID`) VALUES (40003320, 'Maspah VI - 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 'pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14)' at line 1"
1stly: im a nublet with PHP and MYSQL. Im still not sure if i have this set up correctly :P
secondly: i got the same "ran out of room error" so went onto the bigdump.php
hence the above message. Im a bit confused and generally looking lost :P
oh, any chance you can create a nice "idiot proof" guide :) Installing PHP and MYSQL is easy, and doing the simple config stuff wasnt a prob. but im WAY outa my league right now :P
|
Vincent Liftor
|
Posted - 2007.11.09 19:31:00 -
[62]
I used the bigdump.php file to load the sql information but when I go to the install.php file to create the admin account, I am still getting the error: Fatal error: Out of memory (allocated 74186752) (tried to allocate 134 bytes)
Can you provide some guidance for how to get around this?
|
Johnathan Roark
Caldari
Quantum Industries
Interstellar Alcohol Conglomerate
|
Posted - 2007.11.09 20:17:00 -
[63]
 Originally by: Mestoth
"Error at the line 3001: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
Query: pID`, `typeID`) VALUES (40003320, 'Maspah VI - 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 'pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14)' at line 1"
1stly: im a nublet with PHP and MYSQL. Im still not sure if i have this set up correctly :P
secondly: i got the same "ran out of room error" so went onto the bigdump.php
hence the above message. Im a bit confused and generally looking lost :P
oh, any chance you can create a nice "idiot proof" guide :) Installing PHP and MYSQL is easy, and doing the simple config stuff wasnt a prob. but im WAY outa my league right now :P
My guess is your running into a actual size issue with your host? I'd check with your host about size restrictions on your database.
There is no way i can make an idiot proof guide. Each host is different and someone will find some way to mess it up. The install scripts are the closest we can come to that.
Originally by: Vincent Liftor
I used the bigdump.php file to load the sql information but when I go to the install.php file to create the admin account, I am still getting the error: Fatal error: Out of memory (allocated 74186752) (tried to allocate 134 bytes)
Can you provide some guidance for how to get around this?
your running the wrong install file, if you run bigdump.php, you need to run install2.php (notice the '2' in the name) which should be linked from bigdump.php.
Corporation Management Improvement |
Vincent Liftor
|
Posted - 2007.11.09 20:33:00 -
[64]
There's the problem. Line 707 of bigdump.php links to install.php instead of install2.php. Thanks for the quick reply.
|
Vincent Liftor
|
Posted - 2007.11.10 08:01:00 -
[65]
Another quick question, once a tower has been added to the tracker, how can you add a tower name if none was entered at creation? There doesn't seem to be an edit field for the tower name or really any other way to change this information currently.
Thanks!
|
Lillis85
Gallente
Dark Matter Coalition
|
Posted - 2007.11.10 14:33:00 -
[66]
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?
|
Johnathan Roark
Caldari
Quantum Industries
Interstellar Alcohol Conglomerate
|
Posted - 2007.11.10 16:20:00 -
[67]
Originally by: Vincent Liftor
Another quick question, once a tower has been added to the tracker, how can you add a tower name if none was entered at creation? There doesn't seem to be an edit field for the tower name or really any other way to change this information currently.
Thanks!
Only current way is to manually edit it in the database.
Originally by: Lillis85
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?
Honestly, I have no clue.
Corporation Management Improvement |
Shime
|
Posted - 2007.11.11 18:17:00 -
[68]
Hello,
Another question ; how work the "secret pos" system ??
Under sql i write 1 to secret pos, but the owner don"t see his own pos after ??
I do not want that all members can see all the pos position and status with the pos tracker.
|
Lillis85
Gallente
Dark Matter Coalition
|
Posted - 2007.11.11 21:16:00 -
[69]
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?
|
Johnathan Roark
Caldari
Quantum Industries
Interstellar Alcohol Conglomerate
|
Posted - 2007.11.11 23:04:00 -
[70]
Originally by: Shime
Hello,
Another question ; how work the "secret pos" system ??
Under sql i write 1 to secret pos, but the owner don"t see his own pos after ??
I do not want that all members can see all the pos position and status with the pos tracker.
the secret POS is related to highly trusted flag in the user table. This is an incomplete feature but It think is the only things that are missing is the toggle for highly trusted and secret pos.
Corporation Management Improvement |
|
|
Wipster
Righteous-Indignation
FREGE Alliance
|
Posted - 2007.11.13 21:25:00 -
[71]
Hey,
There seem to be alot of bug fixes in this thread and looking at the sourceforge release its a month old and the svn hasn't been touched in about the same, where abouts can I get my hands on an up to date copy or when would a new release be scheduled?
Great tool btw, I used an old version for a while, looking forward to the new functionality.
|
Johnathan Roark
Caldari
Quantum Industries
Interstellar Alcohol Conglomerate
|
Posted - 2007.11.14 06:57:00 -
[72]
Originally by: Wipster
Hey,
There seem to be alot of bug fixes in this thread and looking at the sourceforge release its a month old and the svn hasn't been touched in about the same, where abouts can I get my hands on an up to date copy or when would a new release be scheduled?
Great tool btw, I used an old version for a while, looking forward to the new functionality.
There really hasn't been many fixes since the last version. I think the SVN has a few more fixes. The only other bugs are small ones in the database, the code should be current as of reversion 95.
I have been considering changing the way it handles passwords. Currently it uses a method that is vulnerable to a rainbow attack, which is no big deal as long as no one gets a copy of your database. I would attempt to make it so you can stay with the current method if I did make this change. Upgrading would mean deleting all the users and asking everyone to re-register.
Corporation Management Improvement |
Xawen
|
Posted - 2007.11.14 14:39:00 -
[73]
Can someone post a simple howto for getting reactions set up on the page? I can't seem to get one to start calculating and show up on the POS View page.
Right now I'm just trying a simple reaction:
silo 0 (cadmium)
|
Reactor --- silo 2 (Caesarium Cadmide)
|
silo 1 (caesium)
First I set the reactor material to caesarium cadmide. Then I set silo 0 and 1 to the right material, then set them to input and assigned them to the reactor marked caesarium cadmide. Then, I set silo 2 to caesarium cadmide, output and assigned to the reactor. I gave silos 0 and 1 15000 units of material and assumed it would start computing the reaction, but nothing happened. I'm sure I'm missing something simple, but I can't figure out what.
Anyone know what I screwed up?
|
Elfishy
Gallente
|
Posted - 2007.11.17 17:58:00 -
[74]
when trying to update sov:
Fatal error: Call to undefined function curl_init() in /var/www/possy/updatesov.php on line 14
or when trying to update alliance list:
Fatal error: Call to undefined function curl_init() in /var/www/possy/updateallianceinfo.php on line 14
|
CaldFighter
|
Posted - 2007.11.17 20:44:00 -
[75]
anyone notice Liquid Ozone and Heavy water don't seem to calculate properly in outpost view?
Liquid Ozone says 55 but should be closer to 600
Heavy Water says 800 but should be closer to 450
Apart from that, we've had no problems.
|
Johnathan Roark
Caldari
Quantum Industries
Interstellar Alcohol Conglomerate
|
Posted - 2007.11.18 06:37:00 -
[76]
Originally by: Xawen
Can someone post a simple howto for getting reactions set up on the page? I can't seem to get one to start calculating and show up on the POS View page.
Right now I'm just trying a simple reaction:
silo 0 (cadmium)
|
Reactor --- silo 2 (Caesarium Cadmide)
|
silo 1 (caesium)
First I set the reactor material to caesarium cadmide. Then I set silo 0 and 1 to the right material, then set them to input and assigned them to the reactor marked caesarium cadmide. Then, I set silo 2 to caesarium cadmide, output and assigned to the reactor. I gave silos 0 and 1 15000 units of material and assumed it would start computing the reaction, but nothing happened. I'm sure I'm missing something simple, but I can't figure out what.
Anyone know what I screwed up?
Try updating the materail in silo 2. Also make sure silo 0 and 1 are set to input. Other than that, I can't tell much without seeing it.
Originally by: Elfishy
when trying to update sov:
Fatal error: Call to undefined function curl_init() in /var/www/possy/updatesov.php on line 14
or when trying to update alliance list:
Fatal error: Call to undefined function curl_init() in /var/www/possy/updateallianceinfo.php on line 14
My guess is your host has CURL disabled. That would mean you have 3 options: get them to enable it, switch host, bribe me/someone to convert it to fopen.
Try running the following code on your host:
<?php
$curl_version=curl_version();
echo "Your CURL Version: ".$curl_version['version']."<br>";
?>
Originally by: CaldFighter
anyone notice Liquid Ozone and Heavy water don't seem to calculate properly in outpost view?
Liquid Ozone says 55 but should be closer to 600
Heavy Water says 800 but should be closer to 450
Apart from that, we've had no problems.
Yea, thats one of the bugs that would be easier for Rx to look at as he wrote that part.
Corporation Management Improvement |
Elfishy
Gallente
|
Posted - 2007.11.18 12:42:00 -
[77]
Quote:
My guess is your host has CURL disabled. That would mean you have 3 options: get them to enable it, switch host, bribe me/someone to convert it to fopen.
your were right.. it wasn't installed, but its running on my own server so easy fix and now it works ... thx :)
|
Shime
|
Posted - 2007.11.24 01:39:00 -
[78]
Another error in database with true sansha medium tower
When u have the sov 1, we can see 5 oxygen,2 mechanical,35 hvy water,39 Liquid / hour.
Or in reality :
6,3,42,42
I found the error in sovereignty_static database, but don"t find where i can change the hvy water and LO.
(cause in this database there are ok)
|
Johnathan Roark
Caldari
Quantum Industries
Interstellar Alcohol Conglomerate
|
Posted - 2007.11.24 06:14:00 -
[79]
Edited by: Johnathan Roark on 24/11/2007 06:17:27
Originally by: Shime
Another error in database with true sansha medium tower
When u have the sov 1, we can see 5 oxygen,2 mechanical,35 hvy water,39 Liquid / hour.
Or in reality :
6,3,42,42
I found the error in sovereignty_static database, but don"t find where i can change the hvy water and LO.
(cause in this database there are ok)
I think your seeing a bug in EVE, not POS-Tracker. EVE starbase control pannel displays the max Liquid ozone and heavy water used per hour. POS-tracker calculates actual use based on the structures you tell it that you have online.
Corporation Management Improvement |
Wipster
Righteous-Indignation
FREGE Alliance
|
Posted - 2007.11.24 12:57:00 -
[80]
Hey,
I'm just setting up the tracker and I'm a bit stuck, we have a reactor going into a silo and then another reactor taking from that silo (because we produce more then we can second reaction) is there a way to let a silo be an input aswell as an output?
Wip
|
|
|
Johnathan Roark
Caldari
Quantum Industries
Interstellar Alcohol Conglomerate
|
Posted - 2007.11.24 18:52:00 -
[81]
Originally by: Wipster
Hey,
I'm just setting up the tracker and I'm a bit stuck, we have a reactor going into a silo and then another reactor taking from that silo (because we produce more then we can second reaction) is there a way to let a silo be an input aswell as an output?
Wip
No, sorry, the silo tracking is a simple solution and can't cover all the possibilities, just most of the more common setups.
With some miner modifications, you probably could trick it into giving the data you want.
Corporation Management Improvement |
Shime
|
Posted - 2007.11.29 03:02:00 -
[82]
Originally by: Johnathan Roark
Edited by: Johnathan Roark on 24/11/2007
I think your seeing a bug in EVE, not POS-Tracker. EVE starbase control pannel displays the max Liquid ozone and heavy water used per hour. POS-tracker calculates actual use based on the structures you tell it that you have online.
Can"t be that, i saw the problem because ive got somes differences enter the fuel into the tower and on the pos manager.
|
Johnathan Roark
Caldari
Quantum Industries
Interstellar Alcohol Conglomerate
|
Posted - 2007.11.29 07:02:00 -
[83]
Originally by: Shime
Originally by: Johnathan Roark
Edited by: Johnathan Roark on 24/11/2007
I think your seeing a bug in EVE, not POS-Tracker. EVE starbase control pannel displays the max Liquid ozone and heavy water used per hour. POS-tracker calculates actual use based on the structures you tell it that you have online.
Can"t be that, i saw the problem because ive got somes differences enter the fuel into the tower and on the pos manager.
Yea, your right. I am guessing a rounding error. Others may have the same issue.
This should fix that one:
UPDATE `sovereignty_static` SET `oxygen` = '6',
`mechanical_parts` = '3' WHERE `sovereignty_static`.`pos_race` =14 AND `sovereignty_static`.`pos_size` =2 AND `sovereignty_static`.`isotope` =127 AND `sovereignty_static`.`oxygen` =5 AND `sovereignty_static`.`mechanical_parts` =2 AND `sovereignty_static`.`coolant` =3 AND `sovereignty_static`.`robotics` =1 AND `sovereignty_static`.`uranium` =2 AND `sovereignty_static`.`ozone` =42 AND `sovereignty_static`.`heavy_water` =42 AND `sovereignty_static`.`strontium` =56 AND `sovereignty_static`.`capacity` =55000 AND `sovereignty_static`.`strontium_hanger` =25000 LIMIT 1 ;
Corporation Management Improvement |
Johnathan Roark
Caldari
Quantum Industries
Interstellar Alcohol Conglomerate
|
Posted - 2007.11.30 19:24:00 -
[84]
POS-Tracker's future:
To me, it seems most of the bugs have been worked out. Most of the remaining ones seem to be typos in the database exports.
I am now beginning to look toward a 2.1 version and I am wondering what everyone would like to see in it? Currently I am looking at the new starbase api features and how to add them into the tracker. This should be rather easy if we get moon location IDs. This may require some database changes, hopefully nothing too major. I have also been looking at making the install process a little better. The Secret POS/Highly Trusted needs finishing. We where also intending on adding a comment box for towers that we never go arround to coding. The field for this is already in the database.
Corporation Management Improvement |
Shime
|
Posted - 2007.11.30 20:40:00 -
[85]
perfectly work ! thks a lot.
In future addon-patch, can u create some a buttons, to order track.php by what we want. That will help when we have many tower.
Because, by default, this is order by Tower Name.
Thinks that will be more easy by owner or system name.
Great job anyways 
|
Johnathan Roark
Caldari
Quantum Industries
Interstellar Alcohol Conglomerate
|
Posted - 2007.11.30 20:50:00 -
[86]
Originally by: Shime
perfectly work ! thks a lot.
In future addon-patch, can u create some a buttons, to order track.php by what we want. That will help when we have many tower.
Because, by default, this is order by Tower Name.
Thinks that will be more easy by owner or system name.
Great job anyways
yea, that shouldn't be too hard to do. I'll probably change the default to system Name anyway. The Tower name is a relic from when it wasn't associated with a specific system.
Corporation Management Improvement |
CaldFighter
|
Posted - 2007.12.01 11:42:00 -
[87]
Can't think of much off the top of my head besides whats been mentioned previously. (Liquid Ozone/Heavy Water Calc in outpost).
Although i think classified pos's should be removed for users not classed as trusted in the pos's tracked list in outpost.
i'm sure i'll think of something else but it's early.
|
Braineater
Minmatar
BINFORD
Solidus Alliance
|
Posted - 2007.12.03 12:23:00 -
[88]
When adding silos/harvesters/reactors to a POS, both at creation and later on via edit, the corresponding row in silo_info/reactor_info always has it's pos_id set to 0. Is this a bug, or am I doing something wrong?
______
|
Ecid Q'Wulf
Caldari
Galactic Fighter Syndicate
Knights Of the Southerncross
|
Posted - 2007.12.04 05:00:00 -
[89]
I like your tool, great job done sofar.
What could be usefull for alliances, or a bunch of corps working together is multicorp-usability. where for example only Corp A sees all details of Corp B but A sees that B has at planet x moon y pos z.
Also some sort of moon database might be nice, where everyone who has access to it, is able to post new scans in it, and every user of teh tool is able to see em, probably even gets em as automatical choice when trying to set resources for the harvester.
________
A great man once said: "Rabble-Rabble" and "check my Corp-Ticker". Ive you come a across him, make sure to join his ranks (if your not german) |
Tiger Wolf
|
Posted - 2007.12.07 05:25:00 -
[90]
I just downloaded the current version and got it installed today. I got the pos put in the thing but for some reason the information that I put in the corp hanger array for fuel doesnt save. The only button I see to save it is the update fuel button above the hanger array area. I dont know if there is a button missing or something or what, but thought I would say something, maybe someone has a fix for me...
Thanks,
TW
|
|
|
|
|
| |
|
| Pages: 1 2 [3] 4 5 6 7 8 9 10 11 12 13 14 .. 14 :: one page |
| First page | Previous page | Next page | Last page |