RESOLVED: The update table is not up to date. Please rebuild your update server table Topic is solved

General questions regarding the use of languages in Joomla! 3.x.

Moderators: infograf768, General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
Phil91
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed Jun 10, 2009 7:51 am

RESOLVED: The update table is not up to date. Please rebuild your update server table

Post by Phil91 » Fri Apr 19, 2019 2:05 pm

Hello experts,

I just experience right now an issue which I believed originally was belonging to the template provider I use since this is a brand new install I'm trying to achieve.

Here's what happens:
I just installed a brand new package consisting of a 3.9.0 Joomla+ the template, using by default the en-GB version.
Once installed, I then tried to install the additional French language package and this is where I get the A/M error.

After searching a bit further, I found out that all my other live sites (all of them being 3.9.5, with all updated extensions), I figured that they all exhibit the same issue and I have no clue as to where to look for a fix. All update sites xml files are ok as I can update all existing extensions, so the only option for now is to bang my head against the wall :)

I don't believe it has anything to do with the language files as I can install the packages separately, so.....

Should anyone be able to help, I'd be more than a happy man!

Cheers

Philippe
Last edited by Phil91 on Fri Apr 19, 2019 2:20 pm, edited 1 time in total.

 
Phil91
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed Jun 10, 2009 7:51 am

Re: The update table is not up to date. Please rebuild your update server table

Post by Phil91 » Fri Apr 19, 2019 2:19 pm

OK....Issue fixed!

For those who would experience the same issue, the answer is here and works absolutely like a charm!

https://zemez.io/joomla/support/knowled ... oomla-3-7/

Sorry for not reading the web enough before posting :)

Philippe

graziano68
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Wed Mar 23, 2016 10:27 am

Re: RESOLVED: The update table is not up to date. Please rebuild your update server table

Post by graziano68 » Thu Jan 09, 2020 10:47 am

same problem here

But when I apply this

INSERT INTO `jos_extensions` (`extension_id`, `package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES
(802, 0, 'English (en-GB) Language Pack', 'package', 'pkg_en-GB', '', 0, 1, 1, 1, '{"name":"English (en-GB) Language Pack","type":"package","creationDate":"April 2017","author":"Joomla! Project","copyright":"Copyright (C) 2005 - 2017 Open Source Matters, Inc. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.7.0.1","description":"en-GB language pack","group":"","filename":"pkg_en-GB"}', '', '', '', 0, '0000-00-00 00:00:00', 0, 0);


I receive this

#1062 - Duplicate entry '802' for key 'PRIMARY'

Any help please ?

User avatar
Chacapamac
Joomla! Guru
Joomla! Guru
Posts: 967
Joined: Wed Feb 20, 2008 6:50 am
Location: Canada, Montreal
Contact:

Re: RESOLVED: The update table is not up to date. Please rebuild your update server table

Post by Chacapamac » Mon Aug 03, 2020 9:48 pm

Nope, didn’t work for me, still the same message after query and rebuild all update sites and cleaning cache, logout, login.
warning.jpg
What now?

My query with my custom database prefix:

Code: Select all

INSERT INTO `w3ibq_extensions` (`extension_id`, `package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES
(802, 0, 'English (en-GB) Language Pack', 'package', 'pkg_en-GB', '', 0, 1, 1, 1, '{"name":"English (en-GB) Language Pack","type":"package","creationDate":"April 2017","author":"Joomla! Project","copyright":"Copyright (C) 2005 - 2017 Open Source Matters, Inc. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"3.7.0.1","description":"en-GB language pack","group":"","filename":"pkg_en-GB"}', '', '', '', 0, '0000-00-00 00:00:00', 0, 0);
Remark that I have 2 install language:
language.jpg
and the site is uni-lingual French....

QUESTION:
Do you pass the query on the whole database or only the _extensions table ?
I’m not a specialist in passing query, a little help to ensure that I do it correctly, I’m using MAMP Server (on my copy test site( Same error on live site....).

I Try both....
query.jpg
You do not have the required permissions to view the files attached to this post.
Can God help us?
Marketing, SEO, Web development - Powered by Joomla!
http://www.grafcomm.ca/

User avatar
Chacapamac
Joomla! Guru
Joomla! Guru
Posts: 967
Joined: Wed Feb 20, 2008 6:50 am
Location: Canada, Montreal
Contact:

Re: RESOLVED: The update table is not up to date. Please rebuild your update server table

Post by Chacapamac » Mon Aug 03, 2020 10:52 pm

I try like this and I get that error????
MySQL said: Documentation
#1292 - Incorrect datetime value: '0000-00-00 00:00:00' for column 'checked_out_time' at row 1

SQL-query.jpg
You do not have the required permissions to view the files attached to this post.
Can God help us?
Marketing, SEO, Web development - Powered by Joomla!
http://www.grafcomm.ca/

User avatar
ladydevil
Joomla! Intern
Joomla! Intern
Posts: 52
Joined: Sun Sep 14, 2014 5:56 am
Location: Singapore
Contact:

Re: RESOLVED: The update table is not up to date. Please rebuild your update server table

Post by ladydevil » Mon Aug 10, 2020 3:48 am

Chacapamac wrote:
Mon Aug 03, 2020 10:52 pm
I try like this and I get that error????
MySQL said: Documentation
#1292 - Incorrect datetime value: '0000-00-00 00:00:00' for column 'checked_out_time' at row 1


SQL-query.jpg
I am having the same case of MySQL error. Can you show me how to fix the error?

User avatar
Chacapamac
Joomla! Guru
Joomla! Guru
Posts: 967
Joined: Wed Feb 20, 2008 6:50 am
Location: Canada, Montreal
Contact:

Re: RESOLVED: The update table is not up to date. Please rebuild your update server table

Post by Chacapamac » Mon Aug 10, 2020 4:16 pm

Ok, this is a serious problem, hopefully somebody will find a good fix and the source of the problem...
Can God help us?
Marketing, SEO, Web development - Powered by Joomla!
http://www.grafcomm.ca/

 

Post Reply

Return to “Language - Joomla! 3.x”