hello,
i am having this error while opening my store please tell me how to solve it
Error: Can't create/write to file '/tmp/#sql_4a8b_0.MYD' (Errcode: 17)
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 3
Last edited by i2Paq on Tue Nov 08, 2011 12:50 am, edited 1 time in total.
Reason: Title adjusted
Reason: Title adjusted
As you might already know its issue with mysql trying to write t a file..
Try two things
1. Check if the files are having enough space usually happens when hosted server tmp space is full .
2. The file/folder you are writing into has permissions to be written or its not changed recently. Usually we see in some of our client applications, hosting companies take it for granted that they are allowed to change the permissions. They call it optimization while we call it a bloody mess
Good luck and HNY.
Try two things
1. Check if the files are having enough space usually happens when hosted server tmp space is full .
2. The file/folder you are writing into has permissions to be written or its not changed recently. Usually we see in some of our client applications, hosting companies take it for granted that they are allowed to change the permissions. They call it optimization while we call it a bloody mess
Good luck and HNY.
See here: http://www.dijiblog.co.uk/opencart-sess ... edir-full/
Opecart is shipped with 2 x php.ini files that casue the issues.
The the above link to fix it for future reference
Opecart is shipped with 2 x php.ini files that casue the issues.
The the above link to fix it for future reference
Professional UK Based eCommerce - Our Free Opencart Mods - Our Premium Opencart Mods
Kashflow Integration
Why not just post the solution here?
The (your) \TMP (temp) folder is full because of an issue with the 2x php.ini files.
The temp files are saved to long.
In the \php.ini find:
This number is in seconds, so in hours that would be; 3,334 – which is 138 days!
Change to:
Wich is just one (1) hour.
In the \admin\php.ini find:
Change to:
Wich is just three (3) hours.
The (your) \TMP (temp) folder is full because of an issue with the 2x php.ini files.
The temp files are saved to long.
In the \php.ini find:
Code: Select all
session.gc_maxlifetime = 12000000;
Change to:
Code: Select all
session.gc_maxlifetime = 3600;
In the \admin\php.ini find:
Code: Select all
session.gc_maxlifetime = 12000000;
Code: Select all
session.gc_maxlifetime = 10800;
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
no it's an out of space issue because since the session lifetime is set so high no sessions ever get deleted, so the fix posted is valid.Daniel wrote:permissions issue. nothing to do with opencart. contact your host.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Daniel you are smart most of the time, then you just act stupid like this. Listen carefully opencart does come with a php.ini which sets the session lifetime to a very long time, so that sessions will not get cleaned up, so the tmp directory that opencart didn't create can get full and piss off shared hosts. Probably one of the reasons you are seeing blowback from hosts like hostgator.Daniel wrote:listen carefully!
opencart does not come with a /tmp directory. this is created by your host to store sessions.
contact your host!
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
LOL
Accept its a problem CAUSED BY YOUR SHIPPED PHP.INI FILES!!!!!!!!
Love the software and appreciate what you guys have put into it..
But admit when you are wrong already
Accept its a problem CAUSED BY YOUR SHIPPED PHP.INI FILES!!!!!!!!
Love the software and appreciate what you guys have put into it..
But admit when you are wrong already
Professional UK Based eCommerce - Our Free Opencart Mods - Our Premium Opencart Mods
Kashflow Integration
Without this getting out of hand.
Can i ask why the values where set as they are Daniel?
It has caused a number of issues on our server, even with tmpwatch clearing out the /tmp folder nightly on a high traffic site still being enough to topple the server with a full /tmp dir.
As discussed above it appears to have also caused a few issues with hostgator and has been mentioned a number of times in the forum (which always results in the user moving server to resolve the "issue")
Can i ask why the values where set as they are Daniel?
It has caused a number of issues on our server, even with tmpwatch clearing out the /tmp folder nightly on a high traffic site still being enough to topple the server with a full /tmp dir.
As discussed above it appears to have also caused a few issues with hostgator and has been mentioned a number of times in the forum (which always results in the user moving server to resolve the "issue")
Cubecart to Opencart Migrations
KashFlow Accounting Integration with OpenCart
I am also bothered by this stupid error "Notice: Error: Can't create/write to file '/tmp". I am not trying to take part on any of you guys and regarding php.ini this has no relevancy in solving this error. I have several developed shops built all on Opencart some are big traffic sites some are low. Only one client presented this error and surprising or not he is hosted on a cheap server. And the server admins just f... him up and take his money. Don't encourage this behavior.
setting a session that can last 24 hours is not issue. having a cheap host is.
are you that dumb! what happens if you want to setup a forum with persistent login!
try buying hosting from a decent company that you don;t have to share with 1000 other people.
are you that dumb! what happens if you want to setup a forum with persistent login!
try buying hosting from a decent company that you don;t have to share with 1000 other people.
OpenCart®
Project Owner & Developer.
I also experienced this same problem with sessions with a not so cheap shared hosting.
My suggestion is to simply stay away from old shared hosts and move on to virtual environment (If this is the correct terminology). Basically, at the same price of classic shared account, you can have your own environment with shared server resources. ie, MySQL, FTP Sessions etc etc will run within your account and are not in shared folders.
My suggestion is to simply stay away from old shared hosts and move on to virtual environment (If this is the correct terminology). Basically, at the same price of classic shared account, you can have your own environment with shared server resources. ie, MySQL, FTP Sessions etc etc will run within your account and are not in shared folders.
Who is online
Users browsing this forum: No registered users and 12 guests
