Joomla Extensions by Joomdonation

Install error follow-up

  • Fred Dinkler
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 4 months ago - 7 years 4 months ago #118928 by Fred Dinkler
Install error - 1054 Unknown column 'custom_field_ids' in 'field list' was created by Fred Dinkler
Installing EB 3.8.1 on Joomla 3.9 site... php 5.6.1
On install, throws:
1054 Unknown column 'custom_field_ids' in 'field list'
Appears to be coming from the en-GB.com_eventbooking.ini files in admin and site

Post install, Config menu item loads, but main dashboard does not.
1054 Unknown column 'is_searchable' in 'where clause'
Stack track is:
1054 Unknown column 'is_searchable' in 'where clause'
/home1/ballooni/public_html/balloonfestivalregistration/libraries/joomla/database/driver/mysqli.php:661

Call stack
Code:
# Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:661 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 3 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_eventbooking/model/common/registrants.php:58 4 EventbookingModelCommonRegistrants->__construct() JROOT/administrator/components/com_eventbooking/libraries/rad/model/model.php:115 5 RADModel::getInstance() JROOT/administrator/components/com_eventbooking/view/dashboard/html.php:25 6 EventbookingViewDashboardHtml->display() JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308 7 RADController->display() JROOT/administrator/components/com_eventbooking/controller/controller.php:28 8 EventbookingController->display() JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273 9 RADController->execute() JROOT/administrator/components/com_eventbooking/eventbooking.php:34 10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 13 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 14 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 15 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51
Last edit: 7 years 4 months ago by Fred Dinkler. Reason: debugging info

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

  • Fred Dinkler
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 4 months ago #118929 by Fred Dinkler
Replied by Fred Dinkler on topic Install error - 1054 Unknown column 'custom_field_ids' in 'field list'
Strange behavior - I turned on system debug and lang debug, then reinstalled the package - and it completed successfully!
Weird...
Fred

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

More
7 years 4 months ago #118934 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Install error - 1054 Unknown column 'custom_field_ids' in 'field list'
Hi Fred

Sometime, the installation / upgrade was not success and it causes the issue. See eventbookingdoc.joomservices.com/trouble...ng-to-latest-version for solution

Regards,

Tuan

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

  • Fred Dinkler
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 4 months ago #118942 by Fred Dinkler
Replied by Fred Dinkler on topic Install error follow-up
Thanks for the reply.

Note that, while the second installation appeared successful, the form content for Invoice, Ticket and Certificate did not populate - all three are blank.

Also, I would really, really like to see a file field mapping actually work on registration form. I can define a custom field as FILE and then map it to a CB field of type FILE, but the existing file reference is not populated at registration time. Is this on your To Do list?
Thanks for the excellent work...
Fred

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

More
7 years 4 months ago #118948 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Install error follow-up
Hello Fred

1. Actually, I found out the issue with installation script and fixed it (it causes by a feature I added 2 days ago to the package). Guess the content was not populated because the installation was not success. If it's needed, maybe uninstall the extension, remove all related tables from database (tables with _eb_ prefix), then access to My Downloads menu item, download latest package, re-install it to yours tie and it should be fine

2. For File upload custom field, honestly, I don't know how the mapping should work yet. Will try to look at it in the future

Regards,

Tuan

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

More
7 years 4 months ago #118984 by EDUARD TORTOSA
Replied by EDUARD TORTOSA on topic Install error - 1054 Unknown column 'custom_field_ids' in 'field list'
Hi!

Having the same problem as Peguschwein.
Database is fixed and we still have Joomla 3.7.5 and EventBooking 3.1.3.

Any solution available, please?

Thanks in advance,
Edu.

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

More
7 years 4 months ago #118992 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Install error - 1054 Unknown column 'custom_field_ids' in 'field list'
Hello Edu

This is a different issue (might happens on a multilingual website). You should install latest version, then access to this URLs and the issue will be sorted

domain.com/administrator/index.php?optio...sk=tool.fix_row_size
domain.com/administrator/index.php?optio...k=tool.fix_row_size2

Of course, domain.com/administrator/ needs to be replaced with administrator URL of your site

Regards

Tuan

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

More
7 years 4 months ago #119029 by EDUARD TORTOSA
Replied by EDUARD TORTOSA on topic Install error - 1054 Unknown column 'custom_field_ids' in 'field list'
Thank you, Tuan.

Edu.

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

  • Fred Dinkler
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 4 months ago - 7 years 4 months ago #119035 by Fred Dinkler
Replied by Fred Dinkler on topic File field mapping (was: Install error follow-up)
Hey Tuan -
I've written php scripts to scan and zip CB uploaded files. I can describe how CB files are uploaded, named and stored.
As to "how the mapping should work" I would write a use case that, if a file field is mapped in the reg form, then if that file exists, the file is copied to the media/com_eventbooking/{userid} folder and the file name stored in the appropriate ##__eb database table, jsut as if it was uploaded by the user when completing the registration form.
Fred
Last edit: 7 years 4 months ago by Fred Dinkler.

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

  • Fred Dinkler
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 4 months ago #119042 by Fred Dinkler
Replied by Fred Dinkler on topic Install error follow-up
Tuan - Did you roll the patch version on the fixed install? I still see 3.8.1 on the download page. Is that the fixed version?
Fred

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.

Connect Us