Chris,

Here's another issue I've just surfaced

I've already made a succesful install of version 0.46 on my development server

I'm just now trying to install a second 0.4.6 development copy to a new MYSQL database instance and am now seeing the following

Inserting all required data in the database.
Failure! - Reported Error:
Sorry, unable to run query:
CREATE TABLE `bb_acls` ( `acl_ID` int(10) NOT NULL auto_increment, `acl_area` int(10) default NULL, `acl_group` int(10) default NULL, `canread` tinyint(1) default NULL, `canwrite` tinyint(1) default NULL, `canstart` tinyint(1) default NULL, `cansee` tinyint(1) default NULL, `canmod` tinyint(1) default NULL, `server` int(10) default NULL, KEY `acl_ID` (`acl_ID`), KEY `groups` (`acl_group`), KEY `server` (`server`), KEY `acl_area` (`acl_area`), KEY `cansee` (`cansee`), KEY `canread` (`canread`), KEY `canwrite` (`canwrite`), KEY `canstart` (`canstart`), KEY `canmod` (`canmod`)/*!40000 ALTER TABLE `bb_acls` DISABLE KEYS */;

Prior to getting this message I got the following

Checking various database settings and user's privileges. Success! - Your database is properly configured. Click on [Next] to import new data in the database: this may take a while, please be patient.

I've unzipped the install contents to the server and am running newinstall.php

 

I've just made a successful install of 0.4.7 on the same development server so am a little stumped at the minute as to why I'd get this message

Do you have any ideas why I'd get this?

Many thanks

---

Hey^^ Plaese download the nightly version.

in this version is this error fixed.

---

Greetings,
CF
----
http://www.commifreak-online.de

Commifreak wrote:

Hey^^ Plaese download the nightly version. in this version is this error fixed.

Thanks, I've just gone back and found my original 0.4.6 install files (which I donwloaded a few weeks back) and the problem is does not exist there

I've found the following:

If you go to sourceforge and download 0.4.6 and take a look at the safedump.sql, you find that the scripts to build each table are all missing the final bracket

e.g.

DROP TABLE IF EXISTS `chris_acls`;

CREATE TABLE `chris_acls` (

`acl_ID` int(10) NOT NULL auto_increment,

`acl_area` int(10) default NULL,

`acl_group` int(10) default NULL,

`canread` tinyint(1) default NULL,

`canwrite` tinyint(1) default NULL,

`canstart` tinyint(1) default NULL,

`cansee` tinyint(1) default NULL,

`canmod` tinyint(1) default NULL,

`server` int(10) default NULL,

KEY `acl_ID` (`acl_ID`),

KEY `groups` (`acl_group`),

KEY `server` (`server`),

KEY `acl_area` (`acl_area`),

KEY `cansee` (`cansee`),

KEY `canread` (`canread`),

KEY `canwrite` (`canwrite`),

KEY `canstart` (`canstart`),

KEY `canmod` (`canmod`)

--

-- Dumping data for table `chris_acls`

--

/*!40000 ALTER TABLE `chris_acls` DISABLE KEYS */;

/*!40000 ALTER TABLE `chris_acls` ENABLE KEYS */;

I've gone back and found my original 0.4.6 install file and the problem does not exist there. It appears the 0.4.6. install file on sourceforge is a bad copy of the original install file

---

no this sourceforge version is an old version. the nightl version has fixes for the new version.



download also, ever the nightly biuld! Warning: this is not ever stable! ok have good luck

---

Greetings,
CF
----
http://www.commifreak-online.de

Actually, I think of the current nightly builds as being the most stable builds we've ever had.
This may be because all current work is focused on stability

---