INSERT INTO default_en_activitylog error when importing with task=get

Q: When I attempt to trigger an import with task=get, I am receiving the following error very soon after:

INSERT INT0 default_en_activitylog (activitylog_log_date, userdb_id, activitylog_action, activitylog_ip_address) VALUES ('2008-02-07 15:03:32', '15', 'Successfully received /residential_data.zip', '123.0.190.13')

A: Your mySQL wait_timeout has probably been changed from its default value, and is breaking the persistent database connection for PHP.

To verify this, issue the following SQL:

SHOW VARIABLES;

Next, look for the variable named:  wait_timeout. mySQL's default wait_timeout is 28800 seconds, and if this has been reduced to a smaller value,  the DB connection can be closed before the add-on can complete its tasks. To repair, simply have your host or system administrator return the wait_timeout back to the default value.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

I get a Fatal Error when trying to access the Open-Realty admin after I uploaded IDXManager

After uploading IDXManager, if you get the following error it means that the files where...

Mysql Error 13 Can't get stat

Q. I am getting a mysql error 13, like the following error, what do i do?ERROR 13 (HY000): Can't...

Import table empty

Q. I get an error saying that the import table is empty when I try and import data.A. In the...

When I trigger the IDXManager's loader, I get a blank screen after a little while, and nothing seems to be imported.

Q: When I trigger the IDXManager's loader, I get a blank screen after a little while, and...

File not found error when importing data/photos

Q: I recently moved my site and everything was working great. Now, when I am attempting to...