sem_wait: invalid argument / corrupt DB

[RumorUS]

when I 'sh start' on tehdaroo's files on my root I get spam in my putty window like this:

sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument

...and so on


Also in my database when I try to repair tables I get this problem:



I previously had 2008 files running perfectly there and I removed that database and serverfiles from the root and put these new ones. The 2010 files work on Virtualbox but not on the root :S.

someone please help me out .

[ThinSmoke]

syserr?

[ThinSmoke]

from the core o_o

[RumorUS]

I deleted all logs and ran server, the problem seems to be in database only. The other folders did not generate a log at all.

/db/syserr

SYSERR: May 10 19:15:58 :: Start: TABLE_POSTFIX not configured use default
SYSERR: May 10 19:16:16 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: May 10 19:16:16 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: May 10 19:16:16 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: May 10 19:16:23 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

/db/syslog

[ThinSmoke]

May 10 19:16:27 :: --mysql_set_character_set(latin1)
May 10 19:16:39 :: AsyncSQL: closing mysql connection.

reinstall your database :/

[RumorUS]

Originally Posted by GothicCore

May 10 19:16:27 :: --mysql_set_character_set(latin1)
May 10 19:16:39 :: AsyncSQL: closing mysql connection.

reinstall your database :/

so rm -R /var/db/mysql then untar it again? ...and what about rights and ownership and all that?

[ThinSmoke]

rights chmod -R 777 /var/db/mysql and chown -R mysql /var/db/mysql

[RumorUS]

Originally Posted by GothicCore

rights chmod -R 777 /var/db/mysql and chown -R mysql /var/db/mysql

I have same problem as before