I followed your instructions in "Akeeba backup and migrating to Joomla 3" to migrate my site from Joomla 2.5 to 3.5.1. The site was fine after going to Joomla 3.5.1 on my local server, but after backing it up and restoring it on Hostgator, the front end shows error 1146 when loading any page that includes an SQL statement referencing a table in my database. An example of the message is in the attached file. The table does exist; I can access it from phpMyAdmin. The table prefix in the database matches the one in the configuration.php file and the one shown on the back end in the Global Configuration - Database Settings. Something isn't matching up, and I don't know where else to look.
#25037 Error 1146 Table doesn't exist after restore to live site
Posted in ‘Site restoration’
This is a public ticket
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Environment Information
PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a
Latest post by on Sunday, 29 May 2016 17:20 CDT
Thursday, 28 April 2016 07:18 CDT
bucksgen
Thursday, 28 April 2016 08:25 CDT
tampe125
Akeeba Staff
Hello Nancy,
if the table is there, it means that the problem is somewhere else.
Did you try to REPAIR/OPTIMIZE the table inside phpMyAdmin? Moreover can you please ask your hosting to take a look at it, to double check that everything is ok?
Finally, I think you should ask support to ChronoForms, since I suspect there's something off in component configuration.
if the table is there, it means that the problem is somewhere else.
Did you try to REPAIR/OPTIMIZE the table inside phpMyAdmin? Moreover can you please ask your hosting to take a look at it, to double check that everything is ok?
Finally, I think you should ask support to ChronoForms, since I suspect there's something off in component configuration.
Davide Tampellini
Developer and Support Staff
🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Thursday, 28 April 2016 09:18 CDT
bucksgen
I have found additional issues that may be related. When I try to open Admin Tools, I get a message "Invalid Joomla configuration settings detected: Invalid or unwritable Joomla log directory. Please fix it inside Joomla Global configuration." However, I can't save any settings in Global Configuration. When I searched for an answer to this issue, I'm told to use Admin Tools to fix file permissions. Catch-22!
Thursday, 28 April 2016 09:32 CDT
tampe125
Akeeba Staff
Regarding the "Global Configuration" issue, it means that you a permission issue on your server. You can try enabling the FTP layer inside Joomla Global Configuration, that should work.
Anyway, you should contact your hosting, since that could lead to several other issues.
Anyway, you should contact your hosting, since that could lead to several other issues.
Davide Tampellini
Developer and Support Staff
🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Thursday, 28 April 2016 12:45 CDT
bucksgen
OK, thanks. I can't enable the FTP layer because I can't save anything in the Joomla Global Configuration. I've contacted my hosting provider and am waiting for an answer.
Friday, 29 April 2016 01:49 CDT
tampe125
Akeeba Staff
Ok, let me know!
I thought that while saving the FTP layer details, it immediately used it to write the new configuration file; maybe it was too smart ;)
I thought that while saving the FTP layer details, it immediately used it to write the new configuration file; maybe it was too smart ;)
Davide Tampellini
Developer and Support Staff
🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Sunday, 29 May 2016 17:20 CDT
System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.