Hosting Module v1.7 SQL problem

eboyuk2004 · dadaClub Joined: Apr 28, 2006 Posts: 4

Hi every time i insert the sql i get this error

SQL query:

--
-- Table structure for table `nuke_host`
--
CREATE TABLE `nuke_host` (

`main` text NOT NULL ,
`conditions` text NOT NULL ,
`presentacion` text NOT NULL ,
`faq` text NOT NULL ,
`country` varchar( 255 ) NOT NULL default ''
) ENGINE = MYISAM DEFAULT CHARSET = latin1
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' at line 11

i am running
phpMyAdmin 2.6.4-pl2
MySQL 4.0.25-standard running

Please help fix this probelm

dadaBIT · Posted: Sat Apr 29, 2006 9:43 pm Post subject:

This indicates that you are running MySQL in a different language format to the default Hosting Module sql file. Use UTF8 (en) or Latin 1.

-dadaBIT
_________________

Visit the DaDaNuke Wish List

eboyuk2004 · dadaClub Joined: Apr 28, 2006 Posts: 4

So how can i fix this to make it work ??
im confused

dadaBIT · Posted: Mon May 01, 2006 12:35 am Post subject:

Edit out all instances of "DEFAULT CHARSET = latin1" from sql file.
_________________

Visit the DaDaNuke Wish List

eboyuk2004 · dadaClub Joined: Apr 28, 2006 Posts: 4

Thanks bro it worked a treat

Only thing tht i can not do is edit these sections in the admin
[ Edit Main Page | Edit Presentation | Edit Terms and Conditions | Edit FAQ ]

Mtwo · dadaClub Joined: Mar 14, 2006 Posts: 42

I would like to use a UTF-8 database for a fresh install of nuke. Do I simply have to replace all instances of CHARSET=latin1; to CHARSET=UTF-8; in nuke.sql? Then import the file?

Please let me know.

Mtwo · dadaClub Joined: Mar 14, 2006 Posts: 42

[quote="dadaBIT"]Edit out all instances of "DEFAULT CHARSET = latin1" from sql file.[/quote]

What do you mean by edit out all instances? I have tried to remove all charset instances but am still having trouble importing into a UTF-8 MySQL db? What am I doing wrong...How do I set up a UTF-8 nuke DB?

readtodd876 · Joined: Jul 02, 2006 Posts: -1

I have found the easyest way to solve that problem is to replace this line:
ENGINE=MyISAM DEFAULT CHARSET=latin1;
with this one:
TYPE=MyISAM;