New Random Image Module Error

[twister65]

Steps to reproduce the issue

Log in as administrator
Extensions -> Modules
New -> Random Image
Set Title, Image Folder, and Position
Save

Expected result

Creation of a new random image module

Actual result

System information (as much as possible)

Joomla-cms-staging (21/08/2017)
PostgreSQL 9.5.6
PHP 7

Additional comments

ERROR: null value in column "ordering" violates not-null constraint DETAIL: Failing row contains (94, 0, Images, , , null, position-7, 0, 1970-01-01 00:00:00, 1970-01-01 00:00:00, 1970-01-01 00:00:00, 1, mod_random_image, 1, 1, {"type":"jpg","folder":"images/space","link":"","width":"","hei..., 0, *).

[ghost]

Can't confirm.

System information

3.8-dev
Multilanguage Site
macOS Sierra, 10.12.6
Firefox 55 (64-bit)

MAMP 4.1.1

• PHP 7.0.15
• MySQLi 5.6.35

[twister65]

System information (as much as possible)

Joomla-cms-staging (21/08/2017)
PostgreSQL 9.5.6
PHP 7

[twister65]

If you set Title, Image Folder, Position, and Ordering : it works !
The default value of ordering column in the insert query is NULL.
Ordering Column can't be NULL (NOT NULL) in the __modules table.

[twister65]

When you create a new module, the ordering is not pre-filled, whatever module you choose.
Before, with Joomla!3.7.5, ordering was a combobox (text now) and pre-filled.

[brianteeman]

@franz-wohlkoenig its a postgres issue - you are on mysql ;)

[ghost]

@brianteeman i wanted to make clear its working on mysql :-)

[twister65]

[Schmidie64]

@icampus
I also couldn't reproduce this item with MySQL its definitely an PostSQL Bug.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/17656.}

[twister65]

With MySQL, you can't select "Ordering" in the New Module page. There is no error message, but it doesn't work too.

[twister65]

There were libraries missing : moduleorder.php, moduleposition.php...
I installed the last staging and it works now.
You can close this issue.

[joomla-cms-bot]

Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/17656

[ghost]

closed as stated above. @twister65 glad you have solve the Issue.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/17656.}