Modify

Opened 7 years ago

Last modified 4 years ago

#8464 reopened defect

Project environment upgrade fails with database error

Reported by: anonymous Owned by: Roberto Longobardi
Priority: normal Component: ResourceReservationPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12

Description (last modified by Ryan J Ollos)

I was trying to install the ResourceReservationPlugin on my system running:

Trac: 0.12.2dev-r10313
MySQL: "5.0.75-0ubuntu10.5", client: "5.0.75", thread-safe: 1

Installation goes fine, I managed to enable the plugin, but failed to upgrade the Trac environment:

Trac [/export/trac/my_project]> upgrade
use the hashlib module instead
resreservation needs to create the db
resreservation needs to create the db
upgrade_environment
resreservation needs to create the db
_upgrade_db
exception in the database creation
OperationalError: (1072, "Key column 'res_from' doesn't exist in table")
Trac [/export/trac/my_project]> quit

I checked the database but there were no tables by the name res* .

Attachments (0)

Change History (9)

comment:1 Changed 7 years ago by Ryan J Ollos

Description: modified (diff)

comment:2 Changed 7 years ago by anonymous

I get exactly the same error when trying to upgrade....any improvements on this?

comment:3 Changed 7 years ago by Roberto Longobardi

Sorry guys, I couldn't take a look at this yet.

I'll try to do it asap.

Ciao, Roberto

comment:4 Changed 7 years ago by Roberto Longobardi

Status: newassigned

I have just released on SourceForge a new release, 1.0.3, which works fine on Trac 0.12.2 in my environment.

Let me know if you still have problems. Otherwise, please close this ticket.

Ciao, Roberto

comment:5 Changed 6 years ago by Roberto Longobardi

Resolution: fixed
Status: assignedclosed

Fixed with 1.0.3 (now 1.0.4 is also available)

comment:6 Changed 4 years ago by anonymous

Resolution: fixed
Status: closedreopened

1.0.4 installed on Trac 1.0 does not create tables res*

Error: Macro ResourceReservationList() failed
no such table: resreservation

comment:7 in reply to:  6 Changed 4 years ago by Ryan J Ollos

Replying to anonymous:

1.0.4 installed on Trac 1.0

Do you see the same error as shown in comment:description?

I can't spot the source code on SF, I see only the eggs.

comment:8 Changed 4 years ago by anonymous

Error: Macro ResourceReservationList(type=chamber1,period=3,override=false) failed no such table: resreservation

comment:9 in reply to:  8 Changed 4 years ago by Ryan J Ollos

Replying to anonymous:

Error: Macro ResourceReservationList(type=chamber1,period=3,override=false) failed no such table: resreservation

Which database backend are you using?

Modify Ticket

Change Properties
Set your email in Preferences
Action
as reopened The owner will remain Roberto Longobardi.

Add Comment


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

 
Note: See TracTickets for help on using tickets.