Issue about "mobile" column
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!
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Issue about "mobile" column
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.
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.
Re: Issue about "mobile" column
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.
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, give us a star
If you like Aimeos, give us a star