RE: [Phpgroupware-developers] phpgroupware and coldsync

[Adam Hull]

Hey!
It worked! using the phpgw userid successfully returned data like so:
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 = 4

so can we replace the question mark with a proper variable?
could we replace it with {phpid} ? (those are braces around phpid)

Brian Johnson (address@hidden) wrote*:
>
>Try replacing the question mark with your phpid - the results should still
>be the same - I just wanted to make sure you didn't get any errors to prove
>that the database tables were setup correctly
>
>I'll be a couple of days - I'm setting up my laptop with coldsync and
>phpgroupware so that I can trouble shoot when not at the office
>
>I hope I can get my Palm to sync via IR - I got it to work under Windows
>
>
>
>> -----Original Message-----
>> From: address@hidden
>> [mailto:address@hidden Behalf Of Adam Hull
>> Sent: Monday, July 08, 2002 7:33 PM
>> To: address@hidden
>> Subject: RE: [Phpgroupware-developers] phpgroupware and coldsync
>>
>>
>> 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
>> >
>>
>>
>> _______________________________________________
>> 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
>