Not sure if it is a bug or not but found interesting.
While installing component I notice that my queries doesn't work in j3.5-beta3.
Query Working in J3.4x
INSERT IGNORE INTO `#__redshop_mail` (`mail_id`, `mail_body`) VALUES
(1, '<p>To Admin, {username} </p>');
The same query is not working in J3.5-beta3. While I change query as shown below it works.
INSERT IGNORE INTO `#__redshop_mail` (`mail_id`, `mail_body`) VALUES
(1, '<p>To Admin,</p>');
To make it working in j3.5-beta3 I have to change,
'<p>To Admin,</p>'
to '<p>To Admin, {username} </p>'
Not sure what is changed in j3.5-beta3. But the same query works in j3.4.x and if I paste the query directly in mysql it works.
@andrepereiradasilva it works with 3.5.0 beta 2. Only issue in 3.5 beta 3
just guessing maybe because of a change that was corrected today (see fc43245)
Can you check if your issue remains in latest staging
https://github.com/joomla/joomla-cms/archive/staging.zip
I don't think so - that issue was specifically dealing with hashtags that aren't present in the SQL file dump provided. I need some more information please @gunjanpatel - I don't really have enough here to work with
I don't think it should happen in HTML because i have had experience of such errors in XML,not with HTML tags.
@wilsonge I am going to attach installer in which I am having issue. May be it will help to reproduce it.
HelloWorldj3.5.beta3
I could install OK HelloWorldj3.5.beta3 on staging (localhost)
I have been able to isolate the problem. The issue happens when using a #
symbol in the sql. This fails:
data.sql:
INSERT IGNORE INTO `#__helloworld_mail` (`mail_id`, `mail_name`, `mail_subject`, `mail_section`, `mail_order_status`, `mail_body`, `published`, `mail_bcc`) VALUES
(24, 'Order Status Change Pending', 'Order Status Change Pending', 'order_status', 'P', '#', 1, ''),
(25, 'Order Status Change Confirmed', 'Order Status Change Confirmed', 'order_status', 'C', '#', 1, '');
But if you remove the #
at ...'order_status', 'P', '#', 1, ''),...
and at ...er_status', 'C', '#', 1, '');
It works
I'm attaching the example component refactored:
I confirm @infograf768 comment the problem does not happen in staging
:
It appears only testing against https://github.com/joomla/joomla-cms/releases/tag/3.5.0-beta3
Then this can be closed then as it has already been fixed
On 3 March 2016 at 10:20, javier gomez notifications@github.com wrote:
I confirm @infograf768 https://github.com/infograf768 comment the
problem does not happen in staging:[image: screen shot 2016-03-03 at 11 19 16]
https://cloud.githubusercontent.com/assets/1375475/13491269/d4bf0030-e131-11e5-9cd4-8d64f2722d86.pngIt appears only testing against
https://github.com/joomla/joomla-cms/releases/tag/3.5.0-beta3—
Reply to this email directly or view it on GitHub
#9254 (comment).
Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-03-03 10:44:38 |
Closed_By | ⇒ | brianteeman |
can you check if it worked in 3.5.0 beta 2?
https://github.com/joomla/joomla-cms/releases/download/3.5.0-beta2/Joomla_3.5.0-beta2-Beta-Full_Package.zip