Hi I tried to import a feed but only the register and global filters are active.
I tried few different things but still can't import anything.
Can someone assist please. Thank you
I did setup and all three have passed and did register then run trial but goes back to page and doesn't run. Still buttons not showing active.
Thank you
Hi,
Apologies for the inconvenience you have experienced getting started. If all database checks pass during set-up that would indicate an INSERT issue (maybe still permissions related) at the end of the feed registration process.
To check this (dependent upon PHP configuration) please enable database debug mode by changing line 6 in config.advanced.php as follows;
$config_databaseDebugMode = TRUE;Then try registering your first feed again, and an extended MySQL error message may be displayed at the end of the process. If you could capture the message and let me know what is displayed I'll check that out further for you. Alternatively, if there is no difference, this is probably down to your PHP configuration using buffering which means there is no change to capture the MySQL error, so if that's the case, let me know and I'll follow up by email with you...
Cheers,
David.
--
PriceTapestry.com
Hi Here is error
{code saved} [Unknown column 'field_sku' in 'field list']
Thank you
Hi,
Thanks - I can see from the INSERT query that you have added the custom field "sku" but the query is failing due to that "field_sku" column not having yet been created on the pt_products table, which sounds like the dbmod.php script created as part of the custom field process has not yet been run so that should be all it is...
Based on the template from , if you create for an "sku" field the following dbmod.php script:
<?php
require("includes/common.php");
$sql = "ALTER TABLE `".$config_databaseTablePrefix."feeds`
ADD `field_sku` VARCHAR(255) NOT NULL";
database_queryModify($sql,$result);
$sql = "ALTER TABLE `".$config_databaseTablePrefix."products`
ADD `sku` VARCHAR(255) NOT NULL";
database_queryModify($sql,$result);
print "Done.";
?>
Upload to the top level folder of your Price Tapestry installation, browse to dbmod.php and then delete the file from your server.
That should be all it is, and feed registration will then complete as normal.
Hope this helps!
Cheers,
David.
--
PriceTapestry.com
I not sure must be doing something wrong. I followed instruction except could not find dbmod.php old file on server. Uploaded new dbmod.php with code still have same problem.
{code saved}
Thank you
Hi augirl,
I've just followed up by email to ask for temporary access your installation to help complete your setup + custom field for you...
Cheers,
David.
--
PriceTapestry.com
Hello augirl and welcome to the forum!
If, having gone through to Feed Registration Step 2, and then clicking Register or Register and Trial Import etc. you are just immediately returned to the /admin/ home page that would indicate that the database setup may not have completed. On this installation browse to /setup.php in the top level and assuming that both checks are passed if "click here to install tables" is still displayed that should be all it is - click the link to complete the set-up and Feed Registration should then complete succsesfully.
If however, you are clicking the install tables link but the setup.php pages returns with the message still displayed that could possibly indicate a database user permissions issue e.g. the username used in the connection (as specified in $config_databaseUsername) does not have CREATE TABLE permissions - if this is the case, let me know and I'll forward by email details of how to debug this for confirmation and help out with regards to the database persmissions...
Hope this helps!
Cheers,
David.
--
PriceTapestry.com