Incorrect syntax near the keyword 'LEFT'

This forum is for issues with installing Joomla! 2.5 (All 1.6 and 1.7 releases have reached end of life and should be updated to 2.5.) on IIS webservers.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
eddigiff
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Jan 01, 2014 12:32 am

Incorrect syntax near the keyword 'LEFT'

Post by eddigiff » Wed Jan 01, 2014 12:45 am

Thank you in advance for your assistance - I have installed Joomla several times over the years and have not had this type of issue previously.

Joomla! 2.5.x, MS-Server 2012, MS-SQL 11.0.3128

After completing the 2.5 installer however, the default page displays the error message provided below. I have attempted to search to resolve, but have not found relevant information and am uncertain as to how to proceed.

[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'LEFT'.SQL=SELECT * FROM ( SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LEN(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id , ROW_NUMBER() OVER (ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC ) AS RowNumber FROM l4uzs_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM l4uzs_content AS a ) _myResults WHERE RowNumber BETWEEN 1 AND 4 LEFT JOIN l4uzs_categories AS c ON c.id = a.catid LEFT JOIN l4uzs_users AS ua ON ua.id = a.created_by LEFT JOIN l4uzs_users AS uam ON uam.id = a.modified_by LEFT JOIN l4uzs_categories as parent ON parent.id = c.parent_id LEFT JOIN l4uzs_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM l4uzs_categories AS cat JOIN l4uzs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = N'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN l4uzs_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = N'1900-01-01 00:00:00' OR a.publish_up <= N'2014-01-01 00:39:28') AND (a.publish_down = N'1900-01-01 00:00:00' OR a.publish_down >= N'2014-01-01 00:39:28') [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LEN(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(SELECT * FROM ( SELECT MAX(contact.id) AS id , ROW_NUMBER() OVER (ORDER BY (select 0)) AS RowNumber FROM l4uzs_contact_details AS contact) _myResults WHERE RowNumber BETWEEN 1 AND 4 WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM l4uzs_content AS a LEFT JOIN l4uzs_categories AS c ON c.id = a.catid LEFT JOIN l4uzs_users AS ua ON ua.id = a.created_by LEFT JOIN l4uzs_users AS uam ON uam.id = a.modified_by LEFT JOIN l4uzs_categories as parent ON parent.id = c.parent_id LEFT JOIN l4uzs_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM l4uzs_categories AS cat JOIN l4uzs_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = N'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN l4uzs_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = N'1900-01-01 00:00:00' OR a.publish_up <= N'2014-01-01 00:39:28') AND (a.publish_down = N'1900-01-01 00:00:00' OR a.publish_down >= N'2014-01-01 00:39:28')

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 25942
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Incorrect syntax near the keyword 'LEFT'

Post by Per Yngve Berg » Wed Jan 01, 2014 12:54 pm

Mod. Note: Relocated the topic to the Installation on IIS server forum.

gexton71
I've been banned!
Posts: 14
Joined: Fri Jan 10, 2014 6:23 am

Re: Incorrect syntax near the keyword 'LEFT'

Post by gexton71 » Mon Jan 27, 2014 10:14 am

Thank you very much for an interesting article on this topic.

brewhaus
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Thu Sep 04, 2014 2:16 pm

Re: Incorrect syntax near the keyword 'LEFT'

Post by brewhaus » Sat Sep 06, 2014 10:33 pm

Was a solution ever found to this? I have tried several times to install and am receiving the exact same error.


Locked

Return to “Joomla! 2.5 on IIS webserver”