Issue about "mobile" column

How to configure and adapt Aimeos based shops as developer
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Gagik
Posts: 38
Joined: 05 Dec 2023, 06:58

Issue about "mobile" column

Post by Gagik » 18 Dec 2023, 14:35

Hello,

PHP version: 8.1
Laravel version: 10
Aimeos version: 2023.10
Environment: Linux
Database: MySQL

I have issue related to the "mobile" columns in my database.
When I run command 'php artisan aimeos:setup --option=setup/default/demo:1' or 'php artisan aimeos:setup', I don't have column 'mobile' for example in table 'users_address'. My project works good.
But when I deploy my project to the 'production' I'm facing with the following issue

Column not found: 1054 Unknown column 'mcus.mobile' in 'field list':
SELECT
mcus."id" AS "customer.id", mcus."siteid" AS "customer.siteid",
mcus."name" AS "customer.label", mcus."email" AS "customer.code",
mcus."company" AS "customer.company", mcus."vatid" AS "customer.vatid",
mcus."salutation" AS "customer.salutation", mcus."title" AS "customer.title",
mcus."firstname" AS "customer.firstname", mcus."lastname" AS "customer.lastname",
mcus."address1" AS "customer.address1", mcus."address2" AS "customer.address2",
mcus."address3" AS "customer.address3", mcus."postal" AS "customer.postal",
mcus."city" AS "customer.city", mcus."state" AS "customer.state",
mcus."countryid" AS "customer.countryid", mcus."langid" AS "customer.languageid",
mcus."telephone" AS "customer.telephone",mcus."telefax" AS "customer.telefax",
mcus."email" AS "customer.email", mcus."website" AS "customer.website",
mcus."longitude" AS "customer.longitude", mcus."latitude" AS "customer.latitude",
mcus."birthday" AS "customer.birthday", mcus."status" AS "customer.status",
mcus."email_verified_at" AS "customer.dateverified", mcus."password" AS "customer.password",
mcus."created_at" AS "customer.ctime", mcus."updated_at" AS "customer.mtime",
mcus."editor" AS "customer.editor", mcus."mobile" AS "customer.mobile",
mcus."superuser" AS ".super"
FROM "users" mcus

WHERE ( ( mcus."siteid" IN ('','1.') ) AND ( ( mcus."id" = 3 ) ) )
GROUP BY mcus."id", mcus."id"
ORDER BY mcus."id" ASC
LIMIT 100 OFFSET 0

My local database is same with my production database. Same version, same data, same tables.

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

Re: Issue about "mobile" column

Post by aimeos » 22 Dec 2023, 09:19

The "mobile" column must be part of "users_address" table:
https://github.com/aimeos/ai-laravel/bl ... er.php#L80

Check why it's not added in your setup.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply