phphub icon indicating copy to clipboard operation
phphub copied to clipboard

Migrations fail

Open kadimi opened this issue 9 years ago • 3 comments

Hello,

I'm try to set up phphub, I installed dependencies with composer and prepared a Sqlite database, but the migrations fail, I believe something went wrong with this migration 014_08_10_091306_create_nodes_table.php

Here is the migration command output:

kadimi@bayn:~/workspace (master) $ yes | php artisan migrate
**************************************
*     Application In Production!     *
**************************************




  [Illuminate\Database\QueryException]                                                                                                                                                                                                                                                                                                                         
  SQLSTATE[HY000]: General error: 1 table "nodes" already exists (SQL: create table "nodes" ("id" integer not null primary key autoincrement, "name" varchar not null, "slug" varchar null, "parent_node" integer null, "description" text null, "topic_count" integer not null default '0', "created_at" datetime not null, "updated_at" datetime not null))  






  [PDOException]                                                  
  SQLSTATE[HY000]: General error: 1 table "nodes" already exists  



migrate [--bench[="..."]] [--database[="..."]] [--force] [--path[="..."]] [--package[="..."]] [--pretend] [--seed]

FYI, here are the migrations that have been processed

kadimi@bayn:~/workspace (master) $ yes | php artisan migrate:rollback
**************************************
*     Application In Production!     *
**************************************

Rolled back: 2014_08_10_085349_create_topics_table
Rolled back: 2014_08_08_234417_create_users_table
Rolled back: 2014_01_03_011552_create_site_statuses_table
kadimi@bayn:~/workspace (master) $ 

kadimi avatar Aug 11 '15 00:08 kadimi

Can you show your migrations table records ?

ghost avatar Aug 20 '15 23:08 ghost

I don't know ,I should do something.

pearlzhu avatar Aug 21 '15 04:08 pearlzhu