[EventCalendar] Version 3.1._pre9

[Jeff Cole]

Hi Alex

I changed all the obvious SQL statements in admin.php and 
eventcalendar3.php.

Find the files attached.

And it now works without error. Thanks

Regards

Jeff
-------------- next part --------------
A non-text attachment was scrubbed...
Name: eventcalendar3.zip
Type: application/zip
Size: 9979 bytes
Desc: eventcalendar3.zip
Url : http://penguin.firetree.net/pipermail/eventcalendar/attachments/20060721/8824a5e2/eventcalendar3-0001.zip
-------------- next part --------------


You wrote on Fri, 21 Jul 2006:

>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
>
>

-- 

Jeff Cole