Error Can not find data record in database table external_fu

Hello,
I am getting the following error on system check. I tried reinstalling few times with no luck. Could you give me some pointers as to where the problem might me.
Many thanks in advance.

Here is the error message

An unexpected error happened: 23604497: Can not find data record in database table external_functions. | ERRORCODE: invalidrecord

I am using Moodle 3.1 Joomdle 1.0.5 and Joomla 3.5

Bijou

- Did you install Joomdle in Moodle?
- Have you added all the Joomdle functions?
- You may wish to read through the thread immediately before your posting - www.joomdle.com/forum/installation/11852...n-php7-or-moodle-3-1

You can turn on Moodle debugging for more information if none of the above is helpful.

Thanks Chris. I went through the thread without much luck,

System health check still gives

An unexpected error happened: 23604497: Can not find data record in database table external_functions. | DEBUG INFO: SELECT * FROM {external_functions} WHERE name IS NULL [array ( )] | ERRORCODE: invalidrecord

Bijou

That's quite strange, as it seems function name passed is NULL. I have never seen that message before, so I cannot give you more info from here.

Hi,

I am having the same issue.

An unexpected error happened: 23604497: Can not find data record in database table external_functions. | DEBUG INFO: SELECT * FROM {external_functions} WHERE name IS NULL [array ( )] | ERRORCODE: invalidrecord

Is there anything we can do to solve this error?


Thank you,

I don't know, as I cannot replicate it.

If you want, you can send access info to antonio at joomdle email address, and I will try talking a look, to see if there is a problem with Joomdle itself, although most probably this will be a problem with your server configuration.

Hi there!!!

How did it end up? I'm facing the same problem too:

An unexpected error happened: 23604497: Não foi encontrada nenhum dado gravado na tabela de banco de dados external_functions. | DEBUG INFO: SELECT * FROM {external_functions} WHERE name IS NULL [array ( )] | ERRORCODE: invalidrecord

Hi.
I also have the same error. "Ocurrió un error inesperado: 23604497: No se puede encontrar registro de datos en la tabla external_functions de la base de datos. | DEBUG INFO: SELECT * FROM {external_functions} WHERE name IS NULL [array ( )] | ERRORCODE: invalidrecord"
Thanks!!

If any of you want, you can send access info to antonio at joomdle email address, and I will try talking a look,

Hey Antonio,

I find out something that may help!!!

When I change the PHP's configuration to 5.6 the Web Service shows me this: An unexpected error happened: 23604497: Não foi encontrada nenhum dado gravado na tabela de banco de dados external_functions. | DEBUG INFO: SELECT * FROM {external_functions} WHERE name IS NULL [array ( )] | ERRORCODE: invalidrecord.

When I change the PHP's configuration to 5.4 the Web Service shows me this: Received empty response from Moodle.

If I change to PHP's configuration to 7 I get two red checks: Moodle to Joomla HTTP connectivity -> Moodle cannot connect to Joomla. And: Web Service -> An unexpected error happened: 23604497: Não foi encontrada nenhum dado gravado na tabela de banco de dados external_functions. | DEBUG INFO: SELECT * FROM {external_functions} WHERE name IS NULL [array ( )] | ERRORCODE: invalidrecord.

Any of them gives me the red check at the last one, any help???

Thanks,

Fabrício.