I just upgraded from 6.3.2 to 6.4.1. I ran the altertable from 6.3 to 6.4, then altertable 6.4 to 6.4.1.
This latter altertable generated errors:
SQL ERROR: Sun, Jan 25 2004 06:27:15 -0600 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX board_topic_ndx
Can't DROP 'board_topic_ndx'. Check that column/key existsSQL ERROR: Sun, Jan 25 2004 06:27:15 -0600 Unable to do_query: ALTER TABLE w3t_Posts ADD INDEX board_topic_index (B_Board,B_Topic,B_Last_Post)
Duplicate key name 'board_topic_index'SQL ERROR: Sun, Jan 25 2004 06:27:15 -0600 Unable to do_query: UPDATE w3t_Version SET V_Version='6.4.1'
Table 'forums.w3t_Version' doesn't existSQL ERROR: Sun, Jan 25 2004 06:27:15 -0600 Unable to do_query: ALTER TABLE w3t_Users ADD U_ProfileHash VARCHAR(32)
Duplicate column name 'U_ProfileHash'Done
DB Error log in Threads admin panel has dozens of errors. Typical ones include:
Sun, Jan 25 2004 06:57:37 -0600 /forums/showthreaded.php 66.196.93.29
Unable to do_query: SELECT O_Type,O_Board,COUNT(*) FROM w3t_Online WHERE O_Board = 'UBB100' GROUP BY O_Type - Unknown column 'O_Board' in 'field list'
The error viewable by admin is:
QL ERROR: Sun, Jan 25 2004 07:34:12 -0600 Unable to do_query: REPLACE INTO w3t_Online (O_Username,O_Uid,O_Last,O_What,O_Board,O_Extra,O_Read,O_Type) VALUES ('little_joe','87','1075041252','all_admin','','','','r')
Unknown column 'O_Board' in 'field list'
Thanks for any help!