Error - insert entry in Quest-Table

A place to submit .patch fixes for the DOL SVN

Moderator: Developer Team

Error - insert entry in Quest-Table

Postby Urza » Sun Jul 04, 2010 12:37 pm

Hi,
i get this error message:
Code: Select all
[14:28:45,399] Error while adding data object Quest bcd981b0-0ca5-47fe-ae00-7e82
472cccec
MySql.Data.MySqlClient.MySqlException: Field 'CharName' doesn't have a default v
alue
   bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   bei MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int6
4& lastInsertId)
   bei MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
   bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavio
r)
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   bei DOL.Database.Connection.DataConnection.ExecuteNonQuery(String sqlcommand)

   bei DOL.Database.Handlers.MySQLObjectDatabase.AddObjectImpl(DataObject dataOb
ject)

What can i do?
greetings
Urza
User avatar
Urza
Developer
 
Posts: 671
Joined: Sun Jan 23, 2005 11:15 am
Website: http://www.juwesch.eu
Location: Germany/Delitzsch

Re: Error - insert entry in Quest-Table

Postby Etaew » Sun Jul 04, 2010 12:57 pm

You could edit the quest table to give the charname field a default value, whilst someone looks at why the error is generated
Retired DOL Enthusiast | Blog
User avatar
Etaew
Inactive Staff Member
 
Posts: 7602
Joined: Mon Oct 13, 2003 5:04 pm
Website: http://etaew.net
Location: England

Re: Error - insert entry in Quest-Table

Postby geshi » Sun Jul 04, 2010 1:14 pm

Hi, delete the CharName column :) I had this issue with tasks and it worked fine^^
geshi
Contributor
 
Posts: 1826
Joined: Tue Oct 21, 2008 9:16 pm

Re: Error - insert entry in Quest-Table

Postby Tolakram » Sun Jul 04, 2010 1:51 pm

CharName was removed a while back, replaced with CharacterID
- Mark
User avatar
Tolakram
Storm / Storm-D2 Admin
 
Posts: 9189
Joined: Tue Jun 13, 2006 1:49 am
Location: Kentucky, USA

Re: Error - insert entry in Quest-Table

Postby Urza » Mon Jul 05, 2010 6:19 am

Hi,
thanks to all.
CharName was removed a while back, replaced with CharacterID

Now it works.
greetings
Urza
User avatar
Urza
Developer
 
Posts: 671
Joined: Sun Jan 23, 2005 11:15 am
Website: http://www.juwesch.eu
Location: Germany/Delitzsch


Return to “%s” DOL Code Contributions

Who is online

Users browsing this forum: No registered users and 1 guest