mysql db - FUNCTION acquireuserpasswd does not exist

anyone knows whats wrong with db:

Code:

---

gdelivery::matrixpasswd query, user=test
GQueryPasswd:account is test , login ip is 1845101147
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION acquireuserpasswd does not exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232)
        at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1607)
        at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:4034)
        at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:709)
        at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:513)
        at com.mysql.jdbc.Connection.parseCallableStatement(Connection.java:4583)
        at com.mysql.jdbc.Connection.prepareCall(Connection.java:4657)
        at com.mysql.jdbc.Connection.prepareCall(Connection.java:4631)
        at application.procedure.handler.execute(handler.java:189)
        at com.goldhuman.account.storage.acquireIdPasswd(storage.java:419)
        at protocol.MatrixPasswd.Server(Unknown Source)
        at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
        at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
        at com.goldhuman.Common.ThreadPool.run(Unknown Source)
        at java.lang.Thread.run(Thread.java:619)
acquireIdPasswd exception:account=test
gauthd: 22 Jul 2010 17:48:59,965  INFO GAuthServer:? - GQueryPasswd:can not find user test

---

how to fix this?

thx
Hendrik

check with php adminer if your mysql pw-db hold the correct procedures: acquireuserpasswd

I haven't found a way to fix the procedures, do you have any idea how to?
In an existing db.


thx
Hendrik

did u check table.xml?

shure. Server was working fine, just changed mysql hosting company.
And after the reimport of the database I know got this damn error.

did you try reupload your backup database. i have moved my server to. and problem something like this. but its solved. forget how to solved this.

it's obviously just a little mistake, but I realy can't find the damn problem:<:

i hope I can solve it quick:):


Hendrik

---------- Post added at 05:36 PM ---------- Previous post was at 05:23 PM ----------

Can someone pls gimme an emty db to do some tests?

thanks
Hendrik

i remember now. upload blank sql first. after this. upload your sql backup. :mellow:

Thanks for the blank db. I'm gonna try to fix it.

---------- Post added at 06:03 PM ---------- Previous post was at 05:58 PM ----------

got it fixed!

BIG thanks to you Vixio!!

Hendrik