Modify

Opened 7 years ago

Closed 7 years ago

#2622 closed defect (fixed)

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

Reported by: didley@… Owned by: JamesMills
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 7 years ago by jtrahan

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

comment:2 in reply to: ↑ description Changed 7 years ago by JamesMills

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

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

Add Comment

Modify Ticket

Action
as closed The owner will remain JamesMills.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.