error installing latest version 2.0.0 beta3

[adw]

I get the following error when installing the latest version of Feng Office on my web server.

Step 4: Finish
Installation process:

  Database connection has been established successfully
  InnoDB storage engine is supported
  Failed to import database construction. MySQL said: 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 'USING BTREE,
  KEY `by_name` (`name`),
  KEY `defines_perm`(`defines_permissions' at line 14

I'm using PHP Version 5.3.2-1 and MySQL 5.0.51a

Any help greatly appreciated.

Thanks,
ADW

[adw]

As an update to this, I downloaded version 1.7.5 & the installation ran correctly & FO is running ok on my web server.  Therefore, I guess there must be a problem with the installation routine itself.

ADW

[insanadair]

Version :Feng Office 2.0-beta3
Problem : MySQL server version for the right syntax to use near 'USING BTREE,

How to fix this problem

1. File : \public\install\installation\templates\sql\mysql_initial_data.php

LINE 33

a.Find this : UNIQUE KEY `code` (`code`) USING BTREE,

a.Change : UNIQUE KEY `code` USING BTREE (`code`),

LINE 686

b..Find this : KEY `rel_obj_id` (`rel_object_id`) USING BTREE,

b.Change : KEY `rel_obj_id` USING BTREE  (`rel_object_id`),

[kinayder]

Hi,

I try install beta3 version but i cant login after install, give me wrong password msg, and is right. I try beta1 and beta2 too, same problem, i cant login. Im using debian 6 , php5 and mysql 5.1.. anyone can help me?

[anglerdk]

In 2.0RC I also found this also beside the kinayder fix - (beside that the php file changed doesnt have the same name though)

public/install/installation/templates/sql/mysql_schema.php

line 980

CREATE TABLE `<?php echo $table_prefix ?>contact_widgets` (
....
  PRIMARY KEY (`widget_name`,`contact_id`) USING BTREE


Change to

PRIMARY KEY USING BTREE (`widget_name`,`contact_id`)

This worked for me

 

[franponce87]

Have you tried installing the Final version yet? Many issues with the installation have been solved there.

Best regards,
Francisco

[Mist. GraphX]

Hi,

 i've just try the latest release of Fo 2.0.0 and i've the same sql error message.

with the modifications mentionned above the problem is solved.

thx