[EventCalendar] Version 3.1._pre9

[Alex Tingle]

Jeff,

I suspect that 'repeat' is a keyword in the newer version of MySQL. Can you try the two SQL statements with the word 'repeat' changed to 'rpt'. I bet they'll both work then.

If that fixes it, then I'll change the code and do another release.

-Alex

--


On Fri, 21 Jul 2006 19:07:18 +0100
Jeff Cole <news2 at clear-vision.org> wrote:

> Hi Alex Tingle
> 
> I created the database manually using phpmyadmin and I am still getting 
> the error in SQL.
> 
> I'm guessing that it is a very new version of  MySQL - 5.0.21-community, 
> as phpMyAdmin - 2.8.1 names it.
> 
> I am using xampplite on windows to test my installation at the moment.
> 
> Regards
> 
> Jeff
> 
> You wrote on Fri, 21 Jul 2006:
> 
> >Hi Jeff,
> >
> >It sounds like you are using an old version of MySQL. Or maybe you are 
> >using a really *new* version.
> >
> >Either way, can you let me know which version you are using, and I'll 
> >try to come up with some SQL that will work for it.
> >
> >(Oh and please reply to the list, not directly to me.)
> >
> >-Alex
> >
> >--
> >
> >On Fri, 21 Jul 2006 17:26:22 +0100
> >Jeff Cole <news2 at clear-vision.org> wrote:
> >
> >> Hi Alex
> >>
> >> I've updated the options several times but it doesn't seem to create the
> >> table required.
> >>
> >> I even uninstalled the plugin, removed all the options from the
> >> wordpress database for eventcalendar, installed the latest beta which I
> >> just downloaded.
> >>
> >> As soon as I went to options and updated them I got the following error
> >>
> >>
> >>
> >> WordPress database error: [You have an error in your SQL syntax; check
> >> the manual that corresponds to your MySQL server version for the right
> >> syntax to use near 'repeat VARCHAR(64), PRIMARY KEY(sched_id) )' at line
> >> 7]
> >> CREATE TABLE wp_ec3_schedule ( sched_id BIGINT(20) AUTO_INCREMENT,
> >> post_id BIGINT(20), start DATETIME, end DATETIME, allday BOOL, repeat
> >> VARCHAR(64), PRIMARY KEY(sched_id) )
> >>
> >> WordPress database error: [You have an error in your SQL syntax; check
> >> the manual that corresponds to your MySQL server version for the right
> >> syntax to use near 'repeat) SELECT id AS post_id, post_date AS start,'
> >> at line 2]
> >> INSERT INTO wp_ec3_schedule (post_id,start,end,allday,repeat) SELECT id
> >> AS post_id, post_date AS start, (post_date + INTERVAL 3 HOUR) AS end, 0
> >> AS allday, '' AS repeat FROM wp_posts p,wp_post2cat p2c WHERE
> >> p.id=p2c.post_id AND category_id=1
> >> >> >
> >
> >> It also told me
> >>
> >> Upgraded database to Event Calendar Version 3.1._Pre10
> >>
> >> However if I go to the wordpress database there is no table for event
> >> calendar.
> >>
> >> Any idea what I might be doing wrong?
> >>
> >> Regards
> >>
> >> Jeff
> >>
> >>
> >> You wrote on Fri, 21 Jul 2006:
> >>
> >> >Jeff,
> >> >
> >> >Have you been to the EventCalendar options screen yet? Version 3.1
> >> >creates its new database table the first time you visit the options
> >> >screen.
> >> >
> >> >-Alex
> >> >
> >> >--
> >> >
> >> >On Fri, 21 Jul 2006 09:27:55 +0100
> >> >Jeff Cole <news2 at clear-vision.org> wrote:
> >> >
> >> >> Hi
> >> >>
> >> >> I also get the following error on the page I put the php code
> >> >>
> >> >> WordPress database error: [Table ___wordpress.wp_ec3_schedule___
> >> >> doesn___t exist]
> >> >> SELECT DISTINCT
> >> >> p.id AS id,
> >> >> post_title,
> >> >> MIN(start) AS the_date,
> >> >> u.user_nicename AS author
> >> >> FROM wp_posts p, wp_ec3_schedule s, wp_users u
> >> >> WHERE post_status = 'publish'
> >> >> AND s.post_id=p.id
> >> >> AND p.post_author = u.id
> >> >> AND start>='2006-07-21 00:00:00'
> >> >> GROUP BY p.id
> >> >> ORDER BY the_date
> >> >> LIMIT 10
> >> >>
> >> >> Regards
> >> >>
> >> >> Jeff Cole
> >> >>
> >> >> _______________________________________________
> >> >> EventCalendar mailing list
> >> >> EventCalendar at firetree.net
> >> >> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar
> >> >
> >> >
> >>
> >> --
> >>
> >> Jeff Cole
> >
> >
> 
> -- 
> 
> Jeff Cole
> 
> _______________________________________________
> EventCalendar mailing list
> EventCalendar at firetree.net
> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar


-- 
:: Let me solve your problems: http://www.firetree.net/consulting/
:: alex.tingle AT firetree.net  +44-7901-552763