Joomla Gallery Support

Hello OrdaSoft

Thank you very much. I have installed the new version, but the problem persists. For example, when creating a new gallery, the following error appears:
An error has occurred.
1054 Unknown column 'gc.ordering' in 'SELECT'
which indicates a database error.

Sincerely,
Rudolf

Hello Rudolf.

I am sorry, but for us all good.

You may:
Please in joomla admin menu: System->"global configuration->Server: "Error Reporting" - turn to "Maximum" development default
Please in joomla admin menu: System->"global configuration"-> System -> Debug Settings ->YES

And show to us full error report.

BUT, I think we need FTP and Admin access - to yours website (or to yours test website) - where we may reproduce this error

Regards
OrdaSoft team

Dear OrdaSoft Support Team,

I would like to report a critical issue with OS Image Gallery Pro 6.2.1 on Joomla 6 / PHP 8.x.

When saving images (in an existing or newly created gallery), the following request is triggered repeatedly:

index.php?option=com_osgallery&task=save_gallery&format=raw

This request returns an HTTP 500 Internal Server Error.
Because the error is not handled on the client side, the AJAX request enters an infinite loop, and the save process never completes.

Based on debugging (Joomla debug + browser network inspection), the root cause is a server-side PHP fatal error occurring during the execution of task=save_gallery under Joomla 6 / PHP 8.x.

Please note:

This is not a configuration issue

Database structure is correct

The problem is reproducible

The issue is clearly caused by incompatible or faulty code in the save handler

For security and data protection reasons, I cannot provide Joomla admin or FTP access to the production system.

Please provide:

a code patch

or an updated version fixing this issue

Thank you for your support. I am looking forward to your technical feedback.

Kind regards
Rudolf

Dear OrdaSoft Support Team,

I would like to report another reproducible bug in OS Image Gallery Pro 6.2.1 on Joomla 6.
Confirmed on Joomla 6.x / PHP 8.x

Error:
When creating a new gallery, the following SQL error occurs:

1054 Unknown column 'gc.ordering' in 'SELECT'

Analysis:

After enabling Joomla debug mode, the stack trace clearly shows that the error originates from:

administrator/components/com_osgallery/helpers/osGalleryHelperAdmin.php

In the method displayGallery(), the following line is executed:

$query->order('gc.ordering ASC';

However, in this execution context no table alias gc is defined in the query, which results in the SQL error.

Working fix:

Changing the line to:

$query->order('ordering ASC';

resolves the issue completely.
After this change, new galleries can be created and saved without any SQL errors.

Conclusion:

The database structure is correct
The column ordering exists
The issue is caused by an invalid table alias used in the ORDER BY clause

Please consider fixing this in the official codebase so users do not need to patch core files manually.

For security reasons, I cannot provide backend or FTP access, but the issue is fully reproducible and the fix is confirmed.

Kind regards
Rudolf

Dear OrdaSoft-Team

I have now set up a new subdomain and installed Joomla 6.0.2, Gantry, and my template on it, just like on the original system. Then I installed your gallery extension... and everything is working fine.

As a result, it seems that my Joomla upgrades have left behind remnants that are not compatible with OS Gallery.

My question now is: If I completely uninstall OS Gallery and reinstall it, will I have to set up all the galleries again?

Sincerely,
Rudolf

Hello Rudolf,

we can't reproduce this error.

We tested this at many WebServers and Web websites

I not know where and why - you see this errors, We have a lot places where we use DataBase.

We need access to you webserver - where we can reproduce this error (or to your test website). Please create this for us.

If you send error details, Please turn on "Develop mode and Max error details" - as I wrote.
Please send "FULL error details report"

Regards
OrdaSoft team