17452 Posts in 4473 Topics by 1971 members
|Go to End|
30 November 2007 at 3:47am Last edited: 30 November 2007 4:46am
db/build refuses to finish...
#FATAL ERROR: DATABASE ERROR: Couldn't run query: ALTER TABLE `Page` ADD fulltext `SearchFields` (Title,MenuTitle,Content,MetaTitle,MetaDescription,MetaKeywords), ADD fulltext `TitleSearchFields` (Title) | Key column 'Title' doesn't exist in table
At line 397 in /var/www/sites/www.xxxxx.nl/htdocs/sapphire/core/model/Database.php
I can't figure out why it uses these column names they don't even exist in that table.....
This is really weird. I had to copy the database to our local development server. Upgrade the database through the db/build script and then copy the database back tot the live server. All the website-code is the same on both machines. If I run the db/build script now (on the live server) , it doesn't want to upgrade anything ... which is correct. I hope this will not happen again on the next big upgrade , took a lot of time...
30 November 2007 at 10:16am
Just to add that I receive the same error on a clean installation:
I am now running through the installation steps (this should take about 30 seconds)
If you receive a fatal error, refresh this page to continue the installation
Creating '.htaccess' file...
Building database schema...
Fatal error: DATABASE ERROR: Couldn't run query: CREATE TABLE `UserDefinedForm` ( ID int(11) not null auto_increment, `EmailTo` varchar(50) character set utf8 collate utf8_general_ci, `EmailOnSubmit` tinyint(1) unsigned not null default '0', `SubmitButtonText` varchar(50) character set utf8 collate utf8_general_ci, `OnCompleteMessage` mediumtext character set utf8 collate utf8_general_ci, fulltext `SearchFields` (Title,MenuTitle,Content,MetaTitle,MetaDescription,MetaKeywords), fulltext `TitleSearchFields` (Title), primary key (ID) ) TYPE=MyISAM | Key column 'Title' doesn't exist in table in /var/www/vhosts/MYDOMAIN/httpdocs/sapphire/core/model/Database.php on line 397
I'm running Apache2/PHP 5.1.2/MySQL 5.0.22 (14.12)
Any advice appreciated.
4 December 2007 at 2:06pm
This may be PHP 5.1.2; we have found some people to have issues with PHP 5.1.2 that go away with PHP 5.1.6.
We recommend PHP 5.2.x
Note that it is often PHP itself which has bugs...
5 December 2007 at 2:29am
That might well be the case (we are running 1.2) ..
I'll have the version upgraded ASAP. ;-)
|Go to Top|