• 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

Again Database Problems


Author Message
ULinn
Uli
Multishop professional
Topic creator
registered since: 14.10.2011
Posts: 34
Hello everybody!

Because I don't get my Multishop-Installation running (See other post "Several Problems with
Database, creating Products) I now set up a fresh Typo3 4.5.8 with the demo-content
and installed Multishop (with all required extensions). But again the Database seems not to
be correct - even after a Database-Update in the Extension-Manager:

SQL
ALTER TABLE tx_multishop_products_method_mappings CHANGE id id int(11) NOT NULL AUTO_INCREMENT;
	Current value: int(11) AUTO_INCREMENT
	ALTER TABLE tx_multishop_products_method_mappings CHANGE negate negate tinyint(1) NOT NULL DEFAULT '0';
	Current value: tinyint(1) DEFAULT '0'
	ALTER TABLE tx_multishop_products_flat CHANGE products_id products_id int(11) NOT NULL AUTO_INCREMENT;
	Current value: int(11) AUTO_INCREMENT
	ALTER TABLE tx_multishop_products_flat CHANGE language_id language_id tinyint(2) NOT NULL DEFAULT '0';
	Current value: tinyint(2) DEFAULT '0'
	ALTER TABLE tx_multishop_products_flat CHANGE products_name products_name varchar(255) NOT NULL;
	Current value: varchar(255) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_model products_model varchar(12<img src="typo3conf/ext/mm_forum//res/smilies/icon_cool.gif" alt="icon_cool.gif" /> NOT NULL;
	Current value: varchar(12<img src="typo3conf/ext/mm_forum//res/smilies/icon_cool.gif" alt="icon_cool.gif" /> DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_shortdescription products_shortdescription varchar(255) NOT NULL;
	Current value: varchar(255) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_description products_description text NOT NULL;
	Current value: text
	ALTER TABLE tx_multishop_products_flat CHANGE products_quantity products_quantity int(11) NOT NULL;
	Current value: int(11) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_price products_price decimal(10,4) NOT NULL;
	Current value: decimal(10,4) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE staffel_price staffel_price varchar(127) NOT NULL;
	Current value: varchar(127) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE ean_code ean_code varchar(13) NOT NULL;
	Current value: varchar(13) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE sku_code sku_code varchar(25) NOT NULL;
	Current value: varchar(25) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE specials_new_products_price specials_new_products_price decimal(10,4) NOT NULL;
	Current value: decimal(10,4) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE final_price final_price decimal(10,4) NOT NULL;
	Current value: decimal(10,4) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE final_price_difference final_price_difference decimal(10,4) NOT NULL;
	Current value: decimal(10,4) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_date_available products_date_available int(11) NOT NULL;
	Current value: int(11) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_last_modified products_last_modified int(11) NOT NULL;
	Current value: int(11) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE tax_id tax_id int(5) NOT NULL;
	Current value: int(5) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE tax_rate tax_rate decimal(4,3) NOT NULL;
	Current value: decimal(4,3) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_id categories_id int(5) NOT NULL;
	Current value: int(5) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_name categories_name varchar(150) NOT NULL;
	Current value: varchar(150) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE manufacturers_id manufacturers_id int(5) NOT NULL;
	Current value: int(5) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE manufacturers_name manufacturers_name varchar(32) NOT NULL;
	Current value: varchar(32) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_id_0 categories_id_0 int(5) NOT NULL;
	Current value: int(5) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_name_0 categories_name_0 varchar(150) NOT NULL;
	Current value: varchar(150) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_id_1 categories_id_1 int(5) NOT NULL;
	Current value: int(5) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_name_1 categories_name_1 varchar(150) NOT NULL;
	Current value: varchar(150) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_id_2 categories_id_2 int(5) NOT NULL;
	Current value: int(5) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_name_2 categories_name_2 varchar(150) NOT NULL;
	Current value: varchar(150) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_id_3 categories_id_3 int(5) NOT NULL;
	Current value: int(5) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_name_3 categories_name_3 varchar(150) NOT NULL;
	Current value: varchar(150) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_id_4 categories_id_4 int(5) NOT NULL;
	Current value: int(5) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_name_4 categories_name_4 varchar(150) NOT NULL;
	Current value: varchar(150) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_id_5 categories_id_5 int(5) NOT NULL;
	Current value: int(5) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE categories_name_5 categories_name_5 varchar(150) NOT NULL;
	Current value: varchar(150) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_image products_image varchar(250) NOT NULL;
	Current value: varchar(250) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_image1 products_image1 varchar(250) NOT NULL;
	Current value: varchar(250) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_image2 products_image2 varchar(250) NOT NULL;
	Current value: varchar(250) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_image3 products_image3 varchar(250) NOT NULL;
	Current value: varchar(250) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_image4 products_image4 varchar(250) NOT NULL;
	Current value: varchar(250) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_viewed products_viewed int(11) NOT NULL;
	Current value: int(11) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_date_added products_date_added int(11) NOT NULL;
	Current value: int(11) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_weight products_weight decimal(5,2) NOT NULL;
	Current value: decimal(5,2) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE sort_order sort_order int(11) NOT NULL;
	Current value: int(11) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE product_capital_price product_capital_price decimal(10,4) NOT NULL;
	Current value: decimal(10,4) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE page_uid page_uid int(11) NOT NULL;
	Current value: int(11) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_extra_description products_extra_description text NOT NULL;
	Current value: text
	ALTER TABLE tx_multishop_products_flat CHANGE products_negative_keywords products_negative_keywords varchar(254) NOT NULL;
	Current value: varchar(254) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_meta_title products_meta_title varchar(254) NOT NULL;
	Current value: varchar(254) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_meta_description products_meta_description varchar(254) NOT NULL;
	Current value: varchar(254) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_meta_keywords products_meta_keywords varchar(254) NOT NULL;
	Current value: varchar(254) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_url products_url varchar(255) NOT NULL;
	Current value: varchar(255) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE sstatus sstatus tinyint(1) NOT NULL;
	Current value: tinyint(1) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE price_filter price_filter int(4) NOT NULL;
	Current value: int(4) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE contains_image contains_image tinyint(1) NOT NULL;
	Current value: tinyint(1) DEFAULT ''
	ALTER TABLE tx_multishop_products_flat CHANGE products_multiplication products_multiplication int(11) NOT NULL DEFAULT '0';
	Current value: int(11) DEFAULT '0'
	ALTER TABLE tx_multishop_products_flat CHANGE minimum_quantity minimum_quantity int(11) NOT NULL DEFAULT '1';
	Current value: int(11) DEFAULT '1'
	ALTER TABLE tx_multishop_products_flat CHANGE maximum_quantity maximum_quantity int(11) NOT NULL;
	Current value: int(11) DEFAULT ''


What can I do???

Uli
Written on: 25. 11. 2011 [10:03]
bas
Bas van Beek
Multishop guru
registered since: 12.05.2010
Posts: 644
Can't you press the submit button so it will correct your database fields?
Written on: 25. 11. 2011 [16:07]
ULinn
Uli
Multishop professional
Topic creator
registered since: 14.10.2011
Posts: 34
Of course I can (and did), but it obviously doesn't have any effect. Same procedure when using COMPARE in the install-tool.

But meanwhile the shop is working, although this table-problem remains.

Uli
Written on: 25. 11. 2011 [16:29]
bas
Bas van Beek
Multishop guru
registered since: 12.05.2010
Posts: 644
The TYPO3 Extension manager is sometimes very annoying when it comes to importing the plugins database tables.

It's very strict about the field type definitions and it's default values.

For example it doesn't like this:

int(11) default ''

It supposed to be:

int(11) default '0'

Same approach can be followed for the decimals fields (instead of '' value change it to: '0.000').

This is because an empty value is not an integer value. TYPO3 keeps complaining about this, so you have to fix them manually, or throw your multishop tables away and import the tables that are shipped with multishop.

I think you have to manually fix your database, or throw all multishop tables away and import the ones that are shipped.

Written on: 03. 12. 2011 [19:29]
Martyn
Martijn Kroon
Multishop experienced
registered since: 10.12.2011
Posts: 15
Hello!
I got the same database problems as mentioned above.
Unfortunately I got no clue how to fix it...

The words of Base sounds nice but still don't give a solution for the problem..
I could probably fix the database manually but i don't know how...
Throwing away all Multishop tables and re-importing them don't work either...

When I check in Php myAdmin it looks like the tables are changed

Ulinn did you manage to solve the problem?

Grtz,
Tyn
Written on: 10. 12. 2011 [23:19]
bas
Bas van Beek
Multishop guru
registered since: 12.05.2010
Posts: 644
It's fixed in version 2.0.5. Silly Extension Manager doesn't like:

not null

Should be: NOT NULL
Written on: 11. 12. 2011 [15:27]
ULinn
Uli
Multishop professional
Topic creator
registered since: 14.10.2011
Posts: 34
I just did update to 2.0.6 - No database problems anymore! Great!

Uli
Written on: 20. 12. 2011 [11:04]