Just overwritten my forum version with the original 3.4.06. Executed the setup.asp. After adding a topic, the topic count remain unchanged. It still wont work. I'll use my modified version.
Have you installed your forum directlyin mysql or have you migrated the db from access? I have had one of our users with the same problem, depending on default values set in members and forum tables.. Setting the right values solved the problem...
I've migrated the DB from access using the "Aruba" method (like the one you've linked) But I've not changed 0 to nulls. Maybe I should read your link "Acces - MySql Migration Tutorial" but I've no problems now. I've fixed the function.
Yes migration strategy that is on aruba vademecum lead to a db with default values and indexes wrong, I am suprise that your search function works properly.. in a lot of forum with this problem it never end catching a server timeout error...
If I can give my two cents.. create a new db with the setup of the forum, add the tables of your mods, empty this db and import in it the data of your old db... but this is only my opinion...
Yes migration strategy that is on aruba vademecum lead to a db with default values and indexes wrong, I am suprise that your search function works properly.. in a lot of forum with this problem it never end catching a server timeout error...
If I can give my two cents.. create a new db with the setup of the forum, add the tables of your mods, empty this db and import in it the data of your old db... but this is only my opinion...
Yes that is correct, but... you cannot add multiple indexes as setup does.. i.e. in FORUM_FORUM you would have PRIMARY KEY (`CAT_ID`,`FORUM_ID`), KEY `FORUM_FORUM_FORUM_ID` (`FORUM_ID`), KEY `FORUM_FORUM_CAT_ID` (`CAT_ID`) but this is not possible from phpmyadministrator
Topic Locked
Posted - 18 April 2007 : 09:08:21
