In our support boards we aim to provide support for the B3 core in its current state. Older releases of B3 are NOT supported. Check our front page for the latest version. You may post feature requests in our General Discussion board. Modifications and Hacks of the core B3 code are NOT supported.
Before you ask for support: [ Read the Support Instructions ] - More info: [ Full Support Disclaimer ]

You are here: Big Brother Bot ForumSupport ForumsInstallation Support (Moderator: MordyT)SQL wont execute any SQLs?
Pages: [1]   Go Down
  Print  
Author Topic: SQL wont execute any SQLs?  (Read 367 times) Bookmark and Share
Newbie
*
OS: Windows
Type: Home user
Gameservers: Cod 6
Posts: 2
Offline Offline
« on: January 22, 2011, 12:14:04 PM »

I am using navicat since I find it more flexible. But back on topic, whenever i try to execute the main b3.sql, it says this is the log:
Code:
[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 'TYPE=MyISAM' at line 29
[Err] -- phpMyAdmin SQL Dump
-- version 2.6.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 20, 2005 at 12:55 PM
-- Server version: 3.23.58
-- PHP Version: 4.3.2
--
-- Database: `b3`
--

-- --------------------------------------------------------

--
-- Table structure for table `aliases`
--

CREATE TABLE IF NOT EXISTS aliases (
  id int(10) unsigned NOT NULL auto_increment,
  num_used int(10) unsigned NOT NULL default '0',
  alias varchar(32) NOT NULL default '',
  client_id int(10) unsigned NOT NULL default '0',
  time_add int(10) unsigned NOT NULL default '0',
  time_edit int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY alias (alias,client_id),
  KEY client_id (client_id)
) TYPE=MyISAM;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

I have the most recent B3, and yes this is my first time installing it Tongue
Logged

Newbie
*
OS: Windows
Type: Home user
Gameservers: Cod 6
Posts: 2
Offline Offline
« Reply #1 on: January 22, 2011, 07:11:43 PM »

Nevermind. Found this while I was bored:
http://www.bigbrotherbot.net/forums/installation-support/mysql-type-gt-engine/
If someone could delete this ASAP, I can stop looking like an idiot Tongue
Logged
Tags:
Pages: [1]   Go Up
  Print  
 
Jump to:  


Rate this page +1 at Google Search


SimplePortal 2.3.1 © 2008-2009, SimplePortal