Conflicting table error

replied 9 years ago

You didn't tell it what to insert:

DB::table('users')->insert(
    ['email' => '[email protected]', 'votes' => 0]
);

Need the key valure pairs.

0

maxehnert

replied 9 years ago

Solution

jimgwhit said:

You didn't tell it what to insert:
DB::table('users')->insert(
   ['email' => '[email protected]', 'votes' => 0]
);
Need the key valure pairs.

So I was orignally trying to store an array of arrays. like here: http://stackoverflow.com/questions/20008687/store-arrays-of-data-into-a-single-array-using-loop-on-laravel-4 but the result was the errors above.

I did fix this by removing the new table but it was tricky because originally I could only see one table in my db and not until I changed the name of my migration did the two tables show up in my db.

Steps:

-rename my migration table name (this the original one)

-enter the sqlite db from command line. (i can now see the conflicting table, I could not before)

-drop the regions table (the table causing the name conflict)

-change migration table name back. (in my editor, not from the command line)

-enter sqlite db again and rename the changed table name (this is the original one associated w/ my migration) back to the original name.

-run artisan:refresh

0

jimgwhit

replied 9 years ago

Did you get it working?

0

maxehnert

replied 9 years ago

jimgwhit said:

Did you get it working?

yes and no. Yes in the sense that I no longer have errors on my tables, but I am still unsuccessful at storing any data to my tables.

By returning different things in my controller, I can see that I am parsing the array correctly, but when I put it into my model it's not going through

// Controller 

if($request->ajax()) {

        $data = $request->all();

        $inserts = array();
        foreach ( $data as $v ) {
            $inserts[] = array('start' => $v['start'], 'end' => $v['end']); 
        }
         // this will show my array being parsed correctly
        //return $inserts; 

        $regions = new Region($inserts);
        
         // this results in an empty array
        //return $regions;
        
       // there was nothing in $regions so nothing to save
        Auth::user()->regions()->save($regions);

// Model 
class Region extends Model {

	protected $table = 'regions';

	//protected $fillable = ['start', 'end', 'data'];
	protected $fillable = ['*'];

	public function user ()
	{
		return $this->belongsTo('App\User', 'user_id');
	}
}

I've been playing with my Model because that seems to be where my problem is but haven't made any progress.

0

Moderators