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!

Comments

kevinquillen’s picture

kevinquillen commented

How about raising the execution time in php.ini and MySQL too?

doneinstyle’s picture

doneinstyle commented

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

kevinquillen’s picture

kevinquillen commented

Hmm. There should be a SQL config file called my.cnf. Not sure wher this is on Windows.

doneinstyle’s picture

doneinstyle commented

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

yrocq’s picture

yrocq commented

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.

krisvannest’s picture

krisvannest commented

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

yrocq’s picture

yrocq commented

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 ?

lavamind’s picture

lavamind commented
Assigned: Unassigned » lavamind
Status: Active » Fixed

Should be fixed in 6.x-2.x-dev with batch api.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.