Register for your free account! | Forgot your password?

You last visited: Today at 07:22

  • 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   #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   #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   #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   #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



« Previous Thread | Next Thread »

Similar Threads
[TUTORIAL] How to make ULTRA A7 server files work with any A7 Client.
-------------------------------------------------------------------------- IF YOU WANNA MAKE SERVER ON DEDI/VPS BY THIS TUTORIAL , ...
72 Replies - Dekaron Private Server
[RELEASE]my whole work - anti-gm-hack,Difference files etc...
(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...
164 Replies - Dekaron Private Server
[Complete TUT] How to make Edited SFF Files Work..
Working Files Clearscope No Smoke Edited Scope (Sharinggan, Cockpit, Etc..) Sorry guys for the late update of this thread.. I've...
22 Replies - Soldier Front Hacks, Bots, Cheats & Exploits
Need Pre-Set server files to work with Difference A6 client over local IP
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...
11 Replies - Dekaron Private Server
Convert new client to work with server files?
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...
1 Replies - Dekaron



All times are GMT +2. The time now is 07:22.


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

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