?
Referenced as Related to: # 4761
avatar adrianfso
adrianfso
13 Oct 2014

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

Votes

# of Users Experiencing Issue
1/1
Average Importance Score
3.00

avatar adrianfso adrianfso - open - 13 Oct 2014
avatar nicksavov
nicksavov - comment - 16 Oct 2014

Thanks Adrian! Could you submit a pull request for it? Here's a really easy way how:
http://docs.joomla.org/Using_the_Github_UI_to_Make_Pull_Requests

avatar nicksavov nicksavov - change - 16 Oct 2014
Labels Added: ?
avatar joomlacorner
joomlacorner - comment - 17 Oct 2014

this's fixed with #2517

avatar jissues-bot jissues-bot - close - 17 Oct 2014
avatar zero-24 zero-24 - close - 17 Oct 2014
avatar brianteeman brianteeman - change - 17 Oct 2014
Status New Closed
avatar jissues-bot jissues-bot - change - 17 Oct 2014
Closed_Date 0000-00-00 00:00:00 2014-10-17 11:25:51
avatar jissues-bot
jissues-bot - comment - 17 Oct 2014
avatar asheshvagh
asheshvagh - comment - 17 Oct 2014

@test i have fixed the issue for sql schema of insert query.

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

avatar brianteeman
brianteeman - comment - 17 Oct 2014

Please see #4761

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

avatar joomlacorner
joomlacorner - comment - 17 Oct 2014

@brianteeman #4761 it's different way from #2517

please recheck the correct way is #2517

avatar zero-24 zero-24 - change - 7 Jul 2015
Labels Added: ?

Add a Comment

Login with GitHub to post a comment