Unable to create new listing and add/edit page for a newly added table?
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
-
- Posts: 26
- Joined: 16 Oct 2023, 15:05
Unable to create new listing and add/edit page for a newly added table?
Hi, I have a new table mshop_taxcode. So I created the class files like below and made changes accordingly (I tried to replicate mshop_service)
packages\npk\src\MShop\Taxcode\Exception.php
packages\npk\src\MShop\Taxcode\Item\Iface.php
packages\npk\src\MShop\Taxcode\Item\Standard.php
packages\npk\src\MShop\Taxcode\Manager\Base.php
packages\npk\src\MShop\Taxcode\Manager\Iface.php
packages\npk\src\Mshop\Taxcode\Manager\Standard.php
So when go to listing page, I am getting this error. Any idea what this could be?
Aimeos\Base\DB\Exception {#1578 ▼ // packages\npk\src\Admin\JQAdm\Base.php:745
#message: """
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mtax.id' in 'order clause':
\t\t\t\tSELECT "id", "siteid", "ctime", "mtime", "editor"
\t\t\t\tFROM "mshop_taxcode"
\t\t\t\t
\t\t\t\tWHERE 1 = 1
\t\t\t\tGROUP BY mtax."id", "id"
\t\t\t\tORDER BY mtax."id" ASC
\t\t\t\tLIMIT 25 OFFSET 0
\t\t\t
packages\npk\src\MShop\Taxcode\Exception.php
packages\npk\src\MShop\Taxcode\Item\Iface.php
packages\npk\src\MShop\Taxcode\Item\Standard.php
packages\npk\src\MShop\Taxcode\Manager\Base.php
packages\npk\src\MShop\Taxcode\Manager\Iface.php
packages\npk\src\Mshop\Taxcode\Manager\Standard.php
So when go to listing page, I am getting this error. Any idea what this could be?
Aimeos\Base\DB\Exception {#1578 ▼ // packages\npk\src\Admin\JQAdm\Base.php:745
#message: """
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mtax.id' in 'order clause':
\t\t\t\tSELECT "id", "siteid", "ctime", "mtime", "editor"
\t\t\t\tFROM "mshop_taxcode"
\t\t\t\t
\t\t\t\tWHERE 1 = 1
\t\t\t\tGROUP BY mtax."id", "id"
\t\t\t\tORDER BY mtax."id" ASC
\t\t\t\tLIMIT 25 OFFSET 0
\t\t\t
Re: Unable to create new listing and add/edit page for a newly added table?
It needs to be
In the latest version, you can create managers much easier:
https://aimeos.org/docs/latest/models/create-managers/
Code: Select all
FROM "mshop_taxcode" AS mtax
https://aimeos.org/docs/latest/models/create-managers/
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