steelmaiden

Unfortunately I turned off all plugins and themes and the problem is still there.

When I google for “add for ctr” or “ctr_category_click” which is part of the corrupted category url (https://mydomain.com/?taxonomy=ctr_category_click&term=fizika), I get no results which is kind of strange.

• This reply was modified 1 year, 9 months ago by steelmaiden.

I tried to search and replace through plugins, also directly from phpmyadmin and also via wpcli command. Nothing helps. I even downloaded the whole database, opened it in notepad++ and search for the old domain but its not there.

That is because VC either stores those urls somewhere else, like in hardcore files on the server, or because the urls are encrypted so i cant find them in the database.

So search and replace plugins will not work unfortunately.

I will remember this for in the future but in my case i migrated almost a year ago and I didn’t even realize that some links were not replaced, until now when the old domain has expired and i noticed a completely broken website.

There must be something that I can do now to fix this?

How come you dont know since you are a plugin author? Is it server related? ??

When i eliminate it, another one pops up… i already removed over 200 rows like this. Also they are not duplicates in the table i am trying to import, it just gives such an error for some reason.

I am not sure if this is the issue, but option_id in my wp_options tables start from number 3 and not number 1.

Screenshot: https://community.easyengine.io/uploads/default/original/2X/9/97948fa96199ce5dad3408bd78c80776861ce757.jpeg

Ok here is update with semi good news.

I have re-imported the tables for my child sites and they work now.

However, when trying to re-import my wp_options table via phpmyadmin for my main site i keep getting erros like this:

**SQL query:**

`
—
— Indexes for dumped tables
—

—
— Indexes for table wp_options
—
ALTER TABLE wp_options
ADD PRIMARY KEY (option_id),
ADD UNIQUE KEY option_name (option_name)
`

**MySQL said:**

#1062 - Duplicate entry '13770809' for key 'PRIMARY'

I tried removing the rows with the 13770809 entry, but a new similar error comes up every time i reimport. How do i fix this, how do i force the table to import?

• This reply was modified 5 years, 9 months ago by steelmaiden.

Another error when i try to upload a media file to those broken sites:

03988309.gif
Could not insert post into the database

Works just fine on sites where i can add new posts.

No errors, except that the favicon.ico is missing.

Ah yeah it is a docker setup, so i got confused. Those paths exist virtually, if you know what i mean. So this is not the problem after all, still lookint to find the real issue in that case ??

OK so i have done the following:

I removed ALL plugins from the /wp-content/plugins folder
I removed ALL themes except the default one from the /wp-content/themes folder

I went to add a new post and here is the result:

View post on imgur.com

I checked profile settings and an option to disable the visual editor is not enabled.

Ok you are right about that… it cant report an error about the file if it doesnt exist lol.

• This reply was modified 5 years, 9 months ago by steelmaiden.
• This reply was modified 5 years, 9 months ago by steelmaiden.
• This reply was modified 5 years, 9 months ago by steelmaiden.

Yeah me too… installed a fresh new wordpress multisite on a new server, imported the database through phpmyadmin and copied the wp-content folder.

The old server had a php5, the new one has php7. The old server was MySQL and the new one uses Mariadb. Not sure if you know about easyengine.io but on the old server i had a v3 version and on the new version i have the v4 version.

I would think that the problem is with the server setup, but i am not sure why would 10 of my child sites work and 3 child sites + the main site would not work.

But i think this error is the key:

View post on imgur.com

It clearly shows that the WP is trying to find files in a non-existent path.

REST API availability: The REST API is available.

I restored again, but it seems like that table have the same situation on the old server, but in there adding new posts work just fine.

Also… the weird thing is that i can EDIT the existing posts without problem, and i get this error only when i want to ADD a new post.

Here are the errors that i receive:

View post on imgur.com

/var/www/htdocs/wp-includes/ – this folder does not exist!

the whole /var/www/htdocs/ path has changed since i moved the server. It is now a different path. However i cant find this path defined anywhere in the database and the wp files were freshly installed so i dont know where i fix this.

And i have just noticed this message when i enter wp_options table from phpmyadmin:
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. — I THINK THIS IS THE PROBLEM!

• This reply was modified 5 years, 9 months ago by steelmaiden.
• This reply was modified 5 years, 9 months ago by steelmaiden.
• This reply was modified 5 years, 9 months ago by steelmaiden.