Unable to finish registering feeds

Submitted by 0U812 on Wed, 2019-03-13 17:04 in Feed Management and Administration

Hello,

I am attempting an installation of PT with wordpress. I am able to get to use the register feed function in the admin and it allows me to do all the mapping. However when I then click any of the register it and just returns to the PT admin page where the feeds are listed as new and no products were imported. (Green register feed button and other options greyed out) Any suggestions?

best,
Joe

Hello Joe, The most likely

Submitted by support on Thu, 2019-03-14 09:46

Hello Joe,

The most likely reason for feeds failing to register is where an existing modified version of the script (I know you have been using Price Tapestry for several years now) is used to make the installation that has had custom fields added but the required database fields have not yet been added to the feeds and products tables (as per node 3094)

If this might be the case, instead of having to run an individual dbmod.php script for each custom field, the following dbmod.php script (run from top level of Price Tapestry installation) will add all required database fields for any custom fields not already in place:

<?php
  require("includes/common.php");
  $ignore = array("name","description","image_url","buy_url","price","category","brand");
  foreach($config_fieldSet as $field => $v)
  {
    if (in_array($field,$ignore)) continue;
    $sql = "ALTER TABLE `".$config_databaseTablePrefix."feeds`
              ADD `field_".$field."` VARCHAR(255) NOT NULL";
    database_queryModify($sql,$result);
    $sql = "ALTER TABLE `".$config_databaseTablePrefix."products`
              ADD `".$field."` VARCHAR(255) NOT NULL";
    database_queryModify($sql,$result);
  }
  print "Done.";
?>

If that's not the case and feeds are still not registering, if you are using the latest distribution set database debug mode to 2 at line 6 of config.advanced.php:

$config_databaseDebugMode = 2;

...then attempt to register a feed again and the script will exit after the first database error so that the output can be captured. If you're not sure from what is displayed where the problem lies, let me know the output and I'll check it out further with you.

If you're not running the latest distribution, set database debug mode to TRUE and then edit includes/database.php and look for the following code around line 56 (within database_queryModify function)

print "[".$sql."][".mysqli_error($link)."]";

...and REPLACE with:

print "[".$sql."][".mysqli_error($link)."]";exit();

Cheers,
David.
--
PriceTapestry.com

Thanks for getting back to

Submitted by 0U812 on Fri, 2019-03-15 14:41

Thanks for getting back to me David.

For some reason this response was not showing up for me earlier.

This installation is with a fresh version on your code downloaded from your site... so I don't believe there would be any custom fields.

I have set $config_databaseDebugMode = 2; in config.advanced.php

and run the register feed again. It returns to the same admin page unregistered. Where do I find results from running debug?

Thanks again

Joe

Hello Joe, Has setup.php

Submitted by support on Fri, 2019-03-15 14:54

Hello Joe,

Has setup.php completed successfully and showing all tests as OK with the link to admin to get started?

Cheers,
David.
--
PriceTapestry.com

Hi David. Thanks so much for

Submitted by 0U812 on Fri, 2019-03-15 16:00

Hi David.

Thanks so much for the quick response.

Yes, I had done that... but something must have gone wrong at the time. ran setup again and the import seems to have worked!

Thanks again. I really appreciate you supporting this script still.

Hope all is well.

best,
Joe

Thank you for your comments!

Submitted by support on Fri, 2019-03-15 16:25

Thank you for your comments!

Cheers,
David.
--
PriceTapestry.com