Previous Thread
Next Thread
Print Thread
Hop To
SQL Error Errcode: 13 #218745 11/03/2008 9:23 PM
Joined: Sep 2006
Posts: 15
duquesne Offline OP
stranger
OP Offline
stranger
Joined: Sep 2006
Posts: 15
Getting the following suddenly on Forum List requests.

We encountered a problem. The reason reported was

Script: /home/virtual/site12/fst/var/www/html/ubbthreads/scripts/cfrm.inc.php
Line#: 163
SQL Error: Can't create/write to file '/var/lib/mysql/#sql_421d_0.MYI' (Errcode: 13)
SQL Error #: 1
Query: SELECT c.CATEGORY_TITLE,c.CATEGORY_ID,c.CATEGORY_DESCRIPTION FROM ubbt_CATEGORIES as c, ubbt_FORUMS as f WHERE (f.FORUM_IS_ACTIVE = 1) AND (f.CATEGORY_ID=c.CATEGORY_ID) GROUP BY c.CATEGORY_ID ORDER BY c.CATEGORY_SORT_ORDER


Google search says it's a permission problem. Everything else seems to be working fine - I can still post. Any idea what the problem is?

Re: SQL Error Errcode: 13 [Re: duquesne] #218746 11/04/2008 12:05 AM
Joined: Jun 2006
Posts: 15,852
Gizmo Online Tapedshut
UBB.threads Developer
Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
Originally Posted by duquesne
SQL Error: Can't create/write to file '/var/lib/mysql/#sql_421d_0.MYI' (Errcode: 13)


It's an issue with your MySQL server; it's saying that it can't write to a flat file associated with the MySQL server; you'll need to contact your webhost to fix the issue for you.


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.
Need to Upgrade?
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!
Re: SQL Error Errcode: 13 [Re: duquesne] #240652 12/13/2010 1:02 AM
Joined: Dec 2010
Posts: 1
pasbanrule Offline
stranger
Offline
stranger
Joined: Dec 2010
Posts: 1
I also have a "you are no supposed to be here" redirection page for any directory that I don't want people have FTP-like HTTP access... once, I accidentally discovered a friend's resume/CV in one of his sub-directories. I think any directory without index.html or index.php automatically have get an FTP-like html interface (if you know what I'm talking about)... like /images/ directories, which I believe most websites will have. A bit of a side-question... is there a technically correct or easier way of preventing such "unauthorized" access to these directories? I can't quite figure out a way with permissions, since for most of those directories, you'll need to set it readable by public for them to access the contents (e.g. images, javascript, etc).


Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
Who's Online Now
2 registered members (Gizmo, Baldeagle), 75 guests, and 375 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)