Uutiset:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu
Advertisement:

table warnig?

Aloittaja joneq, toukokuu 30, 2006, 09:20:23 IP

« edellinen - seuraava »

joneq

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 [nofollow]

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

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


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

Thanks for any help.


Oldiesmann

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).
Michael Eshom
Christian Metal Fans

joneq

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.

Oldiesmann

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.
Michael Eshom
Christian Metal Fans

Advertisement: