Hello,
I’m seeing these intermittent warning messages in my /var/log/messages
on RedHat 9.
This is running RT 3.0.7 using Apache 1.3.29, MySQL 4.0.17.
Dec 29 17:29:04 it-linux1 RT: DBD::mysql::st execute failed: 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 ‘NULL’ at line 1
at /opt/i386-linux/installed/perl-5.8.2/lib/site_perl/5.8.2/
DBIx/SearchBuilder/Handle.pm line 410.
(/export/home2/apache/intranet_html/rt-3.0.7/lib/RT.pm:247)
Best,
Blair
Blair Zajac blair@orcaware.com
Plots of your system’s performance - Orca Home Page - OrcaWare Technologies
Hello,
I’m seeing these intermittent warning messages in my /var/log/messages
on RedHat 9.
What DBIx::SearchBuilder? And can you peek in your mysql error log to
see if it’s the “Load an empty user” issue or something else?
This is running RT 3.0.7 using Apache 1.3.29, MySQL 4.0.17.
Dec 29 17:29:04 it-linux1 RT: DBD::mysql::st execute failed: 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 ‘NULL’ at line 1
at /opt/i386-linux/installed/perl-5.8.2/lib/site_perl/5.8.2/
DBIx/SearchBuilder/Handle.pm line 410.
(/export/home2/apache/intranet_html/rt-3.0.7/lib/RT.pm:247)
Best,
Blair
–
Blair Zajac blair@orcaware.com
Plots of your system’s performance - Orca Home Page - OrcaWare Technologies
rt-users mailing list
rt-users@lists.fsck.com
The rt-users Archives
Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.
Jesse Vincent wrote:
Hello,
I’m seeing these intermittent warning messages in my /var/log/messages
on RedHat 9.
What DBIx::SearchBuilder? And can you peek in your mysql error log to
see if it’s the “Load an empty user” issue or something else?
It’s 0.95 of DBIx::SearchBuilder. I’ve got all the latest CPAN packages
in my Perl install, using Perl 5.8.2.
The only error log I could find with MySQL’s RPMs is in
/var/lib/mysql/HOSTNAME.err
which just contains this
031223 17:14:16 mysqld ended
031223 17:14:16 mysqld started
031223 17:14:16 InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: ‘4.0.17-standard’ socket: ‘/var/lib/mysql/mysql.sock’ port: 0
031223 17:14:24 /usr/sbin/mysqld: Normal shutdown
031223 17:14:24 InnoDB: Starting shutdown…
031223 17:14:26 InnoDB: Shutdown completed
031223 17:14:26 /usr/sbin/mysqld: Shutdown Complete
031223 17:14:26 mysqld ended
031223 17:14:32 mysqld started
031223 17:14:32 InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: ‘4.0.17-standard’ socket: ‘/var/lib/mysql/mysql.sock’ port: 0
Is this where error messages would show up?
The /etc/rc.d/init.d/mysql runs this:
$bindir/mysqld_safe --datadir=$datadir --pid-file=$pid_file >/dev/null 2>&1 &
Would redirecting these errors to /dev/null lose the errors?
Best,
Blair
Blair Zajac blair@orcaware.com
Plots of your system’s performance - Orca Home Page - OrcaWare Technologies
Jesse Vincent wrote:
Hello,
I’m seeing these intermittent warning messages in my /var/log/messages
on RedHat 9.
What DBIx::SearchBuilder? And can you peek in your mysql error log to
see if it’s the “Load an empty user” issue or something else?
It’s 0.95 of DBIx::SearchBuilder. I’ve got all the latest CPAN packages
in my Perl install, using Perl 5.8.2.
It turns out that this is the same problem with trying to Load a user
whose name is “RT::CurrentUser=0x…”. DBIx::SearchBuilder just fails
more obviously when someone tries to do something dangerous.
lib/RT/Interface/Web.pm. sub loc. (Line 216 in 3.0.8rc1)
change “RT::SystemUser” to “RT::SystemUser->Name”
That will fix it.
This fix will be in 3.0.8
Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.