Can't perform database update

[Mortgage]

🎯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

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')

 

[Rodolfo]

For sure this is related to this: https://chevereto.com/community/threads/installation-issues-in-mysql-5-6.11248/

Upgrade to MySQL 8.

 

[Rodolfo]

Check this, it may work for you: https://chevereto.com/community/threads/upgrade-to-3-13-x-db-issues.11263/

 

[Mortgage]

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.

 

[Rodolfo]

In your case I need to fix the DB. I need you to send me full server access to inbox@chevereto.com so I can take a look at it on the week.

 

[Mortgage]

In your case I need to fix the DB. I need you to send me full server access to inbox@chevereto.com so I can take a look at it on the week.

No problem, I've just sent the email. 🙂

 

[Rodolfo]

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.