Originally by: Harbngr

---

Ok;

I downgraded PHP from 5 to PHP 4. and everything works as it should. So I'm not sure if you have tested this on PHP5 yet or not but there might need to be some tweaking.

But otherwise great work guys.

---

Originally by: Esaam DeVries

---

Originally by: Harbngr

---

Ok;

I downgraded PHP from 5 to PHP 4. and everything works as it should. So I'm not sure if you have tested this on PHP5 yet or not but there might need to be some tweaking.

But otherwise great work guys.

---

I'm using php 5 on apache 2.2 and mysql 5 so it should work. Maybe something in your php.ini

---

Originally by: Celedor

---

Here's a little something for you to do ;)

In the revision 48, the install.php script line 51 states to create a field corp_ticker in the user table. This field is not accounted for in the process of registering a user, and thus trying to register a user fails with the message that column count is not correct for the insert statement.

To amend this I just deleted the line that creates the corp ticker field, since it doesn't seem very likely that it's intended to be used anyways.

---

Originally by: franny

---

the current viewpos generates an error

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/mywebspaceurlhere/postracker/viewpos.php on line 53

it still displays fine as far as I could tell, but gets the error

---

Quote:

---

Error

SQL query:

CREATE TABLE IF NOT EXISTS `npc_hanger` (
`corp` varchar( 255 ) NOT NULL ,
`system` varchar( 255 ) NOT NULL ,
`isotope` int( 10 ) unsigned NOT NULL ,
`oxygen` int( 10 ) unsigned NOT NULL ,
`mechanical_parts` int( 10 ) unsigned NOT NULL ,
`coolant` int( 10 ) unsigned NOT NULL ,
`robotics` int( 10 ) unsigned NOT NULL ,
`uranium` int( 10 ) unsigned NOT NULL ,
`ozone` int( 10 ) unsigned NOT NULL ,
`heavy_water` int( 10 ) unsigned NOT NULL ,
`strontium` int( 10 ) unsigned NOT NULL ,
`charters` int( 10 ) unsigned NOT NULL ,
PRIMARY KEY ( `corp` , `system` )
)

MySQL said: Documentation
#1071 - Specified key was too long. Max key length is 500

---

Originally by: Johnathan Roark

---

Edited by: Johnathan Roark on 03/09/2006 16:32:44
When I try to run the install script, nothing happens even though it says tables created successfully.

When i install sql manually through phpmyadmin i get the following error

Quote:

---

Error

SQL query:

CREATE TABLE IF NOT EXISTS `npc_hanger` (
`corp` varchar( 255 ) NOT NULL ,
`system` varchar( 255 ) NOT NULL ,
`isotope` int( 10 ) unsigned NOT NULL ,
`oxygen` int( 10 ) unsigned NOT NULL ,
`mechanical_parts` int( 10 ) unsigned NOT NULL ,
`coolant` int( 10 ) unsigned NOT NULL ,
`robotics` int( 10 ) unsigned NOT NULL ,
`uranium` int( 10 ) unsigned NOT NULL ,
`ozone` int( 10 ) unsigned NOT NULL ,
`heavy_water` int( 10 ) unsigned NOT NULL ,
`strontium` int( 10 ) unsigned NOT NULL ,
`charters` int( 10 ) unsigned NOT NULL ,
PRIMARY KEY ( `corp` , `system` )
)

MySQL said: Documentation
#1071 - Specified key was too long. Max key length is 500

---

I changed the corp and system length to 250 and it works fine.

Also, when I go to use the app, im getting division by zero errors. I changed the actuall path that it outputs to PATH.

Quote:

---

Warning: Division by zero in PATH/postracker/functions.php on line 72

Warning: Division by zero in PATH/postracker/functions.php on line 73

Warning: Division by zero in PATH/postracker/functions.php on line 74

Warning: Division by zero in PATH/postracker/functions.php on line 75

Warning: Division by zero in PATH/postracker/functions.php on line 76

Warning: Division by zero in PATH/postracker/functions.php on line 77

Warning: Division by zero in PATH/postracker/functions.php on line 83

---

also, on my host, it doesn't appear to be redirecting poperly? My hosting is complaining that im using IP rather than domain.

Thanks, this tool is really helpful for us.

---

Originally by: Johnathan Roark

---

Server stats:
PHP5 (more info) 5.1.6 -
MySQL 4.0.27 -

the redirect errors are occuring on anything that uses either user-transaction.php and pos-transaction.php. Maybe something wrong with redirect.php?

---

Originally by: old redirect

---

<?php
function redirect($url) {
if (!headers_sent()) {
header('Location: http://hostname/postrackerpath/' . $url);
} else {
die('Could not redirect; Headers already sent.');
}
}
?>

---

Originally by: franny

---

Originally by: Johnathan Roark

---

Server stats:
PHP5 (more info) 5.1.6 -
MySQL 4.0.27 -

the redirect errors are occuring on anything that uses either user-transaction.php and pos-transaction.php. Maybe something wrong with redirect.php?

---

you have the pos tracker files in a sub directory /postracker ?
the new(current) redirect file gave me errors when I had it in a base lvl directory
to clearify, I had my POStracker files in 'http://hostname/' it gave errors with the current redirect, I moved it to /postracker and it works fine

you could always try the old redirect file
the old redirect file looked like

Originally by: old redirect

---

<?php
function redirect($url) {
if (!headers_sent()) {
header('Location: http://hostname/postrackerpath/' . $url);
} else {
die('Could not redirect; Headers already sent.');
}
}
?>

---

---