sitemap product url
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
sitemap product url
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.
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
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
https://aimeos.org/fileadmin/download/a ... 0-pre8.zip
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: sitemap product url
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.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
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
You can use this pre-release:
https://aimeos.org/fileadmin/download/a ... 5-pre1.zip
https://aimeos.org/fileadmin/download/a ... 5-pre1.zip
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: sitemap product url
aimeos wrote:You can use this pre-release:
https://aimeos.org/fileadmin/download/a ... 5-pre1.zip
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
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.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: sitemap product url
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?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.
Re: sitemap product url
You can delete the table and run the update script again. It will be recreated.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: sitemap product url
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.aimeos wrote:You can delete the table and run the update script again. It will be recreated.
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
Which Aimeos version are you currently using?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star