Fresh install, huge errors SELECT DISTINCT node.nid AS nid, position FROM node node INNER JOIN nodequeue_nodes nodequeue_nodes_n

it is the default nodequeue view which is included in the module. I think it is related to this issue http://drupal.org/node/284392

As posters have said they had the same problem. The only problem is they applied patches from earlier versions of drupal and on 6.16 I cant get the patch they used to work.. they said I have to wait for the next dev release.....

Can you help me make the patch for this ? They talk about it in that queue but I think the patch shouyld b e posted here as it is directly related to nodequeue...

Actually this is killing me. i can not get my nodequeue smartqueue for organic groups to work at all . I am trying everything. This is a very important feature for me. No one in that queue is helping me. I think they module is dying. I am getting the error user warning: 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 'ASC LIMIT 0, 10' at line 11 query: SELECT DISTINCT node.nid AS nid, node.title AS node_title, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, position FROM node node INNER JOIN nodequeue_nodes nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid AND nodequeue_nodes_node.qid = 2 LEFT JOIN nodequeue_subqueue nodequeue_nodes_node__nodequeue_subqueue ON nodequeue_nodes_node.sqid = nodequeue_nodes_node__nodequeue_subqueue.sqid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE nodequeue_nodes_node__nodequeue_subqueue.reference = '2' ORDER BY ASC LIMIT 0, 10 in /home/cyberfan/htdocs/modules/views/includes/view.inc on line 765.

I am using panels. When I select the option to sentd arguments, this error appears. When I dont select the option to send arguments, nothing appears, even there is no message that there are no nodequeus.

here is the export of the view I am using:

$view = new view;
$view->name = 'smartqueue_og_default';
$view->description = 'Displays the nodes in a group\'s queue';
$view->tag = 'nodequeue';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('relationships', array(
'nodequeue_rel' => array(
'label' => 'queue',
'required' => 1,
'limit' => 1,
'qids' => array(
'2' => '2',
),
'id' => 'nodequeue_rel',
'table' => 'node',
'field' => 'nodequeue_rel',
'relationship' => 'none',
),
));
$handler->override_option('fields', array(
'title' => array(
'label' => '',
'link_to_node' => 1,
'exclude' => 0,
'id' => 'title',
'table' => 'node',
'field' => 'title',
'override' => array(
'button' => 'Override',
),
'relationship' => 'none',
),
'body' => array(
'label' => '',
'exclude' => 0,
'id' => 'body',
'table' => 'node_revisions',
'field' => 'body',
'override' => array(
'button' => 'Override',
),
'relationship' => 'none',
),
));
$handler->override_option('sorts', array(
'position' => array(
'id' => 'position',
'table' => 'nodequeue_nodes',
'field' => 'position',
),
));
$handler->override_option('arguments', array(
'reference' => array(
'default_action' => 'not found',
'style_plugin' => 'default_summary',
'style_options' => array(),
'wildcard' => 'all',
'wildcard_substitution' => '',
'title' => '',
'breadcrumb' => '',
'default_argument_type' => 'fixed',
'default_argument' => '',
'validate_type' => 'none',
'validate_fail' => 'not found',
'glossary' => 0,
'limit' => '0',
'case' => 'none',
'path_case' => 'none',
'transform_dash' => 0,
'id' => 'reference',
'table' => 'nodequeue_subqueue',
'field' => 'reference',
'relationship' => 'nodequeue_rel',
'default_options_div_prefix' => '',
'default_argument_user' => 0,
'default_argument_fixed' => '',
'default_argument_php' => '',
'validate_argument_node_type' => array(
'dimdim' => 0,
'feed' => 0,
'feed_item' => 0,
'image' => 0,
'quiz' => 0,
'forum' => 0,
'ipaper' => 0,
'panel' => 0,
'event' => 0,
'evocampus_class_group' => 0,
'evocampus_class_group_lesson' => 0,
'evocampus_class_member_post' => 0,
'evocampus_group_lesson' => 0,
'evocampus_group_post' => 0,
'evocampus_group_prioritypost' => 0,
'evocampus_teacher_strategy_book' => 0,
'evonews_capture_base' => 0,
'evonews_feed_item' => 0,
'evonews_sitewide_base' => 0,
'evonews_sitewide_composit' => 0,
'gallery' => 0,
'gallery_image' => 0,
'page' => 0,
'profile' => 0,
'story' => 0,
'topichub' => 0,
),
'validate_argument_node_access' => 0,
'validate_argument_nid_type' => 'nid',
'validate_argument_vocabulary' => array(
'2' => 0,
'42' => 0,
'3' => 0,
'60' => 0,
'4' => 0,
'5' => 0,
'6' => 0,
'55' => 0,
'7' => 0,
'8' => 0,
'9' => 0,
'43' => 0,
'10' => 0,
'11' => 0,
'1' => 0,
'50' => 0,
'12' => 0,
'49' => 0,
'13' => 0,
'45' => 0,
'47' => 0,
'46' => 0,
'44' => 0,
'51' => 0,
'61' => 0,
'14' => 0,
'15' => 0,
'16' => 0,
'17' => 0,
'18' => 0,
'19' => 0,
'20' => 0,
'21' => 0,
'22' => 0,
'23' => 0,
'53' => 0,
'52' => 0,
'24' => 0,
'25' => 0,
'56' => 0,
'26' => 0,
'27' => 0,
'28' => 0,
'29' => 0,
'30' => 0,
'31' => 0,
'32' => 0,
'33' => 0,
'58' => 0,
'41' => 0,
'34' => 0,
'35' => 0,
'36' => 0,
'37' => 0,
'38' => 0,
'39' => 0,
'40' => 0,
'57' => 0,
'54' => 0,
'48' => 0,
'59' => 0,
),
'validate_argument_type' => 'tid',
'validate_argument_php' => '',
'override' => array(
'button' => 'Override',
),
'validate_user_argument_type' => 'uid',
'validate_user_roles' => array(
'2' => 0,
'3' => 0,
'4' => 0,
),
'default_argument_image_size' => '_original',
'validate_argument_node_flag_name' => '*relationship*',
'validate_argument_node_flag_test' => 'flaggable',
'validate_argument_node_flag_id_type' => 'id',
'validate_argument_user_flag_name' => '*relationship*',
'validate_argument_user_flag_test' => 'flaggable',
'validate_argument_user_flag_id_type' => 'id',
'image_size' => array(
'_original' => '_original',
'thumbnail' => 'thumbnail',
'preview' => 'preview',
'tiny' => 'tiny',
),
'validate_argument_is_member' => 'OG_VIEWS_VALIDATE_GROUP_MEMBER',
'validate_argument_group_node_type' => array(
'evocampus_class_group' => 'evocampus_class_group',
'evocampus_teacher_strategy_book' => 0,
),
'validate_argument_signup_status' => 'any',
'validate_argument_signup_node_access' => 0,
'validate_argument_transform' => 0,
'validate_user_restrict_roles' => 0,
),
));
$handler->override_option('access', array(
'type' => 'none',
'role' => array(),
'perm' => '',
));
$handler->override_option('cache', array(
'type' => 'none',
));
$handler->override_option('empty', 'This group does not have a queue that contains and nodes.');
$handler->override_option('empty_format', '1');
$handler->override_option('use_pager', '1');
$handler->override_option('style_plugin', 'list');
$handler->override_option('row_options', array(
'inline' => array(),
'separator' => '',
));
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('path', 'smartqueue-og');
$handler->override_option('menu', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
'name' => 'navigation',
));
$handler->override_option('tab_options', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
'name' => 'navigation',
));