Page 1 of 1

Unknown column 'color_claim'

Posted: 22 Jul 2018, 19:55
by Danedeath
Hi there,

I am using my own webserver to run the livemap script. I am using TTmod 1.2 and the map version 2.6.2. Up until last night the script was working fine. I looked into the issue and the script was having difficulties connecting to the SQL server and is now acting like a brand new map. I increased the max_allowed_packet to see if this would stop this issue from occurring in the future. Hopefully, that helps. So now that I can get a connection between the server and the livemap it seems like it is trying to setup like a new livemap install (see error below). To fix this do I need to remove the tables with nyu?

Here is a link to my map https://old-guys-gaming.com/forum/map

The only edits I've done to the livemap are adding command descriptors to the rcon page for my admins to restart the server.

PS: I've tried using 2.6.3 with the same result.
PHP Fatal error: Uncaught Exception: A MySQL query failed!\nError 1054: Unknown column 'color_claim' in 'nyu_livemap' in .../map/includes/mysql.class.php:225\nStack trace:\n#0 .../map/includes/mysql.class.php(111): MySQL->handle_error('query', 'ALTER TABLE `ny...')\n#1 .../map/includes/updater.php(90): MySQL->query('ALTER TABLE `ny...')\n#2 /var/www/html/forum/map/index.php(59): require_once('/var/www/html/f...')\n#3 {main}\n thrown in /var/www/html/forum/map/includes/mysql.class.php on line 225, referer: https://old-guys-gaming.com/forum/

Re: Unknown column 'color_claim'

Posted: 22 Jul 2018, 23:07
by Nyuton
Hi,
you can try to delete all livemap tables from the DB to force a clean reinstallation.
This would be:
nyu_livemap
nyu_livemap_groups
nyu_livemap_log
nyu_livemap_sessions

See if that fixes the issue.

Don't delete all tables with nyu_ prefix since some of them belong to FeudalTools like nyu_custom_map and some belong to TTmod if you are using that.

Re: Unknown column 'color_claim'

Posted: 23 Jul 2018, 00:47
by Danedeath
Cool, that solved it. Thanks