phpcollab
Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Support » General Support » SQL Server Installation - connects but doesn't setup the tables
icon9.gif  SQL Server Installation - connects but doesn't setup the tables [message #8622] Tue, 16 February 2010 02:40 Go to next message
jackx is currently offline jackx
Messages: 2
Registered: February 2010
Location: UK
phpCollab guest
Hi,

I'm impressed with the product but in our corporate environment we use SQL Server 2005. I have edited the settings.php so that Apache connects to the database. I know this because I'm no longer getting the connection errors but instead errors like this one:

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'sorting'. (severity 16) in C:\phpCollab-xampp\htdocs\phpcollab\includes\request.class.p hp on line 53

Basically it's because the tables are not there. According to the intro_install guide the tables are created during setup but this isn't happening and yes I am setting the connection settings before running the install. I've tried it on a fresh XP machine just to be sure.

Can someone provide me with an sql script to setup all the necessary database objects? I've searched the files but can only find the scripts for mysql and postgresql

Using SQL Server 2005 as the back-end database server will allow me to integrate phpCollab with our other servers. We already have a PHP website (running on RHEL) that with an SQL Server 2005 back end and it works very well and I'm eager for us to start using more PHP !!

Many thanks

Jack
Report message to a moderator
Re: SQL Server Installation - connects but doesn't setup the tables [message #8626 is a reply to message #8622 ] Mon, 22 February 2010 20:55 Go to previous messageGo to next message
mindblender is currently offline mindblender
Messages: 556
Registered: July 2003
Location: AZ
phpCollab contributor
jackx wrote on Mon, 15 February 2010 18:40

Hi,

I'm impressed with the product but in our corporate environment we use SQL Server 2005. I have edited the settings.php so that Apache connects to the database. I know this because I'm no longer getting the connection errors but instead errors like this one:

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'sorting'. (severity 16) in C:\phpCollab-xampp\htdocs\phpcollab\includes\request.class.p hp on line 53

Basically it's because the tables are not there. According to the intro_install guide the tables are created during setup but this isn't happening and yes I am setting the connection settings before running the install. I've tried it on a fresh XP machine just to be sure.

Can someone provide me with an sql script to setup all the necessary database objects? I've searched the files but can only find the scripts for mysql and postgresql

Using SQL Server 2005 as the back-end database server will allow me to integrate phpCollab with our other servers. We already have a PHP website (running on RHEL) that with an SQL Server 2005 back end and it works very well and I'm eager for us to start using more PHP !!

Many thanks

Jack




Jack,

Thanks for the comments. In regards to your issue, are you using the CVS version of phpCollab?

regards,
Jeff

[Updated on: Mon, 22 February 2010 20:56]

Report message to a moderator
Re: SQL Server Installation - connects but doesn't setup the tables [message #8628 is a reply to message #8626 ] Mon, 22 February 2010 21:45 Go to previous messageGo to next message
jackx is currently offline jackx
Messages: 2
Registered: February 2010
Location: UK
phpCollab guest
Jeff,

I think so, downloaded it from here:

http://sourceforge.net/projects/phpcollab/files/

Cheers

Jack
Report message to a moderator
Re: SQL Server Installation - connects but doesn't setup the tables [message #8630 is a reply to message #8628 ] Tue, 23 February 2010 09:07 Go to previous message
mindblender is currently offline mindblender
Messages: 556
Registered: July 2003
Location: AZ
phpCollab contributor
jackx wrote on Mon, 22 February 2010 13:45

Jeff,

I think so, downloaded it from here:

http://sourceforge.net/projects/phpcollab/files/

Cheers

Jack



Jack,

Most likely you snagged an old copy. I just uploaded a CVS version under the beta releases. You might give that a try.

Jeff
Report message to a moderator
Previous Topic:Assigning Support Requests
Next Topic:PANIC! Error during connection on server MySQL.
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Wed Sep 8 20:52:27 CEST 2010

Total time taken to generate the page: 0.04088 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7RC1.
Copyright ©2001-2007 FUD Forum Bulletin Board Software