SQL Installation Error

[rad0152]

Hello

I'm hoping someone can help with this I cannot seem to see much about this particular error.

My install is W2K8 R2 + IIS 7.5 + MS SQL 2008 R2

I have PHP 5.5 and PHP driver for this install to run MS SQL.

When running the install wizard I get the SQLSRV option appear which tells me PHP is loading the driver correctly, I can also see it from PHPinfo.

I complete the wizard and it installs about half of the tables then stops with the follwoing error:

Code: Select all

[Microsoft][SQL Server Native Client 11.0][SQL Server]A nested INSERT, UPDATE, DELETE, or MERGE statement must have an OUTPUT clause.SQL=SELECT * FROM ( UPDATE [SDP_extensions] SET [params] = '{"administrator":"en-GB","site":"en-GB"}' WHERE [element] = 'com_languages') _myResults WHERE RowNumber BETWEEN 1 AND 0

Has anyone seen this before and do you have and ideas or solutions?

Many Thanks

[goedda]

Joomla! is not compatible with MS SQL. You need either MySQL or alternatively, with Joomla! 3 you can also use PostgreSQL.
http://www.joomla.org/about-joomla/tech ... ments.html

Even better would be an Apache server with MySQL. And MySQL should be for performance reasons at least MySQL 5.1.

[rad0152]

Joomla! is not compatible with MS SQL. You need either MySQL or alternatively, with Joomla! 3 you can also use PostgreSQL.
http://www.joomla.org/about-joomla/tech ... ments.html

Even better would be an Apache server with MySQL. And MySQL should be for performance reasons at least MySQL 5.1.

I saw the following document on the website and thought I was ready to go...

http://docs.joomla.org/Configuring_sqlserver

So I'm not sure what's correct!

[sovainfo]

Contrary to what people think they need to post here, Joomla supports MySQL, MSSQL and PostgreSQL. Have a look at docs.joomla.org/Technical_requirements.

[rad0152]

Contrary to what people think they need to post here, Joomla supports MySQL, MSSQL and PostgreSQL. Have a look at docs.joomla.org/Technical_requirements.

Thanks for clearing that up, im running MS SQL 10.50.4000 so its supported

So can anyone help with the original question?

[sovainfo]

Which version of Joomla are talking about?

[goedda]

Contrary to what people think they need to post here, Joomla supports MySQL, MSSQL and PostgreSQL. Have a look at docs.joomla.org/Technical_requirements.

Thanks for clarifying.

1. But why isn't it mentioned in the link I posted?
2. It is MS after all... why should it work flawlessly?

[rad0152]

Which version of Joomla are talking about?

Its Joomla 3.2.3

[sovainfo]

Better read again, it is mentioned there as well. At least for J3.

[sovainfo]

Can't find the update statement in my distribution. Are you sure it is the original version?
Might it be a translated version?

[rad0152]

Can't find the update statement in my distribution. Are you sure it is the original version?
Might it be a translated version?

No its the 3.2 version from this link:

http://www.joomla.org/download.html

I dont think this is any different version?

[sovainfo]

Are you installing from an empty folder with only the content of that distribution?

[rad0152]

Are you installing from an empty folder with only the content of that distribution?

The installation was on a fresh server with a newly downloaded distribution.

I have downloaded a new package and deleted all folder contents then reinstalled but I get the same results.

I have looked at the SQL folder in the installation directory and it only contains SQLAZURE not MSSQL is this correct?

[sovainfo]

Yes, sqlazure is correct. It is used for both.
Have not been able to locate the statement producing the error. Used '__extensions' to search for it. Found two update statements but they are not the one we are looking for.

[sovainfo]

Ok, found it. It is updating the default languages for admin and site.
You might try to suppress this by commenting out line 543 of installation/models/database.php. That is the line executing that statement.

[rad0152]

Ok, found it. It is updating the default languages for admin and site.
You might try to suppress this by commenting out line 543 of installation/models/database.php. That is the line executing that statement.

That's exactly what the problem was I removed it and it completed the installation.

Thank you so much

When trying to load pages im getting the following error, do you think its because of the line we removed?

Error displaying the error page: Application Instantiation Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.SQL=SELECT * FROM ( SELECT [session_id] , ROW_NUMBER() OVER (ORDER BY (select 0)) AS RowNumber FROM [SDP_session]) _myResults WHERE RowNumber BETWEEN 1 AND 1 WHERE [session_id] = 'fad2tqh03qn361ql1ne1tdepj4'

[sovainfo]

No, definitely not. You might set them yourself, either by phpMyadmin or Language manager once your in backend. It is no solution but gets you further.

Don't like the construct with _myResult and rownumber. Looks like it is not implemented properly. Haven't been able to find out why these constructs are applied to these statements.

To avoid the error you could stop using database for session in configuration.php.

[rad0152]

No, definitely not. You might set them yourself, either by phpMyadmin or Language manager once your in backend. It is no solution but gets you further.

Don't like the construct with _myResult and rownumber. Looks like it is not implemented properly. Haven't been able to find out why these constructs are applied to these statements.

To avoid the error you could stop using database for session in configuration.php.

Yes its nice moving along even if its slow

I have changed the sessions_handler to equal "none" but it comes back with the same error. I can open another thread if thats better?

[sovainfo]

See no need for separate thread, consider it still the same issue.

Could you try the statement when changing the last WHERE to AND. It shouldn't give a syntax error, but might return 0 rows because the id likely doesn't exist anymore.

[HW2K]

Did this ever get resolved? I have exactly the same set of issues. I am running W2K8 R2, MS SQL 2008, Joomla 3.3.3. Thanks in advance.

[pe7er]

MS SQL 2008

Which MS SQL 2008 version do you use?

According to http://www.joomla.org/technical-requirements.html you'll need at least version 10.50.1600.1+

According to http://support.microsoft.com/kb/321185 it means that you should at least use SQL Server 2008 R2 RTM 10.50.1600.1

SQL Server 2008 RTM, SQL Server 2008 Service Pack 1,2 &3 are 10.00.x.x and thus not suitable because those are lower than 10.50.x.x.

[HW2K]

Hi, and thanks for coming back to me.

The issue seems to be a malformed SQL statement:

[Microsoft][SQL Server Native Client 11.0][SQL Server]A nested INSERT, UPDATE, DELETE, or MERGE statement must have an OUTPUT clause.SQL=SELECT * FROM ( UPDATE [SDP_extensions] SET [params] = '{"administrator":"en-GB","site":"en-GB"}' WHERE [element] = 'com_languages') _myResults WHERE RowNumber BETWEEN 1 AND 0

it is missing an OUPUT parameter?

Also, I'm running SQL 2012 (11.0.2100).

Thanks.

[sovainfo]

See https://github.com/sovainfo/joomla-cms/ ... 695c452f3b

[Planck Mann]

http://www.joomla.org/about-joomla/tech ... ments.html maybe you can get answer in it.thanks