Ticket #153 (defect)
Opened 2 years ago
Last modified 2 years ago
Typo in createtables.sql
Status: closed (fixed)
| Reported by: | pilotsnipes@gmail.com | Assigned to: | brieb |
|---|---|---|---|
| Priority: | minor | Milestone: | 0.8 |
| Component: | phpbms | Version: | 0.7 |
| Keywords: | Cc: | ||
There is a type in the createtables.sql file which prevents the table TABLEDEFS being created correctly.
Here it is:
CREATE TABLE `tabledefs` ( `id` int(11) NOT NULL auto_increment, `displayname` varchar(64) default NULL, `type` varchar(16) NOT NULL default 'table', `moduleid` int(11) NOT NULL default '0', `maintable` varchar(64) NOT NULL default '', `querytable` varchar(255) NOT NULL default '', `editfile` varchar(128) default NULL, `editroleid` int(11) NOT NULL default '0', `addfile` varchar(100) default '', `addroleid` int(11) NOT NULL default '0', `searchroleid` int(11) NOT NULL default '0', `advsearchroleid` int(11) NOT NULL default '-100', `viewsqlroleid` int(11) NOT NULL default '-100', `deletebutton` varchar(32) default '', `defaultwhereclause` varchar(255) default NULL, `defaultsortorder` varchar(255) default '', `defaultsearchtype` varchar(64) default '', `defaultcriteriafindoptions` varchar(128) default '', `defaultcriteriaselection` varchar(128) default '', `createdby` int(11) NOT NULL default '0', `creationdate` datetime NOT NULL default '0000-00-00 00:00:00', `modifiedby` int(11) default NULL, `modifieddate` timestamp NOT NULL, PRIMARY KEY (`id`) ) THYPE=MyISAM AUTO_INCREMENT=1000;
The LAST line should NOT have an "H" in TYPE.
Attachments
Change History
06/19/07 13:03:23: Modified by anonymous
06/19/07 13:07:25: Modified by pilotsnipes@gmail.com
More info:
It's Line 151 in /trunk/phpbms/install/createtables.sql
06/26/07 14:20:01: Modified by brieb
- status changed from new to closed.
- resolution set to fixed.
- milestone changed from unknown to 0.8.
Fixed by [247]
The first line should read:
There is a typo...