Forums

Hi,

Please help, I receive the message below when I try to save a new Connection Manager.
Is there a tutorial on this topic?

Regards

André

Joomla 1.5.11
ChronoConnectivity_V2_RC1

TableChronoConnectivity::store failed - Unknown column 'OnSaveJSCode' in 'field list' SQL=INSERT INTO `jos_chronoconnectivity` ( `id`,`name`,`tablenames`,`SQL`,`head`,`body`,`footer`,`OnSaveJSCode`,`paramsall`,`Config` ) VALUES ( '0','test','jos_chronoforms_bourse','','','','','if(0){ \r\n } else {\r\n submitform( pressbutton );\r\n }','ordersql=\nfrontfilters=\nposted=\ngeted=\nheading=\nenmambots=No\nlistlimit=25\ndeletelink=Delete Record\neditlink=Edit Record\nnewlink=New Record\nfront_edit_form=\neditform=bourse\nprimarykey=cf_id\nauthedit_groups=\nauthdelete_groups=\nauthnew_groups=\nauthedit_users=\nauthdelete_users=\nauthnew_users=','dataviewtitles=Nom\ndataview=lastname' )

Hi André,

This is a known bug - please see this post It looks as though the fix hasn't made it's way into the released version yet.

Bob

Hi Bob,

Thanks for your help.

The connection manager is save, but another question raises :

Warning: Invalid argument supplied for foreach() in ............./components/com_chronoconnectivity/libraries/connection.php on line 264
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `jos_chronoforms_bourse` WHERE `nomBourse` = "HERMES"' at line 1 SQL=SELECT count(*) FROM jos_chronoforms_bourse SELECT * FROM `jos_chronoforms_bourse` WHERE `nomBourse` = "HERMES"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `jos_chronoforms_bourse` WHERE `nomBourse` = "HERMES"' at line 1 SQL=SELECT count(*) FROM jos_chronoforms_bourse SELECT * FROM `jos_chronoforms_bourse` WHERE `nomBourse` = "HERMES".

Is there any documentation??

Best regards

André

Hi André,

The SQL looks OK - I wonder if the problem is No valid database connection.

Please try pasting SELECT * FROM `jos_chronoforms_bourse` WHERE `nomBourse` = "HERMES" into PHP MyAdmin and see if it executes correctly (it's possible that it needs to be = 'HERMES' - with single quotes).

I'm afraid that there is no manual other than the tutorial and this isn't covered there.

Bob

Hi Bob,

It works with PHPMyAdmin. The correct form is "Hermes". But it doesn'work with connectivity.

I can't find the tutorial.

Regards

André