Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL View Error - Invalid table?

Discussion in 'Database Discussions' started by ultramel123, Oct 22, 2013.

  1. ultramel123

    ultramel123 Registered

    Joined:
    Oct 22, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    I have imported a sql database using phpmyadmin. I am receiving the following error:

    Code:
    [wrapped: SQLSTATE[HY000]: General error: 1356 View 'lingerie_models.view_content_i18n_files_types' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them]
all of my tables imported successfully. I have tried to "check" the database in cPanel, but it shows "ok" through the check, and does not bring up any errors.
    The site was made using Symphony.

    Please can someone assist me with what could be causing this error?

    Links to the site are as follows: Frontend_dev.php

    Please advise if there is any additional information which is required in order to assist?

    I have no SQL knowledge, and will appreciate any guidance in this regard

    Thank you
     
    #1 ultramel123, Oct 22, 2013
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,211
    Likes Received:
    1,375
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    This is more of an issue with your database, as opposed to with cPanel itself. Searching for the error message you posted on Google yields a few results that may be helpful. You may want to consult with your hosting provider or support for the script you are using to see if there are actions you can take to resolve this issue.

    Thank you.
     
    #2 cPanelMichael, Oct 22, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - View Error Invalid
  1. jotay

    Restore error You are not authorised to view this resource

    jotay, Jun 11, 2017, in forum: Data Protection
    Replies:
    5
    Views:
    268
    cPanelMichael
    Jun 13, 2017
  2. Steve Kemp

    Logview 500 error

    Steve Kemp, Jan 8, 2017, in forum: General Discussion
    Replies:
    6
    Views:
    739
    Infopro
    May 3, 2017
  3. Andova Begarin

    Latest Visitor to domain view has error

    Andova Begarin, Feb 17, 2016, in forum: User Experience
    Replies:
    3
    Views:
    842
    cPanelMichael
    Feb 29, 2016
  4. electric

    Let customers view and whitelist mod_security rules?

    electric, Aug 26, 2017, in forum: Security
    Replies:
    2
    Views:
    113
    cPanelMichael
    Aug 28, 2017
  5. kerryww

    Viewing site before DNS propagates

    kerryww, Jul 7, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    2
    Views:
    187
    cPanelMichael
    Jul 10, 2017

Share This Page