Hi
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?
XFileSharing Pro - Software Error Problem
Re: Software Error Problem
Hi.
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.
mrperl
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.
mrperl