Note that there are some explanatory texts on larger screens.

plurals
  1. POLaravel Migrations - Table Prefix Issue
    primarykey
    data
    text
    <p>I'm building a dummy site to test Laravel 3.x.</p> <p>I'm creating my site migrations right now. Everything was doing just fine until the following error showed up:</p> <pre><code>SQLSTATE[42s02]: Base table or view not found: 1146 Table 'databasenamehere.prefix_laravel_migrations' doesn't exist </code></pre> <p>The issue is that laravel all of a sudden started to prefix the 'laravel_migrations' table (when it is supposed to do it only with the other ones).</p> <p>I wonder if I'm doing something wrong or if it is a known issue.</p> <p>I'm trying to run the following migration (using the <strong>php artisan migrate application</strong> command):</p> <pre><code>public function up() { Schema::create('siteinfo', function ($table) { $table-&gt;engine = 'InnoDB'; $table-&gt;string('name'); $table-&gt;string('title')-&gt;nullable(); $table-&gt;string('corp_name')-&gt;nullable(); $table-&gt;string('corp_addr')-&gt;nullable(); $table-&gt;string('corp_phone')-&gt;nullable(); $table-&gt;string('corp_city')-&gt;nullable(); $table-&gt;string('corp_state')-&gt;nullable(); $table-&gt;string('corp_email')-&gt;nullable(); $table-&gt;string('main_url')-&gt;nullable(); $table-&gt;timestamps(); }); } </code></pre> <p>Any help would be great.</p> <p><strong>EDIT 1:</strong></p> <ul> <li>I noticed some minutes ago that my tables got no prefix at all, even with the "prefix" configuration set correctly on the config/database.php file.</li> <li>Everything works fine if I remove the prefix. I know that I can set the prefix manually in every migration I run, but well...</li> </ul>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload