Cannot import table from this site

Resolved snezhko
(@snezhko)

10 years, 4 months ago

Hi! After last Tablepress update, I cannot import table from here https://api.privatbank.ua/exchangerate.html
especially this link
https://api.privatbank.ua/p24api/pubinfo?exchange&json&coursid=11

Can you investigate this issue, please!

Thank you!

https://wordpress.org/plugins/tablepress/

Viewing 10 replies - 16 through 25 (of 25 total)

← 1 2

daol9999
(@daol9999)

10 years, 4 months ago

Hi Tobias,

I’ve just recehcked and the manual import has worked. It was the date and time under the last auto import that I was looking at.

However the issue is now that the original CRON job is still running but has not succeeded since 29th Jan. It was working perfectly. So something has changed with the latest version of the plugin.

I have set you up with access to investigate. Let me know your email address and I can let you have the details.

Thanks,
David

Plugin Author Tobias Bäthge
(@tobiasbg)

10 years, 4 months ago

Hi David,

no, the latest version does not affect this. More likely, there’s something happening on the server now, like a memory limit that is being reached.
Can you therefore please try again after increasing the value of the WP_MEMORY_LIMIT constant to e.g. 256M in the wp-config.php file on your server, by following the instructions from http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP ?
Also, please check if you can find something in the server’s error log file (you webhost might have to give them to you).

An admin account will not yet help, as we’ll first have to find out more about this.

Regards,
Tobias

daol9999
(@daol9999)

10 years, 3 months ago

Hi Tobias,

I seem to be experiencing the same issue with the TablePress auto update extension as before. The fix last time was adding ablepress_table_auto_import_hook as CRON job top the scheduled CRON job plugin in play on the site.

Its been reported to me that the non updating issue has occurred again. This time I’ve added the CXRON job again to the scheduler plugin as it seemed to have lost the previous setting.

It has not worked so I referred the issue to my hosting company who have come back with the following information.

Please advise.

Thanks
David

———————————————————————

David, I have run the CronJob manually and there is no output.

In this case I would suggest you to contact with your plugins developer to review it. The strace of the process can be accessed at http://www.stanwayvillafc.co.uk/strace.txt

If there is anything that we can help with on server side, please do not hesitate to get back to us. We will be more than happy to assist with anything within our reach.

Plugin Author Tobias Bäthge
(@tobiasbg)

10 years, 3 months ago

Hi,

I’m really sorry that you are again running into such problems 🙁
Unfortunately, I’m pretty much out of ideas here :-/
I can only suggest that you play around with those cron jobs, or maybe increasing the memory limit some more.
Other than that, directly debugging the code would be necessary, in order to find out if there are maybe helpful error messages.
You could maybe also try checking if all configured auto-imports work if done manually.

Regards,
Tobias

hannibal0504
(@hannibal0504)

10 years, 3 months ago

Hello Tobias, also have problems with the automatic import. Suddenly, on a site without modifying plugins, I just updated the first of three tables to import. None of the three refreshes Last Auto Import column on any of the options Perform Auto Update. However, in the option list of tables, if listed the date of last change, in the first table.
According to my tests, it is only importing the designated table or the first if they are several.
Thanks!
Anibal

Plugin Author Tobias Bäthge
(@tobiasbg)

10 years, 3 months ago

Hi,

unfortunately, I can also only suggest the same ideas as above here.

Please check for all tables if the manual import works for the configured source and increase the PHP Memory Limit.

Regards,
Tobias

daol9999
(@daol9999)

10 years, 3 months ago

Hi Tobias,

Unfortunately the issue with the auto import is still persistent. These are the recent communications through the hosting company (SiteGround).

Please advise further,
David

———————————————————————–

Avatar
You

Posted On 18 Mar, 2016 11:10 CDT

Hi,

Unfortunately the plugin developer does not know why this has suddenly occurred again. I’ve pasted the message thread with him below. Please can this be escalated / investigated.

Thanks,
David

—————————————————————————————————————————-

daol9999
Member
Posted 2 days ago #

Hi Tobias,

I seem to be experiencing the same issue with the TablePress auto update extension as before. The fix last time was adding ablepress_table_auto_import_hook as CRON job top the scheduled CRON job plugin in play on the site.

Its been reported to me that the non updating issue has occurred again. This time I’ve added the CXRON job again to the scheduler plugin as it seemed to have lost the previous setting.

It has not worked so I referred the issue to my hosting company who have come back with the following information.

Please advise.

Thanks
David

———————————————————————

David, I have run the CronJob manually and there is no output.

In this case I would suggest you to contact with your plugins developer to review it. The strace of the process can be accessed at http://www.stanwayvillafc.co.uk/strace.txt

If there is anything that we can help with on server side, please do not hesitate to get back to us. We will be more than happy to assist with anything within our reach.

TobiasBg
Member
Plugin Author
Posted 1 day ago #

Hi,

I’m really sorry that you are again running into such problems 🙁
Unfortunately, I’m pretty much out of ideas here :-/
I can only suggest that you play around with those cron jobs, or maybe increasing the memory limit some more.
Other than that, directly debugging the code would be necessary, in order to find out if there are maybe helpful error messages.
You could maybe also try checking if all configured auto-imports work if done manually.

Regards,
Tobias

hannibal0504
Member
Posted 2 hours ago #

Hello Tobias, also have problems with the automatic import. Suddenly, on a site without modifying plugins, I just updated the first of three tables to import. None of the three refreshes Last Auto Import column on any of the options Perform Auto Update. However, in the option list of tables, if listed the date of last change, in the first table.
According to my tests, it is only importing the designated table or the first if they are several.
Thanks!
Anibal

TobiasBg
Member
Plugin Author
Posted 1 hour ago #

Hi,

unfortunately, I can also only suggest the same ideas as above here.

Please check for all tables if the manual import works for the configured source and increase the PHP Memory Limit.

Regards,
Tobias
Avatar
Zdravko Zamfirov

Support Guru
Posts: 9973
Posted On 18 Mar, 2016 11:52 CDT

Hello David,

I have brought this case to the attention of our Supervisors and you will be contacted with more information as soon as possible.

This ticket will be updated with any further information regarding this issue.

Thank you for your patience.

Best Regards,
Zdravko Zamfirov
Technical Support Team
Avatar
Kiril Ivanov

Tech Support of 2011
Posts: 117462
Posted On 18 Mar, 2016 17:39 CDT

Hello,

Thank you for your patience!

We have reviewed your case in details. I have noticed that the cron job:

Code:
php /home/ctests32/public_html/stanwayvillafc.co.uk/wp-content/plugins/wp-cron-control/wp-cron-control.php http://www.stanwayvillafc.co.uk a14b61378d8e6d15a920c5f9b3a9bfa2

is using the “WP Cron Control” plugin, but this plugin was not active. I have activated it for you.

Stracing the specified cron shows that it actually calls the other type of cron available for the plugin:

Code:
wget -q “http://www.stanwayvillafc.co.uk/wp-cron.php?doing_wp_cron&a14b61378d8e6d15a920c5f9b3a9bfa2”

I have then straced the execution of the specified wget command. The command is not returning any error messages on our end.

If you still continue to experience any problems, we would recommend you to further consult with the developer of the plugins that you are using, since there is not much we can do when the problem is caused by a plugin problem.

Best Regards,
Kiril I.
Technical Support Supervisor

Avatar
You

Posted On 20 Mar, 2016 13:45 CDT

Hi,

Thanks for looking at this.

Unfortunately the issue still persists.

Also I used to receive notification messages when the CRON job ran on the server. These have now stopped.

I have manually run the table imports for the tiem being.

Please advise further.

Thanks,
David

Plugin Author Tobias Bäthge
(@tobiasbg)

10 years, 3 months ago

Hi David,

this indicate that the cron jobs by themselves are working.
Other than that, directly debugging the code would be necessary, in order to find out if there are maybe helpful error messages.
You could maybe also try checking if all configured auto-imports work if done manually.

Regards,
Tobias

daol9999
(@daol9999)

10 years, 3 months ago

Hi Tobias,

Thanks for your reply on this…

I’ve undertaken manual imports which have all worked.

Where would I start with debugging the code?

Thanks,
David
Plugin Author Tobias Bäthge
(@tobiasbg)

10 years, 3 months ago
Hi David,

the best way would probably be to modify the code of the Extension in the handler functions for the cron job.
As techniques like var_dump() won’t really work, the best way is to store the output of such functions (to inspect the content of variables) in a file or the debug log, e.g. with something like
```
$error_content = var_export( $variable, true );
error_log( $error_content, 1, 'your-email@example.com' );
```
where $variable is the variable that you want to inspect.
Then, you could trigger the cron job using one of the cron plugins, to then receive an email with the content of the variable during the execution of the cron job handler function.

Regards,
Tobias