| View previous topic :: View next topic |
| Author |
Message |
polococta
Joined: 31 May 2009 Posts: 13
|
Posted: Aug 28, 2010 3:52 am Post subject: Software Error Problem |
|
|
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? |
|
| Back to top |
|
 |
mrperl
Joined: 06 Mar 2010 Posts: 65
|
Posted: Aug 28, 2010 6:14 pm Post subject: 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 |
|
| Back to top |
|
 |
polococta
Joined: 31 May 2009 Posts: 13
|
Posted: Aug 31, 2010 11:36 pm Post subject: |
|
|
| Thanks for your help. |
|
| Back to top |
|
 |
|