Bug: Joomla2.5 with msSQL 500 error on extensions:database tab

Question

Error with a new Joomla 2.5 installation from the web gallery if a MSSQL database is chosen rather than a mySQL database.

In the Joomla administration interface under the extensions manager selecting the database tab will return a 500 internal server error.

Exact message is as follows:

Server error
The website encountered an error while retrieving http://*websitename*.azurewebsites.net/administrator/index.php?option=com_installer&view=database. It may be down for maintenance or configured incorrectly.
Here are some suggestions:
Reload this webpage later.
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request.

Answer 1

Can you see the database created in your sql azure?

Answer 2

Yes, I can see the msSQL database that was created for the website through the web gallery in Azure. I can also access the SQL server through Azure to access the database tables.

The issue is just this one tab in the website which is not getting a database connection; the tab is used to check the database for errors and make corrections or updates to the structure.

Answer 3

Can you please help on fiddler trace?

1. download Fiddler on your pc

http://www.fiddler2.com/fiddler2/

2. Clear all IE cache

3. Run Fiddler

4. Reproduce the problem

5. Send us the fiddler  to

WAWSForums at microsoft dot com

Answer 4

I have created the report as requested and sent it to the address you provided.

To cross check some of the issues I am experiencing, I have also created a new Joomla 2.5 site from the gallery using mySQL instead of msSQL.

With the mySQL database site, I was able to access the extensions:database tab, but the gallery site had the following fixable database errors.

Warning: Database is not up to date!

5 Database Problems Found

Database schema version (None) does not match CMS version (2.5.6).

Database update version (2.5.4) does not match CMS version (2.5.6).

Table 'jos_redirect_links' does not have column 'hits'. (From file 2.5.5.sql.)

Table 'jos_users' does not have column 'lastResetTime'. (From file 2.5.5.sql.)

Table 'jos_users' does not have column 'resetCount'. (From file 2.5.5.sql.)

Other Information

Database schema version (in #__schemas): None.
Update version (in #__extensions): 2.5.4.
Database driver: mysql.
63 database changes were checked successfully.
24 database changes did not alter table structure and were skipped.

I'm assuming that original site based on msSQL has a similar database schemas issue. 

I should also mention that it would be highly advisable for the Azure team to update the gallery install of joomla2.5 to use the new 2.5.8 version, since the older 2.5.6 version that is currently in the gallery has several security vulnerabilities.

Answer 5

Hey,

Thanks for the info. I have a Joomla site with MySQL as well. I will try to setup an Joomla site with MSSQL to reproduce the problem.

thanks,

Wei

Answer 6

I reproed the problem, now is looking into it.

Answer 7

I got this error message from php_error.log. And then I reviewed these to PHP files. Looks it is wrong to use sqlsrv.php, instead, sqlazure.php should be used.

I would suggest you post the issue on Joomla forum.

[10-Dec-2012 09:32:15 UTC] PHP Catchable fatal error:  Argument 1 passed to JSchemaChangeset::getUpdateQueries() must be an array, boolean given, called in C:\DWASFiles\Sites\WZHAOJOOMLA\VirtualDirectory0\site\wwwroot\libraries\cms\schema\changeset.php on line 63 and defined in C:\DWASFiles\Sites\WZHAOJOOMLA\VirtualDirectory0\site\wwwroot\libraries\cms\schema\changeset.php on line 213
[10-Dec-2012 09:32:15 UTC] PHP Fatal error:  sqlsrv_errors contains an invalid type in C:\DWASFiles\Sites\WZHAOJOOMLA\VirtualDirectory0\site\wwwroot\libraries\joomla\database\database\sqlsrv.php on line 677
[10-Dec-2012 09:32:25 UTC] PHP Catchable fatal error:  Argument 1 passed to JSchemaChangeset::getUpdateQueries() must be an array, boolean given, called in C:\DWASFiles\Sites\WZHAOJOOMLA\VirtualDirectory0\site\wwwroot\libraries\cms\schema\changeset.php on line 63 and defined in C:\DWASFiles\Sites\WZHAOJOOMLA\VirtualDirectory0\site\wwwroot\libraries\cms\schema\changeset.php on line 213
[10-Dec-2012 09:32:25 UTC] PHP Fatal error:  sqlsrv_errors contains an invalid type in C:\DWASFiles\Sites\WZHAOJOOMLA\VirtualDirectory0\site\wwwroot\libraries\joomla\database\database\sqlsrv.php on line 677
[10-Dec-2012 09:32:31 UTC] PHP Catchable fatal error:  Argument 1 passed to JSchemaChangeset::getUpdateQueries() must be an array, boolean given, called in C:\DWASFiles\Sites\WZHAOJOOMLA\VirtualDirectory0\site\wwwroot\libraries\cms\schema\changeset.php on line 63 and defined in C:\DWASFiles\Sites\WZHAOJOOMLA\VirtualDirectory0\site\wwwroot\libraries\cms\schema\changeset.php on line 213
[10-Dec-2012 09:32:31 UTC] PHP Fatal error:  sqlsrv_errors contains an invalid type in C:\DWASFiles\Sites\WZHAOJOOMLA\VirtualDirectory0\site\wwwroot\libraries\joomla\database\database\sqlsrv.php on line 677

Answer 8

I'll consider also posting this in the Joomla forums. 

From my take on this it is an Azure issue since this was a new site from an Azure gallery. If it's wrong to use sqlsrv.php, and I should use sqlazure.php instead. Then why did the Azure team set up the gallery install to use sqlsrv.php rather than sqlazure.php?

Following your statement, I attempted to switch to sqlazure database type, and the site returned a "can't connect to SQL server" error. I had to use FTP to revert the database type back to sqlsrv in the global configurations to get the site back up.

Answer 9

Use what type of database is totally controlled by Joomla as well. We will try to see what we can do from our side.

thanks,

Wei