I am using the "Export/Import Tool" (by Jeff Neuhof), and get this error when importing my file.
1) It was working fine on 1and1 (on a shared server) till I hit over 4000 products. Then I got this error.
2) Recommended that I go to a VPS, so I I am now on a VPS on Godaddy.
NOW.... I get the error even when I import a file with less than 4000 products.
In fact, I even get it when I try re- importing the same file that I just exported!)
3) In both php.ini files, I raised the memory_limit to 256M.
The actual Excel file is only 2.6M. I would appreciate any help! Thanks.
When I open Putty, it asks for the "Hostname or IP address". Would anyone familiar with Godaddy know how I could find that info? I have something like... ip-xx-xx-xx-xxx.ip.secureserver.net, Is this what Putty wants ( don't mean to sound too ignorant, but it is my first time working with a VPS). Thank you.
I did that that and now it says "A reboot is now in progress...".
Hopefully it will let me know when it is complete. Thank you very much!
Hmmmmm.... After 1 hour, my phpinfo file still shows the orig 64M for memory_limit.
Does that seem right?
I checked the Apache status. It showed that the server was in fact restarted yesterday and has been up for 1 day and 3 hours, so the re-boot seemed to have worked, BUT..... my phpinfo still showed "memory_limit" = 64M, So... I again reset the "memory_limit" (this time to 128M) and did another "Graceful Server Reboot". Again seems to have reboot complete, but phpinfo still shows 64M. Anymore thoughts would be greatly appreciated.
http://support.godaddy.com/help/article ... nux-server
Otherwise try Godaddy tech support again. I don't mean to throw you under the bus here, but Godaddy is such a subpar hoster it's hard for me to justify spending time doing their support department's job for them.
In GODADDY, on my VPS server, I did get my memory_limit changed to 128M, AND my phpinfo.php file does show "memory_limit" = 128M, BUT I still get the Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 94 bytes) error when trying to upload my spreadsheet with the Export/Import Tool. Does anyone have any idea why? Thank you very much in advance.
(2) Since the extension probably uses .csv, and since .csv will not necessarily even work at all, according to a given server's mysql setup, ask your support whether .csv (not might be but) IS the problem in relation to the server's mysql setup. Your phpMyAdmin documentation will probably discuss that problem briefly.) Your 4k threshold indicates that's not the problem, but the change to not working even below that may have triggered a lingering server refusal of some sort.
I got it working.I had to bump my server's "memory_limit" to 384M (for 11,000 products).
And to ensure that I am using the correct format, I first used the tool to export the products from the site.
This "Export/Import" tool does not give me choices for the file type. It exports as XLS format only.
Either way, it is working, but sure does require a lot of memory on the server tp process such a large quantity of products.
I set it to 500MB. Working fine! I must admit that both the "Export/Import Tool" and "Options Boost" are awesome modules, but keep in mind that when getting that Fatal Error that it is probably a memory issue.
As you mentioned, you might as well raise the memory limit" to the max as your server will only use this extra memory when necessary to upload the spreadsheet.
Now, if you have a VPS with Godaddy (and get this error, you will need to raise your "memory limit" with the following steps):
a) Cpanel/service_configuration/php_configuration editor (raise “memory_limit” to 500MB and save).
b) Now, in Cpanel, do a “Graceful reboot” so changes take effect.
c) Then you need to raise the “memory_limit” to 500MB in both of your php.ini files (in the root or public_html folder, and the admin folder).
d) Note: you can upload a phpinfo.php file in your root in your site root to see if changes took place.
Also in Godaddy you need to enable GD & Mbstring(in order for the “Export/Import tool” to work) …. a) Login to Cpanel:
b) Easy Apache (Apache Update)/ start customizing based on profile/next step/next step/exhausted options list/
c) Check GD & Mbstring
d) Save & Build
Thank you for all your help! I will finally mark this thread as solved!
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Table '.\ecommerce\customer_online' is marked as crashed and should be repaired<br />Error No: 145<br />DELETE FROM `customer_online` WHERE (UNIX_TIMESTAMP(`date_added`) + 3600) < UNIX_TIMESTAMP(NOW())' in C:\xampp\htdocs\system\database\mysqli.php:40 Stack trace: #0 C:\xampp\htdocs\vqmod\vqcache\vq2-system_library_db.php(20): DBMySQLi->query('DELETE FROM `cu...') #1 C:\xampp\htdocs\catalog\model\tool\online.php(4): DB->query('DELETE FROM `cu...') #2 C:\xampp\htdocs\catalog\controller\common\footer.php(70): ModelToolOnline->whosonline('127.0.0.1', NULL, 'http://localhos...', '') #3 C:\xampp\htdocs\vqmod\vqcache\vq2-system_engine_controller.php(43): ControllerCommonFooter->index(Array) #4 C:\xampp\htdocs\vqmod\vqcache\vq2-system_engine_controller.php(74): Controller->getChild('common/footer') #5 C:\xampp\htdocs\catalog\controller\common\home.php(24): Controller->render() #6 [internal function]: ControllerCommonHome->index() #7 C:\xampp\htdocs\vqmod\vqcac in C:\xampp\htdocs\system\database\mysqli.php on line 40
kindly help me to solve this error
So I logged in to Cpanel, Under Software/Services there's something called php.ini EzConfig, I enabled it and saw the memory limit was on 64M still. I changed the settings there and now it works. My OC version is 1.5.6 and the Export/Import tool is the latest version.
Hope this helps a lost soul
I don't use Forum Mail, to reach me, contact: email@example.com
Demoversion OpenCart LIGHT v.22.214.171.124
1'500+ FREE OC Extensions - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
I figure it out, actually open cart contain own php.ini file inside admin folder so you should to update memory limit there as well along with whm(php configuration editor), and it will work.
My server is a dedicated server with 8 core (Intel(R) Xeon(R) CPU E3-1230 v3 @ 3.30GHz) and 32 GB RAM.
Memory limit is set at 1024 and i already check with what boxman86 suggested (4 posts before), all is correctly set.
I have 1240919 products in 2778 categories, with total 407417 manufacturers. I have no problem with products, search, and categories but on the manufacturer link on the footer (in my site renamed to Author) lies the problem. I get memory exhausted error when clicking on this link.
I tried to run the query from model\catalog\manufacturer (getManufacturers function) on phpmyadmin and it took only 0.0044 second which is good i think.
Really appreciate if anyone can suggest something worth to try.
Fatal error: Call to a member function link() on a non-object in /home/iskaefrm/public_html/admin/controller/module/mylivechat.php on line 60
how to slove ?
Users browsing this forum: No registered users and 3 guests