Great Problem with WS_Concat

How to fix WS_Concat unknown column error after installing ChronoMyAdmin in ChronoForms.

Overview

The problem is caused by an outdated SQL library in other Chrono extensions, which conflicts with the updated SQL syntax used by ChronoForms 8.
Reinstall ChronoForms 8 to update its SQL library, ensuring compatibility with the latest SQL functions like CONCAT_WS and resolving the unknown column error.

Answered
ChronoForms v8
Fr Fredolino 23d ago

After install ChronoMyAdmin have i a Problem with my WS_Concat in a form Unknown Column concat_ws (",Gattung, ...) in select. And i can Form Not Open. And after the Deinstall the Problem Not going.  Wat can i do?

Fr Fredolino 22d ago
1 Likes

Problem solved. I must CF 8 install new.

The Message wars that SQL new updated.

Max_admin Max_admin 22d ago
Answer

ChronoForms 8 has the latest library update, other Chrono extensions may not have this.

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Fr Fredolino 22d ago

But the Problem ist: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`bundesland`='BB'' at line 1

and i have the Message in Green: row deleted.

But row ist Not deleted...

Max_admin Max_admin 21d ago

But installing the latest ChronoForms8 solved the issue or not ?

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Fr Fredolino 20d ago

Okay, the first Problem ist solved. This Message ist new in Backend from the Extension.

Max_admin Max_admin 19d ago

I will need the full SQL query then, is this a Delete Data action inside a form ?

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Fr Fredolino 18d ago

Hi Max,

I select my table directly in ChronoAdmin, open it, and look for the row I want to delete. There are "Edit" and "Delete" buttons at the beginning of the row. I click "Delete." I get a notification, but the record isn't actually deleted. However, if I use phpMyAdmin via my hosting provider, I can delete the row without any issues.

F.

Max_admin Max_admin 13d ago

Hi Fredolino

I did not understand from the question that is for ChronoMyAdmin, I will check that and update you

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Fr Fredolino 13d ago

Hi Max,

What I mean is that the delete button (see screenshot) didn't work. I get a message stating that the record has been deleted, but it hasn't actually been deleted.If I delete the record directly in the database via phpMyAdmin instead of using ChronoMyAdmin, it works without any issues.

F.

Max_admin Max_admin 6d ago

Hi Fredolino

Your table has primary key as one column or more than 1 ?

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Post a Reply