Classroom booking System

[sippo]

Is WAMP running? What do you get when you just browse to http://localhost/ ?

WAMP says its online. I have started all the services. When I try to access localhost its the http 400 bad request- web page cannot be displayed.

[webman]

That's odd. It does sound like it's not loading properly or there is a conflict. Click on the WAMP icon > Apache > Apache error log and look for any signs in there as to what the issue could be.

[sippo]

Nothing in the error log....

[Shuriken1]

If I can find a test server to install IIS on I'll give it a go today and see how I get on.

That would be very kind of you if you could. Equally, if you don't have time, please let me know too. Thanks a lot.

This is in the background due to SIMS stuff at the moment but I would still very much like to get it working!

Thanks guys,

Shuriken.

[zag]

I've got a problem with the booking system.

Suddenly today its started not putting the days properly

[zag]

I fixed the problem by changing the offset from 1 to 2. Seems to work but I have no idea what else it might break!

function getFirstDayOfWeek($year, $weeknr)
{
	$offset = date('w', mktime(0,0,0,1,1,$year));
	$offset = ($offset < 5) ? 2-$offset : 8-$offset;
	$monday = mktime(0,0,0,1,1+$offset,$year);

	return strtotime('+' . ($weeknr - 1) . ' weeks', $monday);
}

[Hightower]

So when is version 2 hitting the high street? I can't wait to get my hands on it - It will finally mean being able to scrap the aweful system we have now as soon as webman's app has LDAP.

[denon101]

Can some one help me?

I can just get this error



Config file

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

// Full URL to your installation
$config['base_url'] = 'http://booking/crbs/';


// Empty string if using .htaccess
#$config['index_page'] = 'index.php';
$config['index_page'] = '';

// You shouldn't need to change any of these.
$config['layout'] = 'layout';
$config['language'] = 'english';
$config['uri_protocol'] = 'auto';
$config['url_suffix'] = 'http://booking/crbs/';
$config['enable_query_strings'] = FALSE;
$config['controller_trigger'] = 'c';
$config['function_trigger'] = 'm';
$config['time_reference'] = 'local';
$config['log_threshold'] = 0;
$config['log_path'] = '';
$config['log_date_format'] = 'Y-m-d H:i:s';
$config['cache_path'] = '';
$config['encryption_key'] = '';
$config['sess_cookie_name'] = 'ci_session';
$config['sess_expiration'] = 7200;
$config['sess_encrypt_cookie'] = FALSE;
$config['sess_use_database'] = FALSE;
$config['sess_table_name'] = '';
$config['sess_match_ip'] = TRUE;
$config['sess_match_useragent'] = TRUE;
$config['cookie_prefix'] = '';
$config['cookie_domain'] = '';
$config['cookie_path'] = '/';
$config['global_xss_filtering'] = TRUE;
$config['enable_hooks'] = False;
$config['permitted_uri_chars'] = 'a-z 0-9~%.:_-';
$config['compress_output'] = FALSE;
$config['subclass_prefix'] = 'MY_';
$config['rewrite_short_tags'] = FALSE;

?>

Database File

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

$active_group = "default";

$db['default']['hostname'] = 'booking';
$db['default']['username'] = 'ajones';
$db['default']['password'] = 'password';
$db['default']['database'] = 'crbs';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['active_r'] = TRUE;
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = 'dbcache';

?>

I think I have the permissions to the areas set, can anyone help??

Ta!

[webman]

@denon101: Is the database hostname actually 'booking'? Usually MySQL is running on the same server as the webserver so should just be 'localhost'.

[denon101]

I have changed it back to localhost and it has made no difference. Do you need to setup a DB in mysql? the instructions on the wiki does not give instructions on how to setup a db using SQLite.

Maybe I am doing this all wrong. Forgive my stupidity. But help would be most appreciated.

[Hightower]

I think you need to create a database with a user with rights first.

[webman]

Ah, SQLite. I've never used that before; but the documentation says:

For example, when using SQLite you will not need to supply a username or password, and the database name will be the path to your database file. The information above assumes you are using MySQL

I would create a SQLite DB first using your preferred method, and then just set the database config file to the path of the SQLite file.

[sippo]

I installed the Devizes school one now.

Anyone know how to remove the copyright? I'm going to donate anyway, they just haven't got back to me yet.

[sippo]

Devizes school have yet to get back to me. Can anyone help?

[dave.81]

I have just installed classroombookings and have to say looks great and so far been easy to setup.

But we've come across a problem where no matter what day you book it adds it today's. All dates are today. I thought i'd check the Week dates option but get page not found "http://moon:8080/room/index.php/weeks/dates_dates.php".

We also get it on reports "http://moon:8080/room/index.php/reports"

Any ideas about their only being todays date or the missing pages?