?
avatar rjharishabh
rjharishabh
27 Apr 2021

Steps to reproduce the issue

Users > Fields And Content > Fields

Expected result

The error should not occur

Actual result

Error : 500
Unknown column 'a.only_use_in_subform' in 'field list'

error-field

System information (as much as possible)

‎4.0.0-beta8-dev
PHP 8.0.3
Chrome & Firefox on Windows 10
MySQLi 10.4.18-MariaDB

avatar rjharishabh rjharishabh - open - 27 Apr 2021
avatar joomla-cms-bot joomla-cms-bot - change - 27 Apr 2021
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 27 Apr 2021
avatar joomdonation
joomdonation - comment - 27 Apr 2021

Hello

Could you please install Joomla4 nightly build and check it again?

avatar rjharishabh rjharishabh - change - 27 Apr 2021
The description was changed
avatar rjharishabh rjharishabh - edited - 27 Apr 2021
avatar rjharishabh
rjharishabh - comment - 27 Apr 2021

@joomdonation
There are two Which I have to download

Joomla_4.0.0-beta8-dev-Development-Full_Package.zip
Joomla_4.0.0-beta8-dev-Development-Update_Package.zip

avatar joomdonation
joomdonation - comment - 27 Apr 2021

For more information, the field was added in this PR #33096 . Not sure how you updated your site, but maybe the issue happens because the SQL update script is not executed

Install nightly build or execute this SQL command to your database should solve the issue:

ALTER TABLE `#__fields` ADD COLUMN `only_use_in_subform` tinyint(1) NOT NULL DEFAULT 0;

(Of course replace #__ with table prefix used in your database)

avatar joomdonation
joomdonation - comment - 27 Apr 2021

In your case, maybe download the full package Joomla_4.0.0-beta8-dev-Development-Full_Package.zip and setup the site from scratch would be better (or execute the SQL command manually as mentioned above)

avatar sandramay0905
sandramay0905 - comment - 27 Apr 2021

Can't confirm on a installation today via launch.joomla.org.

image

avatar rjharishabh
rjharishabh - comment - 27 Apr 2021

It's not on nightly-builds
It's on git installation

avatar rjharishabh rjharishabh - change - 27 Apr 2021
Status New Closed
Closed_Date 0000-00-00 00:00:00 2021-04-27 05:30:09
Closed_By rjharishabh
avatar rjharishabh rjharishabh - close - 27 Apr 2021
avatar rjharishabh
rjharishabh - comment - 27 Apr 2021

Thanks @joomdonation
After executing the SQL command, the error was resolved

Add a Comment

Login with GitHub to post a comment