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.

Hello,

First, you need to check what the error is

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

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.]

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

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,

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