Geeklog Forums

An SQL error has occurred. Please see error.log for details.
 

Mon 02 Jan 2006 02:14:50 CST - 1064: 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 'AND  (tid = 'Advert' OR tid = 'INET_KENO' OR tid = 'entertainme. SQL in question: SELECT gl_stories.*, gl_users.username, UNIX_TIMESTAMP(date) AS unixdate  FROM gl_stories LEFT JOIN gl_users ON gl_stories.uid=gl_users.uid WHERE 1  AND AND  (tid = 'Advert' OR tid = 'INET_KENO' OR tid = 'entertainment' OR tid = 'KenoSchools' OR tid = 'CityHall' OR tid = 'Religion' OR tid = 'RealEstate' OR tid = 'HACKER' OR tid = 'HISTORY' OR tid = 'Help' OR tid = 'humor' OR tid = 'LAW' OR tid = 'JOBS' OR tid = 'YourHealth' OR tid = 'OP/ED' OR tid = 'KENOMONEY' OR tid = 'ELECTION/2004' OR tid = 'US-CIVILRIGHTS' OR tid = 'Politics' OR tid = 'US-Politics' OR tid = 'US-Crime' OR tid = 'US-Law' OR tid = 'Train' OR tid = 'Homeland' OR tid = 'WI_POLITICS' OR tid = 'WI_NEWS' OR tid = 'WI_LAW' OR tid = 'WI_EDITORIAL' OR tid = 'US_GOVT' OR tid = 'WORLD_NEWS' OR tid = 'US_WAR' OR tid = 'USNEWS' OR tid = 'KENOARTS' OR tid = 'USECON' OR tid = 'FAMILYCONTENT' OR tid = 'ArtsandLit' OR tid = 'LegalNotice' OR tid = 'KENOSPORTS' OR tid = 'ARCHIVE' OR tid = 'KenoCrime' OR tid = 'KenoParents' OR tid = 'technology' OR tid = 'CityDesk' OR tid = 'MOTHERHOOD' OR tid = 'OUTDOORS' OR tid = 'Holiday' OR tid = 'WISC' OR tid = 'OP-ED')  ORDER BY unixdate desc LIMIT 0,50;

 

01/02/06 10:36:07 - 1366: Incorrect integer value: '' for column 'sortnum' at row 1. SQL in question: REPLACE INTO gl_topics (tid, topic, imageurl, sortnum, limitnews, is_default, archive_flag, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('test', 'test', '/images/icons/','','',0,'0',2,6,3,2,2,2)
01/02/06 10:36:46 - 1366: Incorrect integer value: '' for column 'statuscode' at row 1. SQL in question: REPLACE INTO gl_stories (sid,uid,tid,title,introtext,bodytext,hits,date,comments,related,featured,commentcode,trackbackcode,statuscode,expire,postmode,frontpage,draft_flag,numemails,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,show_topic_icon,in_transit) VALUES ('20060102103630802',2,'GeekLog','test','test','',0,FROM_UNIXTIME(1136216190),'0','',0,'0','0','',FROM_UNIXTIME(943938030),'plaintext','1',0,0,2,3,3,2,2,2,1,1)
01/02/06 10:37:41 - 1366: Incorrect integer value: '' for column 'sp_nf' at row 1. SQL in question: REPLACE INTO gl_staticpage (sp_id,sp_uid,sp_title,sp_content,sp_date,sp_hits,sp_format,sp_onmenu,sp_label,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_php,sp_nf,sp_centerblock,sp_tid,sp_where,sp_inblock) VALUES ('20060102103731337',2,'test','test','2006-01-02 10:37:31',0,'allblocks',0,'',2,14,3,2,2,2,'0','',0,'none',1,'1')


 

Incorrect integer value: ' '
 

/* This is a list of HTML tags that users are allowed to use in their posts.
 * Each tag can have a list of allowed attributes (see 'a' for an example).
 * Any attributes not listed will be filtered, i.e. removed.
 */

$_CONF['user_html'] = array (
    'p'      => array('style' => 1, 'align' => 1),
    'span'   => array('style' => 1, 'color' => 1),
    'font'   => array('style' => 1, 'color' => 1),
    'div'    => array('style' => 1, 'align' => 1),
    'strong' => array(),
    'b'      => array(),
    'i'      => array(),
    'a'      => array('href' => 1, 'title' => 1),
    'em'     => array(),
    'br'     => array(),
    'tt'     => array(),
    'hr'     => array(),
    'li'     => array(),
    'ol'     => array(),
    'ul'     => array(),
    'code'   => array(),
    'pre'    => array()
);

/* This is a list of HTML tags that Admins (site admin and story admins) can
 * use in their posts. It will be merged with the above list of user-allowable
 * tags ($_CONF['user_html']). You can also add tags that have already been
 * listed for the user-allowed HTML, so as to allow admins to use more
 * attributes (see 'p' for an example).
 */
$_CONF['admin_html'] = array (
    'p'     => array('class' => 1, 'id' => 1, 'align' => 1),
    'div'   => array('class' => 1, 'id' => 1),
    'font'  => array('face' => 1, 'size' => 1, 'style' => 1, 'color' =>1),
    'span'  => array('class' => 1, 'id' => 1),
        'img'   => array('class' => 1, 'id' => 1, 'src' => 1, 'hspace' => 1, 'vspace' => 1, 'type' => 1, 'border' => 1, 'width' => 1, 'height' => 1, 'align' => 1),
    'form'  => array('class' => 1, 'id' => 1, 'action' => 1),
    'table' => array('class' => 1, 'id' => 1, 'width' => 1, 'border' => 1, 'background' => 1, 'bgcolor' => 1, 'cellspacing' => 1, 'cellpadding' => 1),
    'tr'    => array('class' => 1, 'id' => 1, 'align' => 1, 'valign' => 1, 'background' => 1, 'bgcolor' => 1),
    'th'    => array('class' => 1, 'id' => 1, 'align' => 1, 'valign' => 1, 'colspan'    => 1, 'rowspan' => 1),
    'td'    => array('class' => 1, 'id' => 1, 'align' => 1, 'valign' => 1, 'background' => 1, 'bgcolor' => 1, 'colspan' => 1, 'rowspan' => 1)
);

/* Optional HTML Tags that will be enabled if advanced editor is enabled
 * Posible to add tags to the allowable general USER $_CONF['user_html'] as well
*/
if ($_CONF['advanced_editor']) {
    $_CONF['admin_html']['img']  = array('src' => 1, 'width' => 1, 'height' => 1);
    $_CONF['admin_html']['font'] = array('face' => 1, 'size' => 1, 'color' =>1);
    $_CONF['user_html']['img']  = array('src' => 1, 'width' => 1, 'height' => 1);
    $_CONF['user_html']['font'] = array('face' => 1, 'size' => 1, 'color' =>1);
 

REPLACE INTO gl_blocks (bid,name,title,help,type,blockorder,content,tid,rdfurl,rdfupdated,rdflimit,phpblockfn, onleft,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,is_enabled)
VALUES (,'refer','Refer Folks to the Daily Kenoshan!','','phpblock','40','','homeonly','','','0',' phpblock_referal',1,2,4,3,2,2,2,1)
 

REPLACE INTO gl_blocks (name,title,help ...etc... VALUES ('refer','Refer Folks ... etc ...