[SQL-Error]Sql Database For HellmouthSoruce

03/27/2011 18:35 Pro4Never2#1

Hello, i was setting up the Hellmouth source 5300+ everything was going smoothly and because i'm stupid and noob + i never used/liked navicat i got error when trying to execute the sql databse and here's the error

Quote:

[Err] 1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working
[Err] CREATE TABLE `accounts` (
`UID` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(22) NOT NULL,
`password` varchar(22) NOT NULL,
`email` varchar(22) DEFAULT NULL,
`question` varchar(22) DEFAULT NULL,
`answer` varchar(22) DEFAULT NULL,
`idnumber` int(11) DEFAULT NULL,
`Permission` int(3) NOT NULL DEFAULT '1',
PRIMARY KEY (`UID`)
) ENGINE=InnoDB AUTO_INCREMENT=1000010 DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

03/27/2011 19:00 chickmagnet#2

enable innodb when u first install appserv this has been said multiple tie ya kno

03/28/2011 09:43 zath#3

well i might know the problem , but last time i helped people i did get a infraction :

Originally Posted by Korvacs
If you don't know what your talking about, then stop talking.

XD well if you still need my help i prefer help you with msn/ contact me: [Only registered and activated users can see links. Click Here To Register...] / get teamviewer if you dont got it yet.

03/28/2011 12:15 Syst3m_W1z4rd#4

Quote:

Originally Posted by zath

well i might know the problem , but last time i helped people i did get a infraction :

Originally Posted by Korvacs
If you don't know what your talking about, then stop talking.

XD well if you still need my help i prefer help you with msn/ contact me: [Only registered and activated users can see links. Click Here To Register...] / get teamviewer if you dont got it yet.

I'm sure you don't get an infraction, if you're helping.

03/28/2011 13:29 chickmagnet#5

ye bro this ur prob right here just reinstall appserv and enable innodb

Code:

[Err] 1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

03/28/2011 13:31 teroareboss1#6

change InnoDB in MyISAM

03/28/2011 13:36 Korvacs#7

Quote:

Originally Posted by Syst3m_W1z4rd

I'm sure you don't get an infraction, if you're helping.

He got one for double posting. :rolleyes:

03/28/2011 17:12 Pro4Never2#8

guys guys, i enabled innodb in appserv and the problem is solved thnk you every1 and sorry for disturbance

03/29/2011 05:46 BioHazarxPaul#9

:facepalm: would be nice if people would read the hellmouth FAQ, people keep asking about the same questions that are already talked about in that thread..

04/28/2011 15:17 hunterlow2#10

i did't find to uncheck innodb when i install the appserv

04/28/2011 15:52 fotis007#11

go in sql file click ctrl+h in "Find What:" put ENGINE=InnoDB and click replace all "save it" and try it again xD