[Phpgroupware-developers] phpgroupware and coldsync

[Adam Hull]

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