[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Depends on||73390 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Depends on||72171 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Bug 9767 depends on bug 71024, which changed state. Bug 71024 Summary: MS Sql Driver has compatibility bugs (see description) https://bugzilla.wikimedia.org/show_bug.cgi?id=71024 What|Removed |Added Status|PATCH_TO_REVIEW |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Kunal Mehta (Legoktm) legoktm.wikipe...@gmail.com changed: What|Removed |Added Depends on||71207 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Depends on||71027 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Keywords|patch, patch-reviewed | Depends on||71024 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Bug 9767 depends on bug 65813, which changed state. Bug 65813 Summary: MSSQL installer broken; updateRowExists returns always false https://bugzilla.wikimedia.org/show_bug.cgi?id=65813 What|Removed |Added Status|PATCH_TO_REVIEW |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Bug 9767 depends on bug 65757, which changed state. Bug 65757 Summary: Explicitly name check constraints for Microsoft SQL Server schema https://bugzilla.wikimedia.org/show_bug.cgi?id=65757 What|Removed |Added Status|PATCH_TO_REVIEW |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Rainer Rillke @commons.wikimedia ril...@wikipedia.de changed: What|Removed |Added Depends on||65808 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Rainer Rillke @commons.wikimedia ril...@wikipedia.de changed: What|Removed |Added Depends on||65813 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Rainer Rillke @commons.wikimedia ril...@wikipedia.de changed: What|Removed |Added Depends on||65757 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Samuel Bronson naes...@gmail.com changed: What|Removed |Added Alias||mssql -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Bug 9767 depends on bug 22093, which changed state. Bug 22093 Summary: Native Microsoft SQL Server Support https://bugzilla.wikimedia.org/show_bug.cgi?id=22093 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WONTFIX -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Chad H. innocentkil...@gmail.com changed: What|Removed |Added Status|NEW |RESOLVED CC||innocentkil...@gmail.com Resolution|--- |WONTFIX --- Comment #83 from Chad H. innocentkil...@gmail.com --- WONTFIX per reason I outlined 22093 comment 30 -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Bug 9767 depends on bug 22093, which changed state. Bug 22093 Summary: Native Microsoft SQL Server Support https://bugzilla.wikimedia.org/show_bug.cgi?id=22093 What|Removed |Added Status|RESOLVED|REOPENED Resolution|WONTFIX |--- -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Mark A. Hershberger m...@everybody.org changed: What|Removed |Added Status|RESOLVED|REOPENED CC||m...@everybody.org Resolution|WONTFIX |--- --- Comment #84 from Mark A. Hershberger m...@everybody.org --- Reopening per bug 22093 comment 31 -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #85 from Mark A. Hershberger m...@everybody.org --- I did some work to support SQL Server access from Linux this summer (https://bugs.php.net/bug.php?id=64338), so you don't have to have a Windows box to implement support for SQL Server. Azure access should work just fine. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Keywords||patch-reviewed --- Comment #82 from Andre Klapper aklap...@wikimedia.org --- DJ Bauch, would you have time to work on aforementioned issues with your patches? -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Michelle Lee Kosik kosi...@mail.com changed: What|Removed |Added CC||kosi...@mail.com -- You are receiving this mail because: You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #81 from Sumana Harihareswara suma...@wikimedia.org 2012-08-17 10:41:29 UTC --- DJ, did you have time to work on these issues? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Max Semenik maxsem.w...@gmail.com changed: What|Removed |Added Keywords|need-review | --- Comment #80 from Max Semenik maxsem.w...@gmail.com 2012-04-19 17:15:53 UTC --- -need-review, already reviewed. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Sumana Harihareswara suma...@panix.com changed: What|Removed |Added Keywords||need-review CC||suma...@panix.com -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 D J Bauch dj.ba...@gmail.com changed: What|Removed |Added Attachment #6091|0 |1 is obsolete|| --- Comment #76 from D J Bauch dj.ba...@gmail.com 2011-07-29 18:34:40 UTC --- Created attachment 8841 -- https://bugzilla.wikimedia.org/attachment.cgi?id=8841 MS SQL Server Script for MediaWiki 1.16.5 At the Microsoft SQL Server JumpIn Camp, I updated the script to support MediaWiki 1.16.5. I tested on SQL Server 2008, SQL Server Denali, and SQL Server Azure. It also still works on SQL Server 2005. The code now uses Microsoft's PDO driver for SQL Server rather than ADODB, but the SQL script is not affected by that. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #77 from D J Bauch dj.ba...@gmail.com 2011-07-29 18:46:09 UTC --- Created attachment 8842 -- https://bugzilla.wikimedia.org/attachment.cgi?id=8842 includes\db\DatabaseMSPDO.php Database subclass for use with Microsoft SQL Server PDO driver. This class works with both traditional SQL Server connections as well as with SQL Server Azure. It doesn't exactly obsolete DatabaseADODB.php, although I suppose that practically, it does. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Max Semenik maxsem.w...@gmail.com changed: What|Removed |Added CC||maxsem.w...@gmail.com --- Comment #78 from Max Semenik maxsem.w...@gmail.com 2011-07-29 22:06:11 UTC --- So that MSSQL native thing is obsolete and everybody should use PDO? Should we throw away our current MSSQL backend that bitrots for a year now? A few quick comments on attached code: 1) We don't accept patches with new functionality against released versions. Only trunk. And for such complex things, we don't accept patches at all. Instead, we give commit access to people interested in continuously maintaining these. 2) Database class is a legacy alias for DatabaseMysql, inherit from DatabaseBase. 3) Code duplication in constructor and newFromParams(). 4) wfProfileIn(dbconnect-$server) is superfuluous, no heavy operations between it and parent wfProfileIn(__METHOD__). 5) Due to (2), you have to resort to overloading query() and performing messy manual SQL rewrites, don't do that. Change SQL abstraction functions instead. 6) Same thing for copy-paste inheritance of virtually every function. 7) Manual magic quotes fighting in strencode() and qstr() is not needed, magic_quotes_gpc is handled in WebRequest while installer refuses to install with magic_quotes_runtime on. 8) Lots of commented-out code. 9) Code doesn't follow our coding conventions outlined at http://www.mediawiki.org/wiki/Manual:Coding_conventions -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #79 from D J Bauch dj.ba...@gmail.com 2011-07-29 22:35:30 UTC --- (In reply to comment #78) So that MSSQL native thing is obsolete and everybody should use PDO? Should we throw away our current MSSQL backend that bitrots for a year now? A few quick comments on attached code: 1) We don't accept patches with new functionality against released versions. Only trunk. And for such complex things, we don't accept patches at all. Instead, we give commit access to people interested in continuously maintaining these. 2) Database class is a legacy alias for DatabaseMysql, inherit from DatabaseBase. 3) Code duplication in constructor and newFromParams(). 4) wfProfileIn(dbconnect-$server) is superfuluous, no heavy operations between it and parent wfProfileIn(__METHOD__). 5) Due to (2), you have to resort to overloading query() and performing messy manual SQL rewrites, don't do that. Change SQL abstraction functions instead. 6) Same thing for copy-paste inheritance of virtually every function. 7) Manual magic quotes fighting in strencode() and qstr() is not needed, magic_quotes_gpc is handled in WebRequest while installer refuses to install with magic_quotes_runtime on. 8) Lots of commented-out code. 9) Code doesn't follow our coding conventions outlined at http://www.mediawiki.org/wiki/Manual:Coding_conventions Thanks for those comments. I'll endeavor to fix those issues. As to MSSQL native, I never have used that. I haven't had any luck getting that or PDO for SQL Server working on Windows XP, so I used the ADODB library in the past. I started on the PDO driver by making a copy of my old ADODB driver code, so that explains some of the legacy stuff that now needs to be cleaned up. MSSQL native and PDO work fine for me on Windows 7 and on Windows Azure, and with SQL Azure. ADODB doesn't do as well with SQL Azure, so right now I either use ADODB on XP with SQL Server 2005 or 2008 or I use PDO on Windows 7 or Azure with SQL Server 2005, 2008, Denali, or Azure -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Reedy s...@reedyboy.net changed: What|Removed |Added Depends on||22093 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Bug 9767 depends on bug 15493, which changed state. Bug 15493 Summary: syntax errors with MSSQL https://bugzilla.wikimedia.org/show_bug.cgi?id=15493 What|Old Value |New Value Status|NEW |RESOLVED Resolution||INVALID -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 Andrew Garrett agarr...@wikimedia.org changed: What|Removed |Added Keywords||tracking --- Comment #74 from Andrew Garrett agarr...@wikimedia.org 2009-07-29 16:38:53 UTC --- Adding 'tracking' keyword. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #73 from Yedidia Klein yedi...@yedidia.net 2009-05-06 10:04:05 UTC --- (In reply to comment #72) (In reply to comment #66) After some fixes on php.ini (most important is to set a file for error log for not getting 500 errors), my installation is moving. first I found that tables.sql has to be in maintenance/sqlserver (and not in mssql dir). then after creating some tables it stops. refreshing the installation give this info: There are already MediaWiki tables in this database. Checking if updates are needed... ...ipblocks table does not exist, skipping new field patch ...ipblocks table does not exist, skipping new field patch Creating interwiki table: then it stop... could be that tables.sql that is provided here is broken ? This problem is fixed in the updated tables.sql I just uploaded. You are right, there was an error in the SQL for creating the interwiki table. I stumbled on this because it was a type-conversion error rather than a syntax error. A couple of columns had to be varchar rather than varbinary. Wonderful! the installation was smooth and all the tables were created. LocalSettings.php exist also. now after moving LocalSettings.php to the right place I get a timeout on main page, changed max_execution_time on php.ini to 300 sec (!) and still it get a timeout. this is what I get on the error_log: [06-May-2009 12:46:00] PHP Notice: Undefined index: REQUEST_METHOD in C:\Inetpub\wiki\mediawiki-1.14.0.patched\includes\WebRequest.php on line 410 [06-May-2009 12:46:00] PHP Notice: Undefined index: SERVER_PROTOCOL in C:\Inetpub\wiki\mediawiki-1.14.0.patched\includes\OutputHandler.php on line 117 [06-May-2009 12:46:09] PHP Notice: Undefined index: REQUEST_METHOD in C:\Inetpub\wiki\mediawiki-1.14.0.patched\includes\WebRequest.php on line 410 [06-May-2009 12:51:09] PHP Fatal error: Maximum execution time of 300 seconds exceeded in C:\php\adodb5\adodb.inc.php on line 3593 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #66 from Yedidia Klein yedi...@yedidia.net 2009-05-05 09:02:27 UTC --- After some fixes on php.ini (most important is to set a file for error log for not getting 500 errors), my installation is moving. first I found that tables.sql has to be in maintenance/sqlserver (and not in mssql dir). then after creating some tables it stops. refreshing the installation give this info: There are already MediaWiki tables in this database. Checking if updates are needed... ...ipblocks table does not exist, skipping new field patch ...ipblocks table does not exist, skipping new field patch Creating interwiki table: then it stop... could be that tables.sql that is provided here is broken ? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #67 from Roan Kattouw roan.katt...@gmail.com 2009-05-05 09:05:17 UTC --- (In reply to comment #66) After some fixes on php.ini (most important is to set a file for error log for not getting 500 errors), my installation is moving. first I found that tables.sql has to be in maintenance/sqlserver (and not in mssql dir). then after creating some tables it stops. refreshing the installation give this info: There are already MediaWiki tables in this database. Checking if updates are needed... ...ipblocks table does not exist, skipping new field patch ...ipblocks table does not exist, skipping new field patch Creating interwiki table: then it stop... could be that tables.sql that is provided here is broken ? There is no maintenance/sqlserver directory, and maintenance/mssql/tables.sql has an entry for ipblocks. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #68 from Yedidia Klein yedi...@yedidia.net 2009-05-05 10:15:34 UTC --- (In reply to comment #67) (In reply to comment #66) After some fixes on php.ini (most important is to set a file for error log for not getting 500 errors), my installation is moving. first I found that tables.sql has to be in maintenance/sqlserver (and not in mssql dir). then after creating some tables it stops. refreshing the installation give this info: There are already MediaWiki tables in this database. Checking if updates are needed... ...ipblocks table does not exist, skipping new field patch ...ipblocks table does not exist, skipping new field patch Creating interwiki table: then it stop... could be that tables.sql that is provided here is broken ? There is no maintenance/sqlserver directory, and maintenance/mssql/tables.sql has an entry for ipblocks. but DatabaseADODB.php has this on line 1360: dbsource( ../maintenance/sqlserver/tables.sql, $this); And for some reason the table creation fail at the middle, these table were created: * user2 * user_newtalk * user_groups * text * templatelinks * revision2 * pagelinks * page2 * imagelinks * categorylinks * archive And these views were created: * page * revision * user There are missing about 20-30 other tables... -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #69 from D J Bauch dj.ba...@gmail.com 2009-05-05 18:56:53 UTC --- (In reply to comment #68) (In reply to comment #67) (In reply to comment #66) After some fixes on php.ini (most important is to set a file for error log for not getting 500 errors), my installation is moving. first I found that tables.sql has to be in maintenance/sqlserver (and not in mssql dir). then after creating some tables it stops. refreshing the installation give this info: There are already MediaWiki tables in this database. Checking if updates are needed... ...ipblocks table does not exist, skipping new field patch ...ipblocks table does not exist, skipping new field patch Creating interwiki table: then it stop... could be that tables.sql that is provided here is broken ? There is no maintenance/sqlserver directory, and maintenance/mssql/tables.sql has an entry for ipblocks. but DatabaseADODB.php has this on line 1360: dbsource( ../maintenance/sqlserver/tables.sql, $this); And for some reason the table creation fail at the middle, these table were created: * user2 * user_newtalk * user_groups * text * templatelinks * revision2 * pagelinks * page2 * imagelinks * categorylinks * archive And these views were created: * page * revision * user There are missing about 20-30 other tables... I am starting to fix this. The problem is that the way the tables are initially created has changed since I created my wiki. I'll have to update ./maintenance/updaters.php and add a SQL Server case to the function archive($name) so that it looks in $IP/maintenance/archives/sqlserver. Right now it is trying to use the MySQL archives (since the only other option currently is postgress. I'll have to populate that directory under maintenance. If you just run the SQL in ./maintenance/sqlserver/tables.sql, you should get all the current tables. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 D J Bauch dj.ba...@gmail.com changed: What|Removed |Added Attachment #6006 is|0 |1 obsolete|| --- Comment #70 from D J Bauch dj.ba...@gmail.com 2009-05-05 22:04:50 UTC --- Created an attachment (id=6091) -- (https://bugzilla.wikimedia.org/attachment.cgi?id=6091) MS SQL Server Script There were a couple of mistakes in the SQL Server script, but that wasn't the root of the problem, since the install was attempting to run a bunch of patch SQL scripts from the MySQL directory. Replace the tables.sql with this updated one. The root of the problem is addressed by a change to updaters.inc, which I'll upload next. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #71 from D J Bauch dj.ba...@gmail.com 2009-05-05 22:08:13 UTC --- Created an attachment (id=6092) -- (https://bugzilla.wikimedia.org/attachment.cgi?id=6092) Replacement updaters.inc to dbsource SQL Server script Replace ./maintenance/updaters.inc with this modestly changed one. If the database type is 'adodb' it will dbsource the MS SQL Server Script rather than try to run the patch scripts from ./maintenance/archives. No patching is necessary anyway, since there won't be an exisiting SQL Server wiki database. I just tested this and the MS SQL Server Script on a fresh box, and it's working for me. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #72 from D J Bauch dj.ba...@gmail.com 2009-05-05 22:12:27 UTC --- (In reply to comment #66) After some fixes on php.ini (most important is to set a file for error log for not getting 500 errors), my installation is moving. first I found that tables.sql has to be in maintenance/sqlserver (and not in mssql dir). then after creating some tables it stops. refreshing the installation give this info: There are already MediaWiki tables in this database. Checking if updates are needed... ...ipblocks table does not exist, skipping new field patch ...ipblocks table does not exist, skipping new field patch Creating interwiki table: then it stop... could be that tables.sql that is provided here is broken ? This problem is fixed in the updated tables.sql I just uploaded. You are right, there was an error in the SQL for creating the interwiki table. I stumbled on this because it was a type-conversion error rather than a syntax error. A couple of columns had to be varchar rather than varbinary. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #65 from D J Bauch dj.ba...@gmail.com 2009-04-30 02:56:16 UTC --- Created an attachment (id=6073) -- (https://bugzilla.wikimedia.org/attachment.cgi?id=6073) Patch for the ADODB libarary, version 5.05 Minor patches to the ADODB library for PHP, version 5.05 so that it supports the MS SQL connection for MediaWiki. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #63 from Yedidia Klein yedi...@yedidia.net 2009-04-26 09:59:40 UTC --- OS: win2003, MSSQL 2000 (8.0) first thanks for the patch, I've troubles w/ installation patched 1.14.0 w/ your patch, updated tables.sql , created db and user on mssql side then got nice installation page. but after filling all info - got back the installation page w/o any error. no tables were created.. any way to debug ? what can be done ? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #62 from Aryeh Gregor simetrical+wikib...@gmail.com 2009-04-13 00:29:29 UTC --- I guess you should re-request commit access. I don't think you were denied because anyone wanted to deny you -- probably the request just got lost at some point, because granting commit access is one facet of the MediaWiki development process that seems to be particularly dysfunctional right now. If you still want it, I'd remind Brion and/or Tim every month or two if we don't get a saner system in place soon. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #58 from D J Bauch dj.ba...@gmail.com 2009-04-08 19:45:14 UTC --- Created an attachment (id=6005) -- (https://bugzilla.wikimedia.org/attachment.cgi?id=6005) Patch for MediaWiki 1.1.4.0 to adapt to MS SQL support This patch contains the changes to be applied to the 1.14.0 release to adapt the release to run on Windows with Microsoft SQL Server 2000 or SQL Server 2005. I've made it to simplify the installation for other users based on the experiences I gained going through the installation with another user. Yes, there is at least one other user that I'm aware of. I had been tracking changes against the trunk rather than against the releases -- but since the trunk is always changing it was easier to have him install the 1.14.0 release and then patch in the changes. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 D J Bauch dj.ba...@gmail.com changed: What|Removed |Added Attachment #5825 is|0 |1 obsolete|| --- Comment #59 from D J Bauch dj.ba...@gmail.com 2009-04-08 19:49:55 UTC --- Created an attachment (id=6006) -- (https://bugzilla.wikimedia.org/attachment.cgi?id=6006) MS SQL Server Script Updated MS SQL script (./maintenance/sqlserver/tables.sql) to be used in conjunction with 1.14.0 patch. This script also creates the new tables (change_tag, tag_summary, valid_tag) introduced since 1.14.0. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #60 from Alexandre Emsenhuber [IAlex] alex.emsenhu...@bluewin.ch 2009-04-08 20:15:18 UTC --- The patch (id 6005) seems to contains some strange modifications: * AutoLoader.php: where's the file? * Defines.php: this has nothing to do in core * Revision.php: don't comment that out, it's needed for PostgreSQL * SpecialShortpages.php, SpecialWantedcategories.php, SpecialWantedpages.php: why commenting out the link existence batch? * SpecialWantedtemplates.php: already fixed in r47618 * SpecialListfiles.php: already fixed in r48350 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 --- Comment #61 from D J Bauch dj.ba...@gmail.com 2009-04-09 03:09:32 UTC --- (In reply to comment #60) The patch (id 6005) seems to contains some strange modifications: * AutoLoader.php: where's the file? * Defines.php: this has nothing to do in core * Revision.php: don't comment that out, it's needed for PostgreSQL * SpecialShortpages.php, SpecialWantedcategories.php, SpecialWantedpages.php: why commenting out the link existence batch? * SpecialWantedtemplates.php: already fixed in r47618 * SpecialListfiles.php: already fixed in r48350 Yes, the modifications are strange in that they are not necessarily intended to replace the MySQL/PostgreSQL code in the trunk. They're only useful to someone trying to run on SQL Server. The file missing from autoloader.php is an attachment to the bug report (DatabaseADODB.php). It doesn't get picked up when I make the diff because it didn't exist before. The extra lines from my defines.php are for my extra namespaces and are optional. I'm assuming the commented out line you're referring to is the attempt to insert an ID in the text table. It won't work in my text table because the column is an auto-number column. I could make a view to eliminate this issue if necessary. The link existence batches don't work with the ADODB database adapter and not doing them didn't change the desired outcome. I may alter the ADODB database adapter to allow them to work at some time, but I don't own that code or have commit access on that project. Those last two already fixed issues were actually ones that I asked for but couldn't make myself (see comment #13 to this bug), since I don't have commit access. If I remember correctly, Tim Starling made the fixes back then. In addition to the patch file, you would need the tables.sql attachment above, the databaseadodb.php attachment above, and a patch to the ADODB library (which I could place here too, I suppose). -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 9767] Microsoft SQL Server/MSSQL support (tracking)
https://bugzilla.wikimedia.org/show_bug.cgi?id=9767 D J Bauch dj.ba...@gmail.com changed: What|Removed |Added Attachment #5348 is|0 |1 obsolete|| --- Comment #57 from D J Bauch dj.ba...@gmail.com 2009-02-17 23:21:01 UTC --- Created an attachment (id=5825) -- (https://bugzilla.wikimedia.org/attachment.cgi?id=5825) MS SQL Server Script Includes a change for the category table. cat_title must use COLLATE SQL_Latin1_General -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
