Joomla Extensions by Joomdonation

Error 1054 in different languages

  • Fred Almeida
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 5 months ago - 9 years 5 months ago #72809 by Fred Almeida
Error 1054 in different languages was created by Fred Almeida
Hi,

I just updated Event Booking this week and it seems the "Language: All" option is gone. Now the error below is appearing when we are supposed to load a category list in a language other than the main one.

1504 error
Unknown column 'alias_es' in 'field list' SQL=SELECT id, alias_es-ES AS alias, parent FROM tcgwu_eb_categories
It appears the page you were looking for doesn't exist. Sorry about that.


main language portuguese OK:
www.linguaculturabrasil.com/index.php?op...temid=439&lang=pt-BR

second language spanish: 1504 ERROR
www.linguaculturabrasil.com/index.php?op...temid=438&lang=es-ES

.Any tips?
Last edit: 9 years 5 months ago by Fred Almeida. Reason: add links to clarify the issue...

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

  • Vincent Schuurhuis
  • Offline
  • Junior Member
  • Junior Member
More
9 years 5 months ago #72812 by Vincent Schuurhuis
Replied by Vincent Schuurhuis on topic Error 1054 in different languages
Try the following procedure.

Login to the admin of your site
Go to the event booking component( dashboard)
Select the categories
Open/ edit a random category
Select save and close

Do the same for a random event.

Your database has now been extended with the needed fields for spanish usage.

The last ( and most time consuming) is to open every category and event and go to the tab translation. For every language you have to provide at least a name. The same for custom fields and messages.

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

  • Fred Almeida
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 5 months ago - 9 years 5 months ago #72813 by Fred Almeida
Replied by Fred Almeida on topic Error 1054 in different languages
Thank you for your quick reply. The problem persists, though... :(

I did the editing and the save+close for both a category and an event. Prior to writing you, I had already added names and translations (copied the descriptions) to every open event and category as I wondered this could have been the issue.

Now, I just translated the custom fields and the I'm getting the same error. Any other ideas? Your friend here is about to have a heart attack! :pinch:
Last edit: 9 years 5 months ago by Fred Almeida.

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

  • Vincent Schuurhuis
  • Offline
  • Junior Member
  • Junior Member
More
9 years 5 months ago #72819 by Vincent Schuurhuis
Replied by Vincent Schuurhuis on topic Error 1054 in different languages
Do you have access to your database via a tool like PhpMyAdmin
Can you check if the table tcgwu_eb_categories has the field alias_es or any other fields which have a suffix like _es

The additional fields for mulitlangual support must be the last columns of the table.
Do you see any fields(columns) which begin with "alias_"

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

  • Fred Almeida
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 5 months ago #72820 by Fred Almeida
Replied by Fred Almeida on topic Error 1054 in different languages
Yes. For both spanish and english (see attached table structure)
Attachments:

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

  • Vincent Schuurhuis
  • Offline
  • Junior Member
  • Junior Member
More
9 years 5 months ago #72821 by Vincent Schuurhuis
Replied by Vincent Schuurhuis on topic Error 1054 in different languages
Strange, there seems to be some kind of other interpretation for the language code.
Th SQL statement includes the field alias_es-ES, but the error message is stating the field alias_es is missing. Based on the database this is correct, this field is not present in the database.

As far as I can see you have three languages installed for your site, Portuguese which is working with event booking, Spanish which is causing trouble. How about the English option, do you also get an error message when English is set as language on your site.

Did you change/alter some parameters for the languages or did you only update event booking to version 2.1.0

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

  • Fred Almeida
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 5 months ago #72822 by Fred Almeida
Replied by Fred Almeida on topic Error 1054 in different languages
en-US also not working. The only change was the update and everything was working fine for all the languages . Before the update events were "all" languages.

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

More
9 years 5 months ago #72828 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Error 1054 in different languages
Hi Fred

1. Please download latest version of Events Booking and upgrade it to your site

2. After that, from any page in Events Booking (for example, events management page), access to Tools => Fix Database Schema

Doing that will update the database schema to latest version and also add missing fields if you are using additional languages

3. After that, please check it again and update us with the result

4. Please also note that if you update from a very old version, the way multilingual works is now changed. Instead of creating different events, each event for one language in the past, we now just create an event, then on event add/edit page, there will be an additional tab called Translation to allow you to translate the events to all extra languages

Regards,

Tuan

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

  • Fred Almeida
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 5 months ago - 9 years 5 months ago #72862 by Fred Almeida
Replied by Fred Almeida on topic Error 1054 in different languages
I just took all the steps suggested and the problem persists. :(

Just FYI, this is the first upgrade I did from a version downloaded around Feb/Mar this year. I noticed the language management change and added translated infos for each one. I'd appreciate your help as this is our main form of registering new students.
Last edit: 9 years 5 months ago by Fred Almeida.

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

  • Vincent Schuurhuis
  • Offline
  • Junior Member
  • Junior Member
More
9 years 5 months ago #72885 by Vincent Schuurhuis
Replied by Vincent Schuurhuis on topic Error 1054 in different languages
Do you get an error message like this only on the front-end or also on the back-end?
If you do not get an error message on the back-end can you try to login at het backend with the language set to english and open several functions of the event booking module.

I have checked any of the sources of the latest 2.1.0 version and all the fields necessary for category view which are language dependant the suffix is extracted from the language table, the field which is used is sef.
Could you post a screenshot of the content of the language table to see the values for lang_code and sef.

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

Moderators: Tuan Pham Ngoc

Support

Documentation

Information

Copyright © 2025 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