I have just copied my DB and run altertable 6.0 - 6.1 and then 6.1 to 6.2 but am getting this error now:
SQL ERROR: Thu, Jan 02 2003 16:34:35 +0000 Database error only visible to forum administrators
I can login and use admin functions but as soon as I hit main index it logs me out and no forums are displayed.
my forum can be seen here:
http://forums.turbosport.co.ukThis is being logged in my log file:[ERROR][Thu, Jan 02 2003 16:24:39 +0000] [/ubbthreads.php] [62.24.242.20] Unable to do_query: SELECT U_FrontPage, U_Groups, U_TimeOffset,U_Display,U_Favorites,U_WhichForums,U_Categories,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number FROM w3t_Users WHERE U_Number = '3' - Unknown column 'U_WhichForums' in 'field list'
[ERROR][Thu, Jan 02 2003 16:24:39 +0000] [/ubbthreads.php] [62.24.242.20] Unable to do_query:
SELECT t1.Mod_Board,t1.Mod_Uid,t2.U_Username
FROM w3t_Moderators AS t1,
w3t_Users AS t2
WHERE t1.Mod_Uid = t2.U_Number
- Unknown column 't1.Mod_Uid' in 'field list'
[ERROR][Thu, Jan 02 2003 16:24:40 +0000] [/ubbthreads.php] [62.24.242.20] Unable to do_query:
SELECT DISTINCT Cat_Title,Cat_Number,Cat_Description
FROM w3t_Category
WHERE Cat_Type = 'forum'
ORDER BY Cat_Number
- Unknown column 'Cat_Type' in 'where clause'
[ERROR][Thu, Jan 02 2003 16:32:36 +0000] [/altertable-6.1-6.2.php] [62.24.242.20] Unable to do_query:
ALTER TABLE w3t_Boards
DROP Bo_Moderators
- Can't DROP 'Bo_Moderators'. Check that column/key exists
[ERROR][Thu, Jan 02 2003 16:32:36 +0000] [/altertable-6.1-6.2.php] [62.24.242.20] Unable to do_query:
ALTER TABLE w3t_Users
DROP U_Post_Format
- Can't DROP 'U_Post_Format'. Check that column/key exists
[ERROR][Thu, Jan 02 2003 16:32:43 +0000] [/altertable-6.1-6.2.php] [62.24.242.20] Unable to do_query:
ALTER TABLE w3t_Messages
DROP INDEX Messindx1
- Can't DROP 'Messindx1'. Check that column/key exists
[ERROR][Thu, Jan 02 2003 16:34:35 +0000] [/ubbthreads.php] [62.24.242.20] Unable to do_query: SELECT U_FrontPage, U_Groups, U_TimeOffset,U_Display,U_Favorites,U_WhichForums,U_Categories,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number FROM w3t_Users WHERE U_Number = '3' - Unknown column 'U_WhichForums' in 'field list'
[ERROR][Thu, Jan 02 2003 16:34:35 +0000] [/ubbthreads.php] [62.24.242.20] Unable to do_query:
SELECT t1.Mod_Board,t1.Mod_Uid,t2.U_Username
FROM w3t_Moderators AS t1,
w3t_Users AS t2
WHERE t1.Mod_Uid = t2.U_Number
- Unknown column 't1.Mod_Uid' in 'field list'
[ERROR][Thu, Jan 02 2003 16:34:35 +0000] [/ubbthreads.php] [62.24.242.20] Unable to do_query:
SELECT DISTINCT Cat_Title,Cat_Number,Cat_Description
FROM w3t_Category
WHERE Cat_Type = 'forum'
ORDER BY Cat_Number
- Unknown column 'Cat_Type' in 'where clause'