ltwCalendar Issue

Matt,

I get the following error when trying to add an event to the calendar:

Error: A problem was encountered while executing this query.

Any ideas? It worked one day but not the next.

I am not aware of any changes done to our site that would have affected the calendar (ie. no mySQL database structure mods, or movements and no calendar code mods).

BTW: It'll show current events just fine.

I too am having the same problem. I was able to add about 4 events and then it started giving me this error every time I tried to add an event.

In the ltw_classes.php file around line 468 which should read
$query = "INSERT $this->calendar_table VALUES('', '" . strip_tags($name) . "', '" . $date . "', '" . $start_time . ":00', '" . $end_time . ":00', '" . strip_tags($description) . "', " . $recurring . ", " . $dayofweek . ")";

add:

echo "<BR>$query<BR>";

after it..

that will show the query that is trying to be run....let's take a look at that and maybe we can find the problem...

Here you go, Matt. I hope this helps.

I copied/pasted this directly from the pop-up window:

---POP-UP WINDOW---
INSERT ltw_events VALUES('', 'CAL Match - Ballz', '2002-05-07', '21:00:00', '22:30:00', 'CAL League Match Opponent: Ballz MAP: mp_beach SERVER: [*:TP's Bathroom Drama START TIME: 9:00pm Eastern Match Type: SW ROUNDS: ABBA - 4 Total SW Rounds SCORE: 1st team to 3 points wins the match', 0, -1)
Error: A problem was encountered while executing this query.

---SNIP FROM MY ltw_classes.php---
$query = "INSERT $this->calendar_table VALUES('', '" . str
ip_tags($name) . "', '" . $date . "', '" . $start_time . ":00', '" . $end_time . "
:00', '" . strip_tags($description) . "', " . $recurring . ", " . $dayofweek . ")"
;
echo "<BR>$query<BR>";
$this->db->db_query($query);

The problem looks like that I am not adding slashes to the query. I am assuming the magic quotes is on. Looks like it isn't on your server. try adding an event and not having a single quote ( ' ) in the description....

That did it. Thanks man. I didn't even think about that when looking at the code.

This problem is fixed in the new version....

Sweet!

Is there an expected release date of the new version?

Thanks man!

Yep, it's up on the server now