gastronimo

A bit more info here:

When I go to the Elementor (FREE) Tools window and click on a tab I cannot access like REPLACE URL, the Inspect Element>Console>JS gives me:

ReferenceError: originalEvent is not defined[Learn More] common.min.js:2:113221
ReferenceError: elementorAdmin is not defined[Learn More] beta-tester.min.js:2:24490
Use of Mutation Events is deprecated. Use MutationObserver instead. enable.js:93:3

@heateor

one more thing… is there any option for sharing as a .pdf file?

@heateor

I am now finding Parler and Telegram, thank you very much.

When will Gab, Signal, BitChute, Rumble and Patreon be added, so I can give my 5 star rating?

• This reply was modified 4 years ago by gastronimo.

OK, all is well…

Yes, and thanks, wildcards are SSL’d!

-G

Thanks Umesh…his was more helpful, but I still ran into errors:

MySQL said: Documentation
#1005 – Can’t create table ‘mydb_smush_dir_images’ (errno: -1) (Details…)

Since ghost tables (which are listed, but do not ‘exist’) were already present for each subsite, the only way around this was to create this smush table under a non-existant subsite ‘mydb_0_smush…’. Even then I was unable to copy OR rename ‘0’ table to the main site ‘mydb_smush…'(got same error).

So, I copied the ‘0’ table to another non-existant subsite ‘mydb_1_smush…’, then I was able to remame ‘1’ to the main site.

Next, using this procedure https://www.ads-software.com/support/topic/new-install-seeing-error/#post-10719066 , I had to manually delete each ghost table, then recreate the ‘0’ table by copying from one ‘good’ table, then rename it for each subsite. What a pain! Not blaming you though. Just sharing the process.

Hey @umeshsingla & @wpmudev-support9!

I ran into this same problem a short time ago, and this time could not resolve it by plugin deactivation/reactivation, or by simple table deletion and recreation- because I got this NEW error suing the same CREATE TABLE query:

Static analysis:
4 errors were found during analysis.
1. An alias was previously found. (near “:00’” at position 328)
2. A comma or a closing bracket was expected. (near “:00’” at position 328)
3. Unexpected beginning of statement. (near “id” at position 362)
4. Unrecognized statement type. (near “UNIQUE KEY” at position 368)

================================================
I copied exactly what you gave me above (using my real DB id), is there something else in this query that needs to be changed?

Thanks for looking at this again!

SIDE NOTE: I just realized that with IPGB network activated the table ip_geo_block_cache ‘appears’ to be present on all my subsites in phpMyAdmin– though actually selecting any (all except for one!) will return the error: #1146-table does not exist.

Looks like I will be manually deleting these ghost tables, then copying the only good table from the one subsite where it actually does exist to repopulate all the others…(Of course, if you do NOT have one good table example to work with, you will need to create a new one for a non-existing subsite like #0=’0’=_0_)

BONUS ROUND:
So after much trial and error, this is my only way successful way to Delete ghost DB tables for IPGB cache repop:

1) Select subsite# ghost table Structure ICON (not table name/link!) >>ignore errors
1a) go to Operations>> from the bottom of window, not the top- Delete the table(DROP) >> Confirm – OK >> you will see ‘# unknown table’ popup
2) Switch to or Select (good) table from Recents (i.e.: wp_8_ip_geo_block_cache)
2a) go to Operations>> Copy table to subsite ‘0’ = wp_0_ip_geo_block_cache
3) Switch to or Select – wp_0_ip_geo_block_cache
3a) RENAME table from ‘0’ to desired subsite# (i.e.: wp_4_ip_geo_block_cache)

REPEAT the above for each ghost table entry ??
then Recheck debug.log for errors

Hola @tokkonopapa!

Just wanted to close this thread by reporting that I never found an online solution for the DB error, BUT I was able to successfully create a similarly named table (wp1_ip_geo_block_cache), the RENAME it to my main site (wp_ip_geo_block_cache), and voila! Seems to hold up fine.

Thanks for all.

OK, that info is very useful, although not so much in my case, just because the table in question does not show up under structure, and is only listed on the file structure menu. However, as one link mentioned, I do have an upper case letter in part of the DB name!

As I already exported the plugin settings, I guess I will try removing every trace of IPGB manually then see what happens.

Thanks again

You know, @tokkonopapa,

I’ve said something similar before, and it certainly bears mentioning again, that your dedication to your plugin and user support of it is outstanding, if not second to none that I have seen on www.ads-software.com.

I admire and thank you for that.

Having said that, I’ve had some unfortunate experiences dealing with tables that are not supposed to exist but do. In this particular case, I was able to somehow delete one table anyway, but on re-creation I am presented with this error:

#1005 – Can’t create table ‘my_prefix_ip_geo_block_cache’ (errno: -1)

Maybe you have seen this before, or can tell we how to proceed next?

Gracias!

so far, when I enter (using my real DB ID)

SQL query:

CREATE TABLE my_prefix_ip_geo_block_cache(
No BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
time INT(10) UNSIGNED NOT NULL DEFAULT 0,
hook VARCHAR(8) NOT NULL,
ip VARBINARY(96) UNIQUE NOT NULL,
asn VARCHAR(8) NULL,
code VARCHAR(2) NOT NULL DEFAULT ‘ZZ’,
auth INT(10) UNSIGNED NOT NULL DEFAULT 0,
fail INT(10) UNSIGNED NOT NULL DEFAULT 0,
call INT(10) UNSIGNED NOT NULL DEFAULT 0,
last INT(10) UNSIGNED NOT NULL DEFAULT 0,
view INT(10) UNSIGNED NOT NULL DEFAULT 0,
host VARBINARY(512) NULL,
PRIMARY KEY(No)
) CHARACTER SET utf8

I only get:

ySQL said: Documentation
#1146 – Table ‘my_prefix_ip_geo_block_cache’ doesn’t exist

I will try again tomorrow and post update…

Hi @tokkonopapa!!

Look, I have almost the same error as OP after reactivation:

IP Geo Block: /home/myacct/public_html/wp-content/plugins/ip-geo-block/classes/class-ip-geo-block-logs.php (893) Table ‘myacct_mydbprefix.mydb_ip_geo_block_cache’ doesn’t exist
IP Geo Block: /home/myacct/public_html/wp-content/plugins/ip-geo-block/classes/class-ip-geo-block-logs.php (938) Table ‘myacct_mydbprefix.mydb_ip_geo_block_cache’ doesn’t exist

I have gone through a number of steps with no relief.

Please let me know if you prefer I start my own topic, or continue here.

Thanks

To confirm, I have upgraded to the most recent version of both, and yes I am SuperAdmin, and I no longer have the error, so THANK YOU. SUPER!

OK, I got it worked out finally…sorry I should have started my own thread at first, but deeper investigation showed there was already a ghost table- that the db listed as there, but also said it wasnt. So it would not let me create new table…
After I could finally drop the ghost table, in whatever subdomain was giving me the error/problem, then I was able to create it anew.

Yippeee, SMUSH MULTiSITE ACTIVATED!

It would seem that the failure to finish loading the page or finish saving edits in the Group Type admin window creates a PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 65536 bytes) in /home/mysite/public_html/wp-content/plugins/buddypress/bp-groups/classes/class-bp-groups-template.php on line 19