• 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

Can't create some tables during installation


Author Message
uli
Ulrich
Multishop experienced
Topic creator
registered since: 13.05.2011
Posts: 5
Hi,

I'm using TYPO3 4.5.2 with MySQL 5.045, and I want to try the multishop. During the Installation the shop wants to create some tables but he can't. The first on is tx_multishop_address_book, than categories and a lot more. I detected the error, because i tried to create a fe usergroup, but that failed with the following error message:
SQL
2: SQL error: 'Unbekanntes Tabellenfeld 'tx_multishop_discount' in field list' (fe_groups:NEW4dccb9f254e6b)


Do you have an idea?

Best wishes

uli
Written on: 13. 05. 2011 [04:57]
uli
Ulrich
Multishop experienced
Topic creator
registered since: 13.05.2011
Posts: 5
Hi,

I'm using TYPO3 4.5.2 with MySQL 5.045, and I want to try the multishop. During the Installation the shop wants to create some tables but he can't. The first on is tx_multishop_address_book, than categories and a lot more. I detected the error, because i tried to create a fe usergroup, but that failed with the following error message: 2: SQL error: 'Unbekanntes Tabellenfeld 'tx_multishop_discount' in field list' (fe_groups:NEW4dccb9f254e6b)

Do you have an idea?

Best wishes

uli
Written on: 13. 05. 2011 [04:59]
uli
Ulrich
Multishop experienced
Topic creator
registered since: 13.05.2011
Posts: 5
Sorry for the new posting, but i want you to know, the Folling error message:
SQL
Fehlerhafter Vorgabewert (DEFAULT) für 'customer_id'

This is the error message in the install Tool, when i try to create the missing tables, in this case tx_multishop_address_book

Perhaps you have an idea?
Written on: 13. 05. 2011 [09:35]
uli
Ulrich
Multishop experienced
Topic creator
registered since: 13.05.2011
Posts: 5
O.K., i installed an older Version (1.0.10) now it works, seems to be a Problem with ext_tables.sql and ext_tables_static+adt.sql...
Written on: 13. 05. 2011 [09:48]
keizo
keizo
Multishop newbie
registered since: 14.05.2011
Posts: 1
Hi,

I've got the same problem. The first time I've modified the .sql file to set the default values of the fields.

After i did like you icon_smile.gif
Written on: 14. 05. 2011 [10:28]
pandeussilvae
Paolo Nugnes
Multishop experienced
registered since: 08.05.2011
Posts: 9
Well, this is definitely a Multishop bug (but it's really simple to correct, btw).
You can workaround it by adding the "tx_multishop_discount" field to the feuser table.
You can do it editing the table with phpmydmin or by adding the line to .sql file just like keizo did.
After adding the field Multishop should run fine.

Cheers
Paolo Nugnes
Written on: 16. 05. 2011 [11:16]
uli
Ulrich
Multishop experienced
Topic creator
registered since: 13.05.2011
Posts: 5
Thanks Paolo, that helped for the moment icon_smile.gif

Cheers

Uli
Written on: 17. 05. 2011 [12:46]
ToBe
Tobi
Multishop experienced
registered since: 26.05.2011
Posts: 6
same Problem...

in some mysql-Versions (don't know) is the problem, that an INT or DECIMAL cant have as default value ''. (its a string)

so I changed the sql-file

here it is, for those who want to save some time icon_wink.gif

ITS ONLY AN WORKAROUND!!! I think developers will fix this very soon.
icon_wink.gif
Attachment

Written on: 26. 05. 2011 [09:28]
xaver
xaver
Multishop newbie
registered since: 04.04.2011
Posts: 1
Create field manuell or add a User and group BEFORE you install multishop. Now install multishop and login in frontend and click multishop updater.
Written on: 26. 05. 2011 [13:18]
Ingo
Ackermann
Multishop newbie
registered since: 08.04.2011
Posts: 1
Hi,

I am not a sophisticated user, so please forgive me a stupid question:

If I want to add tx_multishop_discount to fe_users, what type of data do I have to choose: varchar, decimal ?

kind regards

Ingo
Written on: 30. 05. 2011 [15:59]