Modify

Opened 4 years ago

Last modified 9 months ago

#8464 reopened defect

Project environment upgrade fails with database error

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

Description (last modified by rjollos)

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 4 years ago by rjollos

  • Description modified (diff)

comment:2 Changed 4 years ago by anonymous

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

comment:3 Changed 4 years ago by seccanj

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

I'll try to do it asap.

Ciao, Roberto

comment:4 Changed 4 years ago by seccanj

  • Status changed from new to assigned

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 4 years ago by seccanj

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

Fixed with 1.0.3 (now 1.0.4 is also available)

comment:6 follow-up: Changed 20 months ago by anonymous

  • Resolution fixed deleted
  • Status changed from closed to reopened

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 20 months ago by rjollos

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 follow-up: Changed 9 months ago by anonymous

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

comment:9 in reply to: ↑ 8 Changed 9 months ago by rjollos

Replying to anonymous:

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

Which database backend are you using?

Add Comment

Modify Ticket

Action
as reopened The owner will remain seccanj.
Author


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

 
Note: See TracTickets for help on using tickets.