Blog Documentation Try Vanilla Cloud
Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Fatal Error in Gdn_Database.Query();

StretchStretch
edited March 2010 in Vanilla 2.0 - 2.8
I get "Fatal Error in Gdn_Database.Query();" while trying to install V2. Here's the rest of the error:

The used table type doesn't support FULLTEXT indexes

create table `GDN_Discussion` (
`DiscussionID` int not null auto_increment,
`CategoryID` int not null,
`InsertUserID` int not null,
`UpdateUserID` int not null,
`FirstCommentID` int,
`LastCommentID` int,
`Name` varchar(100) not null,
`CountComments` int not null default 1,
`Closed` enum('1','0') not null default 0,
`Announce` enum('1','0') not null default 0,
`Sink` enum('1','0') not null default 0,
`DateInserted` datetime,
`DateUpdated` datetime not null,
`DateLastComment` datetime,
`Attributes` text,
key `FK_Discussion_CategoryID` (`CategoryID`),
key `FK_Discussion_InsertUserID` (`InsertUserID`),
key `FK_Discussion_FirstCommentID` (`FirstCommentID`),
key `FK_Discussion_LastCommentID` (`LastCommentID`),
key `FK_Discussion_DateInserted` (`DateInserted`),
index `IX_Discussion_DateLastComment` (`DateLastComment`),
primary key (`DiscussionID`),
fulltext index `TX_Discussion` (`Name`) ) default character set utf8 collate utf8_unicode_ci

The error occurred on or near: /forum/library/database/class.database.php 
227:          $PDOStatement = $this->Connection()->query($Sql);
228:       }
229: 
230:       if ($PDOStatement === FALSE) {
231:          trigger_error(ErrorMessage($this->GetPDOErrorMessage($this->Connection()->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
232:       }
233:       
234:       $Result = TRUE;
235:       // Did this query modify data in any way?
Line 231 is highlighted.

My server config:

Rackspace Cloud Site
Apache 2.2
MySQL 5.0.77
PHP 5.2.6
PDO Driver for MySQL, client library version 5.0.77

I had to modify .htaccess to get it to run the installer in a folder: 
RewriteEngine On
RewriteBase /forum/
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ index.php/$1 [QSA,L]
The installer has appears to have created all the tables in the database (there are 14 of them).

Any suggestions much appreciated.

Comments

  • StretchStretch
    I submitted a ticket to Rackspace on this and the response was, "Within Cloud Sites, we unfortunately can't support the requirement of Full Text indexes."

    The support tech went on to say, "Something I might recommend however would be to setup a cloud server for your database needs and then run the site from cloud sites connecting to your cloud server."

    Sounds overly complicated to me. I think I'll just run up a Cloud Server.
  • MarkMark Vanilla Staff
    Well, you do get the benefit of the automated scaling if you keep the web app on cloud sites and just put the db on a cloud server - he's got a good point.
  • StretchStretch
    That's true. Digging a little deeper, traffic between the cloud server and cloud site isn't free, unlike cloud server to cloud server.
  • PamelaPamela ✭✭
    Hi, I've got this error too (at "shared" MavenHosting.com) with Vanilla_2.0_rc1-0-gcb12ba2 version

    Apache 1.3.41 - PHP 5.2.11 - MySQL 5.0.90 (and PDO Driver for MySQL enabled...)

    The used table type doesn't support FULLTEXT indexes|Gdn_Database|Query|create table `GDN_Discussion` ( `DiscussionID` int not null auto_increment, `CategoryID` int not null, `InsertUserID` int not null, `UpdateUserID` int not null, `LastCommentID` int, `Name` varchar(100) not null, `Body` text not null, `Format` varchar(20), `CountComments` int not null default 1, `Closed` tinyint(1) not null default 0, `Announce` tinyint(1) not null default 0, `Sink` tinyint(1) not null default 0, `DateInserted` datetime, `DateUpdated` datetime not null, `DateLastComment` datetime, `LastCommentUserID` int, `Score` float, `Attributes` text, key `FK_Discussion_CategoryID` (`CategoryID`), key `FK_Discussion_InsertUserID` (`InsertUserID`), index `IX_Discussion_DateLastComment` (`DateLastComment`), primary key (`DiscussionID`), fulltext index `TX_Discussion` (`Name`, `Body`) ) default character set utf8 collate utf8_unicode_ci;

    Is it possible for me to install your version 2 but how do ;-) or... not here ?

    Many thanks in advance

    PS: 18 tables have been created in my data-base
  • shyaminayeshshyaminayesh New

    @Stretch : i think your vanilla exceed maximum sql database connection count .... so try increase your database connection count in the hosting ... :D

  • peregrineperegrine MVP

    @shyaminayesh said:
    Stretch : i think your vanilla exceed maximum sql database connection count .... so try increase your database connection count in the hosting ... :D

    so stretch asked this question in 2010? Stretch has logged in everyday for 3 years waiting for your answer. :) Do you think stretch found the solution prior to this? hmm.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • shyaminayeshshyaminayesh New

    @peregrine : oh shit ... 2010 march ... i didn't see it, :D

Sign In or Register to comment.