Unknown column 'quantity_field' error

  • Stephan Hodges
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
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.

Please Log in or Create an account to join the conversation.

More
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

Please Log in or Create an account to join the conversation.

  • Stephan Hodges
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
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