[EventCalendar] Version 3.1._pre9

[Alex Tingle]

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


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