Installation Issues

[benmor...@googlemail.com]

I am sure I am doing something stupid but I have installed ClassroomBookings on IIS and installed Mysql, mysql workbench, and PHP, downloaded the modified .sql file as mentioned in another thread (as I was getting the errors too) however when I attempt to log in using my admin credentials, it says they are invalid.

When I query the DB table in workbench, I can see the users table is completely empty which I assume is why I cannot login, can someone point me in the right direction?

[Craig A Rodway]

Hi Ben

Once you managed to run the updated SQL file, did you re-run the installer? That should be enough to get you going.

If not, an alternative would be to run the following snippet against the database to create a user:

INSERT INTO `users` (`user_id`, `school_id`, `department_id`, `username`, `firstname`, `lastname`, `email`, `password`, `authlevel`, `displayname`, `ext`, `lastlogin`, `enabled`, `created`) VALUES

(NULL, 1, 0, 'admin', NULL, NULL, 'te...@example.com', '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', 1, NULL, NULL, '2013-12-19 23:25:28', 1, '0000-00-00');

The password for that account is "password".

One other important thing to check is that there is an entry in the "schools" table as well - there should be one row in there with an ID of 1.

Hope that helps.

Craig.