update

Questions around the TYPO3 integration and plugins
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Stefan80
Posts: 42
Joined: 27 Nov 2017, 09:57

update

Post by Stefan80 » 01 Nov 2019, 08:35

Hello,

I want to update an old TYPO3 (7.6) Aimeos installation (17.4.1) to the newest version (19.10.1).

I installed the new Aimeos version, run the update script of the extension and removed the Aimeos extension template from the root template and add it again (and cleared all Caches).

But the Aimeos extension crashed and when I click on the Aimeo icon in the Backend I get an "Oops, an error occurred!" error:

Code: Select all

Argument 1 passed to Aimeos\MShop\Price\Item\Standard::setTaxRates() must be of the type array, float given, called in .../typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/src/MShop/Order/Manager/Base/Service/Standard.php on line 910

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: update

Post by aimeos » 01 Nov 2019, 09:03

Do you have a stack trace available?

Possible issues could be:
- You have a custom extension that modifies the basket that isn't prepared for multiple tax rates yet
- There's an old extension not updated yet in your installation

The update script finished without an error and shows the time required for the setup at the end?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Stefan80
Posts: 42
Joined: 27 Nov 2017, 09:57

Re: update

Post by Stefan80 » 01 Nov 2019, 09:15

No, I get an error in the end of the executed script (setup process lasted 6.214971 sec):

Code: Select all

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '63-1-de-' for key 'unq_msindte_pid_sid_lid_url': CREATE UNIQUE INDEX unq_msindte_pid_sid_lid_url ON mshop_index_text (prodid, siteid, langid, url)

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: update

Post by aimeos » 01 Nov 2019, 09:20

Product with ID 63 (and at least one other) seems to have no label, name and URL segment. At least the label is required.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Stefan80
Posts: 42
Joined: 27 Nov 2017, 09:57

Re: update

Post by Stefan80 » 01 Nov 2019, 12:27

But the process how to update the 17.4.1 version to the 19.10.1 build is correct (see first Thread) ?

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: update

Post by aimeos » 01 Nov 2019, 12:39

You should remove any custom Aimeos extensions first, then do the upated as described and at last migrate your own code.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Stefan80
Posts: 42
Joined: 27 Nov 2017, 09:57

Re: update

Post by Stefan80 » 04 Nov 2019, 09:44

The DB is MySQL 5.6 - is that maybe a problem?

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: update

Post by aimeos » 04 Nov 2019, 11:33

Don't think so. Have you checked product with ID 63?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Stefan80
Posts: 42
Joined: 27 Nov 2017, 09:57

Re: update

Post by Stefan80 » 12 Dec 2019, 08:30

I think the aimeos database is crashed.

When I first updated to the 19.10.1 aimeos-TYPO3-version (using the Extension Manager) I got this error after the update:

SQLSTATE[HY000]: General error: 1553 Cannot drop index 'IDX_628DFA7F4842F28': needed in a foreign key constraint: DROP INDEX idx_628dfa7f4842f28 ON mshop_locale

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: update

Post by aimeos » 13 Dec 2019, 08:54

In the Aimeos TYPO3 extension 19.10.2, some improvements regarding the update process have been made and the upcoming 19.10.3 (next week) will improve that more.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply