Re: [SM-PLUGINS] Shared Calendar SQL DATE stamp iCal

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

> Date: Mon, 14 Jan 2008 16:20:58 -0800
> From: pa...@sq...
> To: squ...@li...
> Subject: Re: [SM-PLUGINS] Shared Calendar SQL DATE stamp iCal
>=20
> > >>>>> Hello all I have a small problem again. One of my end users is us=
ing
> > >> the
> > >>>>> calendar system and seems to have screwed something up. The error
> > >> which is
> > >>>>> coming up is "Badly formatted DATE stamp in iCal stream" There is
> > >> roughly
> > >>>>> about a month missing from her calendar and then it will start wo=
rking
> > >> again
> > >>>>> in February. I was wondering if anyone knows of a way to get her
> > >>>>> appointments and information back. I do not know a lot about SQL =
so if
> > >>>>> there is a quick and easy way to fix this problem I would be real=
ly
> > >>>>> interested in finding out how.
> > >>>>
> > >>>> This plugin tends to just stop when it sees malformed iCal data
> > >>>> instead of being more graceful. Fixing that behavior is on my
> > >>>> short(er) list, but in the meantime, you might find that error str=
ing
> > >>>> in the code and output some debug data in the code at that point t=
o
> > >>>> help narrow it down. Then you'll have to dig through the user
> > >>>> calendar data in your database to find the offending calendar and
> > >>>> event and fix it or remove it to get her calendar working again. I=
f
> > >>>> you are not versed in SQL, you can try to use something like
> > >>>> PHPMyAdmin to do this step instead.
> > >>>
> > >>> Oh, you can also have the user try to export the whole calendar, wh=
ich
> > >>> may get you the full iCal source that you can try to inspect for fi=
shy
> > >>> looking dates.
> > >>
> > >> I found this website
> > >> http://archive.netbsd.se/?ml=3Dsquirrelmail-plugins&a=3D2006-04&m=3D=
1923442
> > >
> > > Well found. Thank you for doing your own homework. Unfortunately,
> > > although this post shows the problematic iCal data, it doesn't do muc=
h
> > > to show how the problem was produced. It does look like a bug in the
> > > plugin, but reproducing it (so it can be fixed) is still an issue. If
> > > you can find out from your user how this happened (if you see that th=
e
> > > same problem happened (you find "##SQ_CAL_NL##" anywhere in the
> > > calendar iCal source)), that would be very helpful.
> > >
> > >> which seems to be the same problem which I am having. Where would I =
find
> > >> this file within the server?
> > >
> > > If you are using the Calendar SQL backend plugin, then it's in your
> > > database (see that plugin's config file for the database information
> > > if you forget what database that is).
> >
> > so I am within the SQL and am using the limited knowledge which I have =
so far I have typed in
> > show databases;
> > it then shows me 3 different databases
> > -information_schema
> > -test
> > -vpopmaill
>=20
> None of these sound particularly SM-related.  You might create one
> specifically for SM in the future.
>=20
> > use the command
> > use vpopmail;
> > then use command "show tables"
> > it then shows
> > -address
> > -calendar_owners
> > -calenndar_readers
> > -calendar__writers
> > -calendars
>=20
> This is it.
>=20
> > and so on I then use the command use calendars;
> > and then type desc calendars;
> > +------------------+--------------+------+-----+---------+-------+
> > | Field | Type | Null | Key | Default | Extra |
> > +------------------+--------------+------+-----+---------+-------+
> > | id | varchar(250) | NO | PRI | | |
> > | type | varchar(30) | NO | MUL | | |
> > | name | varchar(255) | YES | | | |
> > | domain | varchar(128) | YES | | | |
> > | created_on | datetime | YES | | NULL | |
> > | last_modified_on | datetime | YES | | NULL | |
> > | ical_raw | text | NO | | | |
> > +------------------+--------------+------+-----+---------+-------+
> > 7 rows in set (0.01 sec)
> >
> > how do I read the ical_raw file and change the correct persons calendar=
?
>=20
> The complete iCal source for any one full calendar is not in one place
> in the database.  The plugin will pull it together for you when you
> view or export it.  The best you can do here is to search for the
> malformed event.
How do I search for this information what SQL commands will allow me to fin=
d this info?
> IIRC, there is also an events table that you will
> need to search.
How do I find this events table? =20

>=20
> > Also I can not export the calendar it will not allow this to happen i j=
ust get an errror message I have attached the error
> > message to this email.
>=20
> Save the file on your desktop instead of trying to open it with any
> application.  Then, to view it, open it with Notepad or something
> similar.

I saved the file to my desktop and opened it with Notepad=20

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta name=3D"robots" content=3D"noindex,nofollow">
<title>SquirrelMail: ERROR</title>
<!--[if IE 6]>
<style type=3D"text/css">
/* avoid stupid IE6 bug with frames and scrollbars */
body {
    width: expression(document.documentElement.clientWidth - 30);
}
</style>
<![endif]-->
</head>
<body text=3D"#000000" bgcolor=3D"#ffffff" link=3D"#0000cc" vlink=3D"#0000c=
c" alink=3D"#0000cc">
<table width=3D"100%" cellpadding=3D"1" cellspacing=3D"0" align=3D"center" =
border=3D"0" bgcolor=3D"#ababab"><tr><td><table width=3D"100%" cellpadding=
=3D"0" cellspacing=3D"0" align=3D"center" border=3D"0" bgcolor=3D"#ffffff">=
<tr><td align=3D"center" bgcolor=3D"#dcdcdc"><font color=3D"#cc0000"><b>ERR=
OR:</b></font></td></tr><tr><td><table cellpadding=3D"1" cellspacing=3D"5" =
align=3D"center" border=3D"0"><tr><td align=3D"left">Badly formatted DATE s=
tamp in iCal stream
</td>
</tr></table></td></tr></table></td></tr></table>

That is what I got when I tried to open it??

>=20
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketpl=
ace
> -----
> squirrelmail-plugins mailing list
> Posting guidelines: http://squirrelmail.org/postingguidelines
> List address: squ...@li...
> List archives: http://news.gmane.org/gmane.mail.squirrelmail.plugins
> List info (subscribe/unsubscribe/change options): https://lists.sourcefor=
ge.net/lists/listinfo/squirrelmail-plugins

_________________________________________________________________