RE: [Phpgroupware-developers] phpgroupware and coldsync

[Brian Johnson]

1. Check that palm_addressbook table has been added to the phpgw database

2. Check that the coldsync configuration file lists the correct host and
name for the phpgw database (I don't think this is the problem or you'd get
an error when trying to connect - not after you've connected)

3. I'm going to see if I can get some time to check whether an empty table
causes a problem for this query (I don't think it should)



> -----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