RE: [Phpgroupware-developers] phpgroupware and coldsync

[Brian Johnson]

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