JoomDev: Error 1146 Table 'xxx.#__updates' doesn't exist (1/1)

Introducing astroid v2.0 with article types, custom badges and much more. Download Now

Welcome, Guest
Username: Password: Remember me

TOPIC: Error 1146 Table 'xxx.#__updates' doesn't exist

Error 1146 Table 'xxx.#__updates' doesn't exist 4 months 2 weeks ago #7145

  • zmazu
  • zmazu's Avatar
  • Offline
  • Junior Member
  • Posts: 21
  • Karma: 1
Hi,

I'm testing this template installed on existing Joomla site. And from time to time I've got the message as in the topic. After I check the database and the table 'xxx_updates' really is not there. The site administration works fine except Quix module. Of course it is important for me. I can deal with that, I duplicate this table from another database but it is not definitive solution. How to repair this problem?

Regards
The administrator has disabled public write access.

Error 1146 Table 'xxx.#__updates' doesn't exist 4 months 2 weeks ago #7147

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Posts: 1110
  • Thank you received: 157
  • Karma: 27
Hello,

There can be 2 possible solutions here.

1. Login to Joomla backend >> Extensions >> Database and if there are any database warnings, Click the fix button and that should do.
2. (Assuming the above doesn't work), Run the below query in your Joomla DB (using PhpMyAdmin) and this will recreate the table for you.
CREATE TABLE IF NOT EXISTS `#__updates` (
  `update_id` int(11) NOT NULL AUTO_INCREMENT,
  `update_site_id` int(11) DEFAULT 0,
  `extension_id` int(11) DEFAULT 0,
  `name` varchar(100) DEFAULT '',
  `description` text NOT NULL,
  `element` varchar(100) DEFAULT '',
  `type` varchar(20) DEFAULT '',
  `folder` varchar(20) DEFAULT '',
  `client_id` tinyint(3) DEFAULT 0,
  `version` varchar(32) DEFAULT '',
  `data` text NOT NULL,
  `detailsurl` text NOT NULL,
  `infourl` text NOT NULL,
  `extra_query` varchar(1000) DEFAULT '',
  PRIMARY KEY (`update_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Available Updates';
Thank You,
If you like our support and products, tweet us at joomdev and let the world know about it.
The administrator has disabled public write access.

Error 1146 Table 'xxx.#__updates' doesn't exist 4 months 13 hours ago #7244

  • zmazu
  • zmazu's Avatar
  • Offline
  • Junior Member
  • Posts: 21
  • Karma: 1
Hello,
Thanks for your answer, but I have still the same problem. The table 'xxx.#__updates' disappears from time to time. Of course the first method proposed by you doesn't work, fix database has no effect. And the second method, recreate the table, works only for certain time. After few days, the table disappears again. What to do?
Regards
Zmazu
The administrator has disabled public write access.

Error 1146 Table 'xxx.#__updates' doesn't exist 4 months 9 hours ago #7247

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Posts: 1110
  • Thank you received: 157
  • Karma: 27
Hello Zmazu,

I can't think of a reason why the updates table would be deleted after some time.

Let me do some research on this and I'll get back to you with more info.

Thanks,
Chetan
Thank You,
If you like our support and products, tweet us at joomdev and let the world know about it.
The administrator has disabled public write access.
Moderators: priyasingh
Time to create page: 0.381 seconds