sitemap product url

Questions around the TYPO3 integration and plugins
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!
Post Reply
27bit.ru
Posts: 36
Joined: 15 Jan 2017, 05:36

sitemap product url

Post 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=&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>
Top
User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: sitemap product url

Post 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/a ... 0-pre8.zip
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star
Top
27bit.ru
Posts: 36
Joined: 15 Jan 2017, 05:36

Re: sitemap product url

Post 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/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
Top
User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: sitemap product url

Post by aimeos » 14 Mar 2017, 15:24

You can use this pre-release:
https://aimeos.org/fileadmin/download/a ... 5-pre1.zip
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star
Top
27bit.ru
Posts: 36
Joined: 15 Jan 2017, 05:36

Re: sitemap product url

Post by 27bit.ru » 15 Mar 2017, 02:20

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
Top
User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: sitemap product url

Post 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.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star
Top
27bit.ru
Posts: 36
Joined: 15 Jan 2017, 05:36

Re: sitemap product url

Post 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?
Top
User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: sitemap product url

Post by aimeos » 15 Mar 2017, 10:01

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, Image give us a star
Top
27bit.ru
Posts: 36
Joined: 15 Jan 2017, 05:36

Re: sitemap product url

Post 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 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 ('
Top
User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: sitemap product url

Post by aimeos » 06 Apr 2017, 16:26

Which Aimeos version are you currently using?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star
Top
Post Reply

Return to “TYPO3 extension”