Register for your free account! | Forgot your password?

You last visited: Today at 11:05

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


[Help] SQL files don't work

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2006
Posts: 26
Received Thanks: 7
[Help] SQL files don't work

The SQL commands aren't working for my Structure.SQL files.



[Err] 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 'collate utf8_unicode_ci NOT NULL default '',
`password` varch
[Err] CREATE TABLE `accounts` (
`acct` bigint(20) unsigned NOT NULL auto_increment,
`login` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`password` varchar(28) collate utf8_unicode_ci NOT NULL default '',
`encrypted_password` varchar(40) collate utf8_unicode_ci NOT NULL default '',
`gm` varchar(27) collate utf8_unicode_ci NOT NULL default '',
`banned` int(1) unsigned NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
`lastip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
`email` varchar(50) collate utf8_unicode_ci NOT NULL default '',
`flags` int(11) unsigned NOT NULL default '0',
`forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
`muted` int(30) NOT NULL default '0',
`banreason` varchar(255) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[Msg] Finished - Unsuccessfully



That's what it looks like when I try to Execute the file through Navicat


I need an answer please -_-" I've been posting everywhere and searching google for a good 3 weeks now.



LMSIMDIIII is offline  
Old 05/02/2009, 12:12   #2
 
elite*gold: 62
Join Date: Apr 2006
Posts: 12,492
Received Thanks: 2,859
Your MySQL is not configured for the UTF-8 Charset...


Gordge is offline  
Old 05/11/2009, 01:47   #3
 
elite*gold: 0
Join Date: Nov 2006
Posts: 26
Received Thanks: 7
My database isn't working!....All files are formatted to my MySQL user and pass which is test/test, my stupid wolrdserver.exe says my logon files and world files don't have the correct information and im using AC-web repacks/ original Arc-emu repacks.
Attached Images
File Type: jpg error.jpg (288.5 KB, 6 views)
LMSIMDIIII is offline  
Old 05/11/2009, 07:00   #4
 
elite*gold: 62
Join Date: Apr 2006
Posts: 12,492
Received Thanks: 2,859
the file ipban.frm seems to be damaged


Gordge is offline  
Thanks
1 User
Old 05/12/2009, 00:03   #5
 
elite*gold: 0
Join Date: Nov 2006
Posts: 26
Received Thanks: 7
Well Gordge, since your the only who replied, i'd like to thank you for your imput atleast -_-". I fixed my problem after using phpmyadmin instead of running the SQL files in navicat D:!


LMSIMDIIII is offline  
Reply



« WoW ~ pServer ~ 3.1.1 wie? | Suche 2.4.3 Server mit 5x Blizzlike Rates o.. »

Similar Threads
[TUTORIAL] How to make ULTRA A7 server files work with any A7 Client.
05/06/2011 - Dekaron Private Server - 72 Replies
-------------------------------------------------------------------------- IF YOU WANNA MAKE SERVER ON DEDI/VPS BY THIS TUTORIAL , DON`T READ THIS TUT , AND GO AWAY ! DONT STEAL !...
[RELEASE]my whole work - anti-gm-hack,Difference files etc...
04/23/2011 - Dekaron Private Server - 164 Replies
(my price for this post-->i was kicked from UG) update:18.03.09 my release had some errors. the server fixes are: - d-shop working - tele to space working - teleporter in maze to deatrhland fixed. file: http://www.sendspace.com/file/1hf9pi...
[Complete TUT] How to make Edited SFF Files Work..
10/17/2009 - Soldier Front Hacks, Bots, Cheats & Exploits - 22 Replies
Working Files Clearscope No Smoke Edited Scope (Sharinggan, Cockpit, Etc..) Sorry guys for the late update of this thread.. I've been away since sunday to volunteer in an affected areas in manila by the storm.. Anyweiz, I still...
Need Pre-Set server files to work with Difference A6 client over local IP
08/03/2009 - Dekaron Private Server - 11 Replies
Hi, I used the Difference server and client found here to run a Dekaron private server and test how it works. I am not a complete idiot, I have made MU servers in the past ussing MS-SQL2000. Still... It seems that I do something wrong. I...
Convert new client to work with server files?
02/07/2009 - Dekaron - 1 Replies
Hello everyone. Is there any way to either take out the gameguard stuff in the new client so that it will work with the server files or an updated gameguard emulator or something of the sort? Thanks



All times are GMT +2. The time now is 11:05.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.