MS SQL support?

[Two Face]

I run my own server with Windows 2003 Enterprise with SQL 2005 due to demands from other ventures. I am trying to set up Pligg on my SQL database, but there does not seem to be support for SQL. I was wondering if anyone has successfully install Pligg on a SQL server.

I am able to the to the install2.php page and it tells me it cannot login with information provided. I did set up a database for Pligg and I am using the correct login information. Any ideas or am I out of luck?

[savant]

hey

Pligg uses something called the ezSQL library to handle database layer

now pligg currently only supports mysql.
so you on your own when trying this out
but i'll try and help :)

look in your libs folder
you'll see a file called db.php
this is the file that handles the database layer

download a copy from
http://php.justinvincent.com/downloads/ez_sql_1.26.zip
open the ms-sql folder
drag and drop the ez_sql.php to the libs folder.
in ez_sql.php enter you ms-sql username and password.
backup your current db.php
and rename your ez_sql.php to db.php
and try it out

I do't have ms-sql so please post what you find.
i'm sure people will love the multi platform

only probelm is when making the tables, structure of mysql table maybe different from ms-sql so you might have to do them manually.

if you do have a problem theres no support cos pligg is made for mysql.
hope it works

[Two Face]

Thank you, I will try that now and let you know what happens.

[Two Face]

The file is corrupt. I cannot decompress the folder due to some parts not transfering. I have tried to download many times. I will try to find a copy of this somewhere else.

[savant]

http://savant.oioplus.com/text/

here you go i've mirrored it.

[Two Face]

Thank you for hosting it; your file worked great. I tried that, but got the same error as before:

Cannot connect to the database server using the following information.
Server: ***
User: ***
Password: ***

Fatal error: Call to undefined function _() in D:\Inetpub\wwwroot\Pligg\install\install2.php on line 113

I even deleted the user login info and rebuilt it in SQL, but no go. I still think there is some platform issue with SQL.

[AshDigg]

Are you sure you're starting the install from the beginning?

You get the error: Call to undefined function _()

The function _() is added to dbconnect.php if the install script sees that your php doesn't have support for _() built in. Either you're not doing the install or the dbconnect isn't writeable and it can't update it.

[savant]

i forgot about dbconnect.php

when you replace db.php with the one with MS-sql

find this line.

define("EZSQL_DB_USER", ""); // <-- MS SQL Server db user
define("EZSQL_DB_PASSWORD", ""); // <-- MS SQL Server db password
define("EZSQL_DB_NAME", ""); // <-- MS SQL Server db pname
define("EZSQL_DB_HOST", ""); // <-- MS SQL Server server host

replace those lines with

PHP Code:

// function _($s) {
// return $s;
// }

    include_once("dbconnect.php"); 


and try the installation.

I thought if we didn't care about dbconnect.php and have the login details in db.php it might just work.
but since you're doingthe whole installation this might be whats wrong.

not sure sry.