22405 Posts in 6902 Topics by 2748 members
|Go to End|
13 December 2009 at 11:10pm
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?
14 December 2009 at 8:57am
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
14 December 2009 at 1:48pm
Wow! That fixed it! Yey! haha... Thanks a lot!
|Go to Top|