Table Auto Update

Hi,

thanks for your post, and sorry for the trouble.

For auto-updating, you will indeed need that Extension. As the import source link, you should use the public Sharing to CSV URL from Google Sheets.
Unfortunately, it’s hard to tell why it only “jumps” to /admin-post.php. Can you maybe check the server error log file for hints?

Regards,
Tobias

Hi Tobias,

Yeah I tried that, I can’t see anything crazy, but hey, my knowledge of that is slim.

[29-Apr-2022 19:23:15 UTC] PHP Deprecated:  screen_icon is <strong>deprecated</strong> since version 3.8.0 with no alternative available. in /wp-includes/functions.php on line 5333
[29-Apr-2022 19:23:15 UTC] PHP Deprecated:  get_screen_icon is <strong>deprecated</strong> since version 3.8.0 with no alternative available. in /wp-includes/functions.php on line 5333
[29-Apr-2022 19:23:17 UTC] PHP Deprecated:  screen_icon is <strong>deprecated</strong> since version 3.8.0 with no alternative available. in /wp-includes/functions.php on line 5333
[29-Apr-2022 19:23:17 UTC] PHP Deprecated:  get_screen_icon is <strong>deprecated</strong> since version 3.8.0 with no alternative available. in /wp-includes/functions.php on line 5333
[29-Apr-2022 19:27:00 UTC] PHP Fatal error:  Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1785

Any idea?

Hi,

ok, that last line, talking about mysql_connect() is the problem here. Somehow WordPress (or another plugin) is calling this function, even though it does not exist (anymore).

Can you therefore please try again after temporarily deactivating all other plugins and after switching to a WordPress default theme like Twenty Twenty? That way, we can find what’s causing this.

Regards,
Tobias

Hi Tobias,

Yep I tried that too, yet still no luck. I have these active/deactive:

WP:
5.9.3

PHP:
7.4

Theme:
Twenty-Twenty-One

Plugins:
TablePress 1.14
TablePress Extension: Table Auto Update 1.3

I deactivated plugins:

Brizy
Brizy Pro
TablePress Extension: Turn off Output Caching

Hi,

ok, thanks for testing that. I can only assume that something in the server configuration is wrong then, as WordPress shouldn’t be calling that function – but probably is because some checks to prevent that are failing.
In particular, the PHP mysqli (note the i) is maybe not installed or not working. You might have to contact your web host company’s support team about this.

Regards,
Tobias

Hi Tobias,

I just checked my php and ‘mysqli’ wasn’t installed. So I checked it.

There was a conflict with ‘nd_mysqli’ so I turned this off.

It hasn’t changed anything on my websites and still hasn’t fixed the issue within the updater plugin.

?

Hi,

are you still getting that PHP error in the server error log file? I’m afraid that’s what needs to be fixed, but as there’s no code regarding this in TablePress or the Extension, I’m not sure what else I can do here ??

Regards,
Tobias

Hi Tobias,

It’s 100% an issue with my server. I’ve tested your plugin and my spreadsheet on another hosting company and everything worked perfectly.

Thanks for your support. Hopefully my hosting company can help.

Hi,

I really hope that they can find a solution ??

Best wishes,
Tobias

Hi Tobias,

I spoke with my hosting and they switched on a php that was causing the issue, but I’m still having problems saving the auto update feature.

They told me to send you this link and ask you if any PHP plugins that are missing or would be conflicting.

https://sundaywreckleague.nerdhousedesign.com/myphp.php

Also, my error log is coming up with these errors

[30-Apr-2022 15:01:52 UTC] PHP Fatal error:  Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1788
Stack trace:
#0 /wp-includes/wp-db.php(724): wpdb->db_connect()
#1 /wp-includes/load.php(561): wpdb->__construct('nerdhous_wreck', ')--3Bhpv14AS]!1...', 'nerdhous_wreck', 'localhost')
#2 /wp-settings.php(124): require_wp_db()
#3 /wp-config.php(98): require_once('/home/nerdhous/...')
#4 /wp-load.php(50): require_once('/home/nerdhous/...')
#5 /wp-blog-header.php(13): require_once('/home/nerdhous/...')
#6 /index.php(17): require('/home/nerdhous/...')
#7 {main} /wp-includes/wp-db.php on line 1788

Hi,

I really have no idea what’s going on here, as I’m not an expert in the PHP/mySQL internals. Neither TablePress nor the Extension are calling the mysql_connect() function, so something else must be triggering WordPress to (falsely) do that.
All Google results that I can find hint that it’s a PHP or database thing, with one common cause being the line

define('WP_USE_EXT_MYSQL', true);

in wp-config.php (which should then be removed). Can you maybe check that?

I’m really sorry that I don’t have better news here.

Regards,
Tobias

Hi Tobias,

What a pain. I’ve seen that in other forums too. I checked all my websites on the shared hosting and non include that line.

So, I just noticed I can save the URL in the updater section, as long as I remove the https:// from the front of the Google CSV URL.

It saves the setting perfectly, but obviously now is failing and giving this warning: ‘Failed @ 2022-05-02 18:50:46 A valid URL was not provided.’

Hi,

so the difference between working and not working is whether you include the https in the URL input field?! Things are getting super-strange now.
Then, my feeling would be that some sort of firewall or security software on the server play a role here. For example, such a software might be (falsely) thinking that a hacking attempt is going on (with script injection or something like that), and then modifies the request (e.g. by removing data) so that subsequent processing by WordPress fails (as it gets wrong/just partial data).

Regards,
Tobias

Well, thats what it took to fix everything. Seems my server had ‘ModSecurity’ switched on for the domain and that was causing the issue.

Everything is now working perfectly.

Thank you so much for brainstorming this issue with me. Your support has been outstanding!

Hi,

no problem, you are very welcome! ?? Good to hear that this helped!

Best wishes,
Tobias
?
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!