Forums

My Theme causes MySql errors

Permalink 1 user found helpful
Hi!

Im total newbie to C5.
I made a theme yesterday and today I found theres something wrong. I couldnt log in, PhpMyAdmin gave me problems could not solve:

Problems with indexes of table `PageSearchIndex`
More than one FULLTEXT key was created for column `cName`
Problems with indexes of table `UserBannedIPs`
PRIMARY and INDEX keys should not both be set for column `ipFrom`
Problems with indexes of table `UserGroups`
PRIMARY and INDEX keys should not both be set for column `uID`

I got same in beginning but PhpMyAdmin corrected those. What is this about?

thank you for help.
 
ThemeGuru replied on at Permalink Reply
ThemeGuru
I don't think those have to do with creating a theme. You might want to try and reinstall c5 and make sure all the files are uploaded properly.

hmm...
foolevil replied on at Permalink Reply
Correct, they where not. I got them also after fresh install. Site seems to run ok, sometimes gets slow. After refreshing database it seems to go better.