BW 1.31 database connection error

6shooterNed
Joined: 09 Jun 2008

BW 1.31 database connection error

Posted:01 Jul 2008 (13:02 UTC)
Hello,

I ran into the following error message while setting up the database connection in the BW 1.31 install wizard. I verified the database settings in the kernel\config_inc.php.

Database connection could not be established.

The returned error message is:
Incorrect syntax near 'tiki_preferences'.

Win2k3
IIS
SQL 2005
PHP 5.26
Will
Joined: 28 Sep 2005

Re: BW 1.31 database connection error

Posted:01 Jul 2008 (13:44 UTC)
is this a new site, or updating an old or migrating from tikiwiki site?
spiderr
Profile Picture
Joined: 08 Feb 2004

Re: BW 1.31 database connection error

Posted:01 Jul 2008 (13:51 UTC)
Ned, can you post the exact SQL line that failed? It should have been dumped in the fatal error. Actually, if you could post the entire stack and SQL errors (everything on screen when it puked (:razz:), we call that a "Fatal" ) that would be great.
6shooterNed
Joined: 09 Jun 2008

Re: BW 1.31 database connection error

Posted:01 Jul 2008 (13:51 UTC)
New Site... not migrating from TikiWiki... thx
6shooterNed
Joined: 09 Jun 2008

Re: BW 1.31 database connection error

Posted:01 Jul 2008 (13:56 UTC)
Hi Spiderr,

hope this is what you are looking for... thx

Warning: mssql_connect() function.mssql-connect: Unable to connect to server: localhost in K:\Bitweaver131\util\adodb\drivers\adodb-mssql.inc.php on line 508

Click here to log a bug, if this appears to be an error with the application.

Go here to begin the installation process, if you haven't done so already.

- 1.3.1 - Tue Jul 01 10:54:23 2008

        1. USER AGENT: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
        2. ACCT: User unknown
        3. URL: http://servername/index.php
        4. HOST: servername
        5. IP: x.x.x.x
        6. SQL: localhost
        7. ADODB: Message: Connection error to server 'localhost' with user 'bitweaver'

}}}}}} -> bit_error_string(Array7)
}}}}}} LINE: 40, K:\Bitweaver131\kernel\bit_error_inc.php
}}}}} -> bit_error_handler(mssql, CONNECT, false, Connection error to server 'localhost' with user 'bitweaver', localhost, bitweaver, Object:ADODB_mssql)
}}}}} LINE: 425, K:\Bitweaver131\util\adodb\adodb.inc.php
}}}} -> ADOConnection::Connect(localhost, bitweaver, password, bitweaver)
}}}} LINE: 111, K:\Bitweaver131\kernel\BitDb.php
}}} -> ADOConnection
BitDb
BitDb()
}}} LINE: 67, K:\Bitweaver131\kernel\setup_inc.php
}} -> ADOConnection
BitDb
require_once(K:\Bitweaver131\kernel\setup_inc.php)
}} LINE: 9, K:\Bitweaver131\bit_setup_inc.php
} -> ADOConnection
BitDb
require_once(K:\Bitweaver131\bit_setup_inc.php)
} LINE: 23, K:\Bitweaver131\index.php

Fatal error: Call to a member function isFatalActive() on a non-object in K:\Bitweaver131\kernel\bit_error_inc.php on line 59
spiderr
Profile Picture
Joined: 08 Feb 2004

Re: BW 1.31 database connection error

Posted:01 Jul 2008 (15:22 UTC)
Ned,

This is a problem with your local MSSQL configuration. Whatever database settings you are using in kernel/config_inc.php does not work with your MSSQL setup. Try to make a connection using the identical settings on the same host using another tool. Could be permissions, could be it is not accepting connections on the local interface. Could be Windows love. Dunno. I know nothing about windows except I should personally avoid it.
Stephan Borg
Joined: 15 Feb 2004

Re: BW 1.31 database connection error

Posted:01 Jul 2008 (19:42 UTC)
SetupMSSQL

This is about 3 years old, but some of it may still be relevant.
  Page 1 of 1  1