Cannot get the install script to start.

[Cruise Slater]

Hey Everyone,

I would like to start by saying thanks to everyone who takes the time to read this! I am at the edge of my comfort zone trying to get this set up for my school and am in desperate need of some help if anyone is willing to offer some suggestions.

I am trying to get the install script to appear but I keep getting access to a hierarchy of the root folder in which CRBS is installed (see rooms.lalochecommunityschool.ca).

I believe my problem lies in not entering in the proper variables for the database config file. I have tried following the installation instructions but I am obviously missing something. I have attached a few pictures to help clear things up if at all possible. Note that the user password is not password but typed as a placeholder for safety reasons. 

Is anyone willing to offer some suggestions or point me in the right direction? Thanks in advance!

-Cruise

[Craig A Rodway]

Hi Cruise, thanks for checking out Classroombookings.

The main problem seems to be with the folder structure you have there. This can be fixed by moving everything from inside classroombookings-1.0.2/ into that folder where the zip file is.

Even now - it works (sort of!) if you go to rooms.lalochecommunityschool.ca/classroombookings-1.0.2/index.php/install. It just doesn't currently work correctly with the folder in the URL.

Once you've done that - you need to make a slight change to your DB config. Make sure the "dbprefix" one is empty, and change the "database" one to "lalochec_crbs". (The dbprefix in this case is if you wanted to use prefix on the table names inside the DB - typical only if the app will share a DB with other systems).

Once you have done those, you should be good to go!

Craig.

[Cruise Slater]

Thanks so much Craig! The help you offered is great and Im really looking forward to implementing this software as it meets everything we need at our school.

The file structure was definitely something I was overlooking! By moving the folder outside to the main root and removing the database prefix I was able to to view the installation script.

 However, I now receive two php errors dealing with "controllers/login.php" on lines 23 and 35 when attempting to log in. I noticed this was an issue with another user and have replaced lines 115-126 with the highlighted segment of the github code, followed by a second install but the errors are still popping up. Anything else I should try?

DROP TABLE IF EXISTS `school`;
CREATE TABLE `school` (
  `school_id` int(6) unsigned NOT NULL auto_increment,
  `name` varchar(255) NULL,
  `website` varchar(255) NULL,
  `colour` char(6) default NULL,
  `logo` varchar(40) NULL,
  `bia` int(3) unsigned NULL,
  `d_columns` enum('periods','rooms','days') NULL,
  `displaytype` enum('room','day') NULL,
  PRIMARY KEY  (`school_id`)
);

[Cruise Slater]

Craig, please disregard my last message, I had a typo in my DB username. Thanks for everything :)