Import table empty

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

A.
In the DB import tuning section of the ServerManager module right below where you set up your IDX server login and password information, try setting the LOCAL parameter to "yes" and re-try the import.

If changing the LOCAL parameter does not solve the problem, this usually means that mySQL FILE permissions have not been granted to your Open-Realty database user or mySQL did not have permission to import the raw .txt file for some other reason. Make sure that you have assigned your Open-Realty database user FILE privileges, typically this is something your hosting provider must set, unless you have a dedicated server or VPS. If you continue to receive this error check your mySQL error logs, they will contain more details on the problem.

Useful mySQL information regarding LOAD DATA INFILE and FILE permissions:

http://dev.mysql.com/doc/refman/4.1/en/privileges-provided.html
http://dev.mysql.com/doc/refman/4.1/en/load-data.html


  • 245 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...

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...

My IDXManager add-on documentation links to a blank page

Q: When I click on the IDXManager add-on's documentation link, all I see is a blank page. A: Your...