Support Forums
AChecker
achecker install - table issues
You must be signed-in to post.
| Author | Subject | |
|---|---|---|
| Page: 1 | ||
| dhartford | Subject: achecker install - table issues |  |
| 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 | Subject: Re: achecker install - table issues | |
| 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 issues | |
| 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 issues | |
| 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.