Skip to content

Instantly share code, notes, and snippets.

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'en' in 'where clause'. The SQL statement executed was: SELECT *
FROM `lime_questions`
WHERE (sid=654311) AND (qid=1) AND (language=en)
CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g.gid' in 'where clause'. The SQL statement executed was: SELECT `qid`
FROM `lime_questions` `q`
WHERE g.gid=q.gid AND g.gid=1 AND q.parent_qid=0
GROUP BY `qid`
/Users/yaxar/MAMPSTACK/apache2/htdocs/limesurvey_yii/framework/db/CDbCommand.php(516)
504 return $result;
$query = 'SELECT qid FROM , {{questions}} q WHERE g.gid=q.gid AND g.gid=' . $gid . ' AND q.parent_qid=0 group by qid';
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g.gid' in 'where clause'. The SQL statement executed was: SELECT `qid`
FROM `lime_questions` `q`
WHERE g.gid=q.gid AND g.gid=1 AND q.parent_qid=0
GROUP BY `qid`
SELECT `qid`
FROM `lime_questions` `q`
WHERE g.gid=q.gid AND g.gid=1 AND q.parent_qid=0
GROUP BY `qid`
#!/usr/bin/env perl
use Mojolicious::Lite;
use EV;
use AnyEvent::IRC;
use AnyEvent::IRC::Client;
use DateTime;
use Config::Tiny;
# Join #mojo on irc.perl.org
my $irc = AnyEvent::IRC::Client->new;
my $configfile = 'config.conf';
#!/usr/bin/env perl
use Mojolicious::Lite;
use EV;
use AnyEvent::IRC::Client;
# Join #mojo on irc.perl.org
my $irc = AnyEvent::IRC::Client->new;
$irc->connect('irc.perl.org', 6667, {nick => "mojobot$$"});
$irc->send_srv(JOIN => '#test');
Can't load application "hl.pl": Can't locate EV.pm in @INC (@INC contains: /Users/yaxar/perl5/perlbrew/perls/perl-5.14.2/bin/../lib/5.14.2/darwin-2level /Users/yaxar/perl5/perlbrew/perls/perl-5.14.2/bin/../lib/5.14.2 /Users/yaxar/perl5/perlbrew/perls/perl-5.14.2/bin/../lib /Users/yaxar/perl5/perlbrew/perls/perl-5.14.2/bin/lib /Users/yaxar/perl5/perlbrew/perls/perl-5.14.2/lib/site_perl/5.14.2/darwin-2level /Users/yaxar/perl5/perlbrew/perls/perl-5.14.2/lib/site_perl/5.14.2 /Users/yaxar/perl5/perlbrew/perls/perl-5.14.2/lib/5.14.2/darwin-2level /Users/yaxar/perl5/perlbrew/perls/perl-5.14.2/lib/5.14.2 .) at hl.pl line 3.
BEGIN failed--compilation aborted at hl.pl line 3.
#include "EXTERN.h"
#include "perl.h"
#include "XSUB.h"
/* fix perl api breakage */
#undef signal
#undef sigaction
#include "schmorp.h"
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'efy9jhjpnphpxvr' in 'field list'. The SQL statement executed was: UPDATE lime_tokens_446798 SET token=efy9jhjpnphpxvr WHERE tid=102