Page 1 of 4
sitemap product url
Posted: 11 Mar 2017, 07:18
by 27bit.ru
Hello
I created a site map using the scheduler. I looked at her, and I can not figure out how to check the links. I tried to substitute this link with the domain of the site, the product does not show, if you attach to the category, there is also no result. Or did I make the import incorrectly, or do I need settings for the sitemap?
If I can not use this link on the site, then the search engine will also be unavailable
Below, the code from the site map.
Code: Select all
<url><loc>/?id=&ai%5Bcontroller%5D=catalog&ai%5Baction%5D=detail&ai%5Ba-name%5D=%D0%9A%D0%BE%D1%84%D0%B5%D0%B2%D0%B0%D1%80%D0%BA%D0%B0-Vigor-HX-2115&ai%5Bd-product-id%5D=1</loc><lastmod>2017-01-20T17:56:25+03:00</lastmod><changefreq>daily</changefreq></url>
Re: sitemap product url
Posted: 11 Mar 2017, 16:56
by aimeos
The job for the product (sitemap) export must be executed by the advanced (email) scheduler task because it needs parameters like the catalog detail page ID. But the "product sitemap export" is currently shown in the Aimeos default scheduler task. Can you try this version instead?
https://aimeos.org/fileadmin/download/a ... 0-pre8.zip
Re: sitemap product url
Posted: 14 Mar 2017, 11:33
by 27bit.ru
aimeos wrote:The job for the product (sitemap) export must be executed by the advanced (email) scheduler task because it needs parameters like the catalog detail page ID. But the "product sitemap export" is currently shown in the Aimeos default scheduler task. Can you try this version instead?
https://aimeos.org/fileadmin/download/a ... 0-pre8.zip
When upgrading to version 17, there are a lot of errors and problems. I was able to upgrade the store to version 16.10.4 without any problems. But the problem with the product card remained unresolved. Is there a way to solve it by hand? Because I will need links to the goods in the export of goods.
I tried these settings(catalog detail page ID), but they also did not help me.
Code: Select all
plugin.tx_aimeos.settings.client.html.email.catalog.detail.url.target = 13
Re: sitemap product url
Posted: 14 Mar 2017, 15:24
by aimeos
Re: sitemap product url
Posted: 15 Mar 2017, 02:20
by 27bit.ru
Executing statement "ALTER TABLE "mshop_product_stock" ADD UNIQUE INDEX "unq_msprost_sid_pid_wid" ("siteid", "prodid", "warehouseid")" failed: An exception occurred while executing 'ALTER TABLE "mshop_product_stock" ADD UNIQUE INDEX "unq_msprost_sid_pid_wid" ("siteid", "prodid", "warehouseid")': SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'prodid' doesn't exist in table
Re: sitemap product url
Posted: 15 Mar 2017, 09:34
by aimeos
Did you updated to 17.x and then reverted to 16.10? After an update, you can't go back. Instead, you have to restore your database from a backup.
Re: sitemap product url
Posted: 15 Mar 2017, 09:56
by 27bit.ru
aimeos wrote:Did you updated to 17.x and then reverted to 16.10? After an update, you can't go back. Instead, you have to restore your database from a backup.
The first time I updated long enough to 17, back in January if I'm not mistaken. Therefore, I did not have such an old backup. Is there another option?
Re: sitemap product url
Posted: 15 Mar 2017, 10:01
by aimeos
You can delete the table and run the update script again. It will be recreated.
Re: sitemap product url
Posted: 06 Apr 2017, 15:49
by 27bit.ru
aimeos wrote:You can delete the table and run the update script again. It will be recreated.
I installed your package, but after that a lot of problems arose, the mail scheduler - now it works only in manual mode, and when I import the product to the site it gives an error.
Code: Select all
#0 /home/virtwww/w_new-site/http/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(800): Aimeos\MW\DB\Statement\PDO\Simple->execute()
#1 /home/virtwww/w_new-site/http/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/src/MShop/Product/Manager/Standard.php(557): Aimeos\MShop\Common\Manager\Base->searchItemsBase(Object(Aimeos\MW\DB\Connection\PDO), Object(Aimeos\MW\Criteria\SQL), 'mshop/product/m...', 'mshop/product/m...', Array, NULL, 3)
#2 /home/virtwww/w_new-site/http/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(201): Aimeos\MShop\Product\Manager\Standard->searchItems(Object(Aimeos\MW\Criteria\SQL), Array, NULL)
#3 /home/virtwww/w_new-site/http/typo3conf/ext/aimeos/Resources/Private/Extensions/ai-controller-jobs/controller/common/src/Controller/Common/Product/Import/Csv/Base.php(304): Aimeos\MShop\Common\Manager\Decorator\Base->searchItems(Object(Aimeos\MW\Criteria\SQL), Array)
#4 /home/virtwww/w_new-site/http/typo3conf/ext/aimeos/Resources/Private/Extensions/ai-controller-jobs/controller/jobs/src/Controller/Jobs/Product/Import/Csv/Standard.php(340): Aimeos\Controller\Common\Product\Import\Csv\Base->getProducts(Array, Array)
#5 /home/virtwww/w_new-site/http/typo3conf/ext/aimeos/Classes/Scheduler/Base.php(45): Aimeos\Controller\Jobs\Product\Import\Csv\Standard->run()
#6 /home/virtwww/w_new-site/http/typo3conf/ext/aimeos/Classes/Scheduler/Task/Typo6.php(42): Aimeos\Aimeos\Scheduler\Base::execute(Array, Array, Array)
#7 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/sysext/scheduler/Classes/Scheduler.php(158): Aimeos\Aimeos\Scheduler\Task\Typo6->execute()
#8 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/sysext/scheduler/Classes/Controller/SchedulerModuleController.php(918): TYPO3\CMS\Scheduler\Scheduler->executeTask(Object(Aimeos\Aimeos\Scheduler\Task\Typo6))
#9 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/sysext/scheduler/Classes/Controller/SchedulerModuleController.php(244): TYPO3\CMS\Scheduler\Controller\SchedulerModuleController->executeTasks()
#10 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/sysext/scheduler/Classes/Controller/SchedulerModuleController.php(159): TYPO3\CMS\Scheduler\Controller\SchedulerModuleController->getModuleContent()
#11 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/sysext/scheduler/Classes/Controller/SchedulerModuleController.php(311): TYPO3\CMS\Scheduler\Controller\SchedulerModuleController->main()
#12 [internal function]: TYPO3\CMS\Scheduler\Controller\SchedulerModuleController->mainAction(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(TYPO3\CMS\Core\Http\Response))
#13 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/sysext/core/Classes/Http/Dispatcher.php(41): call_user_func_array(Array, Array)
#14 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/sysext/backend/Classes/Http/BackendModuleRequestHandler.php(202): TYPO3\CMS\Core\Http\Dispatcher->dispatch(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(TYPO3\CMS\Core\Http\Response))
#15 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/sysext/backend/Classes/Http/BackendModuleRequestHandler.php(93): TYPO3\CMS\Backend\Http\BackendModuleRequestHandler->dispatchModule('system_txschedu...')
#16 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/sysext/core/Classes/Core/Bootstrap.php(302): TYPO3\CMS\Backend\Http\BackendModuleRequestHandler->handleRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#17 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/sysext/backend/Classes/Http/Application.php(94): TYPO3\CMS\Core\Core\Bootstrap->handleRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#18 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/index.php(20): TYPO3\CMS\Backend\Http\Application->run()
#19 [internal function]: {closure}()
#20 /home/virtwww/w_new-site/http/typo3_src-7.6.16/typo3/index.php(21): call_user_func(Object(Closure))
#21 {main}
Code: Select all
Product import error: Number of binds (0) doesn't match the number of markers in "
SELECT mpro."id" AS "product.id", mpro."siteid" AS "product.siteid",
mpro."typeid" AS "product.typeid", mpro."code" AS "product.code",
mpro."label" AS "product.label", mpro."config" AS "product.config",
mpro."start" AS "product.datestart", mpro."end" AS "product.dateend",
mpro."status" AS "product.status", mpro."ctime" AS "product.ctime",
mpro."mtime" AS "product.mtime", mpro."editor" AS "product.editor"
FROM "mshop_product" AS mpro
WHERE ( mpro."siteid" IN (1) AND mpro."code" IN ('
Re: sitemap product url
Posted: 06 Apr 2017, 16:26
by aimeos
Which Aimeos version are you currently using?