Software Error Problem

[polococta]

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?

[mrperl]

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

[polococta]

Thanks for your help.