[EventCalendar] Version 3.1._pre9

[Jeff Cole]

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