Donate to the B3 fund!

"even a small donation helps!"
Donate with PayPal!
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 ]

Author Topic: On MySQL 5.5.8+ in b3.sql: TYPE -> ENGINE  (Read 8790 times)

Offline D9_Zorro

  • Jr. Member
  • **
  • Posts: 35
On MySQL 5.5.8+ in b3.sql: TYPE -> ENGINE
« on: December 28, 2010, 07:08:04 PM »
I was installing B3 with the latest MySQL (5.5.8) and the b3.sql generates an error. This may be a known issue, but I did not see an explicit mention in the forums. Oracle decided to change the keyword.

In the b3.sql file, TYPE=MyISAM needs to be changed to ENGINE=MyISAM.

Once the change is made, the script works again.

Later,
« Last Edit: January 02, 2011, 12:21:13 PM by xlr8or »

Offline ateamrocks

  • Newbie
  • *
  • Posts: 4
Re: On MySQL 5.5.8+ in b3.sql: TYPE -> ENGINE
« Reply #1 on: January 19, 2011, 07:27:07 AM »
Found this after spending 2 hours trying to figure out why my manually created (because the b3.sql failed) db wasnt working.

:P

Thanks!

Offline xlr8or

  • [ www.xlrstats.com ]
  • Project Lead
  • Hero Member
  • *
  • Posts: 2057
    • The Art of Tactical Gaming
Re: On MySQL 5.5.8+ in b3.sql: TYPE -> ENGINE
« Reply #2 on: February 02, 2011, 02:46:58 PM »
Thanks, sql is fixed

Offline -Chaotic-

  • Full Member
  • ***
  • Posts: 65
    • The Walking Dead
Re: On MySQL 5.5.8+ in b3.sql: TYPE -> ENGINE
« Reply #3 on: February 02, 2011, 09:39:27 PM »
The issue also occurs with Echelon when importing the tables for it.

Offline MordyT

  • Moderator
  • Hero Member
  • *
  • Posts: 3644
  • Over $300 Donated to B3!
    • MordyT
Re: On MySQL 5.5.8+ in b3.sql: TYPE -> ENGINE
« Reply #4 on: February 07, 2011, 05:37:18 PM »
Ah yes, I did some research into this a while back... in 2006 they marked type= as depreciated, and finally removed it.
So I modified three sq files.... attached. These will work right. Rename them from.txt to .sql

[attachment deleted by maintenance]
Help will be given to those with a b3.log

If drop off the map it is due to RL becoming busy :)

System: Python 2.7.3 - Deb 7 - B3 Source Code - 128MB RAM box (rented at $5 a year) - remote MySQL - Remote Web Services

Offline adikjester

  • Jr. Member
  • **
  • Posts: 10
Re: On MySQL 5.5.8+ in b3.sql: TYPE -> ENGINE
« Reply #5 on: March 31, 2011, 07:13:31 PM »
hi im new here btw everytime i import that b3.sql file it always have a error i already try the renaming ENGINE=MyISAM thingy still having an error

Error

SQL query:

-- 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 )
) ENGINE = MYISAM ;

MySQL said: Documentation
#1046 - No database selected

how can i fix this thanks!

Offline MordyT

  • Moderator
  • Hero Member
  • *
  • Posts: 3644
  • Over $300 Donated to B3!
    • MordyT
Re: On MySQL 5.5.8+ in b3.sql: TYPE -> ENGINE
« Reply #6 on: March 31, 2011, 07:35:18 PM »
You need to create a database and then select it from the side bar before importing...
Help will be given to those with a b3.log

If drop off the map it is due to RL becoming busy :)

System: Python 2.7.3 - Deb 7 - B3 Source Code - 128MB RAM box (rented at $5 a year) - remote MySQL - Remote Web Services

 


Rate this page +1 at Google Search