Loading...
 
Skip to main content

Database update error on upgrading a Tiki21 to Tiki22

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Database update error on upgrading a Tiki21 to Tiki22
Version
22.x
Category
  • Error
  • Upgrade Blocker
Feature
Database MySQL (InnoDB)
Resolution status
New
Submitted by
Bernard Sfez / Tiki Specialist
Lastmod by
Bernard Sfez / Tiki Specialist
Rating
(0)
Description

I installed from git a new Tiki22.
Create (externally) the database and populate it with a Tiki21 previous database.
Completed the installation. with the following error:

Image

Accessing to the admin it shows there is an issue with the database.
From ssh using database:update I get an error and I can’t neither rebuilt the index:

Copy to clipboard
root@ec2-xx-xx-xx-xxx:/home/xxx/public_html# php console.php database:update
PDO::query(): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tsaharoniki_tiki22.sessions' doesn't exist on line 104 of /home/xxxx/public_html/lib/core/TikiDb/Pdo.php
Update completed.
Failed: 20200513_expand_sessions_data_column_tiki
Queries executed successfully: 3
Error in 20200513_expand_sessions_data_column_tiki
	ALTER TABLE `sessions` CHANGE `data` `data` LONGBLOB NOT NULL
	Table 'tsaharoniki_tiki22.sessions' doesn't exist

root@ec2-xx-xx-xx-xxx:/home/xxx/public_html# php console.php i:r
Command not available at this stage.
The database needs to be updated. Solved by: php console.php database:update


I compared 2 tikis created at different times.
One that was created before Tiki18 and has a "sessions" table with a data col.
And one created after Tiki19 that doesn’t have a "sessions" table.

May be this should be conditioned to the table existence ?
Or if this table is legacy it should be removed (data moved to tiki_sessions ?)

Solution
A core table was missing from the Tiki tables.
Importance
7
Easy to solve?
5
Priority
35
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
7551
Created
Thursday 01 October, 2020 07:09:27 UTC
by Bernard Sfez / Tiki Specialist
LastModif
Wednesday 07 October, 2020 13:51:15 UTC


Show PHP error messages