THE BOOK--Playing The Percentages In Baseball

Wednesday, September 08, 2010

MySQL VIEW access problem

I tried to re-create a view (which was successful), but for some reason when I do a SELECT, I got this crazy error:
#1356 - View ‘XX.YY’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

In order to get around this, I changed:
create or replace view YY as
into
create table YY as

This error seems old and related to bug from previous versions of PHP.  I can tell you that my host, last week, upgraded our server:

Custom PHP
If you built your own custom PHP (or php.ini), it may be broken now. This is because the old servers used a 32bit architecture and the new servers are 64bit. Unfortunately, this isn’t something we can help you troubleshoot, but you’ll just need to rebuild your custom php (or php.ini) again using the new servers libraries.

While PHP has nothing to do with my creating VIEWS with SQL, I am using phpMyAdmin.

Thoughts?