search

joomlaboat / custom-tables

The Custom Tables extension allows you to create, manage, and display custom data on your Joomla site. It is helpful if you need to display data that is not part of the standard Joomla content structure. For example, you could use this extension to create a custom table for product information, customer data, or any other type of data that you need to display on your site. The Custom Tables is the CRUD solution for Joomla 3.x and 4.x - CREATE, READ, UPDATE and DELETE. You can add tables, fields, and layouts to create catalogs, forms, or details pages. It has 40 Field Types: Integer (numbers), Decimal, Text String, Time, Email, Color, Image, File, User, Language, etc.
https://joomlaboat.com/custom-tables
GNU General Public License v2.0
35 stars 11 forks source link

Problem creating new field in table #59

Closed mennoswaak closed 4 months ago

mennoswaak commented 11 months ago

When I try te make a new field in an existing table this error message apears:

Field 'asset_id' doesn't have a default value You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(40) null COMMENT 'Geboorteplaats'' at line 1 Could not save the field.

What can be the course?

joomlaboat commented 11 months ago

Hello Menno,

Please delete "asset_id", "params", "version" and "hits" fields. They are not used. They are created by an ancient version of the Custom Tables.

ALTER TABLE #__customtables_fields DROP asset_id, DROP params, DROP version, DROP hits;

mennoswaak commented 11 months ago

that helped; it is working now. I cab add fields and even fill them in the backend But adding the newly made fields into the layouts is not working. There is an erros message saying: 0 Typed property CustomTables\Layouts::$layoutId must not be accessed before initialization please help me with this as well thanks in advance

joomlaboat commented 11 months ago

Please show me a screen-shot where the message appears and/or the file name and the line - in Debug mode.

joomlaboat commented 9 months ago

Hello Menno, could you fix the problem? I need to see the error message when it appears.

joomlaboat commented 7 months ago

Hello Menno,

Please update to 3.2.0 version. Many many bugs are fixed. Please try.