Loading...
 
Skip to main content

new tikitrunk install (Nov29, 2008) shows sql errors on mysql 5.0.51a

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
new tikitrunk install (Nov29, 2008) shows sql errors on mysql 5.0.51a
Version
3.x
Category
  • Error
Feature
Installer (profiles, upgrades and server-related issues)
Resolution status
Fixed or Solved
Submitted by
Xavier de Pedro
Lastmod by
Xavier de Pedro
Rating
(0)
Description

I just installed a brand new tiki trunk on local (Ubuntu GNU/Linux 8.04, using Mysql 5.0.51a), and tiki-install.php returned those error messages:

Copy to clipboard
SELECT patch_name FROM tiki_schema
Table 'tikitrunk_svn.tiki_schema' doesn't exist
CREATE TABLE tiki_tracker_fields (
  fieldId int(12) NOT NULL auto_increment,
  trackerId int(12) NOT NULL default '0',
  name varchar(255) default NULL,
  options text,
  type char(15) default NULL,
  isMain char(1) default NULL,
  isTblVisible char(1) default NULL,
  position int(4) default NULL,
  isSearchable char(1) NOT NULL default 'y',
  isPublic char(1) NOT NULL default 'n',
  isHidden char(1) NOT NULL default 'n',
  isMandatory char(1) NOT NULL default 'n',
  description text,
  isMultilingual char(1) default 'n',
  itemChoices text,
  errorMsg text,
  visibleBy text,
  editableBy text,
  descriptionIsParsed char(1) default 'n',
  PRIMARY KEY (fieldId),
  INDEX trackerId (trackerId),
) ENGINE=MyISAM AUTO_INCREMENT=1 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE=MyISAM AUTO_INCREMENT=1' at line 23

#2008-11-05 rook1666
ALTER TABLE tiki_calendar_items ADD COLUMN allday tinyint(1) NOT NULL default '0'
Duplicate column name 'allday'
#2008-11-20 JohannesMoser
ALTER TABLE `tiki_polls` ADD `anonym` ENUM( 'a', 'u', 'i', 'c' ) NOT NULL DEFAULT 'u'
Duplicate column name 'anonym'
#2008-11-25 kerrnel22
ALTER TABLE tiki_tracker_fields CHANGE type type VARCHAR(15) default NULL
Table 'tikitrunk_svn.tiki_tracker_fields' doesn't exist
Importance
6
Priority
30
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
2185
Created
Saturday 29 November, 2008 11:08:31 UTC
by Unknown
LastModif
Monday 01 February, 2010 10:13:46 UTC


Show PHP error messages