dongya4335 2016-10-17 10:09
浏览 23

通过迁移我的laravel迁移,我得到了非感性的结果。 它说我的桌子不存在

I didn't know what to put as a title. Here is the story basically:

  1. We have copied all the project files from our development machines to the server.
  2. We have dumped the database (an .sql file) from our development machines and installed the whole database to the server machine. (In this stage we didn't make any migration on the server machine.)
  3. Three months has passed since the last work. We cloned the repository and the dumped database file to our development machines again.

Now we get the same error when we try to apply migrations. First situation:

  1. There are all the tables in the database. We create a migration via php artisan make:migration some_name
  2. When we apply this migration via php artisan migrate it fails. Here is the error message: enter image description here
  3. The above exception is thrown when all the tables in the database. We have deleted all the tables (or all the tables except migrations) we got this error message when we applied migrations via php artisan migrate:enter image description here

I would really like to know what is going on in here. Before we deleted the tables the output of php artisan migrate:status is this:

+------+-------------------------------------------------------+
| Ran? | Migration                                             |
+------+-------------------------------------------------------+
| Y    | 2014_10_12_000000_create_users_table                  |
| Y    | 2014_10_12_100000_create_password_resets_table        |
| Y    | 2016_01_06_094947_create_announcements_table          |
| Y    | 2016_02_22_075425_create_menuheadings_table           |
| Y    | 2016_02_22_075913_create_menuitems_table              |
| Y    | 2016_02_24_071923_create_publication_databases_table  |
| Y    | 2016_02_24_075752_create_contact_table                |
| Y    | 2016_02_24_095726_create_personnels_table             |
| Y    | 2016_02_24_140554_add_image_field_to_announcement     |
| Y    | 2016_02_26_075730_create_slider_table                 |
| Y    | 2016_02_26_104627_create_publicaton_databases_table   |
| Y    | 2016_02_26_105429_create_databasees_categories_table  |
| Y    | 2016_02_26_135506_add_publication_database_published  |
| Y    | 2016_03_02_072620_create_replaceable_pages_table      |
| Y    | 2016_03_02_072702_create_page_images_table            |
| Y    | 2016_03_02_090219_create_general_pages_table          |
| Y    | 2016_03_02_123206_delete_column_page_images           |
| Y    | 2016_03_02_123227_create_column_image_url             |
| Y    | 2016_03_04_074143_create_wish_information_table       |
| Y    | 2016_03_04_074557_create_wish_books_table             |
| Y    | 2016_03_04_074632_create_wish_article_table           |
| Y    | 2016_03_04_074727_create_wish_ill_table               |
| Y    | 2016_03_11_071731_rename_image_url_personnels         |
| Y    | 2016_03_11_072543_rename_personnels_image_url         |
| Y    | 2016_03_16_104742_add_published_expiration_table      |
| Y    | 2016_03_16_125254_add_weight_column_personnels        |
| Y    | 2016_03_23_091637_create_database_istatistics_table   |
| Y    | 2016_03_24_084610_create_library_use_statistics_table |
| N    | 2016_05_16_111816_create_rating_questions_table       |
| N    | 2016_05_17_124800_create_rating_results_table         |
| N    | 2016_05_23_093005_create_english_menuheadings         |
| N    | 2016_05_23_093214_create_english_menuitems            |
| N    | 2016_05_23_093409_create_eng_general_pages            |
| N    | 2016_05_23_093531_create_english_replaceable_pages    |
| N    | 2016_10_17_084839_create_some_table                   |
+------+-------------------------------------------------------+
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 python的qt5界面
    • ¥15 无线电能传输系统MATLAB仿真问题
    • ¥50 如何用脚本实现输入法的热键设置
    • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
    • ¥30 深度学习,前后端连接
    • ¥15 孟德尔随机化结果不一致
    • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
    • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
    • ¥15 谁有desed数据集呀
    • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100