Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Conquer Online 2 > CO2 Private Server
You last visited: Today at 19:37

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[SQL-Error]Sql Database For HellmouthSoruce

Discussion on [SQL-Error]Sql Database For HellmouthSoruce within the CO2 Private Server forum part of the Conquer Online 2 category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Dec 2010
Posts: 97
Received Thanks: 11
[SQL-Error]Sql Database For HellmouthSoruce

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
--------------------------------------------------
Pro4Never2 is offline  
Old 03/27/2011, 19:00   #2
 
chickmagnet's Avatar
 
elite*gold: 0
Join Date: Jun 2009
Posts: 372
Received Thanks: 53
enable innodb when u first install appserv this has been said multiple tie ya kno
chickmagnet is offline  
Thanks
1 User
Old 03/28/2011, 09:43   #3
 
zath's Avatar
 
elite*gold: 0
Join Date: Dec 2010
Posts: 48
Received Thanks: 6
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: / get teamviewer if you dont got it yet.
zath is offline  
Thanks
1 User
Old 03/28/2011, 12:15   #4
 
elite*gold: 0
Join Date: Nov 2010
Posts: 1,162
Received Thanks: 370
Quote:
Originally Posted by zath View Post
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: / get teamviewer if you dont got it yet.
I'm sure you don't get an infraction, if you're helping.
Syst3m_W1z4rd is offline  
Thanks
1 User
Old 03/28/2011, 13:29   #5
 
chickmagnet's Avatar
 
elite*gold: 0
Join Date: Jun 2009
Posts: 372
Received Thanks: 53
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
chickmagnet is offline  
Thanks
1 User
Old 03/28/2011, 13:31   #6
 
elite*gold: 0
Join Date: Feb 2009
Posts: 259
Received Thanks: 159
change InnoDB in MyISAM
teroareboss1 is offline  
Thanks
1 User
Old 03/28/2011, 13:36   #7


 
Korvacs's Avatar
 
elite*gold: 20
Join Date: Mar 2006
Posts: 6,125
Received Thanks: 2,518
Quote:
Originally Posted by Syst3m_W1z4rd View Post
I'm sure you don't get an infraction, if you're helping.
He got one for double posting.
Korvacs is offline  
Thanks
3 Users
Old 03/28/2011, 17:12   #8
 
elite*gold: 0
Join Date: Dec 2010
Posts: 97
Received Thanks: 11
guys guys, i enabled innodb in appserv and the problem is solved thnk you every1 and sorry for disturbance
Pro4Never2 is offline  
Old 03/29/2011, 05:46   #9
 
BioHazarxPaul's Avatar
 
elite*gold: 0
Join Date: Nov 2005
Posts: 548
Received Thanks: 93
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..
BioHazarxPaul is offline  
Old 04/28/2011, 15:17   #10
 
elite*gold: 0
Join Date: Dec 2010
Posts: 12
Received Thanks: 1
i did't find to uncheck innodb when i install the appserv
hunterlow2 is offline  
Old 04/28/2011, 15:52   #11
 
elite*gold: 0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
go in sql file click ctrl+h in "Find What:" put ENGINE=InnoDB and click replace all "save it" and try it again xD
fotis007 is offline  
Reply


Similar Threads Similar Threads
Database Error!
03/06/2011 - Flyff Private Server - 10 Replies
Also meine Fehlermeldung schon den ganzen Tag:confused::confused::confused: FAIL der Datenbase Habe alles Doppelt Ausgeführt meine ODBC zum 3. mal neu gebatcht. Ich komm einfach nicht mehr Klar! Habe auch den richtigen Pfad für Resource Angegeben... Bitte helft mir
Database.cs Error
06/17/2010 - CO2 Private Server - 6 Replies
Can someone help me fix this error in red? public double ReadDouble(string Section, string Key) { string section = ""; IniSectionStructure ISS = null; Sections.TryGetValue(section, out ISS); if (ISS != null) { IniValueStructure IVS = null;
Database.cs Error?
12/13/2009 - CO2 Private Server - 2 Replies
Well I get my friends playing my server and I'm getting this alot. This therefore isn't saving them. They also DC alot but maybe thats more to do with my conenction. http://img704.imageshack.us/img704/2858/error1n.p ng and inside line 1183 is the save char region. public static void SaveCharacter(Game.Character C, string Acc) { try { FileStream FS = new FileStream(@"C:\OldCODB\Users\Characters\&quo t; + C.Name + ".chr", FileMode.Open); ...
[Help] SQL Error with DataBase
10/29/2009 - Aion - 0 Replies
Hey im working on my Server and i think i have everything working but when i run the Sql to add my database to navicat it says there is an error :( If someone can help me add me on msn please and thank you. [email protected]
[HELP] DataBase Error
09/12/2008 - CO2 Private Server - 1 Replies
http://img261.imageshack.us/img261/739/databaseerr ortw9.png İ use Steals Server Pack What is wrong here ?? -- phpMyAdmin SQL Dump -- version 2.10.3 -- http://www.phpmyadmin.net --



All times are GMT +2. The time now is 19:37.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.