Questions around the TYPO3 integration and plugins as well as Flow and NeosCMS
Forum rules: Always add your TYPO3/Flow, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
#4015 by 27bit.ru
11 Mar 2017, 07:18
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=&amp;ai%5Bcontroller%5D=catalog&amp;ai%5Baction%5D=detail&amp;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&amp;ai%5Bd-product-id%5D=1</loc><lastmod>2017-01-20T17:56:25+03:00</lastmod><changefreq>daily</changefreq></url>
#4021 by aimeos
11 Mar 2017, 16:56
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/aimeos_aimeos_17.3.0-pre8.zip
#4028 by 27bit.ru
14 Mar 2017, 11:33
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/aimeos_aimeos_17.3.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 allplugin.tx_aimeos.settings.client.html.email.catalog.detail.url.target = 13
#4040 by 27bit.ru
15 Mar 2017, 02:20
aimeos wrote:You can use this pre-release:
https://aimeos.org/fileadmin/download/aimeos_16.10.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
#4042 by aimeos
15 Mar 2017, 09:34
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.
#4043 by 27bit.ru
15 Mar 2017, 09:56
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?
#4112 by 27bit.ru
06 Apr 2017, 15:49
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 allProduct 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 ('