|
|
Joined: Nov 2001
Posts: 28
User
|
User
Joined: Nov 2001
Posts: 28 |
I had a problem with the ubbt_TOPIC_VIEWS table, therefore, I dropped it.
I tried the repair command w/o success, therefore, can somebody give me the create command line for creating this now dropped and missing table?
Daryl Fawcett
|
|
|
|
Joined: Jan 2000
Posts: 5,833 Likes: 20
UBBDev / UBBWiki Owner Time Lord
|
UBBDev / UBBWiki Owner Time Lord
Joined: Jan 2000
Posts: 5,833 Likes: 20 |
The repair command only works on a valid table; dropping a table isn't a solution, it'll lead to more errors. I posted this over at UBBCentral: CREATE TABLE `ubbt_TOPIC_VIEWS` ( `TOPIC_ID` int(11) unsigned NOT NULL default '0', KEY `topic_ndx` (`TOPIC_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
|
Joined: Nov 2001
Posts: 28
User
|
User
Joined: Nov 2001
Posts: 28 |
I thought Rick over there had said it was OK to drop it.
I must have misunderstood him.
I will read over that whole topic there again.
Anyway, I altered that table to "heap" in hopes that will solve any future problems, as this is the third time that particular table was corrupted.
Daryl Fawcett
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 808
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|