SQL syntax error in 3.0.7

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 — 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 — Best Practical Solutions – Trouble Ticketing. Free.