navigation  interaction  search

 other resources

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

The first line should read:

There is a typo...

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]


Add/Change #153 (Typo in createtables.sql)




Change Properties
Action

 
Copyright © 2006-2007 Kreotek, LLC. All Rights reserved.