Loading...
 
Skip to main content

Architecture / Installation


integrator errors

Anyone have integrator working? 1.8.2 is giving me the following error when I try to add or modify rules:


Notice: Undefined offset: 10 in /home/.nalren/tiki/domain.com/exec/lib/adodb/adodb.inc.php on line 738
Input Array does not match ?: insert into `tiki_integrator_rules` (`repID`,`ord`,`srch`,`repl`,`type`,`casesense`,`rxmod`,`enabled`,`description`) values('3','4','d',,'n','n',,'n','dfdf')0

Warning: mysql error: 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 '0' at line 3 in query:
insert into `tiki_integrator_rules` (`repID`,`ord`,`srch`,`repl`,`type`,`casesense`,`rxmod`,`enabled`,`description`) values(?,?,?,?,?,?,?,?,?)
in /home/.nalren/tiki/doamin.com/exec/lib/tikidblib.php on line 133
Values:
Array ( 0 => 3 1 => 4 2 => d 3 => 4 => n 5 => n 6 => 7 => n 8 => dfdf 9 => 0 )
$result is false
$result is empty

Hiya

I dont think the integrator was actually ever finished. Apart from that it looks like the values dont match up correctly you example shows some strange ' values and a double comma

Are they just typos?

I'll check the code anyway......

Damian


Yep we have a problem in the code. Working on a fix to commit into CVS now.

Just commited the corrected integrator.php library to CVS.

Copy to clipboard
if ($ord == 0) { $query = "select max(`ord`) from `tiki_integrator_rules` where `repID`=?"; $ord = $tikilib->getOne($query, array($repID)) + 1; } if (strlen($ruleID) == 0 || $ruleID == 0) { $query = "insert into `tiki_integrator_rules` (`repID`,`ord`,`srch`,`repl`,`type`,`casesense`,`rxmod`,`enabled`,`description`) values(?,?,?,?,?,?,?,?,?)"; $qparms = array($repID, $ord, $srch, $repl, $type, $case, $rxmod, $en, $descr); } else { $query = "update `tiki_integrator_rules` set `repID`=?,`ord`=?,`srch`=?,`repl`=?,`type`=?,`casesense`=?, `rxmod`=?,`enabled`=?,`description`=? where `ruleID`=?"; $qparms = array($repID, $ord, $srch, $repl, $type, $case, $rxmod, $en, $descr,(int) $ruleID); } $result = $tikilib->query($query, $qparms); // Clear cached pages for this repository $this->clear_cache($repID); }


is the corrected area in function add_replace_rule 😀


Thanks for the amazingly quick reply !!!!!

This fix made the original error go away.

Now I'm getting this error:

Fatal error: Call to a member function on a non-object in /home/.nalren/tiki/domain.com/exec/lib/integrator/integrator.php on line 127

> sam_a:
> Thanks for the amazingly quick reply !!!!!
>
> This fix made the original error go away.
>
> Now I'm getting this error:
>
> Fatal error: Call to a member function on a non-object in /home/.nalren/tiki/domain.com/exec/lib/integrator/integrator.php on line 127


😂 Ok. I'll take a look at this one in the morning, tis bedtime really now 1:33am

Damian


> sam_a:
> Thanks for the amazingly quick reply !!!!!
>
> This fix made the original error go away.
>
> Now I'm getting this error:
>
> Fatal error: Call to a member function on a non-object in /home/.nalren/tiki/domain.com/exec/lib/integrator/integrator.php on line 127


😂 Ok. I'll take a look at this one in the morning, tis bedtime really now 1:33am

Damian