ZoneMinder Forums

Posted: **Sun Jul 03, 2011 1:54 am**

this line

) ENGINE=@ZM_MYSQL_ENGINE@;

from file ZoneMinder-1.24.4/db/zm_create.sql.in causes an sql failure in phpadmin in xampp

Code: Select all

DROP TABLE IF EXISTS `Config`;
CREATE TABLE `Config` (
  `Id` smallint(5) unsigned NOT NULL default '0',
  `Name` varchar(32) NOT NULL default '',
  `Value` text NOT NULL,
  `Type` tinytext NOT NULL,
  `DefaultValue` tinytext,
  `Hint` tinytext,
  `Pattern` tinytext,
  `Format` tinytext,
  `Prompt` tinytext,
  `Help` text,
  `Category` varchar(32) NOT NULL default '',
  `Readonly` tinyint(3) unsigned NOT NULL default '0',
  `Requires` text,
  PRIMARY KEY  (`Name`)
) ENGINE=@ZM_MYSQL_ENGINE@;

--
-- Table structure for table `ControlPresets`
--

DROP TABLE IF EXISTS `ControlPresets`;
CREATE TABLE `ControlPresets` (
  `MonitorId` int(10) unsigned NOT NULL default '0',
  `Preset` int(10) unsigned NOT NULL default '0',
  `Label` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`MonitorId`,`Preset`)
) ENGINE=@ZM_MYSQL_ENGINE@;

Posted: **Sun Jul 03, 2011 9:18 am**

You are not supposed to use zm_create.sql.in, bu zm_create.sql which is created after ./configure is run.

mastertheknife.

Posted: **Mon Jul 04, 2011 2:40 pm**

thanks for the answer. after going through make there was no database so that is why i was in phpadmin doing things. after doing the recommended sql first, i tried sql.in in phpadmin because my install was still missing things and i though they might be in that sql.in file.
i will post the output from configure and make later and perhaps get some more directions. thanks again.

ZoneMinder Forums

sql failure

sql failure

Re: sql failure

Re: sql failure