- Posts: 18
COMMUNITY FORUM
- Forum
- K2 Community Forum
- English K2 Community
- After Adding A bulk amount of data via phpmyadmin add new item brings up error
After Adding A bulk amount of data via phpmyadmin add new item brings up error
- Mickey Perre
-
Topic Author
- Offline
- New Member
Less
More
15 years 1 month ago #79936
by Mickey Perre
After Adding A bulk amount of data via phpmyadmin add new item brings up error was created by Mickey Perre
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 49 bytes) in index/libraries/joomla/database/database/mysql.php on line 462
Please Log in or Create an account to join the conversation.
- Simon Wells
-
- Offline
- Platinum Member
Less
More
- Posts: 955
15 years 1 month ago #79937
by Simon Wells
Replied by Simon Wells on topic After Adding A bulk amount of data via phpmyadmin add new item brings up error
Hi Mickey,
Seems by the error message that this is a problem with your database and not K2.
I would suggest that your restore your database to before the bulk upload.
Recheck your upload file for errors, consider importing in the data in two smaller batches.
I would consult the documentation for mysql, check the mysql forums or speak with your host company.
Regards,
Simon
K2Joom.com
Seems by the error message that this is a problem with your database and not K2.
I would suggest that your restore your database to before the bulk upload.
Recheck your upload file for errors, consider importing in the data in two smaller batches.
I would consult the documentation for mysql, check the mysql forums or speak with your host company.
Regards,
Simon
K2Joom.com
Please Log in or Create an account to join the conversation.
- Georgi Borislavov Petkov
-
- Offline
- New Member
Less
More
- Posts: 2
14 years 2 months ago #79938
by Georgi Borislavov Petkov
Replied by Georgi Borislavov Petkov on topic After Adding A bulk amount of data via phpmyadmin add new item brings up error
Hello Friends,
I have same problem but the file in error is diferent:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 3600 bytes) in /home/martinet/public_html/design/administrator/components/com_k2/lib/class.upload.php on line 2947
I open this file fith code editor but didn't see eny memory limiti in line 2947
Can you help me?
I have same problem but the file in error is diferent:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 3600 bytes) in /home/martinet/public_html/design/administrator/components/com_k2/lib/class.upload.php on line 2947
I open this file fith code editor but didn't see eny memory limiti in line 2947
Can you help me?
Please Log in or Create an account to join the conversation.
- Terry Britton
-
- Offline
- Elite Member
Less
More
- Posts: 198
14 years 2 months ago #79939
by Terry Britton
Replied by Terry Britton on topic After Adding A bulk amount of data via phpmyadmin add new item brings up error
This is a php error. I forget what the default is, but I think it's 32MB memory usage per php program. Check with your hosting provider and find out how you can change php.ini. You need to add the following line, which will increase the memory usage to 64MB. This can often happen with large databases. If you don't have a large database you have some other problem causing the excess memory usage.
define('WP_MEMORY_LIMIT', '64M');
define('WP_MEMORY_LIMIT', '64M');
Please Log in or Create an account to join the conversation.
- Georgi Borislavov Petkov
-
- Offline
- New Member
Less
More
- Posts: 2
14 years 2 months ago #79940
by Georgi Borislavov Petkov
Replied by Georgi Borislavov Petkov on topic After Adding A bulk amount of data via phpmyadmin add new item brings up error
Thank you for response.
I recieve this error only when I upload rotated images. I download horizontal image, rotate it in vertical and when I upload I see this error. If i do not rotate rotate image everithing is O.K.
Terry A Britton said:
This is a php error. I forget what the default is, but I think it's 32MB memory usage per php program. Check with your hosting provider and find out how you can change php.ini. You need to add the following line, which will increase the memory usage to 64MB. This can often happen with large databases. If you don't have a large database you have some other problem causing the excess memory usage.
define('WP_MEMORY_LIMIT', '64M');
I recieve this error only when I upload rotated images. I download horizontal image, rotate it in vertical and when I upload I see this error. If i do not rotate rotate image everithing is O.K.
Terry A Britton said:
This is a php error. I forget what the default is, but I think it's 32MB memory usage per php program. Check with your hosting provider and find out how you can change php.ini. You need to add the following line, which will increase the memory usage to 64MB. This can often happen with large databases. If you don't have a large database you have some other problem causing the excess memory usage.
define('WP_MEMORY_LIMIT', '64M');
Please Log in or Create an account to join the conversation.
- Terry Britton
-
- Offline
- Elite Member
Less
More
- Posts: 198
14 years 2 months ago #79941
by Terry Britton
Replied by Terry Britton on topic After Adding A bulk amount of data via phpmyadmin add new item brings up error
That makes sense that you're using a lot of memory when doing that. Make the change and the error will go away.
Please Log in or Create an account to join the conversation.
- Forum
- K2 Community Forum
- English K2 Community
- After Adding A bulk amount of data via phpmyadmin add new item brings up error