Link to home
Start Free TrialLog in
Avatar of Member_2_6574258
Member_2_6574258

asked on

Joomla - database table exists, and it doesn't

When I view my Joomla database northfh5_nw3 in PHPmyAdmin, in the left pane the jml_updates table is listed but the table name does NOT show up in the right pane .

When I try to select it in the left pane, I get an error that says:
#1146: Table 'northfh5_nw3.jml_updates'  does not exist.

I have an exact copy of that database that is named northfh5_nw3a, that contains the same table, 'jml_updates'. I exported it and tried to import it back into the first database. Doing that I get this :

Error
SQL query:
-- -- Database: `northfh5_nw3a` -- -- -------------------------------------------------------- -- -- Table structure for table `jml_updates` -- CREATE TABLE IF NOT EXISTS `jml_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) COLLATE utf8mb4_unicode_ci DEFAULT '', `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `element` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '', `type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '', `folder` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '', `client_id` tinyint(3) DEFAULT '0', `version` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '', `data` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `detailsurl` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `infourl` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `extra_query` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT '', PRIMARY KEY (`update[...]

MySQL said:  
#1146 - Table 'northfh5_nw3.jml_updates' doesn't exist


Any way to fix, replace, or recreate the table in the original database?
Avatar of Carlos Llanos
Carlos Llanos
Flag of United States of America image

Are you still needing assistance with this?
If so, have you been able to simply create any database table within that database?
It might be a permissions issue?

If you have been able to create other tables within that database, then that is not the issue, but let's start there first.
ASKER CERTIFIED SOLUTION
Avatar of Member_2_6574258
Member_2_6574258

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great to hear everything is working again. It is truly puzzling that it did happen. I haven't heard of anything like that before.
Great troubleshooting steps to solve your problem.
Avatar of Member_2_6574258
Member_2_6574258

ASKER

It worked