new schedule default start/stop times from a newbie

[clasporg]

Rgiht now the drop down box start times go from 7pm-6:30pm. Id like to be able to change the start time to 12am and the end to 11:30pm. Can I do that

[Nick]

This is in your local timezone.  You'll need to adjust for whatever timezone the server is set to.  For example, if you set the server timezone to 0 in config.php, and your local timezone to -5, choose 7 pm as the start time.  This will be midnight in the server timezone.

[clasporg]

Ive created 2 resources. In my control panel, I click bookings and try to reserve some time on a particular day.
I get an error message that says there was an error executing your query.. DB Error , no such table..

I was looking for some tutorials to make sure I was doing this right, didnt find one however.

Thanks

Dave

[Nick]

Was this an upgrade from a previous version of phpScheduleIt?

[clasporg]

Was this an upgrade from a previous version of phpScheduleIt?

No .. downloaded the most current 2 days ago

[Nick]

It sounds like the database was never fully set up.  If you dont have anything useful in there, I would try running the installation again and verify that everything looks good.

[clasporg]

Hi Nick,

  I did have problems with the install. I host this at 1and1. When I ran the script I could not create the database. So I created a database and deleted

# phpScheduleIt 1.2.0 #
drop database if exists phpScheduleIt;
create database phpScheduleIt;
use phpScheduleIt;

I inserted

use db176472340;

the name of the database

and ran the script.. It seems to have created the tables, but I did have a problem with the last line of script

grant select, insert, update, delete
ON db176472340.*
etc..

I did change username and password to the credentials of the database I created.

Any thoughts

Dave

[Nick]

There are some pretty detailed instructions for installing on a remote host included in the install directory.  Let me know if you still have problems after that.

[clasporg]

Hi again..

  Well, I really dont know what I did differently, but almost everything seems to be working. Ive added a number of resources, 2 schedules, 10 users or so, made some reservations. The only thing im aware of that is not working is Groups.

When I click on manage groups I get

There was an error executing your query:
DB Error: syntax error

Dave

PS.. this scheduler is just what we need for our group ... Thank you for the great job!!

[clasporg]

I noticed when looking at the structure of user_groups
in My_Sql admin

 PRIMARY and INDEX keys should not both be set for column `groupid`
Create an index on  columns

[Nick]

The manage groups bug is a known issue with MySQL 4.1.0 and lower.  There are workarounds posted in the forum for this.

The 2nd issue is also known, but it does not harm anything the way it is and can be ignored.

[clasporg]

Nick,

  The server Im running this on is using php 4.4.4 and mysql 4.0.27. I downloaded and installed phpscheduleit 1.2.3.

Ive looked thru the site (maybe I just didnt find it) and the one code fix I found was not applicable to phpscheduleit 1.2.3.

Im still having the manage groups problem and if you could point me the work around, Id appreciate it.

Thanks

Dave

[clasporg]

I scheduled a resource for Mon - Fri for a period 2 weeks.

I approved the reservation for all days with no problem by checking the 'apply to all in this occurence' (or words like that) checkbox

I tried to delete all of them using the same method and didnt work.

Had to delete one at a time
Dave

[Nick]

http://www.php.brickhost.com/forums/viewtopic.php?t=317

http://www.php.brickhost.com/forums/viewtopic.php?t=309

[clasporg]

Nick

  The fix suggested in post 309 fixed the db error.

  I dont think this is important to me at this point, but I cant figure out how to assign an administrator to the group.

  Thanks for all you help !!

Dave