Forum module - topics in forum:

Modules - Get help on installing any module or add-on here

File Repository (MY SQL PROBS) Error posted within

ERROR!

SQL query:

Code: :

CREATE TABLE `nuke_fr_apps` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`parent_id` int( 11 ) NOT NULL default '0',
`app_name` varchar( 50 ) NOT NULL default '',
`app_description` text,
`app_url` varchar( 100 ) default NULL ,
`app_icon` varchar( 50 ) default NULL ,
`lbl_custom1` varchar( 50 ) default NULL ,
`show_custom1` tinyint( 1 ) NOT NULL default '1',
`lbl_custom2` varchar( 50 ) default NULL ,
`show_custom2` tinyint( 1 ) NOT NULL default '1',
`lbl_custom3` varchar( 50 ) default NULL ,
`show_custom3` tinyint( 1 ) default '1',
PRIMARY KEY ( `id` ) ,
KEY `parent_id` ( `parent_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1
MySQL said:

#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 AUTO_INCREMENT=1' at line 16

This is the error im getting. Everything else is going fine, its just when I try to get it to draw the tables it doesnt want to move.

Little help please.

I don't know I got it working right out of the box; the correct code for this table taken straight from the sql file:

Code: :

DROP TABLE IF EXISTS `nuke_fr_apps`;
CREATE TABLE `nuke_fr_apps` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`app_name` varchar(50) NOT NULL default '',
`app_description` text,
`app_url` varchar(100) default NULL,
`app_icon` varchar(50) default NULL,
`lbl_custom1` varchar(50) default NULL,
`show_custom1` tinyint(1) NOT NULL default '1',
`lbl_custom2` varchar(50) default NULL,
`show_custom2` tinyint(1) NOT NULL default '1',
`lbl_custom3` varchar(50) default NULL,
`show_custom3` tinyint(1) default '1',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

compare the last line of code in your and mine
yours:

Code: :

DEFAULT CHARSET = latin1 AUTO_INCREMENT =1

mine:

Code: :

DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;

Ah thank you very much that might be it ill give it a try.

Forum module - topics in forum:

Search from web