• 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 ext_tables.sql???


Author Message
thomaaas
Thomas Hirt
Multishop newbie
Topic creator
registered since: 29.09.2011
Posts: 1
Hi!
I try to install the latest version of multishop with the latest version of typo3 (MySQL-Client-Version: 5.1.51) and found the following errors in the ext_tables.sql file:

TABLE tx_multishop_products:
KEY root_oid (root_oid) can not work because the field root_oid is missing in this table. I had to add this field manually to the table.

TABLE tx_multishop_undo_products
KEY root_oid (root_oid) can not work because the field root_oid is missing in this table. I had to add this field manually to the table.

TABLE tx_multishop_product_feeds
delimiter varchar(10) NOT NULL
This line seems not to work because of the word "delimiter".
I had to change it into "delimiter1 varchar(10) NOT NULL," during creation of the table and than rename it to "delimiter" after creation.

Hope this information helps!
Bye,
Thomas
Written on: 29. 09. 2011 [07:17]
pegger
Patric Egger
Multishop newbie
registered since: 03.10.2011
Posts: 2
I second that. But since I have not found a useful purpose for the oid fields, I just omitted the keys from the create table statement. Still funny though.
Written on: 03. 10. 2011 [02:19]
bas
Bas van Beek
Multishop guru
registered since: 12.05.2010
Posts: 644
We removed unused fields in the products table, but forgot to remove the KEY root_oid! I removed it now from ext_tables.sql and will be fixed in the next update.

I'm wondering why this won't work on Thomas install:

SQL
CREATE TABLE `tx_multishop_product_feeds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(75) NOT NULL,
  `page_uid` int(11) NOT NULL,
  `crdate` int(11) NOT NULL,
  `utm_source` varchar(75) NOT NULL,
  `utm_medium` varchar(75) NOT NULL,
  `utm_term` varchar(75) NOT NULL,
  `utm_content` varchar(75) NOT NULL,
  `utm_campaign` varchar(75) NOT NULL,
  `fields` text NOT NULL,
  `format` varchar(25) NOT NULL,
  `delimiter` varchar(10) NOT NULL,
  `code` varchar(150) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `code` (`code`)
) TYPE=MyISAM;


I installed the plugin on a fresh TYPO3 install and it's not complaining about the delimiter field.
Written on: 08. 10. 2011 [15:25]