<p>Without digging too deep into what's going on here...</p>

<p>It looks like you're trying to install Craft into a database which already contains some tables. I say that because of lines like this:</p>

<pre><code>CDbCommand::execute() failed: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'craft_assetfiles' already exists.
</code></pre>

<p>I would recommend dropping <em>every</em> "craft_" table in your database, and starting over.</p>

<p>If that doesn't work, I'd then replace your <code>/app</code> folder with a brand new copy... make sure the entire folder is FTP'd properly.</p>

<p>Finally, if neither of those suggestions work, I'd contact Pixel &amp; Tonic directly (support@buildwithcraft.com), since you may have stumbled across an obscure bug or weird system configuration issue.</p>

CC BY-SA 3.0
2014-11-29T21:53:56.300Z
2014-11-29T21:53:56.300Z
Lindsey D
<p>Can't install on the production side... Please see error below:</p>

<pre><code>2014/11/29 16:16:38 [warning] [application] 404 - 
2014/11/29 16:16:38 [error] [exception.Craft\HttpException.404] exception 'Craft\HttpException' in /home/saveandl/public_html/craft/app/etc/web/WebApp.php:765
Stack trace:
#0 /home/saveandl/public_html/craft/app/etc/web/WebApp.php(194): Craft\WebApp-&gt;_processInstallRequest()
#1 /home/saveandl/public_html/craft/app/framework/base/CApplication.php(180): Craft\WebApp-&gt;processRequest()
#2 /home/saveandl/public_html/craft/app/index.php(35): CApplication-&gt;run()
#3 /home/saveandl/public_html/saveandlearn/index.php(14): require_once('/home/saveandl/...')
#4 {main}
REQUEST_URI=/
---

******************************************************************************************************
2014/11/29 16:18:33 [warning] [application] Skipping record /home/saveandl/public_html/craft/app/records/BaseRecord.php because it’s abstract or an interface.
2014/11/29 16:18:33 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'craft_assetfiles' already exists. The SQL statement executed was: CREATE TABLE `craft_assetfiles` (
    `id` INT(11) NOT NULL PRIMARY KEY,
    `sourceId` INT(11) NULL,
    `folderId` INT(11) NOT NULL,
    `filename` VARCHAR(255) NOT NULL,
    `kind` VARCHAR(50) NOT NULL DEFAULT "unknown",
    `width` SMALLINT(6) UNSIGNED NULL,
    `height` SMALLINT(6) UNSIGNED NULL,
    `size` INT(11) UNSIGNED NULL,
    `dateModified` datetime NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` CHAR(36) NOT NULL DEFAULT 0
) ENGINE=InnoDb DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci.
2014/11/29 16:18:34 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'craft_assetfiles' already exists' in /home/saveandl/public_html/craft/app/framework/db/CDbCommand.php:358
Stack trace:
#0 /home/saveandl/public_html/craft/app/framework/db/CDbCommand.php(1324): CDbCommand-&gt;execute()
#1 /home/saveandl/public_html/craft/app/etc/db/DbCommand.php(481): CDbCommand-&gt;createTable('craft_assetfile...', Array, NULL)
#2 /home/saveandl/public_html/craft/app/records/BaseRecord.php(296): Craft\DbCommand-&gt;createTable('assetfiles', Array, NULL, false)
#3 /home/saveandl/public_html/craft/app/services/InstallService.php(167): Craft\BaseRecord-&gt;createTable()
#4 /home/saveandl/public_html/craft/app/services/InstallService.php(56): Craft\InstallService-&gt;_createTablesFromRecords(Array)
#5 /home/saveandl/public_html/craft/app/controllers/InstallController.php(159): Craft\InstallService-&gt;run(Array)
#6 /home/saveandl/public_html/craft/app/framework/web/actions/CInlineAction.php(49): Craft\InstallController-&gt;actionInstall()
#7 /home/saveandl/public_html/craft/app/framework/web/CController.php(308): CInlineAction-&gt;runWithParams(Array)
#8 /home/saveandl/public_html/craft/app/framework/web/CController.php(286): CController-&gt;runAction(Object(CInlineAction))
#9 /home/saveandl/public_html/craft/app/framework/web/CController.php(265): CController-&gt;runActionWithFilters(Object(CInlineAction), Array)
#10 /home/saveandl/public_html/craft/app/framework/web/CWebApplication.php(282): CController-&gt;run('install')
#11 /home/saveandl/public_html/craft/app/etc/web/WebApp.php(876): CWebApplication-&gt;runController('install/install')
#12 /home/saveandl/public_html/craft/app/etc/web/WebApp.php(749): Craft\WebApp-&gt;_processActionRequest()
#13 /home/saveandl/public_html/craft/app/etc/web/WebApp.php(194): Craft\WebApp-&gt;_processInstallRequest()
#14 /home/saveandl/public_html/craft/app/framework/base/CApplication.php(180): Craft\WebApp-&gt;processRequest()
#15 /home/saveandl/public_html/craft/app/index.php(35): CApplication-&gt;run()
#16 /home/saveandl/public_html/saveandlearn/index.php(14): require_once('/home/saveandl/...')
#17 {main}
REQUEST_URI=/index.php/admin/actions/install/install
HTTP_REFERER=http://saveandlearn.fami.com.ph/admin/install
---

******************************************************************************************************
</code></pre>

<installation>
Installation error
# Installation error

(Asked by: username_0 on 2014-11-29)

Can't install on the production side... Please see error below:
2014/11/29 16:16:38 [warning] [application] 404 - 
2014/11/29 16:16:38 [error] [exception.Craft\HttpException.404] exception 'Craft\HttpException' in /home/saveandl/public_html/craft/app/etc/web/WebApp.php:765
Stack trace:
#0 /home/saveandl/public_html/craft/app/etc/web/WebApp.php(194): Craft\WebApp->_processInstallRequest()
#1 /home/saveandl/public_html/craft/app/framework/base/CApplication.php(180): Craft\WebApp->processRequest()
#2 /home/saveandl/public_html/craft/app/index.php(35): CApplication->run()
#3 /home/saveandl/public_html/saveandlearn/index.php(14): require_once('/home/saveandl/...')
#4 {main}
REQUEST_URI=/
---

******************************************************************************************************
2014/11/29 16:18:33 [warning] [application] Skipping record /home/saveandl/public_html/craft/app/records/BaseRecord.php because it’s abstract or an interface.
2014/11/29 16:18:33 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'craft_assetfiles' already exists. The SQL statement executed was: CREATE TABLE `craft_assetfiles` (
    `id` INT(11) NOT NULL PRIMARY KEY,
    `sourceId` INT(11) NULL,
    `folderId` INT(11) NOT NULL,
    `filename` VARCHAR(255) NOT NULL,
    `kind` VARCHAR(50) NOT NULL DEFAULT "unknown",
    `width` SMALLINT(6) UNSIGNED NULL,
    `height` SMALLINT(6) UNSIGNED NULL,
    `size` INT(11) UNSIGNED NULL,
    `dateModified` datetime NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` CHAR(36) NOT NULL DEFAULT 0
) ENGINE=InnoDb DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci.
2014/11/29 16:18:34 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'craft_assetfiles' already exists' in /home/saveandl/public_html/craft/app/framework/db/CDbCommand.php:358
Stack trace:
#0 /home/saveandl/public_html/craft/app/framework/db/CDbCommand.php(1324): CDbCommand->execute()
#1 /home/saveandl/public_html/craft/app/etc/db/DbCommand.php(481): CDbCommand->createTable('craft_assetfile...', Array, NULL)
#2 /home/saveandl/public_html/craft/app/records/BaseRecord.php(296): Craft\DbCommand->createTable('assetfiles', Array, NULL, false)
#3 /home/saveandl/public_html/craft/app/services/InstallService.php(167): Craft\BaseRecord->createTable()
#4 /home/saveandl/public_html/craft/app/services/InstallService.php(56): Craft\InstallService->_createTablesFromRecords(Array)
#5 /home/saveandl/public_html/craft/app/controllers/InstallController.php(159): Craft\InstallService->run(Array)
#6 /home/saveandl/public_html/craft/app/framework/web/actions/CInlineAction.php(49): Craft\InstallController->actionInstall()
#7 /home/saveandl/public_html/craft/app/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#8 /home/saveandl/public_html/craft/app/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
#9 /home/saveandl/public_html/craft/app/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#10 /home/saveandl/public_html/craft/app/framework/web/CWebApplication.php(282): CController->run('install')
#11 /home/saveandl/public_html/craft/app/etc/web/WebApp.php(876): CWebApplication->runController('install/install')
#12 /home/saveandl/public_html/craft/app/etc/web/WebApp.php(749): Craft\WebApp->_processActionRequest()
#13 /home/saveandl/public_html/craft/app/etc/web/WebApp.php(194): Craft\WebApp->_processInstallRequest()
#14 /home/saveandl/public_html/craft/app/framework/base/CApplication.php(180): Craft\WebApp->processRequest()
#15 /home/saveandl/public_html/craft/app/index.php(35): CApplication->run()
#16 /home/saveandl/public_html/saveandlearn/index.php(14): require_once('/home/saveandl/...')
#17 {main}
REQUEST_URI=/index.php/admin/actions/install/install
HTTP_REFERER=http://saveandlearn.fami.com.ph/admin/install
---

******************************************************************************************************

**Tags:** installation


---

## 1 answers

### Answer by username_1 on 2014-11-29. Score: 1

Without digging too deep into what's going on here...
It looks like you're trying to install Craft into a database which already contains some tables. I say that because of lines like this:
CDbCommand::execute() failed: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'craft_assetfiles' already exists.

I would recommend dropping every "craft_" table in your database, and starting over.
If that doesn't work, I'd then replace your /app folder with a brand new copy... make sure the entire folder is FTP'd properly.
Finally, if neither of those suggestions work, I'd contact Pixel & Tonic directly (support@buildwithcraft.com), since you may have stumbled across an obscure bug or weird system configuration issue.


---

