Previous Thread
Next Thread
Print Thread
Hop To
Page 1 of 2 1 2
Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
I am receiving this error message when trying to access topics:

Quote
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:

Quote
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:

Quote
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:

Quote
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:

Quote
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,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
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...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
How can I correct this?

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,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
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.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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
Will do.

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
R
Former Developer
Former Developer
R Offline
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
Will do.

Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
Working OK now.

I wish I had your knowledge. smile

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
R
Former Developer
Former Developer
R Offline
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. smile

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:

Quote
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:

Quote
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
R
Former Developer
Former Developer
R Offline
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

Rick #168560 11/18/2006 10:21 PM
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
R
Former Developer
Former Developer
R Offline
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.

Rick #168564 11/18/2006 10:26 PM
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. laugh

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Originally Posted by Daryl Fawcett
I may even be a pro someday. laugh


constantly break things, like us, and soon you'll be runnin the place hehe...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
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.html

I 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

Page 1 of 2 1 2

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)