J4 Issue ?
avatar Ninja-007
Ninja-007
22 Oct 2018

Steps to reproduce the issue

Install J4 22.10..1018
Go to menu manager
Create admin menu and set Joomla or Mordern as preset
Click save then you get the following error.

Expected result

Creation of menu without error.

Actual result

This is the error
Menu was saved but failed to import the preset: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY c2.id) AS c2 ON c2.newId = c.id SET published = c2.newPublished' at line 6

System information (as much as possible)

PHP Built On removed
Database Type mysql
Database Version 5.5.61-MariaDB-cll-lve
Database Collation latin1_swedish_ci
Database Connection Collation utf8_general_ci
PHP Version 7.1.23
Web Server Apache
WebServer to PHP Interface litespeed
Joomla! Version Joomla! 4.0.0-alpha5-dev Development [ Amani ] 22-July-2018 22:58 GMT

Relevant PHP Settings
Setting Value

Open basedir None
Display Errors Off
Short Open Tags On
File Uploads On
Output Buffering On
Session Save Path /opt/alt/php71/var/lib/php/session
Session Auto Start 0
XML Enabled Yes
Zlib Enabled Yes
Native ZIP Enabled Yes
Disabled Functions None
Multibyte String (mbstring) Enabled Yes
Iconv Available Yes
Maximum Input Variables 1000

Setting Value
offline
offline_message This site is down for maintenance.
Please check back again soon.
display_offline_message 1
offline_image
sitename Joomla 4 Alpha 5 - 22.10..2018
editor tinymce
captcha 0
list_limit 20
access 1
debug
debug_lang
dbtype mysqli
host xxxxxx
user xxxxxx
password xxxxxx
db gteinc_
dbprefix ap9b9_
live_site
secret removed
gzip
error_reporting default
helpurl https://help.joomla.org/proxy?keyref=Help{major}{minor}:{keyref}&lang={langcode}
ftp_host
ftp_port
ftp_user xxxxxx
ftp_pass xxxxxx
ftp_root
ftp_enable 0
offset UTC
mailonline 1
mailer mail
mailfrom info@igsmart.tech
fromname Joomla 4 Alpha 5 - 22.10..2018
sendmail /usr/sbin/sendmail
smtpauth
smtpuser xxxxxx
smtppass xxxxxx
smtphost localhost
smtpsecure none
smtpport 25
caching 0
cache_handler file
cachetime 15
cache_platformprefix
MetaDesc
MetaKeys
MetaTitle 1
MetaAuthor 1
MetaVersion
robots
sef 1
sef_rewrite
sef_suffix
unicodeslugs
feed_limit 10
feed_email none
log_path removed
tmp_path removed
lifetime 15
session_handler database
shared_session
session_metadata 1

Additional comments

avatar Ninja-007 Ninja-007 - open - 22 Oct 2018
avatar brianteeman brianteeman - change - 23 Oct 2018
Labels Added: J4 Issue ?
avatar brianteeman brianteeman - labeled - 23 Oct 2018
avatar joomla-cms-bot joomla-cms-bot - change - 29 Oct 2018
Closed_Date 2018-10-29 15:46:43 2018-10-29 15:46:44
Closed_By Quy joomla-cms-bot
avatar joomla-cms-bot joomla-cms-bot - close - 29 Oct 2018
avatar Quy Quy - change - 29 Oct 2018
Status New Closed
Closed_Date 0000-00-00 00:00:00 2018-10-29 15:46:43
Closed_By Quy
avatar joomla-cms-bot
joomla-cms-bot - comment - 29 Oct 2018

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

avatar Quy
Quy - comment - 29 Oct 2018

Please test PR #22852


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/22758.

Add a Comment

Login with GitHub to post a comment