after move, error with dataface__view_bids_NNNNN

A place to discuss and receive support for the Web Auction application.

after move, error with dataface__view_bids_NNNNN

Postby 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
 
Posts: 7
Joined: Sat Sep 20, 2008 9:44 am

Re: after move, error with dataface__view_bids_NNNNN

Postby 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.
falcon7
 
Posts: 7
Joined: Sat Sep 20, 2008 9:44 am


Return to Web Auction Discussion

Who is online

Users browsing this forum: No registered users and 24 guests

Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved