Modify

Opened 9 years ago

Closed 9 years ago

#2622 closed defect (fixed)

using of [[SQL(select * from bar)]]

Reported by: didley@… Owned by: James Mills
Priority: normal Component: SqlQueryMacro
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

Hi,

it's me again. Thanx I could download your egg and it's already installed. see it under Plugins and it's enabled.

But I get the message

Error: Macro SQL(SELECT summary FROm ticket) failed
no such table: ticket

I want read your example of your hompage but there is an error no SubWiki ...

Have I to announce my trac that the sql statemant should use the trac.db?

Attachments (0)

Change History (2)

comment:1 Changed 9 years ago by Jason Trahan

I get the same thing. It's acting like its not talking to the right database.

comment:2 in reply to:  description Changed 9 years ago by James Mills

Resolution: fixed
Status: newclosed

Replying to didley@gmx.de:

Hi,

Hi again :)

it's me again. Thanx I could download your egg and it's already installed. see it under Plugins and it's enabled.

But I get the message

Error: Macro SQL(SELECT summary FROm ticket) failed
no such table: ticket

I want read your example of your hompage but there is an error no SubWiki ...

Have I to announce my trac that the sql statemant should use the trac.db?

Oh I do apolagise. I did not include an example of how to configure the plugin. If you look in the Web Admin under trac.ini configuration tool.

You need a section like this:

[sqlquery]
uri=oracle://tamsd:tamsd@tams/

I'll include an example on the wiki page here at TH.

Also, do you have pymills installed ? It uses this to connect to:

  • SQLite
  • MySQL
  • Oracle

--JamesMills

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain James Mills.
The resolution will be deleted.

Add Comment


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

 
Note: See TracTickets for help on using tickets.