TW|Tables|Add existing tables sees the new data table, sees the primary key, and correctly reports that the table contains 115 rows, and creates a default view. Table analysis runs fine. But clicking on the view (either in TW or in Views itself) throws a big pink block (shown in the attached JPG screen shot) and says, at the bottom, "There are no rows in this table." When I try to create a new view, Views sees the data table, lists the fields, but Preview throws part of the same pink block, the part referring to Line 1124. Is it a bug or am I doing something wrong?

CommentFileSizeAuthor
#2 rowcount.JPG61.27 KBmanicolaus
#2 analysis.JPG77.1 KBmanicolaus
#2 norows.JPG144.27 KBmanicolaus
pinkblock.JPG208.28 KBmanicolaus

Comments

cbear42’s picture

cbear42 commented

Same exact problem here. Subscribing.

manicolaus’s picture

manicolaus commented
StatusFileSize
new norows.JPG144.27 KB
new analysis.JPG77.1 KB
new rowcount.JPG61.27 KB

After reporting this bug, I built a clean setup (uninstalled and deleted TW, Migrate, Views; deleted those module folders from files/all/modules; checked Schema and dropped all 'extra' tables in PHPMyadmin; then re-added and reinstalled Views, TW, and Migrate, ran cron and update.php). I then re-ran the TW operation to "Add existing tables" with the "meetings-drupal" table in the default MySQL db. Same result as before, except that the code line numbers flagged in the pink block are different. I attach three jpgs, one showing the correct row count for the "meetings-drupal" table (115, same as PHPMyadmin reports), the second showing part of the TW Analysis page demonstrating that the data is "in there;" and the third showing the new pink block reporting no rows. Efforts to build a new View based on this table also threw pink blocks and showed no rows.

I hope there is a simple solution to this -- maybe I zigged where I should've zagged -- as I'm scheduled to give a talk on data migration at my local user group meeting on Friday and this doesn't make a happy ending to my presentation, LOL.

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Status: Active » Closed (duplicate)

In MySQL, table and column names which are not made up of alphanumerics and underscores, such as your "meetings-drupal", need to be quoted with backticks (`), and Views does not add the backticks - see #410452: Support non-standard field/table names.