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. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.