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?
When I try to select it in the left pane, I get an error that says:
#1146: Table 'northfh5_nw3.jml_updates'
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` -- -- --------------------------
MySQL said:
#1146 - Table 'northfh5_nw3.jml_updates'
Any way to fix, replace, or recreate the table in the original database?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Great troubleshooting steps to solve your problem.
ASKER
It worked
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.