Problems Creating ltw_events Table

I am having a problem creating the calendar table ltw_events. I believe the problem to be on my web hosts end, but I am hopeful there is an easy fix for this problem. On my network at work, I was able to create the ltw_events table with no problems. The exact table would not work on my Web hosts mysql database. The error:


You have an error in your SQL syntax near 'dayofweek tinyint(4) default NULL,

PRIMARY KEY (id),

KEY date (date)
' at line 17

(I'm cheating and using Phpmyadmin -- but using it in both cases - the server at work where it works, and the server for my web host where it does not work).

Hmm..someone else had the same problem...try just making the table manually with phpmyadmin...should work for you fine..what version of mysql are you using? I'd like to see if I can find a commonality between your two systems...

PhpMyAdmin reports this version:

MySQL 3.22.25-log

I will be at work in about an hour and I can get you that version as well (which is probably close tot he latest -- since we had to install it on a Mac Network).

In attempting to create the table manually, I got the following error:

"date" is a reserved word, you can't use it as a database/table/field name.

Which oddly enough I do have a table named date, I'm not sure what is using it though.

In determining commonality's between myself and the last person that had this problem, here is the version that I am using at work (of MySQL) where I can create the table with no problem:

MySQL 3.23.42

I created the ltw_events table manually. To fix the problem, I renamed date to date1 and dayofweek to dayofweek1. Apparently the version of MySQL that my web host is running does not like those column names. I then went through al of the code, and where appropriate changed the variables to that. For complete compatibilty, I hope you can make this change ahead of time (but either way, let people know how to fix it).

Thanks for your time and effort in figuring that out! I will go through the code and make those changes.

My pleasure, I have ben looking for a calendar like yours for awhile. If you would like to see where it's installed:

http://normalheights.org/calendar

I customized the day of the week headings to fit it on my page though.

Nice! I am always glad to see it it in action. I think I will add "Short Day Names" to the list of things to do

I need some help from the pros...

I ran into kinda the same problem described above and renamed the fields in the ltw_events table respectively (id1, name1, dayofweek1 and date1). The table took just fine. I can even run adduser.php from the site and add user and pass (I verified it does update the ltw_users table).

Now I get the following error from calendars.php on the first day of the month:

--------------------------
Error: A problem was encountered while executing this query.
--------------------------

So obviously, I need to change all calls to the newly named fields, but where to start and from which external files? Basically, if I only changed the 4 fields names in the table, where do I need to change the code to reflect this?

I'm extremely new to PHP/SQL and have tried to research this before coming here to no avail. Any help is greatly appreciated!!

You should be able to search the ltw_classes.php file for any instance of query and then change the queries there.

On another note, I will be fixing this very soon..Expect a release within the next week or so that corrects this and other issues...

Thanks Matt for the response!

But I wasn't kidding when I said I'm a newbie! I see where what I think are variables calling "date", "id", "dayofweek" and "name". Do I need to change those as well? I guess the problem is I'm not sure where the querys start and stop. I tried changing those calls anywhere that I saw a SELECT and FROM, but it still breaks...

This calendar is definitely the one I wanna use and I'm trying to get it rolling as soon as possible. Plus, I'm trying to learn more about PHP and mySQL as I go. Thanks in advance for everyone's help!

In that case, I would recommend that you just hold off a few days till the new version is out. Give me until the weekend and I will make sure I have a release which fixes this problem....

A new version has been posted...this should eliminate the table creation bug....