[#17656] - New Random Image Module Error
- Closed
- 23 Aug 2017
- Medium
- Build: staging
- # 17656
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, *).
| Labels |
Added:
?
|
||
| Category | ⇒ | com_modules Postgresql |
| Status | New | ⇒ | Discussion |
System information (as much as possible)
Joomla-cms-staging (21/08/2017)
PostgreSQL 9.5.6
PHP 7
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.
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.
@franz-wohlkoenig its a postgres issue - you are on mysql ;)
@brianteeman i wanted to make clear its working on mysql :-)
@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.
With MySQL, you can't select "Ordering" in the New Module page. There is no error message, but it doesn't work too.
There were libraries missing : moduleorder.php, moduleposition.php...
I installed the last staging and it works now.
You can close this issue.
| Status | Discussion | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-08-23 04:27:15 |
| Closed_By | ⇒ | franz-wohlkoenig |
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.
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/17656
Can't confirm.
System information
3.8-dev
Multilanguage Site
macOS Sierra, 10.12.6
Firefox 55 (64-bit)
MAMP 4.1.1