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!

SQL View Error - Invalid table?

Discussion in 'Database Discussion' 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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,442
    Likes Received:
    1,961
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Oct 22, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - View Error Invalid
  1. Zardiw

    cPanel window size for error log viewing

    Zardiw, Sep 27, 2017, in forum: User Experience
    Replies:
    3
    Views:
    619
    Infopro
    Oct 9, 2017
  2. ericchen0121

    Can't view/edit JSON file. Syntax and Reference error in editit.html

    ericchen0121, Sep 25, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    437
    cPanelMichael
    Sep 26, 2017
  3. jotay

    Restore error You are not authorised to view this resource

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

    Logview 500 error

    Steve Kemp, Jan 8, 2017, in forum: General Discussion
    Replies:
    9
    Views:
    1,427
    EonHost
    Mar 22, 2018
  5. xman888

    Viewing cPanel and Webmail when running through Cloudflare

    xman888, Nov 26, 2018, in forum: General Discussion
    Replies:
    3
    Views:
    281
    cPanelMichael
    Nov 30, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice