I've used TW and Migrate with success a while ago, but just now trying it again with 1.3 and although TW counts the row correctly, Views reports no rows, plus a bunch of SQL errors, just like as reported here: #687816: SQL syntax error: Views sees no rows
However the table name and field names are strictly alphanumeric with underscores so I'm creating a new issue.
I had a very similar table in MySQL left over from many moons ago and Views correctly sees it. Comparing the two files I can see no real difference except the old one had NULL as default in its fields and the new one has none.
What else should I look for?
Tnx, Jeff
Comment | File | Size | Author |
---|---|---|---|
#2 | tblbldgcleanview.txt | 10.81 KB | druplicate |
Comments
Comment #1
druplicate CreditAttribution: druplicate commentedI also flushed all cache and still no workee.
Comment #2
druplicate CreditAttribution: druplicate commentedOffending view is attached.
Comment #3
druplicate CreditAttribution: druplicate commentedSolved.
I had added a serial auto-increment field to the table in MySQL to use as the primary key, but that for some reason caused the problem.
So I deleted that and used another field that happened to be unique but not sequentially numbered.
All I did was add a field called "key", and made it the primary (auto-increment) index.
Why did that fail?