+ Reply to Thread
Results 1 to 6 of 6

Thread: MYSQL Error after update to OLX template

  1. #1
    Junior Member
    Join Date
    Nov 2017
    Posts
    14

    MYSQL Error after update to OLX template

    Hi Someone,

    After changed to OLX Template, Home Page received MYSQL ERROR blank page. May i know what are the setting need to look at to fix it. Thank you.

  2. #2
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    Hello,

    First, you need to check what the error is

    for that, go to includes > config.inc.php > set RL_DEBUG to true

  3. #3
    Junior Member
    Join Date
    Nov 2017
    Posts
    14
    Hi Rudi,

    Thanks for your advice...after that i received this...

    MYSQL ERROR
    Error: Table 'xxxxx_xx.fl_categories' doesn't exist
    Query: SELECT `Parent_ID` FROM `fl_categories` WHERE `Parent_ID` IN ('1','9','20','29','42','52','97','105','106','115 ','122','125') GROUP BY `Parent_ID`
    Function: specialBlockHook2
    File: /home/xxxxx/public_html/includes/classes/rlHook.class.php (line# 189)

    [xxxxx refer to my site db table and the site name.]
    Last edited by Thant Zin; April 28, 2021 at 05:51 PM.

  4. #4
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    Ok,

    1. go to your database (phpMyAdmin) > table hooks > Search > set the following parameters for columns:

    Name - specialBlock

    Plugin - nova_template

    and click search

    then edit found row and in the column Code find and replace fl_categories with {db_prefix}categories


    2. Also go to templates > your_template > settings.tpl.php > at the bottom of the file replace fl_categories with {db_prefix}categories

  5. #5
    Junior Member
    Join Date
    Nov 2017
    Posts
    14
    Hi Rudi,

    Thank you so much.

    Action. No. 1 Done and Site Loading fine Now.

    Regd No.2 I cannot find fl_categories at settings.tpl.php

    Is ok to leave it?

    Best Regards,

  6. #6
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    You're welcome, Thant,

    you can leave step 2 for now, but if you switch back to this template, the error may happen again

    use search by phrase in your text editor and you'll easily find it or send your ftp details to my PM and I'll do it

+ Reply to Thread