Loading...
 
Features / Usability

Features / Usability


Re: Re: pluginSQL out of order

posts: 8

When I try to use the sql plugin in 1.9, i get this error message:
"Missing file: /var/www/devvvv.meso.net/tikiwiki/lib/adodb/drivers/adodb- mysql.inc.php"
notice the space after "adodb- ".

The same plugin does work well on my 1.8.5. installation.

I got the same error with a small plugin script I used successfully in 1.8.5.:

Image
Copy to clipboard
function wikiplugin_cattable($data, $params) { extract ($params); global $tikilib; $db = 'p338607dertz'; $data = 'SELECT catObjectID FROM tiki_category_objects WHERE categID= 12'; $data .= ' LIMIT '.$limit; $perm_name = 'tiki_p_dsn_' .$db; global $$perm_name; if ($$perm_name != 'y') { return (''); } $ret = ''; $dsn = $tikilib->get_dsn_by_name($db); $dbPlugin = DB::connect($dsn); if (DB::isError($dbPlugin)) { return ($dbPlugin->getMessage()); } @$result = $dbPlugin->query($data); if (DB::isError($result)) return $result->getMessage(); $first = true; $class = 'even'; while ($res = $result->fetchRow(DB_FETCHMODE_ASSOC)) { $ret .= '$res object'; } return $ret; }


hope someone can help me here -

max

posts: 8

aaaah and the silly hotfix to this problem: dupliceted the file /lib/adodb/drivers/adodb-mysql.inc.php" and renamed the copy to
"adodb-(space)mysql.inc.php". voila, it works.
so obviously just a typo in the sources somewhere. But actually I was unable to find it with the regular fulltext search...


posts: 1092

Can you give the syntax and parameter you use in your plugin call
Thanks


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting