problem import via SSH
Hello !
I can't anymore import via SSH. It was working fine for the 5 first import but now here is what i have :
topcompam@ssh1:~/www$ cd scripts
topcompam@ssh1:~/www/scripts$ php ./import.php pixmania.xml
X-Powered-By: PHP/4.4.8
Content-type: text/html
importing Pixmania.xml...[done]
backfilling reviews...[done]
topcompam@ssh1:~/www/scripts$
When i then check on my website nothing has been imported... The xml file is quite big (20 MB but even with a very small file it doesn't work... I didn't change anything in the code.
Can you help me please?
Thanks,
Gilles
Hi David,
The feeds that were working are no longer import... It's working via the admin interface but not via ssh and i need to import quite big files (about 20 MB) so i can't do it via the admin interface.
Cheers,
Gilles
Hello Gilles,
I'm wondering if the CLI (command line interface) version of PHP on your server has been changed recently, and maybe isn't configured correctly. It must have the libraries otherwise the MySQL calls would fail etc.
I'll email you a debug version of includes/database.php which will print out any SQL error that occurs which should help identify the problem...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David,
Thanks for your email. I replaced database.php with the one you sent me. But i still got this message :
topcompam@ssh1:~/www$ cd scripts
topcompam@ssh1:~/www/scripts$ php ./import.php pixmania.xml
X-Powered-By: PHP/4.4.8
Content-type: text/html
backfilling reviews...[done]
topcompam@ssh1:~/www/scripts$
Thanks,
Gilles
Hello Gilles,
As database connectivity seems OK, another possibility is that the permissions of the product feeds in the /feeds/ directory have changed, and whilst PHP running as web server module is able to access them, the user that you are logged in as via SSH is not able to.
Could you try this experiment. You need to login via SSH as before; and then execute the following commands:
topcompam@ssh1:~/www$ cd scripts
topcompam@ssh1:~/www/scripts$ more ../feeds/pixmania.xml...then assuming that you can view the first part of the feed, press CTRL-C to exit, and let me know that it worked OK. On the other hand, you may see a "permission denied" or similar message. If that happens, we'll look at why the permissions have changed...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hello Gilles,
Is it just this one feed that won't import via SSH, or do the feeds that were working no longer import either? Does importing via the admin interface not work also?
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum