ADO functions

[brownrl]

Hey guys,

Was trying to use something like this in the new version:

echo $db->getInsertSQL( "table" , $record );

BUT it comes back and says that is not a function $db

nor is AutoExecute or UpdateSQL

Fatal error: Call to undefined function: getinsertsql();

Has soemthing changed in the ADO DB?


Thanks for any help
-- Rob

[tsw]

cmsms uses adodb_lite nowadays..

you can still use adodb if you need it, just download adodb to /lib/ and change config.php to have "$config['use_adodb_lite'] = false;"

adodb_lite also supports modules add some functions...

(you can find supported functions in adodb_lite in http://adodblite.sourceforge.net/functions.php)

[brownrl]

Thanks for the HELP.

Autoexecute was the BOMB!

$params is loaded with params variables but Autoexec would pick out which ones and put them in Update or Insert SQL statement escaped and all.

But I see why you use the lite to avoid all the overhead of the full ADO.

-- Rob

[pluk77]

I tried to use the full Adodb version, but got all sorts of error messages.

downloaded latest version of Adodb
uploaded to /lib
changed config to use_lite=false

Than got the following error messages:

Notice: Only variable references should be returned by reference in /home/berteler/public_html/cmsmadesimple/lib/adodb/adodb.inc.php on line 1421

Notice: Only variable references should be returned by reference in /home/berteler/public_html/cmsmadesimple/lib/adodb/adodb.inc.php on line 1421

Fatal error: Call to a member function on a non-object in /home/berteler/public_html/cmsmadesimple/modules/News/action.default.php on line 104

Which I did not get using ado lite.

Any clue?

By the way, I tried to use the full version because I wanted to start using Gallery2 extention (G2Mod).

Marcel

[pluk77]

Found the 'reference' problem to be a Zend problem. Upgraded to the latest version and it was solved.

Now I am left with 2 errors:

The News extension is giving me:

Fatal error: Call to a member function on a non-object in /home/berteler/public_html/cmsmadesimple/modules/News/action.default.php on line 104

and the rest of the pages produce a notice message:

Notice: Undefined property: query_count in /home/berteler/public_html/cmsmadesimple/index.php on line 210

[reto]

Hi

I was overlooking this post at first. Thats why I started a new thread with about the same question/problem (sorry for that).

Also there are no errors, the news modul doesn't work with the full adodb copied to /lib/ and activated in the config.

Is there any documentation to read about what needs to be adjusted to get adodb work again? Or do you know if it's easier to run gallery2 with adodb_lite (I don't think so...).

I'm a bit lost and help is much appreciated...

reto

[pluk77]

Have a look at these

http://forum.cmsmadesimple.org/index.ph ... 294.0.html

http://forum.cmsmadesimple.org/index.ph ... 976.0.html

Marcel

[reto]

hi marcel

thank you very much for pointing me in the right direction. i'll try this next week and hope it's as easy as it sounds

reto