+ 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
    Location
    Planet Earth
    Posts
    3,138
    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
    Senior Member
    Join Date
    Mar 2019
    Location
    Philadelphia, PA, USA
    Posts
    120
    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