Updating 4.1 to 4.2 multisite troubles RESOLVED

[StefanSultanov]

Hi Elxis team,

I have been trying to update my Elxis 4.1 to 4.2 and 4.3 afterwards.

It looks like I made a mistake and didn't update the database to 4.2 and started to update file system and database to 4.3
As instructed I made backups of my filesystem and reverted back to 4.1
Both Filesystem and Data base are now 4.1, but in the admin area I have Check for updates link producing 404 - page not found.

Normally I would try to perform the updates again but I'm worried I could have damaged my elxis 4.1 irreversibly.

The trouble is I have 1 multisite which I dont want to lose. Otherwise I would go and install fresh copy of Elxis.

Please advise what  should I do?

Thanks!

[StefanSultanov]

Update:
Check for updates link works after uploading the 4.2 patch files.
The "Update database to 4.2" is now missing. If I can perform the update to the database I could move on with 4.2 to4.3 update.

Please give me an alternative for updating the database to 4.2?

Thanks!

[StefanSultanov]

Update:

Here is how my Check Updates page looks like:

[StefanSultanov]

Last Update:

As far as I can see now the frontpage articles do not appear.

I use the Delta template with some modifications, but nothing major.

Help!

[StefanSultanov]

LAST UPDATE:

I restored my websites (Multisite) using the backups I made before I started to upgrade.
I saw everything was working as expected and started the update process again.
My main website now is updated to 4.3, but there is a problem with the subsite.

When I click on "Database needs to be updated to version 4.3" link on the sub-site there is this message:
A fatal error occured at http://webrilliant.co.uk/wmag Please inspect the site to find-out was caused this error and fix it.

The detailed error message was:
ERROR in file /home/webrilli/public_html/includes/libraries/elxis/database/statement.class.php line 41 Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pubdate' in 'elx2_content'' in /home/webrilli/public_html/includes/libraries/elxis/database/statement.class.php:41
Stack trace:
#0 /home/webrilli/public_html/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL)
#1 /home/webrilli/public_html/components/com_extmanager/models/extmanager.model.php(1084): elxisPDOStatement->execute()
#2 /home/webrilli/public_html/components/com_extmanager/controllers/install.php(39): extmanagerModel->updateDatabase()
#3 /home/webrilli/public_html/components/com_extmanager/extmanager.php(52): installExtmanagerController->ipanel()
#4 /home/webrilli/public_html/includes/libraries/elxis/document.class.php(1117): extmanagerRouter->route()
#5 /home/webrilli/public_html/includes/libraries/elxis/document.class.php(925): elxisDocument->renderComponent()
#6 /home/webrilli/public_html/includes/libraries/elxis/document.class.php(842): elxisDocument->makeAdm

This error was logged

Date: 2015-07-06 10:44:17 (UTC)
Site URL: http://webrilliant.co.uk/wmag

The site is offline and I can see that administrator area is not functioning properly.
There is nothing I can do except to revert back to 4.2 which seemed to work fine.

Another thing:
Might b irrelevant but my Check for updates page is displaying the following message:
There is an updated release (rev1716) of the Elxis version you have installed (rev1710). You might consider update.

Please reply anyone.

[webgift]

As far as i can see the database tables of your sub-site haven't been updated properly. You should follow the
instructions step by step.

[datahell]

You did the update from 4.1 to 4.2 and then to 4.3 on the main site without first updating the database of the sub-sites from 4.1 to 4.2 and now you try to update from 4.1 to 4.3 which is impossible. You must manually update the sub-sites database for v4.2 via phpmyadmin.

Go to phpmyadmin and on each sub-site (not the main site!) database execute these queries:

ALTER TABLE `elx_content` ADD COLUMN `pubdate` DATE NOT NULL DEFAULT '2014-01-01';

INSERT INTO `elx_templates` VALUES (NULL, 'Flex', 'flex', 'frontend', 1, NULL);

Replace prefix "elx_" with your database tables prefix.

Then login in Elxis admin for each sub-site and click update database from 4.2 to 4.3

[StefanSultanov]

Many thanks DataHell!

When I was updating the website (4.1 to 4.2), I didn't see any link to update the database for my sub-site.
This prevented 4.2 to 4.3 to be completed successfully.

The additional step you gave (the SQL Queries) resolved my issue.

Thank you for being there for us!

I'll mark this topic RESOLVED.

[webgift]

I assumed that there is an automatic process for that. I am sorry!