RE: [Phpgroupware-developers] phpgroupware and coldsync

[Brian Johnson]

I think this will fix you're problem


The line:
  $sth_select_all->execute($HEADERS)
   or die "$err_exec_sql $dbh->errstr";

should be:
  $sth_select_all->execute($HEADERS{phpid})
    or die "$err_exec_sql $dbh->errstr";





> -----Original Message-----
> From: address@hidden
> [mailto:address@hidden Behalf Of Adam Hull
> Sent: Wednesday, July 03, 2002 4:51 PM
> To: address@hidden; address@hidden
> Cc: address@hidden
> Subject: [Phpgroupware-developers] phpgroupware and coldsync
> 
> 
> Greetings all, I am cross posting this message to the 
> coldsync-hackers and
> phpgroupware-developers mailing lists because I am unsure 
> where my issue stems
> from so I apologize in advance to anyone who receives this twice.
> 
> I am continuing Brian Johnson's excellent work on phpgroupware palm
> synchronization. He has successfully tested the conduits with 
> phpgw 0.9.13.018
> (R14 release candidate 3).
> 
> Here is my setup:
> Mandrake 8.1
> perl 5.6.1
> postgres 7.1.2
> coldsync 2.2.5
> phpgroupware 0.9.15.002
> 
> I am pretty sure I have installed all the necessary perl 
> modules and other
> dependencies. I am now getting the following coldsync error 
> when I attempt
> synching via netsync.
> 
> 401 Error executing sql DBI::db=HASH(0x8200d88)->errstr at
> /usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware l07
> 
> The above error is followed by:
> cond_readstatus: <<< "301 DBD::Pg::st execute failed: ERROR: Relation
> 'palm_addressbook' does not exist at
> /usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware line 107
> DBD::Pg::st execute failed: ERROR: Relation 
> 'palm_addressbook' does not exist
> at 
> /usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware line 107.
> 
> The above I believe may just be a chain reaction from the 
> failed SQL execution
> but I am not sure.
> 
> The line it is failing on in addressbook-phpgroupware is:
> $sth_select_all->execute($HEADERS)
> or die "$err_exec_sql $dbh->errstr";
> 
> which might be failing due to this SQL statement:
> my $sth_select_all = $dbh->prepare(
>  "SELECT e.*, p.palm_rec_id, u.cat_name".
>  " FROM (palm_addressbook p RIGHT JOIN phpgw_addressbook e ON 
> p.cal_id=e.id)".
>  " LEFT JOIN phpgw_categories u ON e.id = u.cat_id".
>  " WHERE e.owner = ?"
> ) or die $err_prep_sql;
> 
> But I compared the above against the phpgw tables and it 
> checks out. There
> does not appear to be any table changes between 0.9.13 and 
> 0.9.15. And it
> appears as though coldsync is making a connection to pgsql 
> because after
> running coldsync and the palm finishes the sync process I do 
> a "ps aux" and I
> can see an open postgres connection process still running. 
> So, I have no idea
> where this is failing. Any help from anyone would be most appreciated.
> 
> Thanks a lot,
> Adam Hull
> http://axisgroupware.org
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers