Got past mem problem only to hit a timeout problem
| Project: | Wordpress Import |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | lavamind |
| Status: | closed |
Jump to:
I'm working on a local installation, almost empty database (only new superuser created, no content or anything.)
As per another support thread on this, I added this on top of the wordpress import file, and got past the out of memory problem.
ini_set('memory_limit', -1);
"Fatal error: Maximum execution time of 60 seconds exceeded in C:\Program Files\xampplite\htdocs\drupal-5.8\includes\database.mysql.inc on line 153"
I tried this with two different xml files, one of which has regular single and double quotes substituting for those dang curly quotes that wordpress usually inserts, since they also, according to another thread, seem to create a problem here. Didn't make a difference.
I really need to get this done for a client site. Any help would be GREATLY appreciated. WP version is 2.2.1. I'd be happy to send the xml file to you directly, I didn't attach since it's a client file. You can email me at bj at doneinstyle dot com if you need to. Thanks!
#1
How about raising the execution time in php.ini and MySQL too?
#2
okay, found it in php and raised it, but where do I do that for MySQL? Be gentle, I'm a new user on XAMPP. :)
Anyway, I did try running it with the time changed in php.ini for php, and got this:
Fatal error: Maximum execution time of 60 seconds exceeded in C:\Program Files\xampplite\htdocs\drupal-5.8\includes\database.mysql.inc on line 153
Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Table 'sessions' was not locked with LOCK TABLES\nquery: SELECT sid FROM sessions WHERE sid = '1cde6c41dead40139f443ec2c7a84f59' in C:\\Program Files\\xampplite\\htdocs\\drupal-5.8\\includes\\database.mysql.inc on line 172.', 2, '', 'http://localhost/drupal-5.8/?q=admin/content/wordpress_import', 'http://localhost/drupal-5.8/?q=admin/content/wordpress_import', '127.0.0.1', 1216842525) in C:\Program Files\xampplite\htdocs\drupal-5.8\includes\database.mysql.inc on line 172
Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Table 'sessions' was not locked with LOCK TABLES\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES ('1cde6c41dead40139f443ec2c7a84f59', 1, 0, '127.0.0.1', 'form|a:6:{s:32:\\"ad5152d552e6a00eea4218c7eb13396e\\";a:2:{s:9:\\"timestamp\\";i:1216835207;s:4:\\"args\\";a:1:{i:0;s:14:\\"system_modules\\";}}s:32:\\"54647ff63bf97e463de2e540a60b11c3\\";a:2:{s:9:\\"timestamp\\";i:1216835250;s:4:\\"args\\";a:1:{i:0;s:14:\\"system_modules\\";}}s:32:\\"1844d2e8a781de17e5320ba8c227 in C:\Program Files\xampplite\htdocs\drupal-5.8\includes\database.mysql.inc on line 172
#3
Hmm. There should be a SQL config file called my.cnf. Not sure wher this is on Windows.
#4
Thanks, gh0st25, I found that file but there is noplace in there where there's any sort of time specified, at least not that I could see, but I'm far from an expert in this stuff. This is the last bit that seemed where it should have the time stuff. Am I missing something? Or is there something I can add in here? Please be very specific. I'm a n00b but I'm trainable. :)
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
#5
This is not a mysql issue, but a PHP one. If the script takes to long to run, you should increase the value of the max_execution_time variable in your php.ini file.
#6
Hi, where would I find that php.ini file? I'm very new to server stuff, but didn't find it in any of my drupal install folders. thx KV
#7
Hi krisvannest,
It depends of your system, and of your Apache and PHP versions. On my server, it's in the directory /etc/php5/apache2/ . What is your configuration ?
#8
Should be fixed in 6.x-2.x-dev with batch api.
#9
Automatically closed -- issue fixed for 2 weeks with no activity.