• 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

Alter table in Databsase Update


Author Message
dav
david
Multishop experienced
Topic creator
registered since: 23.08.2011
Posts: 11
Hello
I am having difficulties with the Multishop database tables. After following a below thread (Error in ext_tables.sql???) I have managed to correct some of the tables issues. I still have issues with the Alter tables as shown in the attached jpeg image.

First question: will these issues cause problems later when using the shop system?

How can I alter the tables so, I have been trying most of the day now without any luck.
Please could you supply a sql query to run in phpmyadmin.

Reagrds, Dav
Attachment

Written on: 07. 10. 2011 [14:28]
bas
Bas van Beek
Multishop guru
registered since: 12.05.2010
Posts: 644
Which TYPO3 version are you running?

The "alter table" should not be a concern. Normally you just submit the form and TYPO3 corrects the fields.
Written on: 08. 10. 2011 [15:04]
dav
david
Multishop experienced
Topic creator
registered since: 23.08.2011
Posts: 11
Hello

I am using version 4.5.6

Regards,
Dav
Written on: 09. 10. 2011 [08:29]
bas
Bas van Beek
Multishop guru
registered since: 12.05.2010
Posts: 644
Please install the latest Multishop. Could you confirm this issue is resolved?
Written on: 10. 10. 2011 [20:02]
dav
david
Multishop experienced
Topic creator
registered since: 23.08.2011
Posts: 11
Hello

Thanks for the reply.

I have installed Multishop 1.0.36. The "Alter Tables" queries are still not working. I attach a file with the results after "Make updates "button was used on the tab "Database Update".
I did not remove the Multishop tables from the DB before installing the extension, because there are some products in the shop.
I only removed the Multishop extension from the extension manager and wrote over the old version with the new version. I hope this was the correct procedure for this situation.
Regards,
Dav
Attachment

Written on: 11. 10. 2011 [09:01]
bas
Bas van Beek
Multishop guru
registered since: 12.05.2010
Posts: 644
PHPmyadmin creates integer fields with a blank default value (''). This is not allowed by TYPO3 as integer fields may only contain 0 (or NULL) as default value.

I have reviewed, adjusted and tested the installation process on a third party vhost and now it's working without a problem.

This fix will be published to TER tonight.
Written on: 14. 10. 2011 [19:32]