No Database Tables Exist Error

I’m getting a similar issue while creating a new site running PHP 7.4 on nginx. Looking in AdminNeo, it says no database tables exist.

If I change to PHP 8.2, the site starts correctly and I’m taken to a WordPress install screen.

Hey @ekarkovack! Moving your comment into it’s own post here as it might be a separate issue.

Could you provide some more details to help us take a further look?

  • What is your OS?

  • What version of Local are you on?

  • Please attach a copy of your Local Logs

Keep us posted and we’d be happy to help further!

Hi @Nick-B, Thanks for your help!

I’m using Windows 11 and Local Version 9.2.6+6872

I’ve also attached my log file. Let me know if you need anything else!

Also, it looks like if I switch to PHP 7.4 and restart the site, I get a database connection error. Going back to PHP 8.2 resolves it.

I am troubleshooting an older site, so it would be great if I could use PHP 7.4.

local-lightning.log (236.4 KB)

It looks like from the log there might have been a problem with the import. Was this a site you imported from a zip and then tried to set to PHP 7.4?

You might try creating a new, blank site with PHP 7.4 first and then manually import your site’s contents over top of that. We’ve got the steps outlined here:

Manually Import a Local Site

I tried an automatic import, which failed a couple of times. Next, I started from scratch and am using Duplicator Pro to import it.

Still getting the issues with PHP 7.4, even with a clean site.

Are you utilizing the C drive or D drive? It looks like the logs are referencing both, and maybe having trouble reconciling.

Additionally, because of some of the connection errors in here, I’d recommend checking through our Windows Troubleshooting guide below that goes over some common items. For example, make sure you’re running Local as an admin user, that you don’t have any security blockers, and that Local has access to update your Hosts file.

Local in installed on C, while my site files are stored on D.

I’ll check out the guide. I have several other local sites working well on my config, but maybe there’s something goofy going on.

I’m glad to hear other sites are working normally for you. So if you create a new, blank site with PHP 7.4 specifically that errors out? Or are you just having troubles when importing this specific site in any way then?

It seems like I routinely have issues with anything related to PHP 7.4, regardless of server type. In this case, I created a blank site with nginx, and the database errors came up. I also rebooted my machine and tried again with the same results.

I also run into import issues once in a while. The site backups come from ManageWP, and the site imports fail and delete themselves.

Just to clarify, when you started from scratch, does a plain WordPress site using PHP 7.4 work? For example, can you create a PHP 7.4 site and log into the wp-admin to create posts and work with WP in general?

If that does work, then there’s likely a PHP error within the site (like the plugin or theme code) that is preventing Local from fully spinning up the various services.

When using Duplicator, are there errors that it shows?

If you are able to create a new, plain PHP 7.4 site, can you try manually importing the site using the steps outlined in this help doc:

Let us know what you come across, and if you still have issues, can you provide an updated version of the Local log?

Hi @ben.turner,

Creating a plain WP site with PHP 7.4 does not seem to work. There was a time when I could get it to work (but only using nginx, Apache has never seemed to work on my machine).

As I mentioned earlier, I’m getting database connection errors when trying to use 7.4. Looking in AdminNeo, there were no tables created. As soon as I switched to 8.2 and restarted the site, the database tables were created and I went through the WP install process.

In this case, I had to switch to PHP 8.2 and import via Duplicator Pro. There were no issues.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.