Ergebnis 1 bis 3 von 3

Thema: Problem mit SQL und Slimbox für Zen

  1. #1
    Padawan Anwärter Avatar von MSchnoor
    Registriert seit
    15.05.2008
    Beiträge
    13
    Themen
    3
    DANKE
    0
    Erhaltene Danke: 0

    Standard Problem mit SQL und Slimbox für Zen

    Hallo zusammen,

    ich möchte gerne Slimbox for Zen in meinem Shop integrieren, aber sobald ich über PhPMyAdmin versuche die Tabellen zu erstellen, bekomme ich folgende Fehlermeldung:
    1136 Column count doesn't match value count at row 1 in:
    [INSERT INTO configuration_group VALUES (NULL, 'Fual Slimbox', 'Configure Slimbox options', '1', '1');]

    Hier ist mal die slimbox_install.sql. Kann mir vielleicht jemand weiterhelfen, bin ehrlich gesagt jetzt nicht so der SQL-Crack. Danke Euch im Vorraus.

    Code:
    SET @t4=0;
    SELECT (@t4:=configuration_group_id) as t4 
    FROM configuration_group
    WHERE configuration_group_title= 'Fual Slimbox';
    DELETE FROM configuration WHERE configuration_group_id = @t4;
    DELETE FROM configuration_group WHERE configuration_group_id = @t4;
    
    INSERT INTO configuration_group VALUES (NULL, 'Fual Slimbox', 'Configure Slimbox options', '1', '1');
    UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
    
    SET @t4=0;
    SELECT (@t4:=configuration_group_id) as t4 
    FROM configuration_group
    WHERE configuration_group_title= 'Fual Slimbox';
    
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) 
    
    VALUES
    
    (NULL, 'Enable Fual Slimbox?', 'FUAL_SLIMBOX', 'true', '
    If true, all product images on the following pages will be displayed within a lightbox:
    
    - document_general_info
    - document_product_info
    - product_free_shipping_info
    - product_info
    - product_music_info
    - product_reviews
    - product_reviews_info
    - product_reviews_write
    
    Please note: To completely remove Fual Slimbox please see the documentation provided.
    
    Zen Lightbox overrides this when installed. This means that if you have the ZL mod and Slimbox, Slimbox will do nothing. I have done this specifically to stop people messing their installations up. I have provided a modified version of ZL for ZL users, unfortunately switching ZL off doesnt really switch it off (all the javascript is still loaded), the modified version actually switches ZL off when you switch it off.
    
    
    The big advantage of Slimbox over lightbox is that it takes only 30kb of javasript rather than well over 100kb for lightbox
    
    Unlike (Zen) Lightbox the Slimbox is completely generated using CSS, so any tweeks that you want to make to the look can be made from the CSS file.
    
    Props to: Christophe Beyls for writing Slimbox, Yukio Arita for extending it to work with iframes (this is the extended version so you can put whole webpages in the Slimbox, dont get carried away though!) and Alex Clarke for the original ZL plugin which inspired me to write this.
    
    Default: true
    ', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option( array(''true'', ''false''), '), 
    
    (NULL, 'Paranoia Mode', 'FUAL_SLIMBOX_NERVOUS', '1', '
    Controls whether to wait until the DOM loads to display the image. This stops the problem of being redirected to the image rather than displaying the image in the lightbox if a user with a slow connection clicks on the image before the slimbox script has been initialised.
    
    0 = Relaxed: Dont wait until the DOM loads.
    1 = Conservative: Waits until the DOM has loaded to make the image visible.
    2 = Funky: Waits until the DOM has loaded to reveal the image with a funky transition. Depending on your template this may cause problems in IE6, so if you want to use the funky transition please test it in older browsers before going live.
    
    Default: 1 (Conservative)
    ', @t4, 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2''), '),
    
    (NULL, 'Safe Navigation', 'FUAL_SLIMBOX_DISPLAY_VAR', 'true', '
    With safe navigation enabled the Next and Prev links are displayed permenantly in the lightbox when there are additional images to display. Safe Navigation is recommended because without it the navigation links fail to show in IE6.
    
    Default: true
    ', @t4, 15, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),
    
    (NULL, 'Page of Text', 'FUAL_SLIMBOX_PAGEOF', 'Page #1 of #2', '
    Sets the "Page #1 of #2" text when there is more than one image.
    
    The text is replaced with a regular expression: #1 is the number of the current page, #2 is the total number of pages.
    
    Examples:
    Page #1 of #2 - default English
    Page #1 (of #2) - variation English
    Pagina #1 di #2 - Itallian
    
    Default: Page #1 of #2
    ', @t4, 17, NOW(), NOW(), NULL, NULL),
    
    (NULL, 'Transition Duration', 'FUAL_SLIMBOX_DURATION', '800', '
    Controls the duration of the transition in milliseconds. (note that 1000 milliseconds = 1 second, so the default value of 800 is just under a second)
    
    Default: 800
    ', @t4, 20, NOW(), NOW(), NULL, NULL),
    
    (NULL, 'Transition Type', 'FUAL_SLIMBOX_TRANSITION_TYPE', 'Sine', '
    Controls the type of the transition. See Mootools for what the options mean.
    
    Default: Sine
    ', @t4, 30, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''linear'', ''Quad'', ''Cubic'', ''Quart'', ''Quint'', ''Expo'', ''Circ'', ''Sine'', ''Back'', ''Bounce'', ''Elastic''), '),
    
    (NULL, 'Transition Ease', 'FUAL_SLIMBOX_EASE', 'easeInOut', '
    Controls the easing of the transition. See Mootools for what the options mean.
    
    Default: easeInOut
    ', @t4, 40, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''easeIn'', ''easeOut'', ''easeInOut''), '),
    
    (NULL, 'Transition Amplitude', 'FUAL_SLIMBOX_AMPLITUDE', '5', '
    Controls the amplitude of the transition.
    
    Default: 5
    ', @t4, 50, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3'',''4'',''5'',''6'',''7'',''8'',''9''), '),
    
    (NULL, 'FPS', 'FUAL_SLIMBOX_FPS', '60', '
    Controls the frames per second of the motion.
    
    Should be an integer value between 1 - 200.
    
    Default: 60
    ', @t4, 60, NOW(), NOW(), NULL, NULL),
    
    (NULL, 'Width', 'FUAL_SLIMBOX_WIDTH', '400', '
    Controls the initial width of the lightbox.
    
    Default: 400
    ', @t4, 70, NOW(), NOW(), NULL, NULL),
    
    (NULL, 'Height', 'FUAL_SLIMBOX_HEIGHT', '300', '
    Controls the initial height of the lightbox. Have a play!
    
    Default: 300
    ', @t4, 80, NOW(), NOW(), NULL, NULL),
    
    (NULL, 'iFrame Width', 'FUAL_SLIMBOX_IWIDTH', '500', '
    Controls the initial width of the lightbox when it contains an iFrame. Have a play!
    
    Default: 500
    ', @t4, 90, NOW(), NOW(), NULL, NULL),
    
    (NULL, 'iFrame Height', 'FUAL_SLIMBOX_IHEIGHT', '300', '
    Controls the initial width of the lightbox when it contains an iFrame. Have a play!
    
    Default: 300
    ', @t4, 100, NOW(), NOW(), NULL, NULL),
    
    (NULL, 'Animate Caption', 'FUAL_SLIMBOX_CAPTION', 'true', '
    Animates the caption. Have a play!
    
    Default: true
    ', @t4, 110, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),
    
    (NULL, 'Class to Hide', 'FUAL_SLIMBOX_HIDE_ME', 'zenLightboxHideMe', '
    Any content wrapped in with this class will be hidden when the lightbox is displayed (this extends the behaviour of Zen Lightbox which only hides DIV tags).
    
    Default: zenLightboxHideMe (This coincides with the Zen Lightbox default class.)
    ', @t4, 120, NOW(), NOW(), NULL, NULL);

  2. #2
    Padawan Stufe V Avatar von kermie
    Registriert seit
    03.08.2005
    Beiträge
    574
    Themen
    15
    DANKE
    0
    Erhaltene Danke: 0

  3. #3
    Padawan Anwärter Avatar von MSchnoor
    Registriert seit
    15.05.2008
    Beiträge
    13
    Themen
    3
    DANKE
    0
    Erhaltene Danke: 0
    Erstellt von

    Standard

    Vielen Dank kermie, damit hat sich mein Problem gelöst! Ich hatte hier zwar gesucht, aber über den Thread bin ich nicht gestolpert.

Lesezeichen

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •  
zen-cart-pro.at
Zen Cart ist eine kostenlose unter der GPL-Lizenz veröffentlichte Open-Source Shopsoftware. Das System wird in den USA entwickelt, die amerikanische Website dazu ist www.zen-cart.com

Die deutsche Zen-Cart Version, um die es hier auf zen-cart-pro.at geht, ist eine Anpassung der amerikanischen Version an die Bedürfnisse von Onlineshopbetreibern im deutschsprachigen Raum.

Die deutsche Zen Cart Version wird von einem Team von Entwicklern in Österreich und Deutschland betreut, weiterentwickelt und supportet und steht kostenlos in unserem Downloadbereich zur Verfügung.

[mehr]
Follow Us
  • zen-cart-pro-at auf Twitter
  • zen-cart-pro-at auf Github
  • zen-cart-pro-at auf SourceForge
Aktuelle Version
Zen Cart 1.5.5 deutsch
Revision 1188 vom 02.12.2016
[Download]