Bug 771693 - ipplan mysql schema needs ENGINE=INNODB
Summary: ipplan mysql schema needs ENGINE=INNODB
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: ipplan
Version: 16
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Andrew Colin Kissa
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-01-04 16:33 UTC by Matt Domsch
Modified: 2012-08-25 03:01 UTC (History)
1 user (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2012-08-25 02:58:05 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)

Description Matt Domsch 2012-01-04 16:33:46 UTC
Description of problem:
The sql/ipplan-mysql.sql file used to create the mysql database schema has TYPE=INNODB throughout, but mysql 5.5.18 in F16 no longer accepts TYPE=, it only accepts ENGINE=.  Suggest you modify sql/ipplan-mysql.sql accordingly.

Version-Release number of selected component (if applicable):
ipplan-4.92-4.a.fc16.noarch


How reproducible:
always

Steps to Reproduce:
1. mysql -p /usr/share/doc/ipplan-*/sql/ipplan-mysql.sql
  
Actual results:
ERROR 1064 (42000) at line 2: 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 'TYPE=INNODB' at line 7


Expected results:
success

Comment 1 Fedora Update System 2012-08-04 10:35:50 UTC
ipplan-4.92-5.b.fc16 has been submitted as an update for Fedora 16.
https://admin.fedoraproject.org/updates/ipplan-4.92-5.b.fc16

Comment 2 Fedora Update System 2012-08-04 10:36:46 UTC
ipplan-4.92-6.b.fc17 has been submitted as an update for Fedora 17.
https://admin.fedoraproject.org/updates/ipplan-4.92-6.b.fc17

Comment 3 Fedora Update System 2012-08-05 21:27:55 UTC
Package ipplan-4.92-5.b.fc16:
* should fix your issue,
* was pushed to the Fedora 16 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing ipplan-4.92-5.b.fc16'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-2012-11505/ipplan-4.92-5.b.fc16
then log in and leave karma (feedback).

Comment 4 Fedora Update System 2012-08-25 02:58:05 UTC
ipplan-4.92-5.b.fc16 has been pushed to the Fedora 16 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 5 Fedora Update System 2012-08-25 03:01:43 UTC
ipplan-4.92-6.b.fc17 has been pushed to the Fedora 17 stable repository.  If problems still persist, please make note of it in this bug report.


Note You need to log in before you can comment on or make changes to this bug.