Welcome to Geeklog, Anonymous Monday, May 06 2024 @ 10:48 pm EDT
Geeklog Forums
Problem with plugin search function
Tom Schenk
Anonymous
I have only discovered one problem that doesn't seem to have been addressed yet. In the functions.inc file on line 493, I had to change:
$sql .= " AND (UNIX_TIMESTAMP(m.date) BETWEEN '$startdate' AND '$enddate'
";
to
$sql .= " AND (UNIX_TIMESTAMP(date) BETWEEN '$startdate' AND '$enddate'";
The "m." was generating an error because when you specified the database in the preceeding FROM clause, you didn't alias "media" as "m". This may only have effected users of the Site Calendar Block (I was getting a SQL error when clicking on a date in the block).
$sql .= " AND (UNIX_TIMESTAMP(m.date) BETWEEN '$startdate' AND '$enddate'
";to
$sql .= " AND (UNIX_TIMESTAMP(date) BETWEEN '$startdate' AND '$enddate'
";The "m." was generating an error because when you specified the database in the preceeding FROM clause, you didn't alias "media" as "m". This may only have effected users of the Site Calendar Block (I was getting a SQL error when clicking on a date in the block).
1
1
Quote
Tom Schenk
Anonymous
Doh!
Accidently created a new topic instead of replying to the one I wanted. In case anyone is wondering, I am referring to a problem with Inmemoriam.
Accidently created a new topic instead of replying to the one I wanted. In case anyone is wondering, I am referring to a problem with Inmemoriam.
1
1
Quote
All times are EDT. The time is now 10:48 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content