Feeling Lucky
?
[#15142] - Unknown column 'a.name' in 'field list'
- Closed
- 7 Apr 2017
- Medium
- Build: Build
- # 15142
Steps to reproduce the issue
After update Joomla 3.7.0 beta4 to Joomla! 3.7.0-rc1
Expected result
Unknown column 'a.name' in 'field list'
Actual result
System information (as much as possible)
Additional comments
joomla-cms-bot
- 
mihailnovak
- comment
- 6 Apr 2017
No access to custом fields in administration.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/15142.
mbabker
- comment
- 6 Apr 2017
You have to do it in the database.
mihailnovak
- comment
- 6 Apr 2017
Thank you mbabker!!!
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/15142.
Bakual
- | Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-04-07 04:57:15 |
| Closed_By | ⇒ | Bakual |
ghazal
- comment
- 17 Apr 2017
For reasons linked to my DB settings, I had to remove my fields table and re-insert it with:
SET sql_mode = '';
SET sql_mode = '';
CREATE TABLE `xxxx_fields` (
`id` int(10) UNSIGNED NOT NULL,
`asset_id` int(10) NOT NULL DEFAULT '0',
`context` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`group_id` int(10) NOT NULL DEFAULT '0',
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
...... etc ....
to rename "alias" to "name".
ymages
- comment
- 27 Apr 2017
ALTER TABLE prefix_fields CHANGE alias name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
franz-wohlkoenig
- | Priority | Critical | ⇒ | Medium |
Known issue with how database upgrades are managed for non-stable releases, see #13661
In your
#__fieldstable, rename the alias column to name and you'll be good.