1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

[Bug] Incorrect Navigaton Sequence in Site Builder Image Gallery

Discussion in 'SiteBuilder' started by ccto, Sep 19, 2009.

  1. ccto

    ccto Basic Pleskian

    Mar 21, 2005
    Likes Received:
    Dear Parallels Support,

    We have updated the Site Builder to 4.5 Hotfix 7 (i.e. the latest one).
    However for the following item (fixed in hotfix 7) -
    ref.: http://autoinstall.plesk.com/SiteBu.../sitebuilder-4.5.7_build2009060500_linux.html


    We found that inside Image Gallery, the Next/Previous Image link Images are not in position sequence.

    As reported, when we navigate the end-user website http://www.hkperpetual.com/allwatches.php?view=thumbnailList&category=1 , it is inside category=1, choose the first image (image=7), then choose next image (image become 13), then choose next image (image become 58), then choose next image (image become 60).

    I tried to browse the sqlite database table module_xxxx_gallery_relations, and spooled the SQL

    The following is the sqlite database table screen capture for your reference.

    If we browse the image with id=7 and position=1,
    the next image should be the image with id=8 and position=2,
    the next next image should be image with id=12 and position=4
    am I right? I think so.

    Then, I tried to turn on DEBUG flag and spool the SQL to have a look -

    I believe the red-highlighted one are the SQL to get the next and previous Image Id.
    However the use of "position > '1'" and "position < '1'" may not get the correct position in order.

    If I execute the red-highlighted SQL in the SQLite database browser, it return image id 13 (that with position id 48), instead of image id 8 (that with position 2) as below -

    May I suggest, say , add one more SQL to fetch the correct next/previous position id before you get the image id, e.g.
    Then, the next and previous image are in sequence.

    If necessary, we may pass you the sqlite database for you to have a look (if the end-user permits)

    Please help and advise.

    Thank you very much for your kind attention.

    Website Solution Limited
  2. SacxSol.com

    SacxSol.com Basic Pleskian

    Dec 9, 2008
    Likes Received:
    Hello, after seven month there are non solutions at this problem?
    Too I have the same problem.
    Nobody's of Parallels Team's that have a solutions?