EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)
-   -   Few problems on new install (https://www.eqemulator.org/forums/showthread.php?t=30510)

bostwick 02-05-2010 04:42 PM

Few problems on new install
 
Running with Ubuntu 9.10.

Server is up and running but with these errors. First one when it starts:

---------------------------------------------
14467 [02.03. - 15:41:46] Starting Log: logs/eqemu_error_zone.log
14467 [02.03. - 15:41:46] Unable to load titles: SELECT `id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`,$
---------------------------------------------
14478 [02.03. - 15:41:46] Starting Log: logs/eqemu_error_zone.log
14478 [02.03. - 15:41:46] Unable to load titles: SELECT `id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`,$
---------------------------------------------
14471 [02.03. - 15:41:46] Starting Log: logs/eqemu_error_zone.log
14471 [02.03. - 15:41:46] Unable to load titles: SELECT `id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`,$
---------------------------------------------
14473 [02.03. - 15:41:46] Starting Log: logs/eqemu_error_zone.log
14473 [02.03. - 15:41:46] Unable to load titles: SELECT `id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`,$
---------------------------------------------
14475 [02.03. - 15:41:46] Starting Log: logs/eqemu_error_zone.log
14475 [02.03. - 15:41:46] Unable to load titles: SELECT `id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`,$




And we get this when anyone logs in:

Error in CheckStatus query 'SELECT `status`, UNIX_TIMESTAMP(`suspendeduntil`) as `suspendeduntil`, UNIX_TIMESTAMP() as `current` FROM `account` WHERE `id` = 0' #1054: Unknown column 'suspendeduntil' in 'field list'




Also, this is the second time we've installed, last time we could lock the server and still log in with 250 access account. This time when it's locked we can't get in with 250 access. I'm not sure if I've just missed something somewhere but I can't see why that is.

Derision 02-05-2010 04:55 PM

Looks like you are running a version of the server that is not compatible with your database, in particular those errors suggest you need to source at least these database updates:

Code:

1057_titles.sql
1077_botgroups.sql
1136_spell_globals.sql
1195_account_suspendeduntil.sql

from http://code.google.com/p/projecteqem.../utils/sql/svn

There may be other SQL updates required, depending on how old your database is.


All times are GMT -4. The time now is 07:48 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.