InMotion Hosting Support Center

Help with a 1064 error

Category: Databases

spegispecial
Asked:
2015-01-30 8:13 am EST

Hits: 319
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);

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

Arn
Staff
40,163 Points
2015-01-30 8:24 am EST
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.

You must login before you can post a comment about this answer.

Thanks Arnel C. for your timely response. I am relatively to programming. i have looked at that article you provided before now without knowing what to do. I will appreciate if you can look at the table syntax and help proffer a solution. Below are info on the database:

-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net
--
-- Host: custsql-ipg48.eigbox.net
-- Generation Time: Jan 08, 2015 at 09:22 AM
-- Server version: 5.5.32
-- PHP Version: 4.4.9
Server: Windows (ipage)
Website: crowdpenny.com
spegispecial
11 Points
2015-01-30 8:48 am EST
Hello Spegispecial,

Sorry for the problem with the mysql code. The issue is that the code you provided doesn't actually provide the area where the problem is located. The error basically tells you where it is. You would need to find the MySQL code per the error and then determine the issue by reading through the code. I would reference the article that I provided earlier, as it gives you examples of what could be causing the 1064 error. It does appear to be an obsolete command in this instance, though.

Apologies that I can't give you a direct answer for the problem at this point.

Regards,
Arnel C.
Arn
40,163 Points
Staff
2015-01-30 5:05 pm EST
Like this Question?

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Social Media Login

   
Social Login Joomla

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!