phpScheduleIt
May 25, 2013, 11:43:47 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: phpScheduleIt 2.4.2 has been released!
 
   Home   Help Login Register  
Pages: [1]
  Print  
Author Topic: MSSQL  (Read 2629 times)
ssj2goku
Newbie
*

Karma: 0
Posts: 2


« on: July 06, 2006, 09:11:14 AM »

Hi, I'm trying to install phpscheduleit with an SQL server DB, but I'm having some problems.

I copied the files to the server, adjusted the config.php and created the database (+user)

When I choose Manage users I get: There was an error executing your query: DB Error: unknown error
On the ctrlpnl.php page I get (below announcements) the same error
If  I make a reservation I get:
Warning: mkdir(/var/log): No such file or directory in C:\Inetpub\vhosts\kfsi.be\httpdocs\tester\phpscheduleit\lib\CmnFns.class.php on line 193
Warning: touch(): Unable to create file /var/log/phpscheduleitlog.txt because No such file or directory in C:\Inetpub\vhosts\kfsi.be\httpdocs\tester\phpscheduleit\lib\CmnFns.class.php on line 195
Your reservation was successfully created for the following dates: 07/03/2006
Close


Does anybody have some experience with this?
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #1 on: July 06, 2006, 10:11:51 AM »

I would just turn off phpScheduleIt logging from the config.php file.  It is trying to write to a directory that doesn't exist on a Windows machine.
Logged
ssj2goku
Newbie
*

Karma: 0
Posts: 2


« Reply #2 on: July 07, 2006, 05:09:10 AM »

Part of the problem is solved now. There are no more errors when I make a reservation.

But the other errors are still there.
It's always the same message: There was an error executing your query: DB Error: unknown error
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #3 on: July 07, 2006, 08:14:24 AM »

When trying to make a reservation?
Logged
tacfit
Newbie
*

Karma: 0
Posts: 7


« Reply #4 on: July 11, 2007, 10:21:49 AM »

Quote from: "Nick"
I would just turn off phpScheduleIt logging from the config.php file.  It is trying to write to a directory that doesn't exist on a Windows machine.


Thanks for this Nick. We were getting an error at various times, with the same message:
Warning: mkdir(/var/log): No such file or directory

Turning off logging fixed it for us too. Is there any way to have logging work?
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #5 on: July 12, 2007, 01:12:24 PM »

The logging in the app is pretty weak right now, so even turning it on isn't going to produce much.  But to get it working you should just have to grant PHP read/write permission on whatever directory is specified for logging in config.php.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2006-2007, Simple Machines Valid XHTML 1.0! Valid CSS!