• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • 😌 This community is user driven. Be polite with other users.
    • 👉 Is required to purchase a Chevereto license to participate in this community (doesn't apply to Pre-sales).
    • 💸 Purchase a Pro Subscription to get access to active software support and faster ticket response times.
  • Chevereto Support CLST

    Support response

    Support checklist

Can't perform database update

Status
Not open for further replies.

Mortgage

Chevereto Member
🎯Description of the issue

I've just updated to the latest version (3.13.0) from v3.11.1. However, upon update it appears the database isn't updating correctly.

▶🚶‍Reproduction steps
  1. Dashboard > Stats > 3.13.0 (3.11.1 DB) install update – check for updates
  2. Clicking "Install update" throws an error (see stack trace below)
  3. Trying /update error's "Can't perform automatic update" > PHP ZipArchive class is not enabled in this server. However, inside PHP PEAR Packages "Archive_Zip" module is installed.
😢Unexpected result

PHP ZipArchive class is not enabled in this server / stack trace below

📃Error log message

Code:
Fatal error [42S02]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'chv218.redirects' doesn't exist
Triggered in /lib/G/classes/class.db.php at line 180

Stack trace:
#0 /lib/G/classes/class.db.php(180): PDOStatement->execute()
#1 /lib/G/classes/class.db.php(206): G\DB->exec()
#2 /app/lib/classes/class.redirect.php(30): G\DB->fetchSingle()
#3 /app/lib/classes/class.redirect.php(35): CHV\Redirect::get('/install')
#4 /app/lib/classes/class.redirect.php(57): CHV\Redirect::getUrl('/install')
#5 /app/loader.php(780): CHV\Redirect::handle('/install')
#6 /lib/G/classes/class.handler.php(137): CHV\{closure}(G\Handler)
#7 /app/loader.php(788): G\Handler->__construct(Array)
#8 /index.php(20): include_once('/app/loader.php')
 
Switched provider (now on TMD) and now on 10.2.23-MariaDB-cll-lve still getting the same error.

/update worked fine, did the extracting and lalala, now it's:
No update needed
  • 23:51:25 System files already up to date
  • 23:51:25 Last available release is v3.13.1
  • 23:51:24 Installed version is v3.13.1
redirects to /install:
[CODE lang="sql" title="SQL"]Fatal error [42S02]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'redirects' doesn't exist
Triggered in /lib/G/classes/class.db.php at line 180

Stack trace:
#0 /lib/G/classes/class.db.php(180): PDOStatement->execute()
#1 /lib/G/classes/class.db.php(206): G\DB->exec()
#2 /app/lib/classes/class.redirect.php(30): G\DB->fetchSingle()
#3 /app/lib/classes/class.redirect.php(35): CHV\Redirect::get('/install')
#4 /app/lib/classes/class.redirect.php(57): CHV\Redirect::getUrl('/install')
#5 /app/loader.php(780): CHV\Redirect::handle('/install')
#6 /lib/G/classes/class.handler.php(137): CHV\{closure}(G\Handler)
#7 /app/loader.php(788): G\Handler->__construct(Array)
#8 /index.php(20): include_once('/app/loader.php')[/CODE]

Can't do /install?dump due to SQLSTATE[42S02]: Base table or view not found.
 
1. You dropped a table. Try to don't drop any system table or this kind of stuff can happen. I had to recreate the redirects table.
2. You have /install tempered. I had to restore it.

Did that and the update was completed without issues.
 
Status
Not open for further replies.
Back
Top