• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space
  • Chevereto Support CLST

    Support response

    Support checklist

    • Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • Confirm that the server meets the System Requirements
    • Check for any available Hotfix - your issue could be already reported/fixed
    • Read documentation - It will be required to Debug and understand Errors for a faster support response

PDOException [42S02]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'chevereto.chv_ip_bans' doesn't exist

M

myyihang

Chevereto Member
Hello, buddies. I installed the 3.20 successfully. However, when I try to open the page, the error comes. How to fix it? Thank you.

----------------------------------------------------------------------QUOTED-------------------------------------------------------------------------------

Aw, snap! Internal Server Error [debug @ print,error_log] - https://v3-docs.chevereto.com/setup/troubleshoot/debug.html

** errorId #66b95d61e755676b **
> PDOException [42S02]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'chevereto.chv_ip_bans' doesn't exist
Click to expand...
At /lib/G/classes/class.db.php:153

Stack trace:
#0 /lib/G/classes/class.db.php(153): PDOStatement->execute()
#1 /lib/G/classes/class.db.php(179): G\DB->exec()
#2 /app/lib/classes/class.ip_ban.php(50): G\DB->fetchSingle()
#3 /app/web.php(44): CHV\Ip_ban::getSingle()
#4 /app/loader.php(230): require_once('/app/web.php')
#5 /index.php(20): include_once('/app/loader.php')


----------------------------------------------------------------------UNQUOTED-------------------------------------------------------------------------------
 
Sort by date Sort by votes
Can you describe how was the update process carried and from which version? Is very odd that the system misses that table, chances are that you MySQL provisioning is failing as the software wasn't even able to install the base tables.
 
Upvote 0 Downvote
I tried to upgrade from V3.18 to V3.20 but failed because the version of MariaDB is low. Finally, I have to delete all data of V3.18 and install V3.20 from the beginning. The installation of V3.20 completed without errors. However, when I try to open the dashboard, I saw the following error:
"> PDOException [42S02]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'chevereto.chv_ip_bans' doesn't exist".
 
Upvote 0 Downvote
You will have to try re-installing again from scratch and you should inform the system versions and library used. What you describe shouldn't happen, but I don't know what you are running anyway.
 
Upvote 0 Downvote
You must log in or register to reply here.
Back
Top