[#11726] - [Sql azure] Normalize joomla install sample blog sql file
- Fixed in Code Base
- 24 Aug 2016
- Medium
- Build: staging
- # 11726
- Diff
- andrepereiradasilva:sqlazure-sample-blog
- Success continuous-integration/travis-ci/pr The Travis CI build passed Details
- Pending JTracker/HumanTestResults Human Test Results: 1 Successful 0 Failed. Details
User tests: Successful: Unsuccessful:
Summary of Changes
Normalizes all sql azure joomla install file.
- always use
SET IDENTITY_INSERT [#__xxxx] ON/OFF; -
INSERTtoINSERT INTO - Quote all table names and db field names
- Always use
'to quote string values. - Code style
Testing Instructions
Mainly code review. (to many changes need to check code in raw)
https://github.com/andrepereiradasilva/joomla-cms/blob/sqlazure-sample-blog/installation/sql/sqlazure/sample_blog.sql
If anyone could test an install 3.6.x would be great. Don't have sql azure to test,
Documentation Changes Required
None.
joomla-cms-bot
- | Category | ⇒ | Installation SQL MS SQL |
| Status | New | ⇒ | Pending |
| Labels |
Added:
?
|
||
I have not tested this item.
I get this error:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'UNION'. SQL=INSERT INTO #__categories UNION ALL SELECT 1, 0, 0, 0, 17, 0, '', 'system', 'ROOT', 'root', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{}', '', '', '', 628, '2011-01-01 00:00:00', 0, '1900-01-01 00:00:00', 0, '', 1 UNION ALL SELECT 2, 27, 1, 1, 2, 1, 'uncategorised', 'com_content', 'Uncategorised', 'uncategorised', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 628, '2011-01-01 00:00:00', 0, '1900-01-01 00:00:00', 0, '', 1 UNION ALL SELECT 3, 28, 1, 3, 4, 1, 'uncategorised', 'com_banners', 'Uncategorised', 'uncategorised', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"target":"","image":"","foobar":""}', '', '', '{"page_title":"","author":"","robots":""}', 628, '2011-01-01 00:00:00', 0, '1900-01-01 00:00:00', 0, '', 1 UNION ALL SELECT 4, 29, 1, 5, 6, 1, 'uncategorised', 'com_contact', 'Uncategorised', 'uncategorised', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 628, '2011-01-01 00:00:00', 0, '1900-01-01 00:00:00', 0, '', 1 UNION ALL SELECT 5, 30, 1, 7, 8, 1, 'uncategorised', 'com_newsfeeds', 'Uncategorised', 'uncategorised', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 628, '2011-01-01 00:00:00', 0, '1900-01-01 00:00:00', 0, '', 1 UNION ALL SELECT 7, 32, 1, 11, 12, 1, 'uncategorised', 'com_users', 'Uncategorised', 'uncategorised', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 628, '2011-01-01 00:00:00', 0, '1900-01-01 00:00:00', 0, '', 1 UNION ALL SELECT 9, 35, 1, 15, 16, 1, 'blog', 'com_content', 'Blog', 'blog', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 628, '2011-01-01 00:00:00', 0, '1900-01-01 00:00:00', 0, '*', 1
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/11726.
fixed, can you test again?
I have tested this item
Works now, thanks!
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/11726.
| Status | Pending | ⇒ | Ready to Commit |
| Labels |
Added:
?
|
||
wilsonge
- | Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-08-24 22:13:43 |
| Closed_By | ⇒ | wilsonge |
| Labels |
Removed:
?
|
||
I have tested this item✅ successfully on 6bbeaa1
on code review still unable to test on MSSQL
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/11726.