Support

UNiTE, Remote CLI, eXtract Wizard

#19901 Problem updating from 2.5 to 3.2.3

Posted in ‘UNiTE and Remote CLI’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
Tool
UNiTE
Tool version
n/a

swingshoes
 I read:
#19119 – Update to 3.2.2 CMS update not working

My update hangs at the "finalise" moment, and I ultimately get:
1091 Can't DROP 'usertype'; check that column/key exists SQL=ALTER TABLE `vts_users` DROP KEY `user type`;

As you recommended, I did a database fix on:
Database schema version (2.5.19) does not match CMS version (3.2.3).
Table 'vts_modules' does not have column 'asset_id'. (From file 3.2.0.sql.)
Table 'vts_users' does not have column 'otpKey'. (From file 3.2.0.sql.)
Table 'vts_users' does not have column 'otep'. (From file 3.2.0.sql.)
Table 'vts_update_sites' does not have column 'extra_query'. (From file 3.2.2-2013-12-22.sql.)
Table 'vts_updates' does not have column 'extra_query'. (From file 3.2.2-2013-12-22.sql.)
Table 'vts_updates' does not have column 'version' with type 'varchar(32)'. (From file 3.2.2-2014-01-18.sql.)

The database fixes everything except for:
Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3).

If I select, Content -> Article Manager:
Warning
Error loading component: com_tags, Component not found

Let me know if you have any suggestions for this.
Let me know if you want "keys" to this basically empty site.

Thanks,
Erik

nicholas
Akeeba Staff
Manager
This error comes from the SQL file included in the update file by the Joomla! project themselves and is the result of the lack of permissions on your database user.

Please assign all necessary privileges to your database user (you may have to ask your host to do that for you): alter, create, drop, index, insert, select, update, create view and show view. Then go to Extensions, Extension Manager, Database and click on the Fix button.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

swingshoes
Thank you for your information.
I have made sure that the database-user has "All Privileges"
I have clicked on Extension Manager > Fix Database,
but it still says:
"Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3)"

There is also present on Content > Article Manager
Warning
Error loading component: com_tags, Component not found

Thanks,
Erik

nicholas
Akeeba Staff
Manager
but it still says:

"Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3)"

That's a known cosmetic bug in Joomla!. When they updated their code for 3.2.3 they forgot to remove the part after the dash when comparing the version of the installed database and the latest available database revision. They are already aware of it but they have not released a fix yet.

Warning

Error loading component: com_tags, Component not found


Also a bug in Joomla!. Most likely you can go to Extensions, Extension Manager, Discover and it will find the missing extensions. Then select them and click on Install.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

swingshoes
Thanks! Your suggestions solved the issues for one of my sites.

Here's the next site's issue:
Update hangs at "Finalise"
Can not get back into Extension Manager:
Message:
An error has occurred.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 'plugin' AND = 'editors' AND = 1' at line 3 SQL=SELECT element, name FROM dancinginct_extensions WHERE = 'plugin' AND = 'editors' AND = 1

Any thoughts on this?
Erik

nicholas
Akeeba Staff
Manager
It's the same thing, all over again. The database update fails (probably just times out?) leading to an incomplete upgrade. At this point the only thing you can do is restore a backup of the site.

I would recommend the following method for performing updates to a new major release of Joomla! (e.g. from 2.x to 3.x):
  • Take a backup of your live site
  • Restore it on a local server (MAMP, XAMPP, WAMPserver or Zend Server)
  • Set max_execution_time=180 and memory_limit=256M in your local server's php.ini and restart it.
  • Make sure you've shut down as many programmes as possible, especially those which produce a lot of disk activity.
  • Upgrade your site on the local server.
  • Take a backup of the upgraded site.
  • Delete the files of your live site (leave the database intact)
  • Restore the backup of the upgraded site to the live site.


That's how we do it on all of our sites.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

swingshoes
I followed your directions to the letter, however I still received the same message:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 'plugin' AND = 'editors' AND = 1' at line 3 SQL=SELECT element, name FROM joom25_extensions WHERE = 'plugin' AND = 'editors' AND = 1

Please let me know any suggestions you have. I can send a jpa file to you if you want.

Thanks,
Erik

nicholas
Akeeba Staff
Manager
Sorry, that seems to not be related to our software or Joomla! after all. I guess that you have some very old extension which is not compatible with Joomla! 3. Most likely it's a WYSIWYG editor or something that uses one as far as I can tell from the SQL error.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

swingshoes
Is there a way to send the jpa file to you so you can tell me the silly problem plug-in that is causing me grief?

thanks,
Erik

nicholas
Akeeba Staff
Manager
No, sorry, I can't debug Joomla! sites on behalf of my clients. I can, however, tell you what I'd do: edit the #__extensions table and unpublish (set enabled=0) to all plugins except the core Joomla! ones. If necessary, I'd do the same with #__modules. One I'd get access to the admin I'd start enabling one plugin/module at a time to find out what the culprit is.

Alternatively, follow this video tutorial to upgrade your site: http://www.siteground.com/tutorials/joomla-video/jooml25-to-joomla3/

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

swingshoes
Thanks!!
I disabled all plug-ins.
I was able to view the Administrator side.
Turned on Plug-ins, one by one.
Found problem (System - Show/Hide content)
Deleted Problem plug-in.

It's a slow process to fix.

Is there a way that your component would be able to detect what the conflicting plug-in or module would be? Perhaps a Debug toggle?
For guys like you, this stuff is simple; for guys like me, it makes me go crazy (and feel dumb).

Thanks,
Erik

nicholas
Akeeba Staff
Manager
Is there a way that your component would be able to detect what the conflicting plug-in or module would be?

No.

Perhaps a Debug toggle?

No.

For guys like you, this stuff is simple; for guys like me, it makes me go crazy (and feel dumb).

I wouldn't call it "simple" by any definition of the term. Maybe you meant "slow, frustrating and with a chance of making you feel like you were born yesterday"? If that's what you meant with "simple" then, yeah, that's exactly what it is.

FWIW, if I could automate this kind of debugging I could shut down the site restoration section of the support ticket system and probably the entire support. Unfortunately, the level of troubleshooting required for this kind of issues requires a human brain or artificial intelligence. We're not there yet :)

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!

Summer vacations: Our support will be closed for replies and new tickets from August 6th to August 21st, 2022 due to summer vacations.