[#4761] - Fixed#4652 Schema updated
- Closed
- 15 Jul 2015
- Medium
- Build: staging
- # 4761
- Diff
- asheshvagh:4652_Schem-notup-to-date
- Failure The Travis CI build failed Details
User tests: Successful: Unsuccessful:
[#4652] - Schema not up-to-date - Error in MSSQL syntax.
Changes applied, The SQL command did as per joomla standard.
Original Report
Steps to reproduce the issue
Upon updating to Joomla! 3.3.6, visit the Extension Manager>Database page. See that the database schema is not up-to-date. Click "Fix." Page will break.
Expected result
It should say "Database table structure is up to date."
Actual result
Page breaks.
System information (as much as possible)
MS-SQL, Joomla 3.3.6, IIS server.
Additional comments
Proposed fix... The SQL command currently is "INSERT INTO [#__schemas] SET [extension_id]= 700, [version_id]= '3.3.6-2014-09-30', but "SET" is not correct syntax apparently. Below is the correct syntax for the statement (not sure where to put this file though).
INSERT INTO #__schemas
VALUES
(700
,'3.3.6-2014-09-30')
GO
jissues-bot
- | Labels |
Added:
?
|
||
brianteeman
- | Category | ⇒ | MS SQL |
| Rel_Number | ⇒ | 4652 | |
| Relation Type | ⇒ | Related to |
| Title |
|
||||||
Please fix the codestyle error that travis is complaining about.
Another month later... Ping?
When I look in database.php in the current staging branch I can see that in the meantime the correct syntax is used for this insert statement. So I think this can be closed.
| Status | Pending | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-07-15 08:19:26 |
| Closed_By | ⇒ | zero-24 |
Closing as per comment by @waader Thanks for checking
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4761.
if fixed as #2517 it will don't need this patch.
my environment test is.
System Information
Setting Value
PHP Built On Windows NT EDKNETWORK 6.1 build 7601 (Windows Server 2008 R2 Enterprise Edition Service Pack 1) i586
Database Version 10.50.2500
Database Collation MSSQL UTF-8 (UCS2)
PHP Version 5.4.14
Web Server Microsoft-IIS/7.5
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.3.6 Stable [ Ember ] 01-October-2014 02:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:32.0) Gecko/20100101 Firefox/32.0
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4761.