Edgewall Software
Modify ↓

Opened 16 years ago

Closed 16 years ago

#370 closed defect (fixed)

Bitten-Upgrade fails on MySql-Backend

Reported by: manfred.benesch@… Owned by: dfraser
Priority: major Milestone: 0.6
Component: General Version: dev
Keywords: upgrade sql Cc:
Operating System: Linux

Description

After upgrading Bitten to rev 595, trac failed with "need to upgrade" error. Upgrading trac failed, because bitten uses "create temp table ..." instead of "create temporary table ..." : 

Add filename column to log table to save where log files are stored.
ProgrammingError: (1064, "Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'TEMP TABLE old_log AS SELECT * FROM bitten_log' in Zeile 1")

After replacing all "create temp table" with "create temporary table" in bitten/upgrade.py all works fine and upgrade could finished.

Attachments (0)

Change History (2)

comment:1 Changed 16 years ago by dfraser

  • Owner changed from cmlenz to dfraser
  • Status changed from new to assigned

comment:2 Changed 16 years ago by dfraser

  • Resolution set to fixed
  • Status changed from assigned to closed

Thanks for the report - I checked and this works on postgresql too, so committed the change as r598

Add Comment

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain dfraser.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.