Plugin SQL needs multi option for stored procedure data
- Status
- Closed
- Subject
- Plugin SQL needs multi option for stored procedure data
- Version
- 1.9.x
- Category
- Error
- Feature
- Administration
- Resolution status
- Duplicate
- Submitted by
- SEWilco
- Lastmod by
- SEWilco
- Rating
- Description
The plugin SQL can not retrieve data returned from a SELECT which is in a stored procedure. Stored procedures can be more secure than granting database read access to the TikiWiki server.
With MySQL, data can be retrieved from a stored procedure if the "mysqli" interface is used instead of "mysql", and if the client_multi_results flag is set before calling NConnect().
if( $dbdriver == 'mysqli' ){
$dbsqlplugin->clientFlags = 131074; // set client_multi_results
}- Importance
- 9 high
- Priority
- 45
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 1903
- Created
- Monday 28 July, 2008 18:19:40 UTC
by Unknown - LastModif
- Wednesday 11 November, 2009 00:01:21 UTC