+ Reply to Thread
Results 1 to 6 of 6

Thread: Mysql error

  1. #1
    Member
    Join Date
    Jul 2016
    Location
    Iran
    Posts
    74

    Mysql error

    Hello

    When i click pagination in listings-by-field(Field Bound Boxes Plugin) this error display:
    Code:
    Only registered members can view the code.
    In other pages not this error
    Pleas help me
    Thanks
    Car sell in: BanBan.ir

  2. #2
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Posts
    810
    Hello Mousa Lotfi,

    We need to look into the problem
    in this case, go to our ticket system and create a ticket attaching your ftp details

  3. #3
    Hello Mousa,

    Open file: ftp://plugins>>fieldBoundBoxes>>listings_by_field.tpl

    find line:

    Code:
    Only registered members can view the code.
    and replace to:

    Code:
    Only registered members can view the code.
    save and check pagination again.
    Viktor,
    Flynax technical department,
    Best wishes.

  4. #4
    Member
    Join Date
    Jul 2016
    Location
    Iran
    Posts
    74
    Thanks Viktor for your help

    The problem has been resolved with these change.

    Thanks
    Car sell in: BanBan.ir

  5. #5
    Hello Viktor,

    I was working normally on my site creating new listing fields and suddenly I get an "MYSQL Error" when creating dropdown type fields. Can you please help me with that?

    Thanks,

  6. #6
    Member
    Join Date
    Mar 2019
    Location
    Philadelphia, PA, USA
    Posts
    71
    Hi Christian,

    I received a similar error yesterday and Viktor's solution worked for me.

    MYSQL ERROR
    Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `Position`' at line 1
    Query: SELECT *, REPLACE(`Key`, '_', '') as `Key` FROM `fl_field_bound_items` WHERE `Status` = 'active' AND `Box_ID` = ORDER BY `Position`
    Function: require_once
    File: /var/www/vhosts/xxx.com/httpdocs/index.php (line# 219)

+ Reply to Thread