+ Reply to Thread
Results 1 to 6 of 6

Thread: SQL Error while upgrading from 4.5.1 to 4.5.2... site down since 5 days

  1. #1

    SQL Error while upgrading from 4.5.1 to 4.5.2... site down since 5 days

    Dear Vikor,

    My Site is down while doing upgrade from 4.5.1 to 4.5.2, i submited ticket 5 days back, after two days they asked for FTP details, and now agein three days gone .

    Site is down from last 5 days, when site is down it should be considered as critical then the support should be little urgent. now its more then 5 days, its not solved.

    how can we get confidence on support when things are not solved for 5 days when we needed the most. where should we go and ask for support when developer are not supporitng in time.

    Please find my site is showing below error, let me know how to solve it, so that i will do it my self.

    MYSQL ERROR
    Error: Unknown column 'Class' in 'field list'
    Query: SELECT `Name`,`Class`,`Plugin`,`Code` FROM `fl_hooks` WHERE (`Status` = 'active')
    Function: getAll
    Class: rlDatabase
    File: /home1/ebuddy16/public_html/includes/classes/dbi.class.php (line# 370)

  2. #2
    Hi, Any update on my Site SQL issue, its still not get sorted.

    My site is down from last from almost a week... I tried it from my side by installing again but SQL error not able to solve it.

    Kindly help me to solve this issue sorted.

  3. #3
    Hello Sanjay Pattar,

    I've fixed this issue, you missed these changes from patch to 4.5.1.
    Thank you, Curtis.
    @Flynax Company

  4. #4
    Hello Sanjay,

    You can try to add new column 'Class' yourself through phpmyadmin in table: 'fl_hooks'
    Use this mysql query: ALTER TABLE `fl_hooks` ADD `Class` VARCHAR(50) NOT NULL AFTER `Name`;
    Viktor,
    Flynax technical department,
    Best wishes.

  5. #5
    Thanks curtis and viktor. My site is live now. But I still have one more SQL issue so I have requested kevin... hope it will be sorted soon.

  6. #6
    Hi Curtis,

    As mentioned my site is live but it is still not functioning. On home page all categories links showing below SQL error. I submitted ticket but somehow its taking long time to solve simple query.
    Request you to please fix it by tomorrow as post two day weekend will stretch this. I havent moved forward from last two weel due to this asQL error.

    Error:Unknown column 'Category_ID' in 'where clause'Query:SELECT `Key` FROM `fl_search_forms` WHERE `Status` = 'active' AND `Category_ID` > 0 AND (`Subcategories` = '1' OR `Category_ID` = 161) AND `Category_ID` IN ('161','95') ORDER BY FIND_IN_SET(`Category_ID`, '161,95') ASC LIMIT 1Function:getOneClass:rlDatabaseFile:/home1/ebuddy16/public_html/includes/classes/rlSearch.class.php (line# 967)

+ Reply to Thread