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

Login
[Register]

Subscribe to Updates

Occasional ATutor release updates


Services

Members Online

No Members Logged In

(7 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.