Jump to ContentJump to Navigation/Login
` ` ` ` ` `

Login
[Register]

Subscribe to Updates

Occasional ATutor release updates


Services

  • Basic Support
  • Development Services
  • Service Providers

    • Members Online

    (4 guests in past 15 min.)

    Visitors

    Locations of visitors to this page
    Home > Forums > AChecker > achecker install - table issues

    Support Forums

    AChecker

    achecker install - table issues


    You must be signed-in to post.

    AuthorSubject
      Page: 1
    dhartford
    		Subject: achecker install - table issuesQuote this post in your reply
    Trying to install Achecker 1.0 (on Zend CE 4.0 app server/apache/windows) with local Windows Mysql (5.1) install.

    Tried the mysql 'Windows essential' install first, but had the issue, tried the full windows mysql, but same issue. This was with a user that has full-access to the entire mysql database server (just to make completely sure).

    The install process via localhost/achecker/install/install.php is unable to create tables:


    AC_guidelines
    AC_privileges
    AC_user_groups

    All the other tables were created fine. I see nothing in the apache or zend logs.
    Posted: 2009-07-15 13:00:01
    cindy

    Avatar for cindy
    		Subject: Re: achecker install - table issuesQuote this post in your reply
    Can you try this:

    open [AChecker root folder]/install/db/achecker_schema.sql, copy the statement that creates one of the 3 tables, go to your mysql (command or web interface), connect to AChecker database, manually run the statement with the same mysql user, can you create the table, or what error is given?
    Posted: 2009-07-15 13:17:48
    dhartford
    		Subject: AW: achecker install - table issuesQuote this post in your reply
    modifying the Achecker/install/db/achecker_schema.sql as follows corrected the issue (for mysql 5.1)

    datatype 'text' can not have a default value. modified to be correct:

    CREATE TABLE `user_groups` (
    `user_group_id` mediumint(8) unsigned NOT NULL auto_increment,
    `title` varchar(255) NOT NULL DEFAULT '',
    `description` text NOT NULL,
    `create_date` datetime NOT NULL,
    `last_update` datetime,
    PRIMARY KEY (`user_group_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

    CREATE TABLE `privileges` (
    `privilege_id` mediumint(8) unsigned NOT NULL auto_increment,
    `title_var` varchar(255) NOT NULL DEFAULT '',
    `description` text NOT NULL,
    `create_date` datetime NOT NULL,
    `last_update` datetime,
    `link` varchar(255) NOT NULL DEFAULT '',
    `menu_sequence` tinyint(4) NOT NULL,
    `open_to_public` tinyint(4) NOT NULL DEFAULT 0,
    PRIMARY KEY (`privilege_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


    Comment inline with SQL caused issues:

    CREATE TABLE `guidelines` (
    `guideline_id` mediumint(8) unsigned NOT NULL auto_increment,
    `user_id` mediumint(8) unsigned NOT NULL default 0,
    `title` varchar(255) default NULL,
    `abbr` varchar(100) default NULL,
    `long_name` varchar(255) default NULL,
    `published_date` date default NULL,
    `earlid` varchar(255) default NULL,
    `preamble` text,
    `status` tinyint(3) unsigned NOT NULL default '0',
    `open_to_public` tinyint(4) NOT NULL DEFAULT 0,
    `seal_icon_name` varchar(255),
    `subset` varchar(100) NOT NULL DEFAULT 0,
    PRIMARY KEY (`guideline_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10;
    # 'Value 0 means this guideline is not a subset of any other guidelines. The format of non-zero value is [guideline group]-[priority], which means this guideline is the subset of others. The guidelines with same [guideline group] are in the same group. For the guidelines in the same group, the ones with lower [priority] value is the subset of the ones with higher [priority] value.',
    Posted: 2009-07-15 13:19:07
    dhartford
    		Subject: Re: AW: achecker install - table issuesQuote this post in your reply
    heh, thanks for the reply Cindy, I was in the middle of just doing that when I posted the above :-)
    Posted: 2009-07-15 13:20:24
     Page: 1

    You must be signed-in to post.