|
|
Joined: Jun 2007
Posts: 2
stranger
|
stranger
Joined: Jun 2007
Posts: 2 |
I had some problens with mysql and php in our server, and when we back the forum files and database, the forum shows one error message all the time that we try to access one topic or message, and I donĀ“t know how I can fix this problem in database.
The error message are:
Script: C:\internet\aplicativos\ubbthreads\scripts\showflat.inc.php Line#: 416 SQL Error: Can't open file: 'ubbt_topic_views.ibd' (errno: 1) SQL Error #: 1016 Query: insert into ubbt_TOPIC_VIEWS (TOPIC_ID) values ( 4846 )
Any idea to fix this problem?
Thanks,
Francisco // cadritech
|
|
|
|
Joined: Jun 2006
Posts: 196
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 196 |
honestly, I would just drop the topic views table and recreate it using create table ubbt_TOPIC_VIEWS (
TOPIC_ID int(11) unsigned not null,
index topic_ndx (TOPIC_ID)
) TYPE=heap
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
I agree with ian, the topic views table is simply a temporary table, loosing any data in it isn't really too big of a deal (so some of your forums will show that no new views are recorded for small time period, at least your forums will work)
|
|
|
|
Joined: Jun 2007
Posts: 2
stranger
|
stranger
Joined: Jun 2007
Posts: 2 |
Worked!!! Thanks a lot for this help!!!
Francisco // cadritech
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
honestly, I would just drop the topic views table and recreate it using create table ubbt_TOPIC_VIEWS (
TOPIC_ID int(11) unsigned not null,
index topic_ndx (TOPIC_ID)
) TYPE=heap If you're like me and give this a try to clear up an error, change TYPE=heap to ENGINE=MEMORY Thank you Giz for keeping hope alive
|
|
|
|
|
|