next »

[D9_Zorro]

I was installing B3 with the latest MySQL (5.5. 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,

[ateamrocks]

Found this after spending 2 hours trying to figure out why my manually created (because the b3.sql failed) db wasnt working.



Thanks!

[xlr8or]

Thanks, sql is fixed

[-Chaotic-]

The issue also occurs with Echelon when importing the tables for it.

[MordyT]

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]

[adikjester]

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!

[MordyT]

You need to create a database and then select it from the side bar before importing...