Joomla Installation Error In Sql Syntax
Contents |
here for a quick overview of the site Help Center Detailed answers
Check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Use Near
to any questions you might have Meta Discuss the workings mysql server version for the right syntax to use near '' at line 1 and policies of this site About Us Learn more about Stack Overflow the company Business mariadb server version for the right syntax Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack http://forum.joomla.org/viewtopic.php?t=195859 Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up 1064 - You have an error in your SQL syntax - Joomla Website up vote 1 down vote favorite I am currently creating a website http://stackoverflow.com/questions/22723801/1064-you-have-an-error-in-your-sql-syntax-joomla-website for one of my clients using Joomla. I am still able to access the administration side of the website, however, when the user views the website, I am presented with this error. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY content.created DESC' at line 28 SELECT content.id AS iid, content.access AS access, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END AS id, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS( ":", categories.id, categories.alias ) ELSE categories.id END AS cid FROM xg6zxarh4_jos_content AS content LEFT JOIN xg6zxarh4_jos_categories AS categories ON categories.id = content.catid LEFT JOIN xg6zxarh4_jos_users AS users ON users.id = content.created_by LEFT JOIN xg6zxarh4_jos_content_rating AS content_rating ON content_rating.content_id = content.id WHERE ORDER BY content.creat
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us http://stackoverflow.com/questions/29246421/sql-1064-you-have-an-error-in-your-sql-syntax-near-in-joomla-component-in Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL #1064 - You have an error in error in your SQL syntax; near `` in Joomla component install up vote 0 down vote favorite Hi I am trying to create a trigger in Joomla component installation, However it seems doesn't work error msg You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 SQL=CREATE TRIGGER tg_jws_worksheet_worksheet_insert BEFORE you have an INSERT ON jws_worksheet_worksheet FOR EACH ROW BEGIN INSERT INTO jws_worksheet_worksheet_seq (id) VALUES (NULL); here is the code -- -- Table structure for table `client` -- DROP TABLE IF EXISTS `#__worksheet_client`; CREATE TABLE IF NOT EXISTS `#__worksheet_client` ( `ClientID` int(11) NOT NULL, `CompanyId` int(11) NOT NULL, `FullName` text NOT NULL, `Email` text, `ContactNo` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `company` -- DROP TABLE IF EXISTS `#__worksheet_company`; CREATE TABLE IF NOT EXISTS `#__worksheet_company` ( `CompanyId` int(5) NOT NULL, `ABN` int(12) NOT NULL, `CompanyName` text NOT NULL, `Street` text, `City` text, `State` text, `PostCode` int(5) DEFAULT NULL, `Country` text, `Phone` text, `HourRate` int(11) NOT NULL, `Notes` text NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `worksheet_seq` -- DROP TABLE IF EXISTS `#__worksheet_worksheet_seq`; CREATE TABLE IF NOT EXISTS `#__worksheet_worksheet_seq` ( `id` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `worksheet` -- DROP TABLE IF EXISTS `#__worksheet_worksheet`; CREATE TABLE IF NOT EXISTS `#__worksheet_worksheet` ( `worksheetNo` varchar(9) NOT NULL, `CompanyId` int(5) NOT NULL, `UserId` int(5) NOT NULL, `CompanyName` text NOT NULL, `Category` varchar(20) NOT NULL, `JobTitle` text NOT NULL, `JobDesc` te