Page MenuHomePhabricator

Installation failed "Table phabricator_dashboard.dashboard doesn't exist"
Closed, ResolvedPublic

Description

Hey, trying to Install Phbaricator on my Server and i always gettings these Message:

EXCEPTION: (AphrontSchemaQueryException) #1146: Table 'phabricator_dashboard.dashboard' doesn't exist at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:309]
arcanist(head=master, ref.master=dae2f0073f01), phabricator(head=master, ref.master=20d2652d03c4), phutil(head=master, ref.master=230c3e161c9a)
  #0 AphrontBaseMySQLDatabaseConnection::throwQueryCodeException(integer, string) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:275]
  #1 AphrontBaseMySQLDatabaseConnection::throwQueryException(mysqli) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:181]
  #2 AphrontBaseMySQLDatabaseConnection::executeRawQuery(string) called at [<phutil>/src/xsprintf/queryfx.php:6]
  #3 queryfx(AphrontMySQLiDatabaseConnection, string, string) called at [<phabricator>/src/infrastructure/storage/management/PhabricatorStorageManagementAPI.php:252]
  #4 PhabricatorStorageManagementAPI::applyPatchSQL(string) called at [<phabricator>/src/infrastructure/storage/management/PhabricatorStorageManagementAPI.php:220]
  #5 PhabricatorStorageManagementAPI::applyPatch(PhabricatorStoragePatch) called at [<phabricator>/src/infrastructure/storage/management/workflow/PhabricatorStorageManagementWorkflow.php:848]
  #6 PhabricatorStorageManagementWorkflow::doUpgradeSchemata(NULL, boolean, boolean) called at [<phabricator>/src/infrastructure/storage/management/workflow/PhabricatorStorageManagementWorkflow.php:719]
  #7 PhabricatorStorageManagementWorkflow::upgradeSchemata(NULL, boolean, boolean) called at [<phabricator>/src/infrastructure/storage/management/workflow/PhabricatorStorageManagementUpgradeWorkflow.php:76]
  #8 PhabricatorStorageManagementUpgradeWorkflow::didExecute(PhutilArgumentParser) called at [<phabricator>/src/infrastructure/storage/management/workflow/PhabricatorStorageManagementWorkflow.php:53]
  #9 PhabricatorStorageManagementWorkflow::execute(PhutilArgumentParser) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:406]
  #10 PhutilArgumentParser::parseWorkflowsFull(array) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:301]
  #11 PhutilArgumentParser::parseWorkflows(array) called at [<phabricator>/scripts/sql/manage_storage.php:172]

PHPAdmin shows that this Database has no Tables... The Autopatches before this update could be installed, but not this one.

Event Timeline

AleisterWeber raised the priority of this task from to Needs Triage.
AleisterWeber updated the task description. (Show Details)
AleisterWeber changed the edit policy from "All Users" to "Custom Policy".
AleisterWeber added a project: Bug Report.
AleisterWeber added a subscriber: AleisterWeber.

Can't reproduce:

$ ./bin/storage --namespace t9962b upgrade --force
Loading quickstart template...
Applying patch 'phabricator:db.xhpast'...
Applying patch 'phabricator:20150906.mailinglist.sql'...
Applying patch 'phabricator:20150930.drydock.log.1.sql'...
Applying patch 'phabricator:20151001.drydock.rname.1.sql'...
Applying patch 'phabricator:20151002.dashboard.status.1.sql'...
Applying patch 'phabricator:20151002.harbormaster.bparam.1.sql'...
Applying patch 'phabricator:20151009.drydock.auth.1.sql'...
Applying patch 'phabricator:20151010.drydock.auth.2.sql'...
Applying patch 'phabricator:20151013.drydock.op.1.sql'...
Applying patch 'phabricator:20151023.harborpolicy.1.sql'...
Applying patch 'phabricator:20151023.harborpolicy.2.php'...
Applying patch 'phabricator:20151023.patchduration.sql'...
Applying patch 'phabricator:20151030.harbormaster.initiator.sql'...
Applying patch 'phabricator:20151106.editengine.1.table.sql'...
Applying patch 'phabricator:20151106.editengine.2.xactions.sql'...
Applying patch 'phabricator:20151106.phame.post.mailkey.1.sql'...
Applying patch 'phabricator:20151106.phame.post.mailkey.2.php'...
Applying patch 'phabricator:20151107.phame.blog.mailkey.1.sql'...
Applying patch 'phabricator:20151107.phame.blog.mailkey.2.php'...
Applying patch 'phabricator:20151108.phame.blog.joinpolicy.sql'...
Applying patch 'phabricator:20151108.xhpast.stderr.sql'...
Applying patch 'phabricator:20151109.phame.post.comments.1.sql'...
Applying patch 'phabricator:20151109.repository.coverage.1.sql'...
Applying patch 'phabricator:20151109.xhpast.db.1.sql'...
Applying patch 'phabricator:20151109.xhpast.db.2.sql'...
Applying patch 'phabricator:20151110.daemonenvhash.sql'...
Applying patch 'phabricator:20151111.phame.blog.archive.1.sql'...
Applying patch 'phabricator:20151111.phame.blog.archive.2.sql'...
Applying patch 'phabricator:20151112.herald.edge.sql'...
Applying patch 'phabricator:20151116.owners.edge.sql'...
Applying patch 'phabricator:20151128.phame.blog.picture.1.sql'...
Applying patch 'phabricator:20151130.phurl.mailkey.1.sql'...
Applying patch 'phabricator:20151130.phurl.mailkey.2.php'...
Applying patch 'phabricator:20151202.versioneddraft.1.sql'...
Applying patch 'phabricator:20151207.editengine.1.sql'...
Applying patch 'phabricator:20151210.land.1.refphid.sql'...
Applying patch 'phabricator:20151210.land.2.refphid.php'...
Storage is up to date. Use 'storage status' for details.
Verifying database schemata...


Database          Table                          Name            Issues
t9962b_drydock    drydock_log                    resourceID      Surplus Key
t9962b_drydock    drydock_log                    leaseID         Surplus Key
t9962b_drydock    drydock_log                    key_blueprint   Missing Key
t9962b_drydock    drydock_log                    key_resource    Missing Key
t9962b_drydock    drydock_log                    key_lease       Missing Key
t9962b_phame      phame_posttransaction_comment  phid            Better Collation Available, Better Character Set Available, Wrong Column Type
t9962b_phame      phame_posttransaction_comment  transactionPHID Better Collation Available, Better Character Set Available, Wrong Column Type
t9962b_phame      phame_posttransaction_comment  authorPHID      Better Collation Available, Better Character Set Available, Wrong Column Type
t9962b_phame      phame_posttransaction_comment  viewPolicy      Better Collation Available, Better Character Set Available, Wrong Column Type
t9962b_phame      phame_posttransaction_comment  editPolicy      Better Collation Available, Better Character Set Available, Wrong Column Type
t9962b_repository repository_coverage            key_path        Key has Wrong Uniqueness
t9962b_repository repository_refcursor           key_phid        Missing Key
t9962b_search     search_editengineconfiguration key_edit        Missing Key
t9962b_xhpast     xhpast_parsetree               returnCode      Wrong Column Type
Fixing schema issues...
Done.
Completed fixing all schema issues.

How did you get to a bad state?

Freshinstall,

Downloaded via the git Repos. Added the Databases from ./bin/storage databases by hand in Plesk and perfomed the "./bin/storage upgrade --force".

Nothing else done,

Added the Databases from ./bin/storage databases by hand in Plesk

this.

Added the Databases from ./bin/storage databases by hand in Plesk

What made you do this? Were you following 3rd party instructions?

Are you installing Phabricator on a shared host?

@avivey followed an instruction from a plesk forum.
@chad not 100% sure if it counts as a shared host. I'm installing on a VPS with Root.

We only support installation from our guide, other guides may be out of date or inaccurate in general.

https://secure.phabricator.com/book/phabricator/article/installation_guide/

(there should be no reason to create databases by hand)

Also our documentation is way more hilarious.

Tried this Installation Guide, and it worked until the point where you have to do the Database upgrade. But it seems like the database user from Plesk (create for phabricator with full permission, thats what plesk told) has no permission to create new Databases.

I'd focus on getting the user access to create databases, you'll want it in the future as well to streamline updates.

Yep, that did the trick for me. Sometimes your are just to blind to see. Thank you guys for your help. Phabricator works now perfectly.

chad claimed this task.

Awesome, good to hear.