• My account
    • (X)Sign in

      I am a returning customer at TYPO3 Multishop

      Enter your username and password here in order to log in on the website:

      Forgot your password?

      Not yet customer of TYPO3 Multishop?

      • Order history
      • Automatic generated e-mail history
      • Track your Order
      New at TYPO3 Multishop
You are here:

Help by translating Multishop in your local language

On the following page you can help by translating Multishop in your local language:

https://translation.typo3.org/projects/TYPO3.ext.multishop/

Spanish:

https://translation.typo3.org/es/TYPO3.ext.multishop/pi1/locallang.xlf

The following language are already translated by our supporters:

  • Dutch
  • German
  • French

Error in FE: exec_SELECTquery


Author Message
kai-hear@gmx.de
Kai Hoffmann
Multishop experienced
Topic creator
registered since: 16.04.2015
Posts: 5
Hi,
everytime after i successful proceed an order, i get error in Frontend:

caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
ERROR Unknown column '20' in 'order clause'
lastBuiltQuery SELECT products_id FROM tx_multishop_orders_products WHERE orders_id = '7' and products_id !='9' ORDER BY 20
debug_backtrace require(ysext/cms/tslib/index_ts.php),hp#28 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript#232 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->recursivelyReplaceIntPlaceholdersInContent#3609 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript_process#3641 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->USER#3693 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#861 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#41 // call_user_func_array#6603 // tx_multishop_pi1->main# // require(nf/ext/multishop/scripts/core.php),nf/ext/multishop/pi1/class.tx_multishop_pi1.php#437 // require(nf/ext/multishop/scripts/front_pages/products_detail.php),nf/ext/multishop/scripts/core.php#110 // require(nf/ext/multishop/scripts/front_pages/includes/products_detail/default.php),nf/ext/multishop/scripts/front_pages/products_detail.php#45 // mslib_fe->getProductRelativesBox#212 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTgetRows#163 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#354 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#289


Any ideas?
Reggards Kai
Written on: 16. 04. 2015 [23:01]
kai-hear@gmx.de
Kai Hoffmann
Multishop experienced
Topic creator
registered since: 16.04.2015
Posts: 5
Next Message in Adition:

caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
ERROR Unknown column 'relation_types' in 'where clause'
lastBuiltQuery SELECT products_id,relative_product_id FROM tx_multishop_products_to_relative_products WHERE (products_id = '7' or relative_product_id = '7') and relation_types='cross-sell' LIMIT 20


Is there any solution to the problem? I'm annoyed now be switched to multi-shop ...
Written on: 19. 04. 2015 [22:15]
bas
Bas van Beek
Multishop guru
registered since: 12.05.2010
Posts: 644
Which version are you using? Better use the bleeding edge:

http://git.bvbmedia.nl/multishop

Make sure you run compare database in the admin panel of Multishop (bottom right: system/system/compare database), it will repair missing columns automatically.

If this is not an option for you fix the missing column yourself:

ALTER TABLE `tx_multishop_products_to_relative_products` ADD `relation_types` varchar(15) NOT NULL DEFAULT 'cross-sell', ADD INDEX (`relation_types`);
Written on: 25. 04. 2015 [12:11]
kai-hear@gmx.de
Kai Hoffmann
Multishop experienced
Topic creator
registered since: 16.04.2015
Posts: 5
Version:

Multishop: 3.0.3
TYPO3 Core: 6.2.0
PHP Version 5.4.39
MySQL: 5.1.73-1+deb6u1

Database compare & consistensy check ist fine...


[This article was edited 1 times, at last 26.04.2015 at 19:35.]
Attachment

Bildschirmfoto 2015-04-26 um 21.34.53.jpg (File type: image/jpeg, Size: 372.04 kilobytes) — 182 downloads
Written on: 26. 04. 2015 [19:34]
kai-hear@gmx.de
Kai Hoffmann
Multishop experienced
Topic creator
registered since: 16.04.2015
Posts: 5
So, update to 3.0.5 - consistency check : fail - runs endless! Multishop cant find any products (in Frontend). In Backend all prodducts are visible .....
Written on: 28. 04. 2015 [06:36]
kai-hear@gmx.de
Kai Hoffmann
Multishop experienced
Topic creator
registered since: 16.04.2015
Posts: 5

The problem is that even if the database is completely empty, Typo can not update or compare the MySQL database correctly. Although the database is deleted and I recreate them, the same errors are present!

I'm really very frustrated and will need to set up another shop. Very pity ...
Written on: 29. 04. 2015 [12:28]