0000729: 3.50Beta2 - Database creation error

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0000729

SiT!

setup/config

public

2009-06-15 14:35

2009-08-16 14:39

Reporter

Tomse

Assigned To

ivan

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

3.45

Target Version

3.50

Fixed in Version

3.50

Summary

0000729: 3.50Beta2 - Database creation error

Description

During setup and having SiT create the database (have only tried with no data)

the following errors occurs

A MySQL error occurred: [1064] 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 '' at line 4
You may have found a bug, if you think this is the case please report it.
Raw SQL: CREATE TABLE `supportcontacts` ( `maintenanceid` int(11) default NULL, `contactid` int(11) default NULL, PRIMARY KEY ( `maintenanceid` , `contactid` )

A MySQL error occurred: [1064] 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' at line 1
You may have found a bug, if you think this is the case please report it.
Raw SQL: ) ENGINE=MyISAM

A MySQL error occurred: [1146] Table 'sit.supportcontacts' doesn't exist
You may have found a bug, if you think this is the case please report it.
Raw SQL: INSERT INTO `supportcontacts` VALUES (1,1)

Summary: 3 Error(s) occurred while creating the schema, please resolve the problems reported and then try running setup again.

Additional Information

svn5458

Tags

No tags attached.

Attached Files

Relationships

Notes
(0001209) ivan (administrator) 2009-06-15 14:46	I can reproduce this

(0001210) ivan (administrator) 2009-06-15 14:49	Fixed in trunk svn r5459

(0001635) ivan (administrator) 2009-08-16 14:39	Released in 3.50rc1

Issue History
Date Modified	Username	Field	Change
2009-06-15 14:35	Tomse	New Issue
2009-06-15 14:36	Tomse	Summary	3.50Beta2 => 3.50Beta2 - Database creation error
2009-06-15 14:36	Tomse	Additional Information Updated
2009-06-15 14:46	ivan	Note Added: 0001209
2009-06-15 14:46	ivan	Assigned To	=> ivan
2009-06-15 14:46	ivan	Status	new => assigned
2009-06-15 14:49	ivan	Note Added: 0001210
2009-06-15 14:49	ivan	Status	assigned => resolved
2009-06-15 14:49	ivan	Resolution	open => fixed
2009-06-15 14:49	ivan	Fixed in Version	=> Current SVN
2009-06-15 14:49	ivan	Target Version	=> 3.50
2009-08-16 13:16	ivan	Fixed in Version	Current SVN => 3.50
2009-08-16 14:39	ivan	Note Added: 0001635
2009-08-16 14:39	ivan	Status	resolved => closed