[Gelöst] WP could not create a database table for address cache.

[Author]

Artikel

[Daniel]

Hello,

this issue is still present in several of my sites, in multisite subsites as well as in single installations.

WP could not create a database table for address cache.

All installation run on latest toolset scripts, latest WordPress and PHP 7.3 and 7.2.

Running the SQL-scripts manually as mentioned in other threads here, is no solution for me.

Is it possible, that this happens when I use diiferent database prefix?

Is there a fix in the queue?

Best wishes

Daniel

[Shane]

Hi Daniel,

Thank you for getting in touch.

Based on your screenshot it could be that wordpress is having issues modifying the database.

You mentioned that the database prefix is different. Did you change this in the database itself?

What is the new prefix now?

Please let me know.

Thanks,
Shane

[Daniel]

Hello Shane,

Other Plugins have no Problems creating Tables. This is a single installation and you can see the Prefix in the Screenshot.

I have the same Problem in other Installations and different Server environments. The biggest Problem is my Multisite.

I never changed the prefix manually, ist was Part of the Installation process.

Best, Daniel

[Shane]

Hi Daniel,

Thanks for the explanation.

You mentioned running the sql script to create the table manually is no solution for you.

Could you let me know the reason? Was it that you ran the script and it still didn't work ?

If so would you mind allowing me to have admin access to the website so that I can create a copy to test here locally?

The private fields have been enabled.

Thanks,
Shane

[Daniel]

Hello Shane,

I have a second account where I run a multisite for educational purposes for older volunteers (unser-quartier.de / daniel.hoffmann@kda.de). These people see the warning message and try to fix it, but get the next error. They are very confused and I don't want htem give access to mysql.

But I think, that this great software should handle websites with databse-prefixes, as this is a security advice on lots of pages?

Best, Daniel

[Shane]

Hi Daniel,

It does handle database prefixes, however in your case i'm not sure why its not working.

This is why I need to get a copy of your site to perform a thorough debug to be able to see why its not working or if its even replicable if the site is moved to a different server environment.

The private fields have been enabled for your next response.

Thanks,
Shane

[Christian Cox]

Hello, Shane is on holiday today and will return tomorrow to continue assisting you.

[Daniel]

ok, looking forward to it.

[Shane]

Hi Daniel,

I installed the duplicator plugin to create a copy of your site to test here locally but when I checked again I see that the plugin has been removed?

It was taking some time to create the backup so I left it running.

Without having a copy I cannot effectively tell where the issue is stemming from whether it is from the site or from the database.

Could you let me know what happened?

Thanks,
Shane

[Daniel]

Sorry Shane, this was my vault. During my weekly updates today, I saw the error of the outdated licencekey of duplictaor and thought this was an old one of mine. Than I deleted it. Within the next days, I won't update or delete plugins. Sorry again.

[Shane]

Hi Daniel,

I'm having some issue creating the backup because of the large file size, but i will let you know as soon as im able to get the copy.

[Shane]

Hi Daniel,

In order to resolve this you will definitely need to run an sql query. Particularly this one.

CREATE TABLE wpbebev_toolset_maps_address_cache (
			address_passed varchar(190) NOT NULL, 
			address varchar(255) NOT NULL, 
			point point NOT NULL,
			PRIMARY KEY  (address_passed)
		) 

The reason is because of your database collation. Once you have done this you will then need to convert the site to the new cache and it should now start working.

I tested this on the copy of your site that I created and it works and the cache was made.

Please let me know if this helps.

Thanks,
Shane

[Daniel]

Hello Shane,

I did it like you adviced me, but now there are only five itmes on my page and not 271 like before?

The system told me not to worry, it could not convert all, but the API will do the rest?
versteckter Link

But the database table is empty. What must the collation be?

Best, Daniel

[Daniel]

even in the cache in the options tab there are no items:

[Shane]

Hi Daniel,

Its good that the database table has been created, however it seems to be still throwing an error.

Is it possible to send me a copy of the server's php log so that I can see if the error has been logged here?

On my end the cache has been created. See Screenshot

This means nothing is wrong with the site per say. Just its having issues with the database on your end.

I should also mention that on my test copy of your site i've disabled every plugin except the toolset ones, so you can try this as well to see if the cache data loads fine.

Thanks,
Shane