XFileSharing Pro - Software Error Problem

Posts: 13
Joined: May 31, 2009 3:13 pm

Software Error Problem

#1 Postby polococta » Aug 28, 2010 3:52 am


Recently added new file server and I get instead of the file this message :

Software error:

Can't execute select:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at Modules/DataBase.pm line 59.

Any pointers on how to fix this?

Posts: 65
Joined: Mar 06, 2010 11:40 am

Re: Software Error Problem

#2 Postby mrperl » Aug 28, 2010 6:14 pm


If you did an XFS Pro upgrade, ensure you followed all the steps.

Then ensure you configured your fileserver correctly in the database.

If there's still a problem, enable DBI_TRACE.

$ perldoc DBI

The DBI_TRACE environment variable specifies the global default trace settings for the DBI at startup. Can also be used to direct trace output to a file.

# export DBI_TRACE="1=/tmp/dbitrace.log"
# service httpd restart

or you can make a backup of Database.pm, and print the second shift value of SelectOne() to a file, as that is the SQL statement.


Posts: 13
Joined: May 31, 2009 3:13 pm

#3 Postby polococta » Aug 31, 2010 11:36 pm

Thanks for your help.

Return to “XFileSharing Pro”