Home » Forums » Ubercart » Support

I'm getting an error on almost every page (Errcode: 13)

Submitted by JamesMarie on Thu, 09/18/2008 - 11:56
JamesMarie
Posts: 4
 Joined: 09/11/2008

Here is the complete error -

user warning: Can't create/write to file '/var/lib/mysql/#sql_bd7_0.MYI' (Errcode: 13) query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 3 ORDER BY v.weight, t.weight, t.name in /var/www/html/modules/taxonomy/taxonomy.module on line 618.

I am using Drupal 6.4... is this an issue with that? So far, everything seems to be working fine - I just keep getting this error...

Thanks for any help/advise!
permalink #1 Thu, 09/18/2008 - 13:26
Ryan

Posts: 5625
 Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

No clue, but it sounds serious. That looks like an issue with your MySQL server, but don't quote me on that. Eye-wink

permalink #2 Thu, 09/18/2008 - 14:31
Andy

Posts: 155
 Joined: 08/07/2007
AdministratorNot Kulvik

James,
This sounds like a problem with MySql and not Ubercart. Does the page load correctly and it just displays the error, or does the rest of the page load and it only displays the error?
The '/var/lib/mysql/#sql_bd7_0.MYI' file is the physical file where MySql stores the database. It is possible you have a permissions problem with MySql. Check to see if the MySql user has permissions to write to the /var/lib/mysql folder.
From the command line:
cd /var/lib
ls -l|less
you will see a long list of folders and files. One of the columns (probably the 2nd and 3rd column) will be user and group ownership. You should see mostly root root in these columns. For the mysql row, you are looking for the user and group to both be mysql. If not, post here what it is.
Hope this helps.
Andy

permalink #3 Thu, 09/18/2008 - 15:01
JamesMarie
Posts: 4
 Joined: 09/11/2008

Ok - the owner is mysql, but the group is sodhouse - which is the site admin name... the owner has full permissions, but the group does not have write permissions... any other ideas?

The thing is - this site worked without errors until I loaded Ubercart... so I don't know if I don't have something set up right, or what...

Thanks for your help!

permalink #4 Thu, 10/02/2008 - 10:54
Andy

Posts: 155
 Joined: 08/07/2007
AdministratorNot Kulvik

How did you install Ubercart? Did you use the automatic installer at install.ubercart.org? It overwrites any old data and creates a new clean install which means it will erase your old data.
Andy