Register for your free account! | Forgot your password?

You last visited: Today at 07:10

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

Advertisement



MySQL Help

Discussion on MySQL Help within the CO2 Private Server forum part of the Conquer Online 2 category.

Reply
 
Old   #1
 
halofrager1's Avatar
 
elite*gold: 0
Join Date: Oct 2011
Posts: 35
Received Thanks: 4
Unhappy MySQL Help

-- ----------------------------
-- Table structure for bannedips
-- ----------------------------
DROP TABLE IF EXISTS `bannedips`;
CREATE TABLE `bannedips` (
`ip_int` int(10) NOT NULL,
`ip` varchar(16) NOT NULL,
PRIMARY KEY (`ip_int`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

I have this but i keep getting an error and MySQL stops executing SQL

Can someone please help me?
halofrager1 is offline  
Old 03/13/2014, 01:10   #2
 
elite*gold: 0
Join Date: Feb 2006
Posts: 726
Received Thanks: 271
Would help if you told us what the error was, or a screenshot.

My guess is you need to use the latest version of MySql
Aceking is offline  
Old 03/13/2014, 01:26   #3
 
turk55's Avatar
 
elite*gold: 130
Join Date: Oct 2007
Posts: 1,655
Received Thanks: 705
Does your MySQL server have InnoDB enabled?
turk55 is offline  
Old 03/13/2014, 12:47   #4
 
abdoumatrix's Avatar
 
elite*gold: 0
Join Date: Jul 2008
Posts: 874
Received Thanks: 238
abdoumatrix is offline  
Old 03/14/2014, 17:45   #5
 
Danial Eugen's Avatar
 
elite*gold: 0
Join Date: Sep 2012
Posts: 171
Received Thanks: 68
Why do i help ? it is YourSql not mine... HA HA HA HA

I KNOW THIS WAS SO BAD JOKE

EHM, as turk55 said do you have InnoDB enabled ?
Danial Eugen is offline  
Thanks
1 User
Old 03/14/2014, 23:20   #6
 
halofrager1's Avatar
 
elite*gold: 0
Join Date: Oct 2011
Posts: 35
Received Thanks: 4
Alright, i got everything fixed, the patch for the client didn't have the right .dll files, so the project was scraped. I'm a terrible coder and would someone suggest where i could start learning how to code for conquer? I want to learn and become alot better so i know how and what to do to be able to setup and code my own

It was because i had the wrong version of MySql it didn't have InnoDB enabled lol
halofrager1 is offline  
Old 03/14/2014, 23:41   #7
 
turk55's Avatar
 
elite*gold: 130
Join Date: Oct 2007
Posts: 1,655
Received Thanks: 705
Quote:
Originally Posted by halofrager1 View Post
Alright, i got everything fixed, the patch for the client didn't have the right .dll files, so the project was scraped. I'm a terrible coder and would someone suggest where i could start learning how to code for conquer? I want to learn and become alot better so i know how and what to do to be able to setup and code my own

It was because i had the wrong version of MySql it didn't have InnoDB enabled lol
I would say, keep Conquer on the sidelines for now and start with the basics of the language you pick. Once you get the hang of it you could get back to Conquer if you want to. This will help you with Conquer and any other stuff that involves programming in the future.
turk55 is offline  
Reply


Similar Threads Similar Threads
Mysql fehler 1130-Host 'xxxx' is not allowed to connect to this MySQL server
02/21/2017 - Metin2 Private Server - 3 Replies
Hallo Community, und zwar ich habe ein Problem wenn ich auf Navicat gehe und auf meiner DB zugreifen möchte steht dort Mysql fehler 1130-Host 'xxxx' is not allowed to connect to this MySQL server ich hoffe mir kannn jemand helfen oder mir es beheben..
Mysql fehler 1130-Host 'xxxx' is not allowed to connect to this MySQL server
10/18/2012 - Metin2 Private Server - 0 Replies
Ich brauche eure hilfe ich wollte einen P-server machen und benutzte Navicat für die DatenBank aber beim ersten mal ging es doch ich hatte dann die DB gelöscht,weil ich ein neues script hatte und dann wollte ich wieder eins machen aber es ging nicht so wie oben der Fehler ich bitte um hilfe danke :) aber bitte so schnell wie möglich um antwort danke Liebe Grüße : Silver2011
MySQL - L server through socket '/tmp/mysql.sock' (38) failed, retrying in 5 secon
06/28/2012 - Metin2 Private Server - 2 Replies
Hi EPvP I have one problem whit my server. I install a new game + db and i start him L server through socket '/tmp/mysql.sock' (38) failed, retrying in 5 secondsSuccess HOTBACKUP Why?
MySQL Navicat 1130-Host'5.xxx.xx.xxx' is not allowed to connect to the MySQL Server
08/07/2010 - Metin2 Private Server - 14 Replies
Hallo com, ich habe ein Problem mit Navicat. Undzwar habe ich diesen Fehler hier : "1130-Host'5.xxx.xx.xxx' is not allowed to connect to the MySQL Server" seid gestern. Ich dachte mir mal ich änder mein Navicat Passwort um... Als ich dies getan habe, und meinen Server rebootet habe und Navicat neugestartet habe, und ich mich wieder in Navicat einloggen wollte kam diese Fehlermeldung. Nun habe ich das Problem das ich mich nicht mehr mit Navicat connecten kann. Habe schon alles versucht...



All times are GMT +1. The time now is 07:11.


Powered by vBulletin®
Copyright ©2000 - 2026, 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 ©2026 elitepvpers All Rights Reserved.