RE: [Phpgroupware-developers] phpgroupware and coldsync

[Brian Johnson]

In the perl program, the HEADERS{phpid} (phpid in braces) is a pointer to an
array

The array's name is HEADERS and phpid is one of the values in that array -
it is defined in the conf file and it also defined at the top of the conduit
in case it is ommitted from the conf file - that shouldn't be the sync
problem you're experiencing - it's something else

I need to play with it to double check what's happening - in the meantime,
try the memo conduit - it's the first one I did and spent the most time on
since it is the easiest (has the fewest fields) - therefore it is the
easiest to debug as well


> -----Original Message-----
> From: address@hidden
> [mailto:address@hidden Behalf Of Adam Hull
> Sent: Tuesday, July 09, 2002 2:12 PM
> To: address@hidden
> Subject: RE: [Phpgroupware-developers] phpgroupware and coldsync
>
>
> 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
> >
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers