database

database copied to clipboard

Add support for duplicate named query parameters to the mysqli driver

6

### Summary of Changes Added support for duplicate named query parameters to the `mysqli` and `sqlsrv` drivers. What I mean is something like this: ```mysql SELECT * FROM dbtest WHERE...

nikosdion

Pull Request for Issue #290 . Alternative to PR #291 . See also https://github.com/joomla/joomla-cms/issues/42333 . ### Summary of Changes Use the `ROW_NUMBER()` window function for MariaDB 11.0.0 and newer. That...

richard67

With Mariadb 11.1.2 ordering of table is broken

4

Copy from https://issues.joomla.org/tracker/joomla-cms/42333 https://github.com/joomla/joomla-cms/issues/42333 --- ### FURTHER BUG REPORT I took a closer look at the function `reorder` and found out that the query is created with a windows function...

tkuschel

FIX With Mariadb 11.1.2 ordering of table is broken #290

8

Pull Request for Issue #290 also see https://issues.joomla.org/tracker/joomla-cms/42333 ### Summary of Changes Removed `public function selectRowNumber($orderBy, $orderColumnAlias)` in `MysqlQueryBuilder.php` it already works within `DatabaseQuery.php` with window function `ROW_NUMBER()` ### Testing...

tkuschel

Pull Request for Issue #298 ### Summary of Changes - `php ./cli/joomla.php database:export --folder ./tmp --zip` is now able to export all tables and compress them in a single zip...

Haran

Exporting all tables in zip results in one file with one table in it instead of all tables

1

### Steps to reproduce the issue 1. Have regular joomla database and installation 2. Run `php cli/joomla.php database:export --folder ./tmp --zip` 3. Assert it succeeds ### Expected result 1. Have...

Haran

Joomla 5: MySQL Error -- 2014 - Commands out of sync; you can't run this command now

3

I am working to upgrade a module from Joomla 3 to Joomla 5. I'm using Joomla 5.0.2, PHP 8.2 and the module I'm upgrading has multiple dropdowns. I'm running into...

mbond87

postgresql 16 release

2

Pull Request for Issue (https://github.com/joomla/joomla-cms/issues/42335) ### Summary of Changes as per https://www.postgresql.org/docs/current/release-16.html Remove read-only server variables lc_collate and lc_ctype ### Testing Instructions with Postgres 16 Go to admin area. Try...

alikon

Enable 'SQL_BIG_SELECT'

20

Enabled this to support certain issues (especially when upgrading Joomla) with providers that have this setting disabled by default. I experienced issues when upgrading a vanilla version of Joomla 4.1.4...

stephan-ansems

### Steps to reproduce the issue Have a database with big tables and run the exporter on the CLI with a more or less restrictive memory limit. At some point...

Hackwar