|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I am receiving this error message when trying to access topics: Script: /home/virtual/site5/fst/var/www/html/forums/scripts/showflat.inc.php Line#: 416 SQL Error: Can't find file: 'ubbt_TOPIC_VIEWS.MYD' (errno: 2) SQL Error #: 1017 Query: insert into ubbt_TOPIC_VIEWS (TOPIC_ID) values ( 5698 ) Is there a MySql command for rebuilding topics?
Last edited by Rick; 10/23/2006 11:51 AM.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
It seems to be a topic_views field problem.
Is there a command for rebuilding that field?
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Will the repair field command fix the problem?
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I tried the repair command and received the following error message: Can't find file: 'ubbt_TOPIC_VIEWS.MYD' (errno: 2) I am at a loss on what to do next. What kind of file is that?
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I tried creating a new file to test out this viewing problem, however, I received the following error message instead: Script: /home/virtual/site5/fst/var/www/html/forums/scripts/addpost.inc.php Line#: 760 SQL Error: Can't find file: 'ubbt_TOPIC_VIEWS.MYD' (errno: 2) SQL Error #: 1017 Query: select count(*),TOPIC_ID from ubbt_TOPIC_VIEWS group by TOPIC_ID I guess I have no other choice now but to wait until somebody here is able to help me as it all seems to impact on this missing ubbt_TOPIC_VIEWS.MYD file. In the meantime I have closed down my board/forum.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I discovered one topic that I can read, however, when I reply to it I receive the following error message: Script: /home/virtual/site5/fst/var/www/html/forums/scripts/addpost.inc.php Line#: 760 SQL Error: Can't find file: 'ubbt_TOPIC_VIEWS.MYD' (errno: 2) SQL Error #: 1017 Query: select count(*),TOPIC_ID from ubbt_TOPIC_VIEWS group by TOPIC_ID The strange thing though is that when I hit my back button, I can see the new post, but, so far, this only works in this one topic, which, so far, is the only topic I can view. I do hope somebody will be able to tell me exactly what to do in relation to this missing ubbt_TOPIC_VIEWS.MYD file, which seems to be causing the whole mess.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I looked at my fields and this is what I see: ubbt_TOPICS Browse Select Insert Properties Drop Empty 5,687 MyISAM 1.0 MB ubbt_TOPIC_VIEWS Browse Select Insert Properties Drop Empty in use ubbt_USERS Browse Select Insert Properties Drop Empty 748 MyISAM 218.0 KB The one causing me all the problem is saying "in use" rather than "MyISAM" like the rest of the fields are also showing. What does "in use" mean in relation to all of the others?
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
MySQL databases are stored as flatfiles on the system; where the table "ubbt_TOPIC_VIEWS" has the flat file "ubbt_TOPIC_VIEWS.MYD" that holds the information on the server.
The erorr message is stating that the table is missing from the server; not sure why, or how, this would be missing however...
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
It also says this field is "in use" with zero rows.
What does that mean?
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Is this a problem that only Rick can solve for me?
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
I have no idea the cause, the original error message indicates the myd file isnt where it's supposed to be; so one would lead to think that something was deleted on the server somehow; has your host by chance disabled MySQL for your server?
Really grasping at straws here, I googled the error message and found a thread on a site stating that their host had disabled MySQL and had a similar error...
You could try the standard mysql tools, try to repair the table, and all that fun jazz...
Last edited by Gizmo; 10/21/2006 5:19 PM.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Daryl,
Can you promote me to admin on your site. I'd like to login and do a couple database queries.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
You are now an Admin there.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Everything else in MySql works.
Even one topic is accessible in a weird sort of way.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, give it a shot now. Since this table is just a temporary table I just did the following:
delete from ubbt_TOPIC_VIEWS
and then
repair table ubbt_TOPIC_VIEWS
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Working OK now. I wish I had your knowledge.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Do you know what caused the problem in the first place?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
It's hard to say. It's a table that does get accessed quite frequently, each time someone views a topic. We may try moving this to a table that just resides in memory instead of being written to disk.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Well, if it happens to somebody else, they can look at this topic to see how they can fix it. Thank you once again.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
This problem has happened again, except it has also closed everything down including the Control Panel. I am getting the following message when trying to access the forums: Script: /home/virtual/site5/fst/var/www/html/forums/libs/ubbthreads.inc.php Line#: 1950 SQL Error: Got error 127 from table handler SQL Error #: 1030 Query: delete from ubbt_CACHED_PERMISSIONS where CACHED_TIMESTAMP < 1163886997 When I try accessing the Control Panel, I get the following message: Fatal error: Call to a member function on a non-object in /home/virtual/site5/fst/var/www/html/forums/libs/mysql.inc.php on line 215 It looks like things will need to be corrected by going to the server itself via phpMyAdmin.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
error 127 is a crashed table. YOu can try to repair by running the following sql command via phpmyadmin
REPAIR table ubbt_CACHED_PERMISSIONS
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Will do.
I can also drop the table and do the repair table command for the ubbt_TOPIC_VIEWS ???
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Yes, I noticed both are saying in use.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I will do the topics one first and then the other one.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Yeah, you can repair the ubbt_TOPIC_VIEWS the same way as earlier. We are going to move this to a memory table in 7.1 that should stop these problems.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Everything is working again.
Thank you.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I am slowly learning a lot on all of this. I may even be a pro someday.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
I may even be a pro someday. constantly break things, like us, and soon you'll be runnin the place hehe...
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I need help on this again.
I dropped the ubbt_TOPIC_VIEWS table using MySql, however, when I do the repair table ubbt_TOPIC_VIEWS command it tells me the table no longer exists.
What now?
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
You can't just drop the table. Now you will need to create table nameoftable; Think you were just supposed to repair it. http://dev.mysql.com/doc/refman/5.0/en/repair-table.htmlI don't know enough of the internal workings of the board code to help you out much more than that. Hopefully someone with more experience or knowledge will stop by soon to give you further advice. Â
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I am trying to create the ubbt_TOPIC_VIEWS table again.
Can somebody give me the exact command here to do that with the proper number of columns, etc.???
Thank you in advance.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I dropped it before and did the repair command without any problem which you can read about earlier in this topic.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I am having a problem now though.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I know Rick could help me very quickly, if he were on here now.
Hopefully, somebody in the know will be able to help me really, really soon.
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
mysql> describe ubbt_TOPIC_VIEWS; +----------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------------+------+-----+---------+-------+ | TOPIC_ID | int(11) unsigned | NO | MUL | | | +----------+------------------+------+-----+---------+-------+
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
mysql> show tables; +------------------------------+ | Tables_in_ubbt7 | +------------------------------+ | ubbt_address_book | | ubbt_admin_searches | | ubbt_announcements | | ubbt_banned_emails | | ubbt_banned_hosts | | ubbt_cache | | ubbt_cached_permissions | | ubbt_calendar_events | | ubbt_categories | | ubbt_censor_list | | ubbt_display_names | | ubbt_files | | ubbt_forum_last_visit | | ubbt_forum_permissions | | ubbt_forums | | ubbt_graemlins | | ubbt_groups | | ubbt_import_map | | ubbt_languages | | ubbt_mailer | | ubbt_member_searches | | ubbt_moderator_notifications | | ubbt_moderator_permissions | | ubbt_moderators | | ubbt_online | | ubbt_poll_data | | ubbt_poll_options | | ubbt_poll_votes | | ubbt_portal_boxes | | ubbt_posts | | ubbt_private_message_posts | | ubbt_private_message_topics | | ubbt_private_message_users | | ubbt_ratings | | ubbt_registration_fields | | ubbt_reserved_names | | ubbt_rss_feeds | | ubbt_saved_queries | | ubbt_search_results | | ubbt_shout_box | | ubbt_styles | | ubbt_topic_views | | ubbt_topics | | ubbt_user_data | | ubbt_user_groups | | ubbt_user_notes | | ubbt_user_profile | | ubbt_user_titles | | ubbt_users | | ubbt_version | | ubbt_watch_lists | +------------------------------+ 51 rows in set (0.02 sec)
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
1 members (Ruben),
814
guests, and
236
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|