Installation

Help
Lanny
2008-06-07
2013-07-24
  • Lanny

    Lanny - 2008-06-07

    I am having difficulty understanding the setup.txt.  If I just bring the root directory of php calendar into my root document on the webserver and the http to it I get 

    Warning: include_once(/Library/WebServer/Documents/booking_calendar/includes/functions/database.php) [function.include-once]: failed to open stream: No such file or directory in /Library/WebServer/Documents/bcal/includes/application_top.php on line 126

    Warning: include_once() [function.include]: Failed opening '/Library/WebServer/Documents/booking_calendar/includes/functions/database.php' for inclusion (include_path='/Library/WebServer/Documents/booking_calendar/:/Library/WebServer/Documents/booking_calendar/includes/:/Library/WebServer/Documents/booking_calendar/includes/functions/:/Library/WebServer/Documents/booking_calendar/includes/widgets/:/Users/lanny/includesl:.:/usr/share/pear') in /Library/WebServer/Documents/bcal/includes/application_top.php on line 126

    Fatal error: Call to undefined function wrap_db_connect() in /Library/WebServer/Documents/bcal/includes/application_top.php on line 128

    Is there an installation guide somewhere which I missed? What do I need to do BEFORE starting to access thhrough the web?

    Thx

     
    • Jeff Walters

      Jeff Walters - 2008-06-14

      From setup.txt

      Much of the 'application_top.php' file is setup constants, which
      are already defined properly.  Web server and file server paths
      are defined and PHP include paths are extended.

      MAIL_MYNAME and MAIL_MYEMAIL must be set for the Web server to
      allow Sendmail to function properly.

      Make sure to properly set the SQL database connection constants:
      DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE
      Check with your ISP if you are not sure of your database connection.

      Towards the bottom of the 'application_top.php' file are the
      majority of the booking calendar settings.

      BOOKING_TIME_INTERVAL:

      This is an extremely important setting!!!!!!!
      Once set, it can not be modified.  I recommend setting the interval
      to either '30' or '15' (seconds).  This should suffice for most
      booking calendar situations.

      MIN_BOOKING_HOUR and MAX_BOOKING_HOUR

      These two settings are also extremely important! Once set, you can
      expand the range, but it has not been fully tested yet.  Reducing the
      range would be more challenging and is not yet supported.

      location_db_name

      This array provides the mapping between location key and the schedule
      MySQL DB table field name.  Is you add additional keys, make sure to
      add the columns to the 'booking_schedule' table.

      location_display

      This array provides the mapping between location keys and the
      display text to be used by the Booking Calendar.

      Requirements for authentication (login) and user settings can
      also be found at the end of this script.

      MySQL:

      Once you've defined the basic setup parameters it's time to
      setup your MySQL tables.  MySQL SQL setup can be found in

      includes/sql/mysql.sql

      I would recommend using phpMyAdmin or some other MySQL tool
      to execute the setup query.  Make sure to add columns for
      additional locations in the 'booking_schedule' table, if needed.

      http://www.phpmyadmin.net/home_page/

      FCK Editor 2.0 Beta 1:

      The booking calendar takes full advantage of one of the best
      WYSIWYG text editors available, FCK Editor.  Now in version 2.0,
      it supports Internet Explorer, Mozilla and Netscape browsers.

      http://www.fckeditor.net/

      FCK Editor directory: editor
      Setup file for the FCK Editor:  fckconfig.js
      CSS for the FCK Editor:  editor/skins/office2003/fck_editor.css

      The FCK Editor distribution has been trimmed down.  For additional
      skins and languages, please visit the FCK Editor download page.

      overLIB 4.00:

      Also integrated into the calendar is the overLIB javascript
      which handles the creation of the popup information boxes.

      http://www.bosrup.com/web/overlib/

      CSS/Fonts can be found in the setup file:  overlib.js

      Session Directory:

      The includes/sessions/ directory must be made writable for the
      user sessions to be stored.  This script is setup not to use the
      PHP default sessions directory, because of security issues.

      chmod 0775 sessions

      Log Files and Logs Directory:

      The Logs Directory and the included files need to also be set
      to writable and executable.

      chmod 0775 logs
      chmod 0664 parse_time_log.txt

      Beta Warning:

      While this is the first official release of the phpBookingCalendar -
      booking calendar script, I can not guarantee that future versions will
      be backwards compatible.  Indeed, the database location mapping will
      most likely be integrated into a future administration section.

      Thank you for reading all the way down here ;)
      Jeff Walters

       
    • Jeff Walters

      Jeff Walters - 2008-06-14

      # phpMyAdmin MySQL-Dump
      # version 2.2.6
      # http://phpwizard.net/phpMyAdmin/
      # http://www.phpmyadmin.net/ (download page)
      #
      # Host: localhost
      # Generation Time: Apr 23, 2003 at 06:54 PM
      # Server version: 3.23.43
      # PHP Version: 4.1.1
      # Database : `booking`
      # --------------------------------------------------------

      #
      # Table structure for table `booking_event`
      #

      CREATE TABLE booking_event (
        event_id mediumint(9) unsigned NOT NULL auto_increment,
        user_id smallint(6) unsigned NOT NULL default '0',
        subject varchar(150) NOT NULL default '',
        location varchar(50) NOT NULL default '',
        starting_date_time datetime NOT NULL default '0000-00-00 00:00:00',
        ending_date_time datetime NOT NULL default '0000-00-00 00:00:00',
        recur_interval varchar(15) NOT NULL default 'none',
        recur_freq tinyint(4) NOT NULL default '0',
        recur_until_date date NOT NULL default '0000-00-00',
        description text NOT NULL,
        date_time_added datetime NOT NULL default '0000-00-00 00:00:00',
        last_mod_by_id smallint(6) NOT NULL default '0',
        last_mod_date_time datetime NOT NULL default '0000-00-00 00:00:00',
        PRIMARY KEY  (event_id),
        UNIQUE KEY event_id (event_id),
        KEY user_id (user_id)
      ) TYPE=MyISAM;
      # --------------------------------------------------------

      #
      # Table structure for table `booking_schedule`
      #

      CREATE TABLE booking_schedule (
        date_time_id mediumint(9) unsigned NOT NULL auto_increment,
        schedule_date_time datetime NOT NULL default '0000-00-00 00:00:00',
        day_of_the_week_id tinyint(4) unsigned NOT NULL default '0',
        event_id_location_1 mediumint(9) unsigned NOT NULL default '0',
        event_id_location_2 mediumint(9) unsigned NOT NULL default '0',
        event_id_location_3 mediumint(9) unsigned NOT NULL default '0',
        PRIMARY KEY  (date_time_id),
        UNIQUE KEY starting_date_time (schedule_date_time)
      ) TYPE=MyISAM;
      # --------------------------------------------------------

      #
      # Table structure for table `booking_user`
      #

      CREATE TABLE booking_user (
        user_id mediumint(9) unsigned NOT NULL auto_increment,
        username varchar(16) NOT NULL default '',
        passwd varchar(36) NOT NULL default '',
        firstname varchar(100) NOT NULL default '',
        lastname varchar(100) NOT NULL default '',
        groups varchar(100) NOT NULL default '',
        email varchar(100) NOT NULL default '',
        PRIMARY KEY  (user_id),
        UNIQUE KEY user_id (user_id)
      ) TYPE=MyISAM;

         

       
    • Alpha Phi Omega

      Alpha Phi Omega - 2008-07-22

      I have received the same error:

      Warning: include_once(/home/apopieta/public_html/booking_calendar/includes/functions/database.php) [function.include-once]: failed to open stream: No such file or directory in /home/apopieta/public_html/BCalendar/includes/application_top.php on line 126

      Warning: include_once() [function.include]: Failed opening '/home/apopieta/public_html/booking_calendar/includes/functions/database.php' for inclusion (include_path='/home/apopieta/public_html/booking_calendar/:/home/apopieta/public_html/booking_calendar/includes/:/home/apopieta/public_html/booking_calendar/includes/functions/:/home/apopieta/public_html/booking_calendar/includes/widgets/:.:/usr/lib/php:/usr/local/lib/php') in /home/apopieta/public_html/BCalendar/includes/application_top.php on line 126

      Fatal error: Call to undefined function wrap_db_connect() in /home/apopieta/public_html/BCalendar/includes/application_top.php on line 128

      I have read the setup, but I still get this error.

      What exactly does this mean and HOW do I fix it?

       
    • VIP member

      VIP member - 2008-09-30

      Maybe you have uploaded the calendar code somewhere else than /booking_calendar directory? I wanted to use another name so I had to adjust the application_top.php accordingly.

      If the path is ok, there might be some file/directory access problems (though the zipped code packet maintains the directory rights quite well).

      Just my thoughts,
      VIP

       
    • VIP member

      VIP member - 2008-09-30

      Documenting further ...

      The basic installation went ok.

      When registering, I found out that my email address can't have top level domain with four characters, so an email address like somebody@mydomain.info does not work. I think this can be overridden in the validations.php with some additional code - yes.

      Logged in ok, but the login form popped up always: the session directory needs write access. Ok.

      I had changed the default installation directory, and had to adjust settings, not only in the application_top.php but in the add_event.php and details_view.php (for FCKeditor to work).

      Event descriptions have extra " characters, let's see some other day. Ok, they might have been the emoticon I tried to include, the image path have some extra characters??

      But hey, it works! Thanks!

       
    • Dwayne Schnell

      Dwayne Schnell - 2008-10-17

      I also get:

      [code]
      Warning: include_once(/home/content/i/n/v/investadmin/html/booking_calendar/includes/functions/database.php) [function.include-once]: failed to open stream: No such file or directory in /home/content/i/n/v/investadmin/html/loklomedia/scripts/booking_calendar/includes/application_top.php on line 251

      Warning: include_once() [function.include]: Failed opening '/home/content/i/n/v/investadmin/html/booking_calendar/includes/functions/database.php' for inclusion (include_path='/home/content/i/n/v/investadmin/html/booking_calendar/:/home/content/i/n/v/investadmin/html/booking_calendar/includes/:/home/content/i/n/v/investadmin/html/booking_calendar/includes/functions/:/home/content/i/n/v/investadmin/html/booking_calendar/includes/widgets/:.:/usr/local/php5/lib/php') in /home/content/i/n/v/investadmin/html/loklomedia/scripts/booking_calendar/includes/application_top.php on line 251

      Fatal error: Call to undefined function wrap_db_connect() in /home/content/i/n/v/investadmin/html/loklomedia/scripts/booking_calendar/includes/application_top.php on line 255
      [/code]

      I've setup application_top.php properly, inlcudes folder is set to 755, tables have been created in DB using the .sql script. (using _10d.zip file version).  Initially had it on my WAMP testing server, then tried setting it up on my linux host: www.loklomedia.com/scripts/booking_calendar

      help?

       
      • VIP member

        VIP member - 2008-10-18

        Look at your folder paths.
        /home/content/i/n/v/investadmin/html/booking_calendar/includes/functions/database.php
        /home/content/i/n/v/investadmin/html/loklomedia/scripts/booking_calendar/includes/application_top.php

        What is your document root directory (the path to folder where www.lokmedia.com/something.html can be found)?

         
        • Dwayne Schnell

          Dwayne Schnell - 2008-10-18

          Aha, fresh eyes.  the path was too long that I didn't realize I was missing half the path!  The first path you pasted was missing /loklomedia/scripts/ before booking calendar.

          Now I can't connect to db...I'll figure it out.  probably user error again (always is).

          Thanks.

           
  • vicandjay

    vicandjay - 2013-07-24

    i meet some problem on

    // MAIL SETTINGS
    // Rewrite Mail Settings for Windows
    // Note, the mail settings have to be specific for the server!
    if (TESTING_SERVER) {
    ini_set('SMTP', 'smtp.yourdomain.com');
    ini_set('sendmail_from', 'username@yourdomain.com');
    define ('MAIL_MYNAME', 'Booking Calendar');
    define ('MAIL_MYEMAIL', 'username@yourdomain.com');
    } else { // Web Server
    define ('MAIL_MYNAME', 'Booking Calendar');
    define ('MAIL_MYEMAIL', 'noreply@yourdomain.com');
    }

    how set rewrite the mail setting for windows?

     

Log in to post a comment.