This is my first submission, I apologize if this isn't as complete as it should be...

I am using Views and Views Slideshow to run a slideshow in "content top" on . The correct Content Types are displayed, but not in a slideshow, rather, they just stack (images) on top of oneanother.

The slideshow should be rotating these images ever 9 miliseconds

When I go to Views to check my settings, I see this error message: "user warning: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' query: SELECT s.uid, v.updated FROM views_object_cache v INNER JOIN sessions s ON v.sid = s.sid WHERE s.sid != '07fe505f3eb0e08f59d30e262ca7dd58' and v.name = 'test' and v.obj = 'view' ORDER BY v.updated ASC in /home/charlesr/public_html/4seasonsgreenery/modules/views/views_ui.module on line 235."

The following pieces of

 and <php> are pasted into a doc which is attached as well if the formatting gets lost.

<code>
<div id="block-views-test-block_1" class="block block-views region-odd even region-count-1 count-4">
<div class="block-inner">
<div class="content">
<div id="block-edit-link-views_test-block_1" class="block-edit-link"/>
<div class="view view-test view-id-test view-display-id-block_1 view-dom-id-1">
<div class="views-admin-links views-hide">
</div>
<div class="view-content">
<div id="views_slideshow_main_1" class="views_slideshow_main" style="opacity: 1;">
</div>
<div id="views_slideshow_main_2" class="views_slideshow_main" style="opacity: 1;">
<div id="views_slideshow_teaser_section_2" class="views_slideshow_teaser_section">
<div id="views_slideshow_div_2_0" style="display: block;">
<div class="views-field-body">
<div class="field-content">
<p>
<img width="684" height="288" src="/userfiles/plants.gif" alt=""/>
</p>
</div>
</div>
</div>
</div>
</div>
<div id="views_slideshow_main_3" class="views_slideshow_main" style="opacity: 1;">
<div id="views_slideshow_teaser_section_3" class="views_slideshow_teaser_section">
</div>
</div>
<div id="views_slideshow_main_4" class="views_slideshow_main" style="opacity: 1;">
<div id="views_slideshow_teaser_section_4" class="views_slideshow_teaser_section">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
$view = new view; $view->name = 'test'; $view->description = 'test'; $view->tag = 'test'; $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('fields', array( 'body' => array( 'label' => '', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'strip_tags' => 0, 'html' => 0, ), 'exclude' => 0, 'id' => 'body', 'table' => 'node_revisions', 'field' => 'body', 'relationship' => 'none', ), )); $handler->override_option('filters', array( 'type' => array( 'operator' => 'in', 'value' => array( 'headerads' => 'headerads', ), 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => FALSE, 'label' => '', ), 'id' => 'type', 'table' => 'node', 'field' => 'type', 'relationship' => 'none', ), 'status' => array( 'operator' => '=', 'value' => '1', 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => FALSE, 'label' => '', ), 'id' => 'status', 'table' => 'node', 'field' => 'status', 'relationship' => 'none', ), )); $handler->override_option('access', array( 'type' => 'none', )); $handler->override_option('cache', array( 'type' => 'none', )); $handler->override_option('style_plugin', 'slideshow'); $handler->override_option('style_options', array( 'grouping' => 'body', 'type' => 'ul', 'mode' => 'single_frame', 'hover_breakout' => 'teaser', 'teasers_last' => 1, 'hover' => 'hover', 'timer_delay' => '9000', 'sort' => '1', 'fade' => 1, 'fade_speed' => 'normal', 'fade_value' => '0.25', )); $handler = $view->new_display('block', 'Block', 'block_1'); $handler->override_option('block_description', ''); $handler->override_option('block_caching', -1);

I'm not advanced enough to know what to do or what the error really means. I'm hoping that someone can identify the issue and fix that code (?) or perhaps I'm doing something grossly inaccruate (for which I apologize in advance). I hope that I've correctly followed submission guidelines, as I've not posted a code fix before.

CommentFileSizeAuthor
views_bug_stuff.txt3.19 KBMilkrow

Comments

merlinofchaos’s picture

Status: Active » Closed (duplicate)

See http://drupal.org/node/319193 which discusses collations.