RE: [Phpgroupware-developers] phpgroupware and coldsync

[Brian Johnson]

Try connecting to the database with a database tool and perform the query
there

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