Jump to:

22999 Posts in 11854 Topics by 2828 members

General Questions

SilverStripe Forums » General Questions » database problem

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 833 Views
  • animasola
    Avatar
    Community Member
    121 Posts

    database problem Link to this post

    Let me give you an idea of what I did. Since the userforms and save and publish have a lot of problems when pages get too many and forms get too long, I downloaded my current site database to perform changes locally where the memory_limit is higher. To avoid unnecessary errors in my current db i decided to create a new database and user altogether. I gave that user full permissions to the new database and then imported my current local database into the new online database.

    I changed to details in the _config.php file of my online site to match the new database and user.

    Now I get this:

    [User Error] Couldn't run query: SHOW FULL FIELDS IN `Permission` Table 'atankers_silver.Permission' doesn't exist

    What the hell does this error indicate? I just gave the new user permissions to the database. Is there another file aside from the _config.php which I have to edit?

  • tobych
    Avatar
    Community Member
    97 Posts

    Re: database problem Link to this post

    The error probably indicates that the table Permission doesn't exist in your database. Have you checked that?

    If your live server is Linux, and your local machine is running Windows, your problem may be related to the fact that the Windows and Linux versions of MySQL handle the case (upper or lower) of table names differently.

    See this post: http://www.silverstripe.org/archive/show/77595#post128453

    Toby

  • animasola
    Avatar
    Community Member
    121 Posts

    Re: database problem Link to this post

    Wow! That fixed it! Yey! haha... Thanks a lot!

    833 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.