next »

[Mr-K]

ok, hi i am completley new to Everything!,

I go to b3.sql and the code for it is wrong according to my xampp localhost phpmyadmin and Can i have a complete guide with pics because i cant understand the dumb one , and how to run it on a server on my home pc non dedicated plz

[Mr-K]

i get this 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 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 ;


MySQL said:

#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 ')
  id int(10) unsigned NOT NULL auto_increment,
  num_used int(10) unsigned N' at line 19

[Jackster]

Here is fixed copy I made for myself.

[attachment deleted by maintenance]

[Valcorb]

Do this:

Open b3.sql in Notepad.
change all TYPE to ENGINE

[Jackster]

Do this:

Open b3.sql in Notepad.
change all TYPE to ENGINE

I tried that but it did not work.

[MordyT]

I attached working ones here: http://www.bigbrotherbot.net/forums/installation-support/mysql-type-gt-engine/