Re: Messages scrambled/Consistency check error [message #25635 is a reply to message #25634] |
Wed, 15 June 2005 21:39 |
keneisman
Messages: 68 Registered: May 2005
Karma:
|
Member |
|
|
Here is the result of show create table GEMSForum_thread_view:
+-----------------------+-------------------------------------------------- --------------------------------------------------------------------------- --------------------------------------------------------------------------- --------------------------------------------------------------------------- --------------------
--------------------------------------------------------------------------- ---+
| Table | Create Table
|
+-----------------------+-------------------------------------------------- -----
--------------------------------------------------------------------------- -----
--------------------------------------------------------------------------- -----
--------------------------------------------------------------------------- -----
--------------------------------------------------------------------------- ---+
| GEMSForum_thread_view | CREATE TABLE `gemsforum_thread_view` (
`forum_id` int(11) NOT NULL default '0',
`page` int(11) NOT NULL default '0',
`thread_id` int(11) NOT NULL default '0',
`pos` int(11) NOT NULL default '0',
UNIQUE KEY `GEMSForum_thread_view_i_fps` (`forum_id`,`page`,`pos`),
KEY `GEMSForum_thread_view_i_ft` (`forum_id`,`thread_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-----------------------+-------------------------------------------------- -----
--------------------------------------------------------------------------- -----
--------------------------------------------------------------------------- -----
--------------------------------------------------------------------------- -----
--------------------------------------------------------------------------- ---+
1 row in set (0.02 sec)
I'm sorry it's so ugly. If there's a better way to capture the output, let me know and I'll do it.
Thanks Ken
|
|
|