Bad HTTP Request

محروم.كوم · #1 03-26-2010, 02:10 AM

It appears you guys have some sort of front-end firewall/filtering in place for your web server that disallows SQL to be posted in a message body (probably some overly aggressive system that tries to stop SQL injection attacks). The problem is... well... you can't post certain stuff.

I'd love to give you an example, but the web server blocks it with a "Bad Request" error.

Code:
############
## Posts Source document IDs 0 - 1,000,000,000 (1B)
############
source postsrc : src
{
sql_query_pre = TRUNCATE TABLE digitalpoint_sphinx_delta
sql_query_range = SELECT MIN(postid), MAX(postid) FROM post
sql_query = \
SELECT postid AS doc_id, postid AS primaryid, 1 AS contenttypeid, post.threadid AS groupid, thread.forumid AS groupparentid, \
userid, thread.replycount, post.title, pagetext, post.visible, post.dateline, thread.prefixid \
FROM post \
LEFT JOIN thread ON(thread.threadid = post.threadid) \
WHERE postid BETWEEN $start AND $end;
sql_attr_uint = primaryid
sql_attr_uint = contenttypeid
sql_attr_uint = groupid
sql_attr_uint = groupparentid
sql_attr_uint = userid
sql_attr_uint = replycount
sql_attr_bool = visible
sql_attr_timestamp = dateline
sql_query_post =
}

source postdeltasrc : postsrc
{
sql_range_step = 100000
sql_query_pre =
sql_query_range = SELECT MIN(primaryid), MAX(primaryid) FROM digitalpoint_sphinx_delta WHERE contenttypeid=1

sql_query = \
SELECT digitalpoint_sphinx_delta.primaryid AS doc_id, digitalpoint_sphinx_delta.primaryid AS primaryid, 1 AS contenttypeid, post.threadid AS groupid, thread.forumid AS groupparentid, \
userid, thread.replycount, post.title, post.pagetext, post.visible, post.dateline, thread.prefixid \
FROM digitalpoint_sphinx_delta \
LEFT JOIN post ON(post.postid = digitalpoint_sphinx_delta.primaryid) \
LEFT JOIN thread ON(thread.threadid = post.threadid) \
WHERE contenttypeid = 1 AND \
primaryid BETWEEN $start AND $end;
sql_query_killlist = SELECT primaryid AS kill_id FROM digitalpoint_sphinx_delta WHERE contenttypeid = 1 AND delete_flag = 1;
}

############
## Threads Source document IDs 2,000,000,001 - 2,100,000,000 (100M)
############

source threadsrc : src
{
sql_query_pre =
sql_query_range = SELECT MIN(threadid), MAX(threadid) FROM thread
sql_query = \
SELECT (threadid + 2000000000) AS doc_id, threadid AS primaryid, 2 AS contenttypeid, forumid AS groupid, title, thread.visible, dateline, replycount, prefixid, \
postuserid AS userid, lastpost \
FROM thread \
WHERE threadid BETWEEN $start AND $end;
sql_attr_uint = primaryid
sql_attr_uint = contenttypeid
sql_attr_uint = groupid
sql_attr_uint = userid
sql_attr_timestamp = lastpost
sql_attr_bool = visible
sql_attr_timestamp = dateline
sql_attr_uint = replycount
sql_attr_multi = uint tagid from ranged-query;SELECT (contentid + 2000000000) AS doc_id, tagid FROM tagcontent WHERE contenttypeid = 2 AND contentid BETWEEN $start AND $end;SELECT MIN(contentid), MAX(contentid) FROM tagcontent;
}

source threaddeltasrc : threadsrc
{
sql_query_pre =
sql_query_range = SELECT IF (ISNULL(MIN(primaryid)), 0, MIN(primaryid)), IF (ISNULL(MAX(primaryid)), 0, MAX(primaryid)) FROM digitalpoint_sphinx_delta WHERE contenttypeid=2
sql_query = \
SELECT (digitalpoint_sphinx_delta.primaryid + 2000000000) AS doc_id, digitalpoint_sphinx_delta.primaryid AS primaryid, 2 AS contenttypeid, thread.forumid AS groupid, thread.title, thread.visible, thread.dateline, thread.replycount, thread.prefixid, \

postuserid AS userid, lastpost \
FROM digitalpoint_sphinx_delta \
LEFT JOIN thread ON(thread.threadid = digitalpoint_sphinx_delta.primaryid) \
WHERE contenttypeid = 2 AND \
primaryid BETWEEN $start AND $end;
sql_attr_multi = uint tagid from ranged-query;SELECT (primaryid + 2000000000) AS doc_id, tagcontent.tagid FROM digitalpoint_sphinx_delta RIGHT JOIN tagcontent ON(tagcontent.contentid = digitalpoint_sphinx_delta.primaryid) WHERE digitalpoint_sphinx_delta.contenttypeid = 2 AND primaryid BETWEEN $start AND $end;SELECT IF (ISNULL(MIN(primaryid)), 1, MIN(primaryid)), IF (ISNULL(MAX(primaryid)), 1, MAX(primaryid)) FROM digitalpoint_sphinx_delta WHERE contenttypeid=2;
sql_query_killlist = SELECT (primaryid + 2000000000) AS kill_id FROM digitalpoint_sphinx_delta WHERE contenttypeid = 2 AND delete_flag = 1;
} __DEFINE_LIKE_SHARE__