Page 1 of 1

update

Posted: 01 Nov 2019, 08:35
by Stefan80
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

Re: update

Posted: 01 Nov 2019, 09:03
by aimeos
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?

Re: update

Posted: 01 Nov 2019, 09:15
by Stefan80
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)

Re: update

Posted: 01 Nov 2019, 09:20
by aimeos
Product with ID 63 (and at least one other) seems to have no label, name and URL segment. At least the label is required.

Re: update

Posted: 01 Nov 2019, 12:27
by Stefan80
But the process how to update the 17.4.1 version to the 19.10.1 build is correct (see first Thread) ?

Re: update

Posted: 01 Nov 2019, 12:39
by aimeos
You should remove any custom Aimeos extensions first, then do the upated as described and at last migrate your own code.

Re: update

Posted: 04 Nov 2019, 09:44
by Stefan80
The DB is MySQL 5.6 - is that maybe a problem?

Re: update

Posted: 04 Nov 2019, 11:33
by aimeos
Don't think so. Have you checked product with ID 63?

Re: update

Posted: 12 Dec 2019, 08:30
by Stefan80
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

Re: update

Posted: 13 Dec 2019, 08:54
by aimeos
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.