Database Error

[danoshea]

In the past, I simply uploaded a csv table and created a list. Now I get an db_name_id doesn't exist error. I don't have an "id" column, but when I keep "Auto Increment" to yes in Fabrik, it created an id column by looking at all of my other tables.

Why not now?? See attached.

 

[danoshea]

Ok, I added an index column called "id" and the error went away.

But can anyone tell me why I never had to do that before?

Funny thing is, in all of my existing tables the primary drop down box shows an "id" column I didn't manually add.

So I manually added it in phpMyAdmin but for that table, it doesn't show "id" column in the Primary Key drop down.

??? Weird.

Any thoughts?

 

[rob]

when you import the csv what option do you have for 'Create primary key' and can you supply a copy of the csv file you are using?

thx
Rob