6 replies to this topic

[Destiny67]

Hello

Installed Wamp on my PC and that went fine but trying to install IPB 2.3.6 I come up with this error.

mySQL query error: CREATE TABLE ibf_admin_logs (
  id bigint(20) NOT NULL auto_increment,
  act varchar(255) default NULL,
  code varchar(255) default NULL,
  member_id int(10) default NULL,
  ctime int(10) default NULL,
  note text NULL,
  ip_address varchar(255) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

SQL error: 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 10
SQL error code: 1064
Date: Saturday 16th o April 2011 02:54:50 PM

Any idea's to what this might mean at all?

[Sandi]

I use XAMPP and run into the same problem.

Try changing TYPE=MyISAM; to ENGINE=MyISAM;

If that don't work, you might try leaving it off and see if the default will work.


-Sandi

[Destiny67]

Sandi, on 16 April 2011 - 04:06 PM, said:

I use XAMPP and run into the same problem.

Try changing TYPE=MyISAM; to ENGINE=MyISAM;

If that don't work, you might try leaving it off and see if the default will work.


-Sandi

Hi Sandi

Do you mean in the DB details section when installing IPB? In there I have only the 'MyISAM' or 'INNODB' to choose from.

[AndyF]

Use the slightly older version of Wamp.

You probably have version 20i , board 2.3.6 does not like this as its php5.3.0

If you use 20h its fine (this is the one I use as I need to keep a 236 testboard functioning) , 20h works fine with 2.3.x, 3.0.x and 3.1.x. It does sort of work with 2.1.x too in a fashion. If you only ever wanted to run 3.x then 20i is fine.


236 will actually run fine on 20i, but installing it is quite difficult.


EDIT... For reference:


20i:

PHP 5.3.0
MySQL 5.1.36
phpMyAdmin 3.2.0.1


20h:

PHP 5.2.9-2
MySQL 5.1.33
PHPMyAdmin 3.1.3.1

[Sandi]

Sorry I read too fast. You obviously don't want to change the installer script.

I hope Andy's suggestion helps.

[Destiny67]

AndyF, on 17 April 2011 - 09:37 AM, said:

Use the slightly older version of Wamp.

You probably have version 20i , board 2.3.6 does not like this as its php5.3.0

If you use 20h its fine (this is the one I use as I need to keep a 236 testboard functioning) , 20h works fine with 2.3.x, 3.0.x and 3.1.x. It does sort of work with 2.1.x too in a fashion. If you only ever wanted to run 3.x then 20i is fine.


236 will actually run fine on 20i, but installing it is quite difficult.


EDIT... For reference:


20i:

PHP 5.3.0
MySQL 5.1.36
phpMyAdmin 3.2.0.1


20h:

PHP 5.2.9-2
MySQL 5.1.33
PHPMyAdmin 3.1.3.1

Ah right, no wonder it did not work then. I will see if I can find the right one and thanks for your help.

Sandi, on 17 April 2011 - 12:30 PM, said:

Sorry I read too fast. You obviously don't want to change the installer script.

I hope Andy's suggestion helps.

No worries and thanks for trying to help.

[AndyF]

The issue this topic was opened for has now been resolved.