Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Linux Servers

Archive::Linux Servers Archive area for Linux Servers's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-03-2004, 03:17 PM
Gangrif
Sarnak
 
Join Date: Oct 2003
Posts: 64
Default 0.5.2 database.CreateCharacter failed

Whenever i try to create a character on my server (0.5.2 on Linux) i get this in the logfile:
Code:
Name approval request for:Maleko race:1 class:14
Choice:4
[Error] Database: could not find start_zones entry in database. Using Defaults..
[Error] CreateCharacter query 'UPDATE character_ SET timelaston=0,guild=0, zonename='freportw', x=0.000000, y=0.000000, z=0.000000, profile=

(insert lots of 0's \'s and other such characters here)

WHERE account_id=2 AND name='Maleko'' #1054: Unknown column 'timelaston' in 'field list'
database.CreateCharacter failed
Got a bogus character (Maleko), deleting it.
PP length =0
and it rejects my character name.
I saw another thread about this, and it said that something wasnt supported by 0.5.2 that caused it, but there must be a way to fix it as i can see 0.5.2 servers up and running. Any suggestions?

Thanks.
Reply With Quote
  #2  
Old 01-04-2004, 02:28 AM
JerryChen
Fire Beetle
 
Join Date: Dec 2003
Posts: 2
Default

I have the same time question with eqemu for win32
Emu5.3Dr2
Database
mw_052_053_alpha2.zip
mw_052_053_alpha2_upgrade.zip
dumpeditems.sql.gz

But some char can be logon in, like agnostic...
Reply With Quote
  #3  
Old 01-04-2004, 04:37 AM
Muuss
Dragon
 
Join Date: May 2003
Posts: 539
Default

Code:
WHERE account_id=2 AND name='Maleko'' #1054: Unknown column 'timelaston' in 'field list'
well, the code tries to write datas to a table field that doesn't exists (timelaston), which causes the query to fail.
You could prolly fix that urself searching for that field into the sqle files you sourced. If you do this, you'll see where it is added or removed and will understand how to fix it
__________________
Muuss - [PEQGC] Dobl, the ogre that counts for 2 !
http://www.vilvert.fr/page.php?id=10
Reply With Quote
  #4  
Old 01-04-2004, 08:30 AM
Gangrif
Sarnak
 
Join Date: Oct 2003
Posts: 64
Default

I thought that was the key, but to be honest i know nothing about SQL. I may just re-build the database... i'm still new to SQL, so i may have done something wrong.

Thanks.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 09:39 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3