RE: [Phpgroupware-developers] phpgroupware and coldsync

[Adam Hull]

I just ran this query:

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

and it returned nothing. is it because the palm_addressbook table is empty?
But I would think that palm_addressbook requires no initial data, right?


Brian Johnson (address@hidden) wrote*:
>
>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
>
>
>_______________________________________________
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>