Critical error while install CF8 on Joomla6 with PostgreSQL18

How to fix ChronoForms 8 installation error on Joomla with PostgreSQL database.

Overview

The problem is that ChronoForms 8 uses MySQL/MariaDB-specific SQL syntax, which is incompatible with PostgreSQL, causing table creation to fail and blocking the admin panel.
Switch your Joomla database to MySQL or MariaDB, as ChronoForms 8 is designed for these systems and does not support PostgreSQL.

Answered
Bugs ChronoForms v8
Ro Roman77 14d ago

Hi guys,I've get error while install CF8 at Jooma 6.1.3 (Apache 2.4, PHP 8.4, PostgreSQL 18):"An error has occurred. 42 42P01, 7, ERROR: relative "roden_chronog3_extensions" doesn't LINE 1: SELECT * FROM "roden_chronog3_extensions" WHERE "name"='com_... ^"

All 3 CF8 tables couldn't be created and admin panel was blocked. I suppose it was due the CF8 is made for MySQL/MariaDB and some PostgreSQL syntax is slightly differs.

So question is that does CF8 works with PostgreSQL or not? May I create this tables manually and CF will work or this doesn't matter and I need only MariaDB/MySQL? Or may be this is just a little bug and you can update installation script?

Max_admin Max_admin 14d ago
Answer

Hi Roman

ChronoForms8 uses the MySQL/MariaDB syntax, I think the syntax may not work on PostgreSQL.

So can you try to switch your database to MySQL or MariaDB ? this is the very common configuration with PHP and Joomla/WordPress.

I know PostgreSQL is more performant but also takes more resources.

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Ro Roman77 14d ago
1 Likes

Hi Max,thanks for the quick and comprehensive reply.

Max_admin Max_admin 13d ago

You are welcome.

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