Database connection errors 2.0RC4

[roonekoos]

Hi all,

I have serious problems with my database connection.
Lot of times my forum take more than 5 minutes to load but the server is fast enough.
I uninstalled lot's of modules already but it seems like the forum get stuck every time when connecting to the database.
I have the problem serveral times an hour.
I checked the database tables and this is what I got:

Problems with indexes of table `ronaldruby_nlaeva_albums`
PRIMARY and INDEX keys should not both be set for column `id_album`
Problems with indexes of table `ronaldruby_nlarcade_rates`
PRIMARY and INDEX keys should not both be set for column `id_game`
Problems with indexes of table `ronaldruby_nlarcade_settings`
PRIMARY and INDEX keys should not both be set for column `id_member`
Problems with indexes of table `ronaldruby_nlmessages`
UNIQUE and INDEX keys should not both be set for column `id_topic`
More than one INDEX key was created for column `id_topic`
UNIQUE and INDEX keys should not both be set for column `id_member`
More than one INDEX key was created for column `id_member`
Problems with indexes of table `ronaldruby_nltopics`
More than one INDEX key was created for column `id_board`

I am not so good in this so I really hope that somebody can help me.

Thanks in advance!

Ronald

[kat]

Hi, Ronald!

Have you been to Admin>Forum maintenance and "Repair errors"?

Maybe your CPanel>Databases and tried a repair, there?

[roonekoos]

Hi, Ronald!

Have you been to Admin>Forum maintenance and "Repair errors"?

Maybe your CPanel>Databases and tried a repair, there?

Hi,

I tried that but no errors found.
I got the message " congratulations no erros found"
I am confused

[kat]

What about the CPanel one?

[roonekoos]

What about the CPanel one?

If I click repair in the Cpanel the error messages keep coming back

[Joker™]

I'm not sure but you can try this

Administration Center » Forum Maintenance » Database » Optimize all tables

[roonekoos]

I'm not sure but you can try this

Administration Center » Forum Maintenance » Database » Optimize all tables

I tried that, I repaired through the forum maintainance and through the database but it seems that there are settings that are not correct somewhere.

[roonekoos]

In my error log I get tons of errors ending with this line:

body_below sub template - eval?)

I had cleared the log , went to a topic, went back to the error log and had 14 errors like this just by going to 1 topic.

[kat]

You need to clear the log, again, go to Admin>Server Settings>General and check "Disable evaluation of templates".

Then, the error-messages will show the REAL error, without that eval crap masking things.

[roonekoos]

I did that and it show that line 249 and 470 are not correct.

I added the file, I hope someone can look into it to see if data is corrupted.

back to top mod and greeting mod are not installed anymore, it points to that.

[kat]

What are the errors saying, now?

[roonekoos]

What are the errors saying, now?

Sorry for the late responce.

I had disabled the AVAL thing and looked at the errors, I had found the broken codes and removed it.
I had a lot of attacks by spam bots too and put all ip's (1300) in the .htacces file.

Now for the first time I am error free

Thanks for the support and taken the time to look at my problem.

Cheers!