Anybody know whats wrong with this?

Page 1 of 2 1 2
11/17/2009 01:13 Arcо#1
Alright so I went through this LOTF Source I found here by Arcotemple.
Its a Cleaned up/Fixed up LOTF I guess.
I took out everything related to heavenlybless.
Meaning I went to Emme's HeavenBlessing release and worked backwards.
Now when I log into my char it says this on the console:
PHP Code:
MySql.Data.MySqlClient.MySqlException: Unknown column 'HeavenBless' in 'field list'
   at MySql.Data.MySqlClient.PacketReader.CheckForError()
   at MySql.Data.MySqlClient.PacketReader.ReadHeader()
   at MySql.Data.MySqlClient.PacketReader.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId)
   at MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst)
   at MySql.Data.MySqlClient.CommandResult..ctor(Driver d, Boolean isBinary)
   at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)
   at MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader)
   at MySql.Data.MySqlClient.MySqlCommand.Consume()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at COServer_Project.DataBase.SaveHB(Character Charr) in C:\Documents and Settings\Coco\My Documents\Good\LOFT Source\Source\COServerProject\DataBase.cs:line 1163 
ANybody know what's wrong?
11/17/2009 01:14 MexicanoCoder#2
What source lol?p
11/17/2009 01:21 Arcо#3
Quote:
Originally Posted by MexicanoCoder View Post
What source lol?p
I already stated that at the beginning of my post.
11/17/2009 01:26 MexicanoCoder#4
Quote:
Originally Posted by Tiku View Post
I already stated that at the beginning of my post.


Quote:
SourceSourceCOServerProjectDataBase.cs:line 1163
Go to the line and check the problem -.-

And then show me the line
11/17/2009 01:29 Arcо#5
Quote:
Originally Posted by MexicanoCoder View Post


Go to the line and check the problem -.-

And then show me the line

You really think I'm that stupid?
I went to the line and that didn't help one bit.
But if you really want that line then here.
PHP Code:
Charr.PackSkills(); 
11/17/2009 01:59 Zion~#6
Quote:
Originally Posted by Tiku View Post

You really think I'm that stupid?
I went to the line and that didn't help one bit.
But if you really want that line then here.
PHP Code:
Charr.PackSkills(); 
Then find Character PackSkills...
11/17/2009 02:20 Arcо#7
Quote:
Originally Posted by Zion~ View Post
Then find Character PackSkills...

You guys act like I'm incapable of checking the obvious.
I already did that.
11/17/2009 09:34 Korvacs#8
Ok, the most important part of your exception is this line:

Quote:
Unknown column 'HeavenBless'
Based entirely on this line you should be able to work out that the database is either missing this column entirely, or its spelt differently, confirm that the Character database in the source contains this column.
11/17/2009 11:29 UnoAmigos#9
Delete HeavenBlessing in Database.cs or add Column in MySQL Database....

Thats the only choice....Press *Thanks if i help you :D
11/17/2009 11:50 gad-legion#10
check the name for heavenblessing in data base then in sql table it must be the same, im pretty sure thats what ur error saying, or u missing it so u need to add it, ill team view u if u need help
11/17/2009 12:31 Arcо#11
Quote:
Originally Posted by Korvacs View Post
Ok, the most important part of your exception is this line:



Based entirely on this line you should be able to work out that the database is either missing this column entirely, or its spelt differently, confirm that the Character database in the source contains this column.
Yeah I went through MySQL and my ENTIRE Source and cannot find anything related to heavenbless. So I have no clue what's wrong.
11/17/2009 13:07 Korvacs#12
Check that the Character table itself in MySQL contains the column.
11/17/2009 22:41 .Guru#13
its not in your database
11/18/2009 18:00 Basser#14
Go to your MySQL DataBase and at the source find out which table it is trying to delete or modify. Its a simple problem, either the table isn't added, or it's wrong. For example it may be an uint instead of an int, or you might have miss-spelled it.
11/18/2009 22:40 #*=DarkAngeL=*##15
There is some replaces in his code?
Then you maybe need the old codes.
Page 1 of 2 1 2