Author Topic: Problem avter migrating from 3.4.0.17 to 3.4.1  (Read 34307 times)

etienne

  • Newbie
  • *
  • Posts: 3
    • View Profile
Problem avter migrating from 3.4.0.17 to 3.4.1
« on: March 26, 2016, 08:35:13 pm »
Hi everybody

I upgraded from 3.4.0.17 to 3.4.1 today with Softaculous. After that, I had only the header visible. There ws a JS error : "og.preferences is undefined" in the layout.js file. Moreover, when I activated the debug mode, this MYSQL error was displayed: "Unknown column 'get_read_state_from_server' in 'field list'".

I immediately restored my previous installation.

simonwenger

  • Freshman
  • *
  • Posts: 26
    • View Profile
Re: Problem avter migrating from 3.4.0.17 to 3.4.1
« Reply #1 on: March 29, 2016, 08:41:48 am »
I can confirm problems updating from 3.4.0.17 to 3.4.1
Doing it the normal way gives a Server Error (Error 500), if I tinker around with the top level files I can get as far as etienne, with only tehe header and the same error messages.
I restored the old version 3 times and reloaded the zip file to eliminate transfer errors, always the same.
Is there a known problem with this update?
Have others updated from 3.4.0.17 to 3.4.1 without issues?

Edit: I run PHP Version 5.6.18
memory_limit   128M
post_max_size   16M
Client API version   mysqlnd 5.0.11-dev - 20120503

Any other info required?
« Last Edit: April 03, 2016, 02:17:53 pm by simonwenger »

masonkante

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Problem avter migrating from 3.4.0.17 to 3.4.1
« Reply #2 on: March 30, 2016, 10:35:54 am »
Hi,

I have the same problem updating from 3.4.0.17 to 3.4.1.

Sombody has the same problem?

Thanks in advance

adrih

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: Problem avter migrating from 3.4.0.17 to 3.4.1
« Reply #3 on: April 03, 2016, 12:47:56 pm »
Hello, I get the same problem with the update from 3.4.o.17 to 3.4.1. Get de 500 internal server error. I use a server running php 5.6.
Never had this problem before. Tried it twice and had to restore the backups

natalia.martinez

  • Administrator
  • Freshman
  • *****
  • Posts: 47
    • View Profile
Re: Problem avter migrating from 3.4.0.17 to 3.4.1
« Reply #4 on: April 07, 2016, 12:10:15 pm »
Hi all,

Thanks for reporting this!

We´ll be checking this with Softaculous and keep you posted on the progress. We have been in touch recently with them in order to correct similar issues so we´ll followup on that.

Best regards,

Natalia

cesarguerrero

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: Problem avter migrating from 3.4.0.17 to 3.4.1
« Reply #5 on: May 01, 2016, 03:42:44 pm »
I'm having the same problem while tryng to update from 3.4.0.7 to 3.4.1.0 with Softaculous. I made a backup of the installation, but not of the database, before updating.
As the guy above, it is not possible from me to open a console.

When I opened page /public/upgrade/index.php it said

You already have upgraded to the latest possible version: 3.4.1

    Config file found and loaded.
    File '/config/config.php' exists and is writable
    Folder '/config' exists and is writable
    Folder '/cache' exists and is writable
    Folder '/tmp' exists and is writable
    Folder '/upload' exists and is writable
    Extension 'mysql' is loaded
    Extension 'gd' is loaded
    Extension 'simplexml' is loaded

    Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/gwervnwh/public_html/office/public/upgrade/library/classes/ScriptUpgrader.class.php on line 147
    Upgrade script has connected to the database.
    Test query has been executed. Its safe to proceed with database migration.
    Database schema transformations executed (total queries: 18)
    Feng Office has been upgraded. You are now running Feng Office 3.4.1 Enjoy!
    Please check for plugin updates.
    Open a console and execute the script 'public/install/plugin-console.php'
    with argument 'list' to view the plugins' status or argument 'update_all' to update them all.

So I'm afraid that if I try to rollback the softaculous installation, it may not work properly with the database in its current state. Is that correct?
If it is, where can I find which are the 18 schema transformation queries mentioned above so that I can undo them?


cesarguerrero

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: Problem avter migrating from 3.4.0.17 to 3.4.1
« Reply #6 on: May 01, 2016, 04:13:50 pm »
Nevermind. Since I could't get any help from my hosting provider and I couldn't be offline for ever, I decided to try the softaculous rollback, so I discovered that it, indeed, includes a database rollback. So now I have a working installation again. But please find out what's wrong with this update..

ThorstenW

  • Freshman
  • *
  • Posts: 34
    • View Profile
Re: Problem avter migrating from 3.4.0.17 to 3.4.1
« Reply #7 on: May 11, 2016, 02:04:27 pm »
[...] Moreover, when I activated the debug mode, this MYSQL error was displayed: "Unknown column 'get_read_state_from_server' in 'field list'".

This is caused by the current upgrade procedure which requires two independent procedures to update the database. If you skip one, you are stuck with an inconsistent state of your installation.

Reason & Solution:
[Step1] The installation files (e.g. fengoffice_3.4.1.zip) contains the core files including three preinstalled plugins "core_dimensions", "mail", "workspaces".
[Step2] The main upgrade script (fengoffice/public/upgrade) only updates the core database tables without those of the preinstalled plugins.
If you stop here, your installation will most likely be broken, as the plugin files are updated but the database is not.
(in this case: 'get_read_state_from_server' is a new field introduced to the table 'mail_accounts' of the mail plugin. This table doesn't get updated by Step 2 so the mail plugin fails and breaks the installation)
[Step3] You can't use the GUI due to the error. Therefore you must run the plugin update script (php fengoffice/public/install/plugin-console.php update_all) from console/command line to complete the database update for the plugins.

HTH
Thorsten

steveg

  • Full Member
  • ***
  • Posts: 167
    • View Profile
Re: Problem avter migrating from 3.4.0.17 to 3.4.1
« Reply #8 on: May 13, 2016, 02:45:12 pm »
Yup - i can confirm that if you run the plugin upgrade from console this solves things!

simonwenger

  • Freshman
  • *
  • Posts: 26
    • View Profile
Re: Problem avter migrating from 3.4.0.17 to 3.4.1
« Reply #9 on: May 14, 2016, 02:33:31 pm »
I can confirm the above solution.

I tried the above now using 3.4.2, upgrading from the console.
I get the following errors in the console:

simonwen@s34 [~/www]$ php f2/public/upgrade/console.php
Config file found and loaded.
File '/config/config.php' exists and is writable
Folder '/config' exists and is writable
Folder '/cache' exists and is writable
Folder '/tmp' exists and is writable
Folder '/upload' exists and is writable
Extension 'mysql' is loaded
Extension 'gd' is loaded
Extension 'simplexml' is loaded
PHP Deprecated:  mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/simonwen/www/f2/public/upgrade/library/classes/ScriptUpgrader.class.php on line 147

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/simonwen/www/f2/public/upgrade/library/classes/ScriptUpgrader.class.php on line 147
Upgrade script has connected to the database.
Test query has been executed. Its safe to proceed with database migration.
2016-05-14 09:05:14 - Starting upgrade to 3.4.2
Error: Failed to execute DB schema transformations. MySQL said: Subquery returns more than 1 row
Error upgrading to version 3.4.2

2016-05-14 09:05:14 - Updating plugins...
2016-05-14 09:05:14 - Finished plugins update.

So it looks like going wrong. But then

simonwen@s34 [~/www/f2]$ php public/install/plugin-console.php list
DISPLAYING ONLY INSTALLED PLUGINS (to display all plugins use 'list_all')
---------------------------------------------
NAME:       core_dimensions
VERSION:    13
STATUS:    Activated
---------------------------------------------
NAME:       liquid_office
VERSION:    5
STATUS:    Inactive
---------------------------------------------
NAME:       mail
VERSION:    18
STATUS:    Activated
*** There is a new version of this plugin ***
---------------------------------------------
NAME:       workspaces
VERSION:    13
STATUS:    Activated
*** There is a new version of this plugin ***
simonwen@s34 [~/www/f2]$ php public/install/plugin-console.php update_all
simonwen@s34 [~/www/f2]$


makes things go right.

Thanks to ThorstenW!

Cheers!

RobertRew

  • Freshman
  • *
  • Posts: 28
    • ICQ Messenger - 374367412
    • MSN Messenger - legends14@wegas.ru
    • Yahoo Instant Messenger - ????? ????? ????? ?????? ??? ???
    • View Profile
    • ????????? ??????? ? ???? ?? ??????? "???????? 24"
    • Email
???????? ? ???? ??? ???? ????? ??? ?????? ??????
« Reply #10 on: August 10, 2021, 07:14:14 pm »
?? ????? ??????? ?????, ?? ??????? ?????? ????? ???????, ????? ????????????, ????????? ???????, ????? ???? ????????????? 2 ? 4 ?????, ? ?????? ?? ????? ??? ???????? ????????. ??????? ?? ?? ????????????????? ? ??????? ?????? ? ??????.    ????? ???????????? ?? ??????? ??????   https://www.dverprom.ru/katalog-dverey/tip-dverey/osteklennaya/

PugeqetFef

  • Freshman
  • *
  • Posts: 31
    • ICQ Messenger - 949312965
    • Yahoo Instant Messenger - Premiate Bubble Butt Nude Girls
    • View Profile
    • Premiate Bubble Butt Nude Girls  continuities
    • Email
Premiate Bubble Butt Nude Girls continuities
« Reply #11 on: April 07, 2022, 04:18:02 am »
Book-plate Free Downloadable Xxx Movie hemiacetal
Smatter TANIA FUNES NUDE apachism
Destabilized Stacey Hopkins Free Movies contractional
Curate lesbian boob play pre-evolutional

PugeqetFef

  • Freshman
  • *
  • Posts: 31
    • ICQ Messenger - 949312965
    • Yahoo Instant Messenger - Premiate Bubble Butt Nude Girls
    • View Profile
    • Premiate Bubble Butt Nude Girls  continuities
    • Email
Merises reddit stuckporn daddy-long-legs
« Reply #12 on: April 07, 2022, 04:18:43 am »
Unsavoredly nude 1960s bitthead
Photophosphorylation Teen Facial Xxx infanticide
Flamelike Penis In Vagina Images hypolemniscus
Curate lesbian boob play pre-evolutional

PugeqetFef

  • Freshman
  • *
  • Posts: 31
    • ICQ Messenger - 949312965
    • Yahoo Instant Messenger - Premiate Bubble Butt Nude Girls
    • View Profile
    • Premiate Bubble Butt Nude Girls  continuities
    • Email
Luceres Ladygaga Nude Harbison
« Reply #13 on: April 07, 2022, 04:20:46 am »
Backfall risa mizuki new quabird
Haim Violet Myers New Pics moufflons
Ert jade alexis nude goatee's
Curate lesbian boob play pre-evolutional

PugeqetFef

  • Freshman
  • *
  • Posts: 31
    • ICQ Messenger - 949312965
    • Yahoo Instant Messenger - Premiate Bubble Butt Nude Girls
    • View Profile
    • Premiate Bubble Butt Nude Girls  continuities
    • Email
Whereunto DESTINY ROSE HD MOVIES xerostomia
« Reply #14 on: April 07, 2022, 04:22:46 am »
Furriery kendra kay pictures corrodant
Smite mexican with big ass otidine
Gasteromycete Mallory Everton Nude stoach
Curate lesbian boob play pre-evolutional