Problems trying to update Joomla!

General questions relating to Joomla! 3.x. Please consider the availability of third-party templates and extensions when deciding which Joomla version to use.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Post Reply
Ironside
Joomla! Ace
Joomla! Ace
Posts: 1724
Joined: Mon Nov 13, 2006 8:01 pm
Contact:

Problems trying to update Joomla!

Post by Ironside » Thu Jul 19, 2018 8:04 pm

I am trying to update Joomla! because it's and 3.3.6. However, I've got the following error in Joomla! updates

Code: Select all

1054 Unknown column 'a.extra_query' in 'field list' SQL=SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query FROM xxifc_update_sites AS a INNER JOIN xxifc_update_sites_extensions AS b ON a.update_site_id = b.update_site_id WHERE a.enabled = 1 AND b.extension_id = 700
I've tried fixing the table but I just get a box saying there's an error and I can't do anything with it. Any idea what's going on?
Ham and eggs. A day's work for a chicken, a lifetime commitment for a pig.

http://www.tetraplegicliving.com
http://www.oscarfishlover.com

User avatar
sozzled
Joomla! Champion
Joomla! Champion
Posts: 5824
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Problems trying to update Joomla!

Post by sozzled » Thu Jul 19, 2018 8:08 pm

Ironside wrote:I am trying to update Joomla! ...
How, specifically, are you trying to update Joomla? Can you describe the steps you're using to update Joomla, please?
https://www.kuneze.com/blog
Former member of Kunena project team
If you think I’m wrong then say “I think you're wrong.” If you say “You’re wrong!”, how do you know?

Ironside
Joomla! Ace
Joomla! Ace
Posts: 1724
Joined: Mon Nov 13, 2006 8:01 pm
Contact:

Re: Problems trying to update Joomla!

Post by Ironside » Thu Jul 19, 2018 8:21 pm

When I signed into this particular website you will normally get a message telling you that there's an update. Normally I would just follow the instructions. However, I'm going into components and Joomla! updater and that is where the error message is.
Ham and eggs. A day's work for a chicken, a lifetime commitment for a pig.

http://www.tetraplegicliving.com
http://www.oscarfishlover.com

User avatar
sozzled
Joomla! Champion
Joomla! Champion
Posts: 5824
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Problems trying to update Joomla!

Post by sozzled » Thu Jul 19, 2018 8:28 pm

I think you've left out a few steps in your description of the problem. From what you've written:

1) You go to Components » Joomla! Update
2) You click the menu item Joomla! Update and, without doing anything else, you get the error message.

Is that correct?
https://www.kuneze.com/blog
Former member of Kunena project team
If you think I’m wrong then say “I think you're wrong.” If you say “You’re wrong!”, how do you know?

Ironside
Joomla! Ace
Joomla! Ace
Posts: 1724
Joined: Mon Nov 13, 2006 8:01 pm
Contact:

Re: Problems trying to update Joomla!

Post by Ironside » Thu Jul 19, 2018 8:38 pm

Yes, I click components, Joomla! update and I met with a message saying an error has occurred and then the code underneath
Ham and eggs. A day's work for a chicken, a lifetime commitment for a pig.

http://www.tetraplegicliving.com
http://www.oscarfishlover.com

User avatar
sozzled
Joomla! Champion
Joomla! Champion
Posts: 5824
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Problems trying to update Joomla!

Post by sozzled » Thu Jul 19, 2018 8:45 pm

Wow! Sounds like your website is broken. :( Consider to starting over or get a professional to work on the problems with you.

You could try fixing the database (that's where the problem lives) but there's no guarantee.

This situation shouldn't happen (just by clicking a menu item and the error message immediately appears like that). Sorry, mate.
https://www.kuneze.com/blog
Former member of Kunena project team
If you think I’m wrong then say “I think you're wrong.” If you say “You’re wrong!”, how do you know?

Ironside
Joomla! Ace
Joomla! Ace
Posts: 1724
Joined: Mon Nov 13, 2006 8:01 pm
Contact:

Re: Problems trying to update Joomla!

Post by Ironside » Thu Jul 19, 2018 8:56 pm

I've tried fixing the database, the updates table but it makes absolutely no difference whatsoever. The actual website is working okay, just can't update it. The main problem is when I make a backup and try and reinstall it on another server that I have I'm getting an error on the homepage telling me that I'm not allowed to view the resource, something along those lines. Luckily, I still had all the files on the old server so I just had to change the name servers and the website came back to life. But it's when I went into update I found this problem. I'm seriously thinking about changing it to a WordPress site. There's not much content so it wouldn't take me more than a couple of hours to set up a new website. I can get a good deal for hosting on a British hosting company website
Ham and eggs. A day's work for a chicken, a lifetime commitment for a pig.

http://www.tetraplegicliving.com
http://www.oscarfishlover.com

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 24869
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Problems trying to update Joomla!

Post by Per Yngve Berg » Fri Jul 20, 2018 6:08 pm

For how long has this been a problem? With 3.3.6, you are several years behind in updating.

You may update in increments:

https://downloads.joomla.org/cms/joomla ... format=zip

Download and install this package with the Extension installer. Note that from 3.5.0, this method can no longer be used. You have to use the Joomla updater.

Please post the FPA Report. There may be restrictions on your hosting server that prevent the updates.
viewtopic.php?f=714&t=793531

Ironside
Joomla! Ace
Joomla! Ace
Posts: 1724
Joined: Mon Nov 13, 2006 8:01 pm
Contact:

Re: Problems trying to update Joomla!

Post by Ironside » Sat Jul 21, 2018 12:45 pm

Ham and eggs. A day's work for a chicken, a lifetime commitment for a pig.

http://www.tetraplegicliving.com
http://www.oscarfishlover.com

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 24869
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Problems trying to update Joomla!

Post by Per Yngve Berg » Sat Jul 21, 2018 1:45 pm

Here is the FPA Report.

Do you have issues with following directions?
Forum Post Assistant (v1.4.3 (Frosty)) : 21st July 2018 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.3.6-Stable (Ember) 01-October-2014
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Writable (644) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 3.3
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 1 | .htaccess/web.config: Yes | GZip: 0 | Cache: 0 | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: N/A | FTP Layer: 0 | Proxy: N/A | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: N/A | SSL: 0 | Error Reporting: default | Site Debug: 0 | Language Debug: 0 | Default Access: 1 | Unicode Slugs: 0 | dbConnection Type: mysqli | PHP Supports J! 3.3.6: No | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.14.52-vs2.3.6.15-1 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 55.85 GiB |

PHP Configuration :: Version: 7.0.30 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22519 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 64M | Max. POST Size: 65M | Max. Input Time: -1 | Max. Execution Time: 30 | Memory Limit: 90M

Database Configuration :: Version: 5.6.34-log (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $) | Host: --protected-- (--protected--) | Localhost: No | Collation: utf8_general_ci (Character Set: utf8) | Database Size: 7.13 MiB | #of Tables:  96
Detailed Environment :: wrote:PHP Extensions :: Core (7.0.30) | date (7.0.30) | libxml (7.0.30) | pcre (7.0.30) | sqlite3 (7.0.30) | filter (7.0.30) | mbstring (7.0.30) | SPL (7.0.30) | PDO (7.0.30) | Reflection (7.0.30) | pdo_sqlite (7.0.30) | hash (1.0) | session (7.0.30) | cgi-fcgi () | bcmath (7.0.30) | bz2 (7.0.30) | calendar (7.0.30) | ctype (7.0.30) | curl (7.0.30) | dom (20031129) | standard (7.0.30) | fileinfo (1.0.5) | ftp (7.0.30) | gd (7.0.30) | gettext (7.0.30) | exif (7.0.30) | iconv (7.0.30) | imap (7.0.30) | json (1.4.0) | mcrypt (7.0.30) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $) | openssl (7.0.30) | pcntl (7.0.30) | pdo_mysql (7.0.30) | zlib (7.0.30) | posix (7.0.30) | pspell (7.0.30) | mysqli (7.0.30) | SimpleXML (7.0.30) | soap (7.0.30) | sockets (7.0.30) | tokenizer (7.0.30) | xml (7.0.30) | xmlreader (7.0.30) | xmlrpc (7.0.30) | xmlwriter (7.0.30) | xsl (7.0.30) | zip (1.13.5) | Phar (2.0.2) | imagick (3.4.3RC1) | memcached (3.0.1) | Zend OPcache (7.0.30) | Zend Engine (3.0.0) |
Potential Missing Extensions ::

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (---) |

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 9365575 | Threads: 15 | Questions: 18248139021 | Slow queries: 753277440 | Opens: 25308227 | Flush tables: 76 | Open tables: 2048 | Queries per second avg: 1948.426 |
Extensions Discovered :: wrote:Components :: SITE ::
Core :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
3rd Party:: WF_LINK_SEARCH_TITLE (2.3.4.4) 1 | WF_MEDIAPLAYER_JCEPLAYER_TITLE (2.3.4.4) 1 | WF_FILESYSTEM_JOOMLA_TITLE (2.3.4.4) 1 | WF_AGGREGATOR_GOOGLEMAPS_TITLE (2.3.4.4) 1 | WF_AGGREGATOR_VINE_TITLE (2.3.4.4) 1 | WF_AGGREGATOR_VIMEO_TITLE (2.3.4.4) 1 | WF_AGGREGATOR_[youtube]_TITLE (2.3.4.4) 1 | WF_POPUPS_WINDOW_TITLE (2.3.4.4) 1 | WF_POPUPS_JCEMEDIABOX_TITLE (2.3.4.4) 1 | WF_LINKS_JOOMLALINKS_TITLE (2.3.4.4) 1 | K2 Links for JCE Link (2.2) 1 | WF_MEDIA_TITLE (2.3.4.4) 1 | WF_SPELLCHECKER_TITLE (2.3.4.4) 1 | WF_TABLE_TITLE (2.3.4.4) 1 | WF_PREVIEW_TITLE (2.3.4.4) 1 | WF_XHTMLXTRAS_TITLE (2.3.4.4) 1 | WF_SEARCHREPLACE_TITLE (2.3.4.4) 1 | WF_INLINEPOPUPS_TITLE (2.3.4.4) 1 | WF_VISUALBLOCKS_TITLE (2.3.4.4) 1 | WF_CLEANUP_TITLE (2.3.4.4) 1 | WF_CHARMAP_TITLE (2.3.4.4) 1 | WF_STYLE_TITLE (2.3.4.4) 1 | WF_PRINT_TITLE (2.3.4.4) 1 | WF_VISUALCHARS_TITLE (2.3.4.4) 1 | WF_KITCHENSINK_TITLE (2.3.4.4) 1 | WF_NONBREAKING_TITLE (2.3.4.4) 1 | WF_CLIPBOARD_TITLE (2.3.4.4) 1 | WF_BROWSER_TITLE (2.3.4.4) 1 | WF_LAYER_TITLE (2.3.4.4) 1 | WF_LISTS_TITLE (2.3.4.4) 1 | WF_CONTEXTMENU_TITLE (2.3.4.4) 1 | WF_TEXTCASE_TITLE (2.3.4.4) 1 | WF_ARTICLE_TITLE (2.3.4.4) 1 | WF_SOURCE_TITLE (2.3.4.4) 1 | WF_ANCHOR_TITLE (2.3.4.4) 1 | WF_IMGMANAGER_TITLE (2.3.4.4) 1 | WF_LINK_TITLE (2.3.4.4) 1 | WF_FULLSCREEN_TITLE (2.3.4.4) 1 | WF_DIRECTIONALITY_TITLE (2.3.4.4) 1 | WF_AUTOSAVE_TITLE (2.3.4.4) 1 |

Components :: ADMIN ::
Core :: com_media (3.0.0) 1 | com_contenthistory (3.2.0) 1 | com_cpanel (3.0.0) 1 | com_templates (3.0.0) 1 | com_weblinks (3.0.0) 1 | com_redirect (3.0.0) 1 | com_plugins (3.0.0) 1 | com_content (3.0.0) 1 | com_checkin (3.0.0) 1 | com_finder (3.0.0) 1 | com_menus (3.0.0) 1 | com_languages (3.0.0) 1 | com_joomlaupdate (3.0.0) 1 | com_newsfeeds (3.0.0) 1 | com_login (3.0.0) 1 | com_messages (3.0.0) 1 | com_installer (3.0.0) 1 | com_config (3.0.0) 1 | com_banners (3.0.0) 1 | com_tags (3.1.0) 1 | com_categories (3.0.0) 1 | com_users (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_ajax (3.2.0) 1 | com_search (3.0.0) 1 | com_modules (3.0.0) 1 | com_cache (3.0.0) 1 | com_admin (3.0.0) 1 |
3rd Party:: JCE (2.3.4.4) 1 | MooFAQ (1.5.2) 1 | Akeeba (4.1.2) 1 |

Modules :: SITE ::
Core :: mod_articles_category (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_search (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_weblinks (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_login (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_banners (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_languages (3.0.0) 1 | mod_whosonline (3.0.0) 1 |
3rd Party:: Phoca - Google AdSense Easy (2.0.2) 1 | Optimized FB Like Button (3.0.4) 1 | Perfect Facebook Like Box Side (1.0.10) 1 | mod_ads_elite (4.5) 1 |

Modules :: ADMIN ::
Core :: mod_version (3.0.0) 1 | mod_status (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_login (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_title (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 |
3rd Party::

Plugins :: SITE ::
Core :: plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_gmail (3.0.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_twofactorauth_totp (3.2.0) 0 | plg_search_tags (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_weblinks (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | PLG_EOSNOTIFY (2.5.0) 1 | plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_system_languagefilter (3.0.0) 0 | plg_system_redirect (3.0.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_highlight (3.0.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_log (3.0.0) 1 | plg_system_p3p (3.0.0) 1 | plg_captcha_recaptcha (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_weblinks (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_content_geshi (3.0.0) 0 | plg_content_joomla (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_pagebreak (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 |
3rd Party:: plg_quickicon_jcefilebrowser (2.3.4.4) 1 | X5 Fastchat for Jomsocial (1.0) 0 | plg_system_adsstarterelite (4.5) 1 | plg_editors_tinymce (4.1.2) 1 | plg_editors_codemirror (3.15) 1 | plg_editors_jce (2.3.4.4) 1 |
Templates Discovered :: wrote:Templates :: SITE :: pulsar (1.0.1.73) 1 | elegant (1.0.0) 1 | ajt001_j25 (2.5.0) 1 | protostar (1.0) 1 | equinox (3.0.1) 1 | a4joomla-sunset-free (1.0) 1 | ol_aspita (2.5.x) 1 | atomic (2.5.0) 1 | creativa (1.0.2.5.4) 1 | beez5 (2.5.0) 1 | beez_20 (2.5.0) 1 | siteground-j16-38 (1.0.0) 1 | sensory (1.0.2.5) 1 | beez3 (3.1.0) 1 | siteground-j16-28 (1.0.0) 1 | iFreedom-FJT (2.5.0) 1 |
Templates :: ADMIN :: bluestork (2.5.0) 1 | hathor (3.0.0) 1 | isis (1.0) 1 |

Ironside
Joomla! Ace
Joomla! Ace
Posts: 1724
Joined: Mon Nov 13, 2006 8:01 pm
Contact:

Re: Problems trying to update Joomla!

Post by Ironside » Sat Jul 21, 2018 2:56 pm

If I did have an issue then it would be lost on me afraid. There's something wrong with the database, I think that is where the problem lays. This is nothing stopping me from using the website, everything seems to work perfectly okay, I just can't update, there is a problem with the update sites table and I've tried fixing it but it just won't work. Apparently, there's a way that I can switch the table off by changing a 1 to a 0, but I can't seem to find that bits in the database, maybe you could point me in the right direction?
Ham and eggs. A day's work for a chicken, a lifetime commitment for a pig.

http://www.tetraplegicliving.com
http://www.oscarfishlover.com

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 24869
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Problems trying to update Joomla!

Post by Per Yngve Berg » Sat Jul 21, 2018 3:32 pm

Create the missing column in the database table.

Code: Select all

ALTER TABLE  `xxifc_update_sites`   ADD COLUMN `extra_query` varchar(1000);
Joomla 3.3 is to old to be compatible with php 7.0.

Did you try the update to 3.4?

User avatar
sozzled
Joomla! Champion
Joomla! Champion
Posts: 5824
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Problems trying to update Joomla!

Post by sozzled » Sat Jul 21, 2018 3:35 pm

J! 3.3.6 won't run properly on PHP 7—see the technical requirements doco. This is probably one reason why the update won't work.
https://www.kuneze.com/blog
Former member of Kunena project team
If you think I’m wrong then say “I think you're wrong.” If you say “You’re wrong!”, how do you know?

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 35850
Joined: Sat Apr 05, 2008 9:58 pm

Re: Problems trying to update Joomla!

Post by Webdongle » Sat Jul 21, 2018 3:56 pm

sozzled wrote:J! 3.3.6 won't run properly on PHP 7—see the technical requirements doco. This is probably one reason why the update won't work.
Yep that will be it.

Change the php version either with the Host's CP or https://stackoverflow.com/questions/125 ... -in-server



I know some don't like working on localhost but if the above can not be done then use wamp on your pc ... it can change php version on the fly.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein


Post Reply

Return to “General Questions/New to Joomla! 3.x”