Still not working. I ran the database fix, tried it and got the 1064 error.
Then I disabled the dynamap and tried to make a new item and got the 1064 error
Got a message from my web host this morning who did some debugging.
So I disabled Gk4 module and I still get the 1064 error.
Additionally - here is what he said when he debugged:
I've debugged the code and found the invalid SQL query was being generated by line ~260 in ./modules/mod_news_pro_gk4/gk_classes/gk.source.k2.php. The offending query (pasted below) had an empty WHERE condition.
I've added this code to line 258 to put a '1' in the SQL query if the WHERE condition is empty:
if (empty($second_sql_where))
$second_sql_where = '1';
The site is now loading :)
The job now is finding out why $second_sql_where (generated on line 228) was empty in the first place
Offending query:
SELECT
content.id AS ID,
cats.name AS cat_name,
cats.alias AS cat_alias,
content.catid AS cat_id,
users.name AS author,
users.email AS author_email,
users.id AS author_id,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count
FROM
j3_k2_items AS content
LEFT JOIN
j3_k2_categories AS cats
ON cats.id = content.catid
LEFT JOIN
j3_users AS users
ON users.id = content.created_by
LEFT JOIN j3_k2_tags_xref AS tx ON content.id = tx.itemID LEFT JOIN j3_k2_tags AS t ON t.id = tx.tagID
LEFT JOIN
j3_k2_rating AS content_rating
ON content.id = content_rating.itemID
WHERE
ORDER BY
content.created DESC
Is there any way I can PM someone and have my site fixed?? This is ridiculous that these problems are persisting and I have businesses depending on the software.
Thanks!