import problems

Submitted by kiddaclo on Wed, 2012-02-08 11:26 in Price Tapestry

Hi,

I have a problem I'm just coming back to a site I haven't done anything with for a while and noticed it hadn't updated the feeds for over 12 months! I have it set up as a cron.

So I logged in to my PT and clicked import but nothing updates.
I tried doing it through putty running import.php and it says it's [done] in less than a second!(20,000 product .csv) Nothings imported. Weird! Must admit I've been out of this game a while so might be missing something really stupid!

Any ideas?

Hi kiddaclo, Could you let

Submitted by support on Wed, 2012-02-08 15:43

Hi kiddaclo,

Could you let me know the installation URL (i'll remove before publishing your reply) and any username / password required for /admin/ and I'll check it out right away for you...

Cheers,
David.
--
PriceTapestry.com

Hi David, {link saved} I

Submitted by kiddaclo on Wed, 2012-02-08 19:42

Hi David,

{link saved}

I forgot to mention I did manage to import the feeds last night using the slow import tool. But nothing if I click on import and nothing importing from the cron job.

Cheers,
Chris.

Hi Chris, I'd like to follow

Submitted by support on Thu, 2012-02-09 08:51

Hi Chris,

I'd like to follow up by email; I know you've been a user on the forum for a few years so just in case your account email isn't your latest please could you drop me an email and I'll get in touch...

Cheers,
David.
--
PriceTapestry.com

same problem for new

Submitted by karolisgo on Sun, 2012-02-19 10:02

same problem for new installation of PriceTapestry.
David, is it known issue, or should I reinstall/double check everything?

Hi again, Here is the link:

Submitted by karolisgo on Sun, 2012-02-19 10:23

Hi again,

Here is the link: {link saved}
I removed password, please try to import xml and see whats happening.

Hello Karolis, The problem

Submitted by support on Sun, 2012-02-19 16:17

Hello Karolis,

The problem documented above turned out to be related to a modification applied to includes/admin.php which was using filesize() to avoid importing feeds that had not downloaded correctly during update (for example if there had been a transient error on the server generating the feed).

To check whether a similar modification is in place search you includes/admin.php file for the keyword "filesize". If you find a line containing this function; REPLACE with:

if (filesize($config_feedDirectory.$filename) < 2048) return;

(this will check the feeds are a minimum of 2K before importing)

If that's not in place, the next step in diagnosing the problem would be to enable database debug mode - to do this change line 6 of config.advanced.php as follows;

$config_databaseDebugMode = TRUE;

Next, click Import alongside one of your feeds and assuming that it is a database issue extended MySQL error information should be displayed. If you're not sure from the information displayed (or if there is nothing at all just a return to the /admin/ home page) let me know - and perhaps the quickest thing to do would be to email me a link to the /admin/ area, any password required if you have re-enabled it and a copy of your includes/admin.php and I'll check it straight out for you...

Cheers,
David.
--
PriceTapestry.com