SQLSTATE[42S02]: Base table or view not found: 1146 Table 'skladiste5.total

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'skladiste5.total_stan

July 15, 2022, 10:54:17 AM

Good day!

In one of the projects I use database_view named total_stanje. While working on localhost in development environment it all works fine but after moving to production (only database name is different) I get error 500:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'skladiste5.total_stanje' doesn't exist

All pages that do not have this view included work just fine on production.

Any advice is welcome!

Many thanks

Andrej

Re: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'skladiste5.total_stan

Reply #1 – July 15, 2022, 11:44:56 AM

One more question, where is SQL entered for custom Database view stored? Can't find it in any of published files?

Thnx!