Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: joneq - toukokuu 30, 2006, 09:20:23 IP

Otsikko: table warnig?
Kirjoitti: joneq - toukokuu 30, 2006, 09:20:23 IP
I just installed smf 1.1rc2 and saw this in phpmyadmin. while checking tables

this is the warning at the bottom of the page after checking tables- all ok

http://i4.photobucket.com/albums/y105/joneq/ScreenHunter_093.gif

the next 2 are after selecting smf_messages and doing some clicking
----------------------------------------------------------------------------
http://i4.photobucket.com/albums/y105/joneq/ScreenHunter_091.gif

http://i4.photobucket.com/albums/y105/joneq/ScreenHunter_092.gif


How do i fix this if I even need to.Do I need to enter stuff into the last image or something.

Thanks for any help.

Otsikko: Re: table warnig?
Kirjoitti: Oldiesmann - toukokuu 31, 2006, 05:18:17 IP
You can ignore all those warnings - they're all from phpMyAdmin (not MySQL). The first two are due to attempts to detect incorrect usage of the index columns, such as duplicate indexes. Because ID_TOPIC is involved with two different indexes, phpMyAdmin is warning you about it, when in fact there is no problem because the two indexes are not duplicates (since one involves the ID_BOARD column as well).

The other one is more of a nuisance than anything. It's just there to remind you that you can't create a PRIMARY index on a column that isn't a primary key (which is true, but there are better ways to prevent this).
Otsikko: Re: table warnig?
Kirjoitti: joneq - toukokuu 31, 2006, 05:30:43 IP
Thanks Oldiesmann. I just deleted the whole thing. wasn't working right. I could not do too much from admin--like could not check for errors. something went wrong with the install I think

Could you tell me how many tables should be in the 1.1rc2 install. I had 41. Something seemed to be missing

I have 2 other forums  that I installed so I can install it, and this one seemed to go semi ok.

Thanks.
Otsikko: Re: table warnig?
Kirjoitti: Oldiesmann - toukokuu 31, 2006, 05:42:15 IP
There are 41 tables in 1.1 RC2. I'm not sure what could have caused your problems, but since you deleted it, try installing it again and see if you run into the same problems. It could be that some files didn't get uploaded properly.