Feeling Lucky
?
[#7444] - mod_related_items - query portability
- Fixed in Code Base
- 3 May 2016
- Medium
- Build: staging
- # 7444
- Diff
- alikon:patch-36
- Success continuous-integration/travis-ci/pr The Travis CI build passed Details
- Success JTracker/HumanTestResults Human Test Results: 2 Successful 0 Failed. Details
User tests: Successful: Unsuccessful:
Steps to reproduce the issue
install test data and click on left menu item Related Items
Expected result
the module works as expected
Actual result
DB error on MSSQL DATE() is not a recognized built-in function name.
System information
MSSQL 2008 R2 10.50.4033
Apache 2.4.7
PHP 5.5.9
Joomla! 3.4.4-dev
Additional comments
DATE() is not a recognized built-in function in MSSQL used CAST instead
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Labels |
Added:
?
|
||
zero-24
- | Category | ⇒ | MS SQL |
wmgraf
- comment
- 15 Apr 2016
I have tested this item 
successfully on 6a3499d
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/7444.
| Status | Pending | ⇒ | Ready to Commit |
brianteeman
- comment
- 3 May 2016
| Labels |
Added:
?
|
||
| Milestone |
Added: |
||
rdeutz
- | Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-05-03 09:35:30 |
| Closed_By | ⇒ | rdeutz |
| Labels |
Removed:
?
|
||
I have tested this item
successfully on 6a3499d
Works with mssql, postgres and mysql. Thanks alikon!
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/7444.