Ankündigung

Einklappen
Keine Ankündigung bisher.

Problem mit SQL und Slimbox für Zen

Einklappen
X
 
  • Filter
  • Zeit
  • Anzeigen
Alles löschen
neue Beiträge

    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.
    
    [b]Zen Lightbox overrides this when installed[/b]. 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: [url="http://www.digitalia.be/software/slimbox"]Christophe Beyls[/url] for writing Slimbox, [url="http://homepage.mac.com/yukikun/software/slimbox_ex/"]Yukio Arita[/url] 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.
    
    [b]Default: true[/b]
    ', @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. [b]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.[/b]
    
    [b]Default: 1 (Conservative)[/b]
    ', @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.
    
    [b]Default: true[/b]
    ', @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.
    
    [b]Examples:[/b]
    Page #1 of #2 - default English
    Page #1 (of #2) - variation English
    Pagina #1 di #2 - Itallian
    
    [b]Default: Page #1 of #2[/b]
    ', @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)
    
    [b]Default: 800[/b]
    ', @t4, 20, NOW(), NOW(), NULL, NULL),
    
    (NULL, 'Transition Type', 'FUAL_SLIMBOX_TRANSITION_TYPE', 'Sine', '
    Controls the type of the transition. See [url="http://docs.mootools.net/Effects/Fx-Transitions.js"]Mootools[/url] for what the options mean.
    
    [b]Default: Sine[/b]
    ', @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 [url="http://docs.mootools.net/Effects/Fx-Transitions.js"]Mootools[/url] for what the options mean.
    
    [b]Default: easeInOut[/b]
    ', @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.
    
    [b]Default: 5[/b]
    ', @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.
    
    [i]Should be an integer value between 1 - 200.[/i]
    
    [b]Default: 60[/b]
    ', @t4, 60, NOW(), NOW(), NULL, NULL),
    
    (NULL, 'Width', 'FUAL_SLIMBOX_WIDTH', '400', '
    Controls the initial width of the lightbox.
    
    [b]Default: 400[/b]
    ', @t4, 70, NOW(), NOW(), NULL, NULL),
    
    (NULL, 'Height', 'FUAL_SLIMBOX_HEIGHT', '300', '
    Controls the initial height of the lightbox. Have a play!
    
    [b]Default: 300[/b]
    ', @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!
    
    [b]Default: 500[/b]
    ', @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!
    
    [b]Default: 300[/b]
    ', @t4, 100, NOW(), NOW(), NULL, NULL),
    
    (NULL, 'Animate Caption', 'FUAL_SLIMBOX_CAPTION', 'true', '
    Animates the caption. Have a play!
    
    [b]Default: true[/b]
    ', @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).
    
    [b]Default: zenLightboxHideMe[/b] (This coincides with the Zen Lightbox default class.)
    ', @t4, 120, NOW(), NOW(), NULL, NULL);

    #2
    Guckst Du:

    Kommentar


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

      Kommentar

      Info zu diesem Forenarchiv:
      Mit Release von 1.5.7 wurde die deutsche Zen Cart Version auf eine reine DIY-Lösung umgestellt.
      Für einen Support via Forum stehen keine personellen und zeitlichen Ressourcen mehr zur Verfügung.
      Dieses Supportforum bleibt im Nur-Lesen-Modus als Wissensarchiv noch online verfügbar.
      PM Funktionalität, Registrierung und Posten neuer Beiträge sind deaktiviert.
      Zugriff auf Anhänge in den Postings ist auch ohne Registrierung/Einloggen möglich.
      FAQ und Downloadbereich des Forums wurden in die neue umfangreiche Knowledgebase auf der zen-cart-pro.at Website übernommen.

      Das Development der deutschen Zen Cart Version geht wie bisher auf Github weiter.
      Wir werden auch weiterhin neue Versionen bereitstellen und die Onlinedokumentation/Knowledgebase aktualisieren.
      Fehler in der Software können auf Github als Issues gemeldet werden.
      Follow us
      aktuelle version
      Zen Cart 1.5.7g deutsch
      vom 12.12.2023
      [Download]
      Lädt...
      X