after move, error with dataface__view_bids_NNNNN

Archived from the Web Auction Discussion forum.

falcon7 — Sun Sep 16, 2012 7:03 pm

I copied my WebAuction site and it’s database to a new place for this year’s run. Most things work except for things to do with bids, which get this error:

SELECT COUNT(*) as num FROM dataface\_\_view\_bids\_228d54c77a9ca1be56fa4e0c72f879d9 as bids WHERE bids.product\_id = ‘1309’ AND bids.bid\_status LIKE CONCAT(‘%’,’APPROVED’,’%’) Fatal error: View ‘arotary12.dataface__view_bids_228d54c77a9ca1be56fa4e0c72f879d9’ references invalid table(s) or column(s)

It looks to me that Dataface stored a particular view of the database for efficiency. How can I get it to re-create that view.

---

falcon7 — Mon Sep 17, 2012 7:41 pm

Answering my own question,I eventually figured out you just have to delete the view.
This can be done from the mysql command line, and probably from phpMyAdmin

mysql> drop view arotary12.dataface__view_bids_228d54c77a9ca1be56fa4e0c72f879d9;
Query OK, 0 rows affected (0.00 sec)

Once I did this, everything works fine.