Getting weird code

I am getting this code when navigating through my site. This is what gets me, It started in spurts, but now I can access my store front at all and I cant edit any of my products on the admin side. Any One have any ideas? This just started happening about half an hour ago, and it has gotten a bit worse now. Any ideas would be of great help. The version I am running is 1.4.9.3.


Error: Can't create/write to file '/tmp/#sql_106a_0.MYI' (Errcode: 28)
Error No: 1
SELECT *, pd.name AS name, p.image, m.name AS manufacturer, ss.name AS stock, (SELECT AVG(r.rating) FROM review r WHERE p.product_id = r.product_id GROUP BY r.product_id) AS rating FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN stock_status ss ON (p.stock_status_id = ss.stock_status_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND pd.language_id = '1' AND p2s.store_id = '0' AND ss.language_id = '1' AND p2c.category_id = '56' ORDER BY p.sort_order ASC LIMIT 0,20

now im getting this code also from age restriction screen:

Warning: session_start() [function.session-start]: open(/tmp/sess_6d72db980d12d16dfd47afa87118be80, O_RDWR) failed: No space left on device (28) in /home/exotics6/public_html/upload/system/library/session.php on line 11Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/exotics6/public_html/upload/index.php:92) in /home/exotics6/public_html/upload/system/library/session.php on line 11Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/exotics6/public_html/upload/index.php:92) in /home/exotics6/public_html/upload/system/library/session.php on line 11Warning: Cannot modify header information - headers already sent by (output started at /home/exotics6/public_html/upload/index.php:92) in /home/exotics6/public_html/upload/index.php on line 173Warning: Cannot modify header information - headers already sent by (output started at /home/exotics6/public_html/upload/index.php:92) in /home/exotics6/public_html/upload/system/library/currency.php on line 45Warning: Cannot modify header information - headers already sent by (output started at /home/exotics6/public_html/upload/index.php:92) in /home/exotics6/public_html/upload/system/engine/controller.php on line 27
Fatal error: Call to a member function get() on a non-object in /home/exotics6/public_html/upload/index.php on line 91


I am getting this code on the Administration login page

Warning: session_start() [function.session-start]: open(/tmp/sess_353b7a3c34e54709fcfc71c0f7ee44f8, O_RDWR) failed: No space left on device (28) in /home/exotics6/public_html/upload/system/library/session.php on line 11Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/exotics6/public_html/upload/admin/index.php:72) in /home/exotics6/public_html/upload/system/library/session.php on line 11Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/exotics6/public_html/upload/admin/index.php:72) in /home/exotics6/public_html/upload/system/library/session.php on line 11Warning: Cannot modify header information - headers already sent by (output started at /home/exotics6/public_html/upload/admin/index.php:72) in /home/exotics6/public_html/upload/system/library/currency.php on line 45

I get this code when clicking "store front" on the admin side

Error: Can't create/write to file '/tmp/#sql_106a_0.MYI' (Errcode: 28)
Error No: 1
SELECT *, pd.name AS name, p.image, m.name AS manufacturer, ss.name AS stock, (SELECT AVG(r.rating) FROM review r WHERE p.product_id = r.product_id GROUP BY r.product_id) AS rating FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN stock_status ss ON (p.stock_status_id = ss.stock_status_id) WHERE p.status = '1' AND p.date_available <= NOW() AND pd.language_id = '1' AND p2s.store_id = '0' AND ss.language_id = '1' ORDER BY p.date_added DESC LIMIT 4

Always mention version of your OpenCart!
Always include a link if you are having a store front issue!

Contacted your hoster if they have done any upgrades?

Maybe you should actually read the error message. Your problem is NOT OpenCart related. You've run out of space on your server.

snoozebtn wrote:Warning: session_start() [function.session-start]: open(/tmp/sess_6d72db980d12d16dfd47afa87118be80, O_RDWR) failed: No space left on device (28) in /home/exotics6/public_html/upload/system/library/session.php on line 11

never mind it started working again. i2paq you were right, the were upgrading. And fido i have unlimited space with my host, and if i knew what that code meant when i read it I wouldn't have posted. thanks anyways.

Now for my next question. Is there a way to change the coding to attach and show a "Page Under Maintenance" page so customers dont see a bunch of coding when the host is down?

snoozebtn wrote:... And fido i have unlimited space with my host, and if i knew what that code meant when i read it I wouldn't have posted. thanks anyways.

You may have "unlimited space", but that is still limited by the size of your hosts hard drives.

No space left on device

means exactly what it says, there is NO SPACE left.

snoozebtn wrote:never mind it started working again. i2paq you were right, the were upgrading.

I'll bet they were upgrading their hard drives to increase the amount of storage space available to themselves and their clients (eg. you).

unlimited space and alloted /tmp space are 2 different things.
I have 10GB on my disk but I have filled up the alloted space for /tmp files before which is usually set to something like a max of 10%. I had the same error you have above. I had to have my host clear it out for me but it was due to some code I was testing. Normally you should not run out of /tmp space

Just had this come up on my own site! It was soon gone again after contacting the supplier.
Mine's 'unlimited' hosting space too, but we all that's never unlimited. But, is it worth considering using someone that can give a limit so you know that you're not being crammed onto a server with others who might be abusing the space available, or is that a case of using a VPS?

It's highly unlikely a server space issue, but as Q. mentioned most hosts will set a small size limit on the /tmp

This is the problem.

/tmp folders are emptied (usually after a set period of time) but if they are too small then they can soon become full causing problems

Always a good idea to create your own /tmp directory (before the document root if possible)

Then set the php 'upload_tmp_dir' value in php.ini (or even better in httpd.conf if you have access)

If you are able to do the above it is also a good idea to set up a cron job to remove files from the tmp folder that are older than 24 hours.

I am getting this wierd message some time... can any one me out form this error

Notice: Error: Can't create/write to file '/tmp/#sql_280d_1.MYI' (Errcode: 28)
Error No: 1
SELECT * FROM desireofshoescategory c LEFT JOIN desireofshoescategory_description cd ON (c.category_id = cd.category_id) LEFT JOIN desireofshoescategory_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /home/geolocat/public_html/desireofshoes/system/database/mysql.php on line 49

Thanks,
Rahul