Help with a 1064 error

Avatar
  • Answered
I get this message when i try to run the website:

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 'Subscription) AND `Type` = 'Group' )' At Line 1 SQL=SELECT Item_id FROM Hmvrd_acctexp_itemxgroup WHERE ( `Group_id` IN (Normal Subscription) AND `Type` = 'Group' )

Here is the Table:

CREATE TABLE `hmvrd_acctexp_itemxgroup` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(255) DEFAULT NULL,
`item_id` int(11) DEFAULT NULL,
`group_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `hmvrd_acctexp_itemxgroup`
--

INSERT INTO `hmvrd_acctexp_itemxgroup` VALUES (13, 'item', 6, 1);
INSERT INTO `hmvrd_acctexp_itemxgroup` VALUES (10, 'item', 5, 1);
INSERT INTO `hmvrd_acctexp_itemxgroup` VALUES (11, 'group', 4, 1);
Avatar
Arn
Hello Spegispecial, Sorry for the problem that you're having with your mySQL syntax. It's very possible that your code might be using syntax that is now outdated. This can happen if you move a program written several years ago and then placed on a newer server. MySQL is continually updated, so certain syntax may no longer apply resulting in the error you are seeing. Unfortunately, you have provided no information about your website, or the server that you're using. We do have a very good article that may help you determine the actual problem: MySQL Error 1064: You have an error in your SQL syntax. I hope this helps to answer your question, please provide us a little more information about your website/server so that we can investigate the issue in more depth. Regards, Arnel C.