Text only | Text with Images

PHPRad Classic Initial 2.7.3 Forum

PHPRad Forum => Issues => Topic started by: pivar on July 15, 2022, 10:54:17 AM

Title: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'skladiste5.total_stan
Post by: pivar on 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
Title: Re: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'skladiste5.total_stan
Post by: pivar on 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!
Text only | Text with Images