The creator of these plugins has not shown activity in a while. Posting in this board may not result in a fast reply or a reply at all. [ Read the full Support Disclaimer here ]

You are here: Big Brother Bot ForumAdd-OnsPlugins DiscussionPlugins by Anubis (Moderator: Anubis)ctime won't import to SQL
Pages: [1]   Go Down
  Print  
Author Topic: ctime won't import to SQL  (Read 708 times) Bookmark and Share
Sr. Member
****
OS: Windows
Type: Owner dedicated server(s)
Gameservers: COD 4 , COD 6
Posts: 154
Offline Offline
« on: December 06, 2011, 02:08:23 PM »

I have been trying to import ctime sql into my database, but it keeps coming up with this error.

#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 'TYPE=MyISAM DEFAULT CHARSET=utf8' at line 20
Logged

Support Hero
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2627
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #1 on: December 06, 2011, 02:48:47 PM »

open the .sql file with notepad++
find and replace TYPE with ENGINE
save file, re-import
Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Sr. Member
****
OS: Windows
Type: Owner dedicated server(s)
Gameservers: COD 4 , COD 6
Posts: 154
Offline Offline
« Reply #2 on: December 06, 2011, 04:34:08 PM »

Thanks again Mordy
Logged
Tags:
Pages: [1]   Go Up
  Print  
 
Jump to:  


Rate this page +1 at Google Search


SimplePortal 2.3.1 © 2008-2009, SimplePortal