[dev] Fwd: RE: channel updated

Fri May 23 10:25:19 PDT 2003

no idea, but i guess some serialization type is used which is only 4.3

forwarding this email to the list.

marko

----- Forwarded message from it at smucayman.com -----
    Date: Fri, 23 May 2003 13:16:39 -0400
    From: Tom Miller <it at smucayman.com>
Reply-To: Tom Miller <it at smucayman.com>
 Subject: RE: channel updated
      To: 'Marko Djukic' <marko at oblo.com>

Setting that field null works fine.

I have a question. I just moved the code to our main server which is
using php 4.2 whereas my laptop where I do development is using 4.3. On
problem I have now that I have uploaded to the server is that I get a
"Invalid channel requested. Unsupported unserialization type" when I try
to update any channels... Any ideas?

-Tom

Tom Miller
Director of IT Services, Systems Administrator, Software Engineer
St. Matthews University School of Medicine
it at smucayman.com
1750 W. Broadway St.
Oviedo, FL 32765
1-800-498-9700
FAX 1-800-565-7177

> -----Original Message-----
> From: Marko Djukic [mailto:marko at oblo.com]
> Sent: Friday, May 16, 2003 9:20 AM
> To: Tom Miller
> Subject: Re: channel updated
>
>
> try what i just committed, there was no reason why the field
> was set up as NOT NULL, so i've changed it to NULL... on
> mysql it works either way, so give it a spin and tell me how
> it goes with postgres (without the mods you put in the
> sql.php file though)
>
> m.
>
>
> Quoting Tom Miller <it at smucayman.com>:
>
> > Ok to fix it I added the line
> >
> > ('0')); to the end of the variables supplied for the insert
> query and
> > changed the query string for the INSERT to
> >
> > $sql_sprintf = 'INSERT INTO
> >
> jonah_channels(channel_id,channel_type,channel_desc,channel_interval,c
> > ha
> > nnel_url,channel_link,channel_img,channel_updated) VALUES
> > (%s,%s,%s,%s,%s,%s,%s,%s)';
> >
> > Just adding channel_updated and a string variable for it.
> >
> > And when you insert a new channel it states "No Data" for the last
> > updated column until the channel is updated. -Tom
> >
> > Tom Miller
> > Director of IT Services, Systems Administrator, Software
> Engineer St.
> > Matthews University School of Medicine it at smucayman.com
> > 1750 W. Broadway St.
> > Oviedo, FL 32765
> > 1-800-498-9700
> > FAX 1-800-565-7177
> >
> >
> > > -----Original Message-----
> > > From: Marko Djukic [mailto:marko at oblo.com]
> > > Sent: Tuesday, May 13, 2003 10:19 PM
> > > To: Tom Miller
> > > Subject: RE: jonah
> > >
> > >
> > > ok, fixed committed to cvs.
> > >
> > > m.
> > >
> > >
> > > Quoting Tom Miller <it at smucayman.com>:
> > >
> > > > postgresql
> > > > --
> > > > Tom
> > > >
> > > >
> > > >
> > > > Quoting Marko Djukic <marko at oblo.com>:
> > > >
> > > > > what DB are you using?
> > > > >
> > > > > m.
> > > > >
> > > > >
> > > > > Quoting Tom Miller <it at smucayman.com>:
> > > > >
> > > > > > In my horde log I get HORDE[22859]: [jonah] DB Error: syntax
> > > > > > error: INSERT INTO jonah_channels SET channel_id = 62,
> > > > > > channel_name = 'health', channel_type = '1',
> > > channel_desc = NULL,
> > > > > > channel_interval = 86400, channel_url =
> > > > > >
> > > 'http://news.bbc.co.uk/go/click/rss/1.0/ticker/-/1/hi/health/30229
> > > > > > 97.stm
> > > > > > ', channel_link = 'http://news.bbc.co.uk', channel_img = ''
> > > > > > [nativecode=ERROR:  parser: parse error at or near
> > > "SET" ] [on line 118
> > > > > > of "/srv/www/htdocs/horde/jonah/lib/News/sql.php"]
> > > > > >
> > > > > > That is after I updated from the cvs. As far as I know
> > > you cannot
> > > > > > use syntax like "insert into" and  "set" together.
> > > > > >
> > > > > > Tom Miller
> > > > > > Director of IT Services, Systems Administrator,
> > > Software Engineer
> > > > > > St. Matthews University School of Medicine it at smucayman.com
> > > > > > 1750 W. Broadway St. Oviedo, FL 32765
> > > > > > 1-800-498-9700
> > > > > > FAX 1-800-565-7177
> > > > > >
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: Marko Djukic [mailto:marko at oblo.com]
> > > > > > > Sent: Tuesday, May 13, 2003 4:26 PM
> > > > > > > To: Tom Miller
> > > > > > > Subject: RE: jonah
> > > > > > >
> > > > > > >
> > > > > > > not sure what you mean, the script does recognise if
> > > there is an
> > > > > > > insert or an update, seems to work for me and others.
> > > send me a
> > > > > > > "diff -u" in any case and i'll have a look see if we
> > > are missing
> > > > > > > something obvious.
> > > > > > >
> > > > > > > thanks,
> > > > > > >
> > > > > > > marko
> > > > > > >
> > > > > > > Quoting Tom Miller <it at smucayman.com>:
> > > > > > >
> > > > > > > > Well it looks to me like a combination of an
> insert and an
> > > > > > > > update query. I rewrote your sql script so it would
> > > work for
> > > > > > > > me for inserting but I haven't gotten the code
> > > finished so it
> > > > > > > > knows the difference between updating and inserting yet.
> > > > > > > >
> > > > > > > > -Tom
> > > > > > > >
> > > > > > > > Tom Miller
> > > > > > > > Director of IT Services, Systems Administrator, Software
> > > > > > > Engineer St.
> > > > > > > > Matthews University School of Medicine
> > > it at smucayman.com 1750
> > > > > > > > W. Broadway St. Oviedo, FL 32765
> > > > > > > > 1-800-498-9700
> > > > > > > > FAX 1-800-565-7177
> > > > > > > >
> > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: Marko Djukic [mailto:marko at oblo.com]
> > > > > > > > > Sent: Tuesday, May 13, 2003 3:21 PM
> > > > > > > > > To: Tom Miller
> > > > > > > > > Subject: Re:jonah
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > you mean line 116 you get a PEAR Error in $result?
> > > > > > > > >
> > > > > > > > > look at your horde log... or var_dump that $result and
> > > > > > > see what the
> > > > > > > > > DB Error is. with syntax errors it should also
> > > give you the
> > > > > > > > > exact spot where the syntax error is. at first
> > > glance can't
> > > > > > > > > see
> > > > > > > anything
> > > > > > > > > wrong with your sql below.
> > > > > > > > >
> > > > > > > > > marko
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Quoting Tom Miller <it at smucayman.com>:
> > > > > > > > >
> > > > > > > > > > Or maybe I'm just a moron. heh... I still
> can't get it
> > > > > > > to save a
> > > > > > > > > > channel without a DB::syntax error
> > > > > > > > > >
> > > > > > > > > > "There was an error saving the channel. DB
> > > Error: syntax
> > > > > > > > > > error"
> > > > > > > > > >
> > > > > > > > > > The query of which I speak is on line 104 of
> > > > > > > > > > jonah/lib/News/sql.php
> > > > > > > > > >
> > > > > > > > > > When I try to add a new channel I get a DB::syntax
> > > > > > > > > > error
> > > > > > > > > and if I tell
> > > > > > > > > > it in the sql.php file to print back the
> sql query it
> > > > > > > > > > returns
> > > > > > > > > > this:
> > > > > > > > > >
> > > > > > > > > > INSERT INTO jonah_channels SET channel_id = 30,
> > > > > > > > > > channel_name = 'Health', channel_type = '1',
> > > channel_desc
> > > > > > > > > > = NULL,
> > > > > > > > > channel_interval =
> > > > > > > > > > 86400, channel_url =
> > > > > > > > > >
> > > > > > > > > 'http://news.bbc.co.uk/go/click/rss/1.0/ticker>
> > > > > > > > /-/1/hi/health/3022997.s
> > > > > > > > > > tm
> > > > > > > > > > ', channel_link = 'http://news.bbc.co.uk',
> > > channel_img =
> > > > > > > > > > 'null'
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Tom Miller
> > > > > > > > > > Director of IT Services, Systems Administrator,
> > > > > > > > > > Software
> > > > > > > > > Engineer St.
> > > > > > > > > > Matthews University School of Medicine
> > > > > > > > > > it at smucayman.com 1750 W. Broadway St.
> Oviedo, FL 32765
> > > > > > > > > > 1-800-498-9700 FAX 1-800-565-7177
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > -------------------------------------------------
> > > > St. Matthew's University School of Medicine
> > > >
> > > >     One Mission, One Purpose, Achieving the Dream
> > > >
> > > > 	Visit http://www.stmatthews.edu today and
> achieve your dream!
> > > >
> > >
> > >
> >
>
>

----- End forwarded message -----