Error code 28, help needed urgently

  • kayeones
  • Born
  • Born
  • kayeones
  • Posts: 2

Post 3+ Months Ago

Hello,

My shop has been up and running for few weeks now. Today I wanted to add new product and here's what happened. I went admin/configure/categories/products and I see the following error:

1 Can't create/write to file '/tmp/#sql_d3d_0.MYI' (Errcode: 28)
in:
[select c.categories_id, cd.categories_name, cd.categories_description, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I checked my online shop to see how things are there and I see same code in the categories (I can see subcategories, but if I press on them I get same message). No products to view.

Zen cart version 1.3.8b , and I haven't changed anything like coding, I added new products just yesterday and it was fine.
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Zealous
  • Guru
  • Guru
  • User avatar
  • Posts: 1240
  • Loc: Sydney

Post 3+ Months Ago

Check if you have any more room on your hosting account, may be your account hard drive space is full. something to look into
  • Zealous
  • Guru
  • Guru
  • User avatar
  • Posts: 1240
  • Loc: Sydney

Post 3+ Months Ago

Also found this.....
Quote:
The tutorial explain how to fix error cause by MYSQL daemon/engine on your server has run out of space for storing its own database files. If the filename/path mentioned includes “/tmp/” in it, then the error is likely referring to temporary/swap files instead of main database files.

Here how to fix:
If you are system administrator :
1. Create another directory example /var/lib/mysql
2. Open your my.cnf using vi editor
3. Add or Edit :
[mysqld]
tmpdir = /var/lib/mysql
4. Restart your Mysql Server

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 48 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.