Hi David,
Quick question. One of my installations of PT will not import any files, either through the admin screen or through shell access. It just hangs. I'm using the script that outputs it's progress through the file. In the shell, it'll tell me how many records it's about to import and then just hangs. On the web version it just hangs and eventually just quits I guess, I don't get an error or anything. It makes me believe that something is looping or hanging. The only thing that I can think of is that I modified some Product Maps and then deleted them after I noticed that import wasn't working. I've edited some other files recently but they've only been the search.php, searchresults.php, product.php, products.php...I think that's it.
Any ideas? The site still seems to work properly so I'm not sure what could be corrupt or broken.
Thanks a lot, -Joe
Hi David,
Well it brought-up an interesting issue. I noticed that I left the debug copy of the database.php file on the server since yesterday when I was trying to figure out some MySQL. I removed it and put the old file back, still no luck. So, I tried the new database.php file and the same thing.
It just locks-up at 0/#### imports.
Any other ideas? I honestly have no idea since it's not affecting my other installation in a different directory which has the same modifications.
The only other thing that I could remember is that I tried a MySQL query on the server earlier through my MySQL Query Browser which seemed to freeze the results of the query. I've been able to query the database numerous times since then. But maybe trying to modify it won't work while it's in use (if it's still running this query?). I'm not sure how processes work on the server. I checked all processes and there were 9 php processes running. I tried to kill them but I don't think I have access to kill them since it didn't do anything.
Could the MySQL server be the problem?...or is that not likely?
Thanks, -Joe
Hi David,
Just to update you on the issue. I contacted support for my server and asked them to look into it. Apparently by the time they looked into it, there were no php threads running anymore (it must've been one heck of a MySQL query that I messed-up) and now the import seems to be working again. Sorry for wasting your time. At least if someone searches and has a similar issue, maybe this will help them.
Thanks a lot for your help, -Joe
Hi Joe,
I'll email you the debug version of database.php which should reveal any problems...
Cheers,
David.