themavo

Hi again, @iamshubhamsp . I’m just following-up.

I enabled the WordPress repair of wp-config.php, following your earlier directions.

After the process of attempting the repair was done, WordPress displayed a log that listed a number of tables as being “okay.” For example:

The wp_users table is okay.
The wp_usermeta table is okay.
The wp_posts table is okay.
etc.

But the wp_options table was listed as being “not okay.” WordPress couldn’t repair it, stating that it “doesn’t exist in engine” (as I noted earlier in this thread).

But then I used Windows File Explorer to locate all of the files related to the tables WordPress accessed for this repair process.

The files for each table listed as okay were there…But so were the files for wp_options, which WordPress claims “doesn’t exist.” They all seem to be there in their correct locations. (It appears each table has two files: name.frm and name.ibd.)

Then, I tried to access the tables using phpMyAdmin.

There, under the affected database, all the tables WordPress checked are listed, including wp_options. But, unlike the other tables, the status of wp_options reads “in use.” It’s the only table which has that status.

When I click on wp_options from within phpMyAdmin, I receive an error message that reads “#1932 – Table ‘themavo.wp_options’ doesn’t exist in engine.”

But, according to File Explorer, it actually does exist along with all the other tables. I’m not sure what could be causing it to be regarded as “nonexistent” in phpMyAdmin and WordPress. Maybe that table’s files are somehow corrupt…

Thanks for your tip, @iamshubhamsp

Before I saw your latest post, I tried replacing the entire XAMPP > MySQL > data folder with a backup that I had. I still received the Error establishing a database connection message. Then, I tried replacing the same data folder with a version from an even older backup. Same error occurs. Again, I had been working on my site for a long time before and the connection to the database was not an issue. If a backup is not restoring the connection and the site, what is causing this issue all of a sudden?

I never really moved/migrated the site anywhere. So far it’s only been on my localhost hard drive connected to my workstation.

In any case, I’ll try the other steps you outlined in your message.

• This reply was modified 1 year, 2 months ago by themavo.

Hello, @catacaustic Thanks for your input.

Inside the wp-config.php file, I corrected the username and the password. Are there other steps I must take within that file or elsewhere to ensure the correct permissions for a given user? If yes, please let me know.

Hi, @iamshubhamsp

Just to be clear, the only file I’m trying to repair via phpMyAdmin the one named wp-config.php. Is that correct, or are there other files I’m supposed to be looking into as well?

I can’t seem to find a file with that name in phpMyAdmin.

@threadi

Currently, when I try to connect to my WordPress dashboard via localhost, the message states:

Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or that contact with the database server at localhost could not be established…

This is after I had gone into the wp-config.php file and typed in the correct login credentials.

Hi, @catacaustic

I looked in to my wp-config.php file and typed in my correct username and password. For some reason, those had both been missing.

There’s one more line that I’m unsure of:
/** The database collate type. Don’t change this if in doubt. */
define( ‘DB_COLLATE’, ” );

That line I left alone.

However, even after inserting my username and password, I still receive the error that the database can’t be found. The error page looks a bit different though. But still no database found.

Hi again, @apollo13themes

I created a little video capture of the issue as I worked in WordPress. To see the video, please visit…
https://vimeo.com/themavo/navlogo?share=copy

You’ll see that, when I customize the theme near the start of the video (via Appearance > Themes > Customize), The Mavo logo, which is the correct logo I need to use, displays in the header.

But then, when I visit a page that includes the Rife theme (Pages > All Pages > The Mavo Home), that page is missing The Mavo logo and displays the Star logo instead. When I go back to customize the page, The Mavo logo is still there. But, when previewing the page, it’s the Star logo that is there.

Also, I notice that, while attempting to edit the page using Elementor, the entire navigation menu (including the logo) vanishes whenever I move the cursor over it or try to select its container or nearby containers.

The correct logo is already in my customizer options (Appearance > Customize > Header Settings > Logo). No trace of the Star logo exists there. The theme header is enabled (under Appearance > Customize > General Settings > Theme Header). The Star logo is merely in the overall list of Media for the site, but not actually applied anywhere on the site, as far as I can see…

• This reply was modified 1 year, 11 months ago by themavo.