Can't perform database update

Status
Not open for further replies.

Jordantbh

Well-Known Member
License owner
Joined
Jul 21, 2011
Messages
71
Points
58
🎯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')
 

Jordantbh

Well-Known Member
License owner
Joined
Jul 21, 2011
Messages
71
Points
58
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:
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')
Can't do /install?dump due to SQLSTATE[42S02]: Base table or view not found.
 

Rodolfo

Chevereto Developer
Chevereto Staff
Joined
Oct 7, 2008
Messages
15,628
Points
237
Location
Chevereto HQ
Website
rodolfoberrios.com
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.