Hi, Our user export for all subscriptions stopped working. The export opens in Excel, but the spreadsheet is empty. But an export of expired or active subscriptions stills works ok. I think there are about 9k total users. Do I need to change a server setting? Any other ideas? Thanks
Check your amember and amember/admin folder, any error.log files that might indicate an issue? Potentially 1 of 3 problems: 1) Need to increase your PHP Timeout to a higher value (240, 360, etc) 2) Need to increase your PHP Memory allocation (512, 1024, 2048, etc) 3) Need to adjust your MySQL memory or timeout
followup Thanks! Here are my settings, which one do I need to change? 1) Need to increase your PHP Timeout to a higher value (240, 360, etc) apache Connection: 300 - Keep-Alive: 15 http keepalive timeout=15, max=85 default_socket_timeout 60 2) Need to increase your PHP Memory allocation (512, 1024, 2048, etc) memory_limit set to 64M 3) Need to adjust your MySQL memory or timeout mysql.connect_timeout 60 connect timeout 5 delayed insert timeout 300 innodb additional mem pool size 1048576 innodb buffer pool size 8388608 I don't see any error.log in amember/admin folder, could it be somewhere else? The failed response is almost immediate. The successful export of expired members takes about 5 sec
If the failure is almost instant I would focus on the memory side of things. Try increasing your memory_limit to 128M. You can usually do this by creating a file called php.ini containing: Code: memory_limit = 128M Place the file in your amember and/or amember/admin folder (depends on your server configuration)
I'm having this issue trying to export a large amount of users. It takes a long time, but then after a minute or two it times out. Do you still suggest the same thing (I notice this post is 5 years old). Thanks!
What version of aMember are you using? Sounds like you may need to adjust your max_execution_time setting in your php.ini file to something higher like 600 to give the process longer to execute.
Where is this php.ini file located? I created one and put it into the amember folder, but that creates the message below. Script Error Error establishing a database connection. Please contact site webmaster if this error does not disappear long time