Attribute Types not in DB... 'mydbname.mshop_type' doesn't exist

mzerbe · Post by **mzerbe** » 12 Dec 2025, 05:40

Hi guys,

some time back as on version 24.10.2 I created attribute types, and than attributes, and all was good.

Than I upgraded to 2025.10.2 and later even 2025.20.x-dev while i was trying to troubleshoot this. (initially I thought it's a cache issue.)

However, finally I figured out that attribute types (product domain) are shown in the backend, but all new created attribute types (after upgrade to 25.10.2) do not appear in the database table.

Since not in db table, I can't select them in the attribute form, when I like to create the new attributes for such type.

This is what I liked to do:
Add new Attribute types e.g. : DMM (Multimeter)
add new attributes to this type: accuracy, max voltage, max current, frequency range,....

I forgot to mention initially, after the upgrade i got a few errors in aimeos log:

Code: Select all

/products
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'c1mydbname.mshop_type' doesn't exist:
SELECT mattty."id" AS "attribute.type.id", mattty."siteid" AS "attribute.type.siteid", mattty."ctime" AS "attribute.type.ctime", mattty."mtime" AS "attribute.type.mtime", mattty."editor" AS "attribute.type.editor", mattty."label" AS "attribute.type.label", mattty."code" AS "attribute.type.code", mattty."domain" AS "attribute.type.domain", mattty."pos" AS "attribute.type.position", mattty."status" AS "attribute.type.status", mattty."i18n" AS "attribute.type.i18n"
FROM "mshop_type" mattty

WHERE ( ( mattty."siteid" IN ('','1.') ) AND ( mattty."code" IN (NULL) AND ( mattty."domain" = 'product' AND ( mattty."domain" = 'attribute' AND ( mattty."status" = 1 ) ) ) ) )
GROUP BY mattty."id", mattty."siteid", mattty."ctime", mattty."mtime", mattty."editor", mattty."label", mattty."code", mattty."domain", mattty."pos", mattty."status", mattty."i18n"
ORDER BY mattty."pos" ASC
LIMIT 0 OFFSET 0

since 2025.10.x-dev I see now also:

Code: Select all

Core: Error handler (BE): PHP Warning: Undefined array key 1 in /var/www/...../vendor/aimeos/aimeos-typo3/Classes/Command/SetupCommand.php line 85

This error is true: mshop_type does not exist in the typo3 db. I see only a table mshop_attribute_type

My environment:

VPS: Ampere® Altra® processors:8 Core, 16MB RAM, KVM
# uname -a
Linux 6.1.0-28-arm64 #1 SMP Debian 6.1.119-1 (2024-11-22) aarch64 GNU/Linux
# apache2 -v
Server version: Apache/2.4.65 (Debian)
Server built: 2025-07-29T20:18:46
# cat /etc/debian_version
12.12

ISPConfig3 version 3.3.0p2
open_basedir = none

TYPO3 Version 13.4.22
PHP Version 8.2.29
Database (Default) MySQL 10.11.6-MariaDB-0+deb12u1
Application Context Production
Composer mode Enabled
Operating System Linux 6.1.0-28-arm64
Bootstrap Package 15.0.4

Aimeos shop and e-commerce framework (origin): 24.10.2 than 2025.10.2 --> NOW 2025.10.x-dev
Other extensions: news 12.3.1, video_shariff 4.0.0 wsslider 13.2.2

Post by **aimeos** » 12 Dec 2025, 15:58

Did you update the database using "php ./vendor/bin/typo3 aimeos:setup"?

mzerbe · Post by **mzerbe** » 14 Dec 2025, 07:58

I was running:

Code: Select all

vendor/bin/typo3 aimeos:setup --option=setup/default/demo:0 --verbose

as user webserver (web1:client1 - on my ISPConfig3 server).

All outputs looked normal, no error appeared.

Today I rerun with php as prefix

Code: Select all

php ./vendor/bin/typo3 aimeos:setup --option=setup/default/demo:0 --verbose

and it worked. (verbose output still the same). I'll monitor this next week, and will share if I found anything.

Thanks a lot.

Help for Aimeos