Joomla on IIS8 and MSSQL 2012

[dburone]

Doesnt even load the page with the mod on the query.php file and the j330 sqlsrv.php.
It only opens a blank page now.

I already mentioned the solution solved the original problem.

For now I think I will use the J303 sqlsrv.php since I now need to get a prototype site working for development so I can wait a little for this to get solved and go back to J330 sqlsrv.php.
I don't kmow exactly what processLimit is but I think it may not be a problem for me now.
Thanks a lot for all youre help! It was really Usefull!

[sovainfo]

The change in sqlsrv.php applies to sqlsrv and not the other db's. The change in query.php applies to all db's. The move of the lines makes the limit apply to only the select statement.

I have seen reports of update and delete (yours) statements with an error because of this construct for sqlsrv.

Unfortunately you'll run into further problems possibly when these issues are fixed.

[dburone]

The change in sqlsrv.php applies to sqlsrv and not the other db's. The change in query.php applies to all db's. The move of the lines makes the limit apply to only the select statement.

I have seen reports of update and delete (yours) statements with an error because of this construct for sqlsrv.

Unfortunately you'll run into further problems possibly when these issues are fixed.

I agree with you!

Its just that my Site wont be live for at least 30 more days and I need to work on other elements of the site.
I'll still try to solve the original problem and I will help you in any way I can. I just dont understand very well those codes for fixing them my self.
If you need me to do some test just tell me. Even if you want I could give you remote access to my PC or some virtual server so you can work directly on the problem.

Im at you're service!

[sovainfo]

In the mean time I have decided upon not considering it one issue. The first issue is that for sqlsrv the processLimit is called too soon. On half of the query. The second issue to me is that the processLimit implementation contains the syntax for the SELECT but is applied to other statements as well. This is regardless the storage (MySQL, MSSQL, Azure, PostgreSQL). It requires a separate issue to be resolved properly.

@dburone: I noticed your statement on Github, thank you for that. While checking JC, I didn't see an entry. Would you mind to register there and add an a line like:
@test Success, issue confirmed, PR resolves issue.
It is http://joomlacode.org/gf/project/joomla ... 18&start=0
Unfortunately, this is what still used for progress. It won't make it into the product unless there are at least two successes reported here.
To investigate the blank screen you would need to return to the J330 situation with my fixes. I would be willing to investigate, but it interrupts you working on your site.
Maybe we can communicate privately to explore that possibility.

[dburone]

I activated the development error tracking on PHP and now the blank screen shows this.

Parse error: syntax error, unexpected T_CASE in C:\inetpub\wwwroot\Joomla_33\libraries\joomla\database\query.php on line 397

Now I have all the J330 files again and the mods you sugested sovainfo.

[sovainfo]

There must be a typo on 397. Could you provide some of the lines around 397 here?

[sovainfo]

Undo the move of the lines in query.php and replace line 476

Code: Select all

if ($this instanceof JDatabaseQueryLimitable && ($this->limit > 0 || $this->offset > 0))

[dburone]

Undo the move of the lines in query.php and replace line 476

Code: Select all

if ($this instanceof JDatabaseQueryLimitable && ($this->limit > 0 || $this->offset > 0))

This change did solve completly the problem. Site is working on complete J330 files.

Im having another problem with installing extensions. Don't know why but it takes over a minute trying to install it and it ends on a error page.

Already adjusted upload limits and permisions over the tmp directory. Joomla hows no errors on the database tab or any warnings.

I guess this is another case or problem for using SQLSERVER

[dburone]

Here the error message in a browser that is in English.
Don't know why the error code is different.

[dburone]

I found out the same thing happens if I try to make a change in a menu.
I'm trying to find out what's happening. The system lets me create users so it has acces to the database, bue menus and extensions give that error code.

[sovainfo]

Thank you for the confirmation and your post on jc.
Do you mind starting a new discussion for the ERR_CONNECTION_RESET.
My impression is that this can't be related to the issues we discussed here.
Hope I am right about that, if not, just say so.

Would like to request another post on JC on http://joomlacode.org/gf/project/joomla ... 07&start=0 from you.

In order to trigger the right administration it requires you to start your post with: @test Succesfull

As further description suggest:
Issue confirmed. PR#### resolves issue. Infra:J3.3.0, PHP #.#.#

[dburone]

Thank you for the confirmation and your post on jc.
Do you mind starting a new discussion for the ERR_CONNECTION_RESET.
My impression is that this can't be related to the issues we discussed here.
Hope I am right about that, if not, just say so.

Would like to request another post on JC on http://joomlacode.org/gf/project/joomla ... 07&start=0 from you.

In order to trigger the right administration it requires you to start your post with: @test Succesfull

As further description suggest:
Issue confirmed. PR#### resolves issue. Infra:J3.3.0, PHP #.#.#

I started another discusion because as you say I think this is another issue.

http://forum.joomla.org/viewtopic.php?f=706&t=845891

[JeremyLC]

I have just installed 3.3.6 on this same combination of web server and database it does not work. The installation went off without any trouble, but if I try to visit the newly installed site I get the error below:

Error displaying the error page: Application Instantiation Error: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near ','.SQL=SELECT * FROM ( DELETE , ROW_NUMBER() OVER (ORDER BY (select 0)) AS RowNumber FROM [xi8ob_session] WHERE [time] < '1421268101') _myResults WHERE RowNumber BETWEEN 1 AND 0

I thought I'd continue this thread rather than start a new one on the same problem.

[jpxxx]

looks like sql statements are faultly, they are being created in /database/[drive]/sqlsrv.php and/or /database/query/sqlsrv.php . however, those statements are created through multiple functions... as i am not well versed in the code i am kind of wary of making a bunch of changes, in fear of breaking other things.

[sovainfo]

@JeremyLC Replacing the line 476 in query.php should solve your issue. Both offset and limit are zero in your case. Still think it should be moved because it now applies to all statements, it should only apply to the SELECT statement.

[JeremyLC]

@JeremyLC Replacing the line 476 in query.php should solve your issue. Both offset and limit are zero in your case. Still think it should be moved because it now applies to all statements, it should only apply to the SELECT statement.

Thanks, I found that earlier and managed to get far enough to experience a more sever problem. I posted in detail in a different sub-forum here http://forum.joomla.org/viewtopic.php?f=728&t=871724

[Bedlam125]

Having the same type of issues. at the moment with joomla 3.2

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 [sevs1_session]) _myResults WHERE RowNumber BETWEEN 1 AND 1 WHERE [session_id] = 'tbejv31atl4f4e8tg4bm78tl52'

Over the past two weeks I have had issue after issue with joomla installs. I keep wiping my site and starting over. Getting very frustrated, as I use this CMS because I am no expert in php and have had success with it in the past... in fact on the same host, same environment and all. But now I can't get past this.

Edit: I get this from accessing both the front end and administrator urls.. only difference I see is the session ID at the end. I have had the same results with 3.3.6, both installing manually myself AND an automated install from my hosting providers web app gallery.

[Planck Mann]

thanks for your information .it is helpful to me.

[aminlv]

can you tell me how exactly you add sql server in database types in joomla installation please

[aminlv]

ok an update, well manage to install it had to remove everything and reinstall it with WPI
it work just fine,

i can easily install extension etc...
however i got weird issue,whenever i install new Language i can see in admin panel i install that language but it won't add to site or admin articles just show default english UK!
i checked database seems language pack wont add themselves in database _language

any idea how can fix this issue?

tnX