Character Creation Error
Hey guys! I recently got my internet connection back and figured I'd come and see how NetGore is doing, I've been reading the forums and am Really excited to dig in and see what I can break!
I decided to go ahead and download the latest revision from the SVN today
The compile went smooth.
I opened up the server, it loaded smoothly
I opened up the client and made a new account. No problems yet
Attempted to make a new character and :
MySql.Data.MySqlClient.MySqlException was unhandled Message=The user specified as a definer ('root'@'%') does not exist Source=MySql.Data ErrorCode=-2147467259 Number=1449 StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.FetchDataRow(Int32 statementId, Int32 columns) at MySql.Data.MySqlClient.Driver.FetchDataRow(Int32 statementId, Int32 columns) at MySql.Data.MySqlClient.ResultSet.GetNextRow() at MySql.Data.MySqlClient.ResultSet..ctor(Driver d, Int32 statementId, Int32 numCols) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at NetGore.Db.DbQueryReader`1.NetGore.Db.IDbQueryReader<T>.ExecuteReader(T item) in C:\Netgore\NetGore\NetGore.Db\Query\DbQueryReader.cs:line 144 at NetGore.Db.DbQueryReader`1.ExecuteReader(T item) in C:\Netgore\NetGore\NetGore.Db\Query\DbQueryReader.cs:line 97 at DemoGame.Server.Queries.CreateUserOnAccountQuery.TryExecute(String accountName, CharacterID characterID, String userName, String& errorMsg) in C:\Netgore\NetGore\DemoGame.Server\Queries\Account\CreateUserOnAccountQuery.cs:line 70 at DemoGame.Server.UserAccountManager.TryAddCharacter(String accountName, String characterName, CharacterID characterID, String& errorMsg) in C:\Netgore\NetGore\DemoGame.Server\Account\UserAccountManager.cs:line 229 at DemoGame.Server.UserAccountManager.TryAddCharacter(String accountName, String characterName, String& errorMsg) in C:\Netgore\NetGore\DemoGame.Server\Account\UserAccountManager.cs:line 209 at DemoGame.Server.Server.CreateAccountCharacter(IIPSocket conn, String name) in C:\Netgore\NetGore\DemoGame.Server\Server.cs:line 210 at DemoGame.Server.ServerPacketHandler.RecvCreateNewAccountCharacter(IIPSocket conn, BitStream r) in C:\Netgore\NetGore\DemoGame.Server\Networking\ServerPacketHandler.cs:line 407 at NetGore.Network.MessageProcessorManager.InvokeProcessor(IIPSocket socket, IMessageProcessor processor, BitStream reader) in C:\Netgore\NetGore\NetGore\Network\MessageProcessor\MessageProcessorManager.cs:line 157 at NetGore.Network.StatMessageProcessorManager.InvokeProcessor(IIPSocket socket, IMessageProcessor processor, BitStream reader) in C:\Netgore\NetGore\NetGore\Network\MessageProcessor\Stats\StatMessageProcessorManager.cs:line 45 at NetGore.Network.MessageProcessorManager.Process(IIPSocket socket, BitStream data) in C:\Netgore\NetGore\NetGore\Network\MessageProcessor\MessageProcessorManager.cs:line 288 at DemoGame.Server.ServerSockets.OnReceiveData(IIPSocket sender, BitStream data) in C:\Netgore\NetGore\DemoGame.Server\Networking\ServerSockets.cs:line 90 at NetGore.Network.ServerSocketManager.Heartbeat() in C:\Netgore\NetGore\NetGore\Network\Sockets\SocketManager\ServerSocketManager.cs:line 231 at DemoGame.Server.Server.GameLoop() in C:\Netgore\NetGore\DemoGame.Server\Server.cs:line 296 at DemoGame.Server.Server.Start() in C:\Netgore\NetGore\DemoGame.Server\Server.cs:line 557 at DemoGame.Server.UI.frmMain.ServerThread() in C:\Netgore\NetGore\DemoGame.Server\UI\WinForms\frmMain.cs:line 290 at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() InnerException:
I've made sure that my database was updated with the most recent dump.
I'm running the server on Windows 7 64 bit
Running mysql-essential-5.1.52-winx64
Also having the same error on the Version 0.3.2 Release
in the middle of writing this post I looked at the SVN log and realized that quite a few updates have been made in the past hour or two. I will go ahead and update to them but will still post this in case you don't know about it yet.
Edit: Just upgraded to MySql Server 5.5 64bit and apparently the sql dumps syntax isn't compatible with this version of MySQL
As usual! Always on top of things 
After looking at the SVN log i suspected that this might be the case, ty for the speedy response. I'll check back in a little later 
No sweat. I should be able to get to it within 24 hours, depending on how much school work I have tomorrow.
Alright, just tested things out and its working fine. I probably should have actually read the error message in the first place. 
What version of MySQL are you using? It seems there is sometimes issues with having the Definer as "root@%". Some of the stored functions use "root@localhost" since that seems to work better (even though it forces you to use localhost, which isn't much of a problem), but I often forget to change it to that when I create new stored functions.
Edit: Updated my local settings so that it will now automatically use root@localhost, so this shouldn't happen again. I'll make a commit with a database dump update in a sec.
I'm in the middle of working on a large amount of changes, so things may not be too stable. Though I will be sure to check this out when I'm done. Thanks for reporting it.