from Amazon
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?
Recent comments
Older comments
Page 1 of 344 pages 1 2 3 > Last »Complete Archive – By Category
Complete Archive – By Date