- Posts: 146
- Thank you received: 11
Unknown column 'quantity_field' error
- Stephan Hodges
- Topic Author
- Offline
- Premium Member
-
Less
More
10 years 8 months ago #66419
by Stephan Hodges
Unknown column 'quantity_field' error was created by Stephan Hodges
We are suddenly getting message for ALL events from Calendar selection or category description pages. Perhaps this started when I upgraded a week or two ago, but I think it happened only today, after adding a new event category and then a new event. It's the first time since the upgrade that I've added either an event or category.
hymcillinois.com/programs/all-events-calendar
hymcillinois.com/programs/workshops
Error message:
1054 - Unknown column 'quantity_field' in 'where clause' SQL=SELECT * FROM utfl_eb_fields WHERE published=1 AND quantity_field = 1 AND quantity_values != "" AND `access` IN (1,1,5,7) AND (event_id = -1 OR id IN (SELECT field_id FROM utfl_eb_field_events WHERE event_id=2864))
I searched the forum but didn't get any results for this error, so I've posted an urgent ticket #31766 as well with login information.
hymcillinois.com/programs/all-events-calendar
hymcillinois.com/programs/workshops
Error message:
1054 - Unknown column 'quantity_field' in 'where clause' SQL=SELECT * FROM utfl_eb_fields WHERE published=1 AND quantity_field = 1 AND quantity_values != "" AND `access` IN (1,1,5,7) AND (event_id = -1 OR id IN (SELECT field_id FROM utfl_eb_field_events WHERE event_id=2864))
I searched the forum but didn't get any results for this error, so I've posted an urgent ticket #31766 as well with login information.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
10 years 8 months ago #66428
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Unknown column 'quantity_field' error
It seems the upgrade was not successfully for some reasons. As replied via support ticket, our support staff has solved the issue
In the future, if you have issue like that, usually run yoursite.com/administrator/index.php?opt...booking&task=upgrade will fix the bug
Tuan
In the future, if you have issue like that, usually run yoursite.com/administrator/index.php?opt...booking&task=upgrade will fix the bug
Tuan
Please Log in or Create an account to join the conversation.
- Stephan Hodges
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 146
- Thank you received: 11
10 years 8 months ago #66431
by Stephan Hodges
Replied by Stephan Hodges on topic SOLVED** Unknown column 'quantity_field' error
Thanks. I didn't know that trick. I did try and do another "upgrade" from the same version number. Too bad that didn't do the "upgrade" trick that you just mentioned.
Please Log in or Create an account to join the conversation.
Moderators: Tuan Pham Ngoc
Support
Documentation
Information
Copyright © 2026 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.