distinctedge

Registered
Jul 5, 2008
4
0
51
Attempted table:

CREATE TABLE `displayid` (
`id` int(11) NOT NULL auto_increment,
`title` text,
`keyword` text,
`scode` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 7168 kB';

******************************************
Return from Cpanel SQL
SQL query:

CREATE TABLE `displayid` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` text,
`keyword` text,
`scode` longtext,
PRIMARY KEY ( `id` )
) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT = 'InnoDB free: 7168 kB'

MySQL said: Documentation
#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 'DEFAULT

CHARSET=latin1 COMMENT='InnoDB free: 7168 kB'' at line


What to do?

Thanks in Advance,

Mike
 

distinctedge

Registered
Jul 5, 2008
4
0
51
Why not just create it in phpMyAdmin?
Hi David,

That is the attempted script install point. Try to see this from a newbie sight of view. I am simply trying to make a piece of software work by following instructions. In this case the code for the table is not working for this Cpanel set up. :

#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 'DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 7168 kB'' at line

So I am searching for a way to make my syntax work. I assume I must change the code a bit. But what?

Someone please help.

Mike
 

cPanelDavidG

Technical Product Specialist
Nov 29, 2006
11,212
13
313
Houston, TX
cPanel Access Level
Root Administrator
Hi David,

That is the attempted script install point. Try to see this from a newbie sight of view. I am simply trying to make a piece of software work by following instructions. In this case the code for the table is not working for this Cpanel set up. :

#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 'DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 7168 kB'' at line

So I am searching for a way to make my syntax work. I assume I must change the code a bit. But what?

Someone please help.

Mike
Your choices are:

1. Contact the script developer for assistance (usually the best thing to do)
2. Read the SQL code and use phpMyAdmin to generate the same table
3. Learn SQL, read the MySQL manual and adjust the code accordingly

This is not a cPanel-specific issue.