Menu

need help

Help
Arun
2006-07-13
2013-03-08
  • Arun

    Arun - 2006-07-13

    while i'm trying to open http://localhost:3000/user/login i'm getting the error :
           Mysql::Error: Table 'openappdotorgtoolkit_development.permissions' doesn't exist: SELECT DISTINCT permissions.*
    FROM permissions, roles,
         permissions_roles
    WHERE roles.name = 'Guest'
    AND roles.id = permissions_roles.role_id
    AND permissions_roles.permission_id = permissions.id
    AND permissions.controller = 'user'
    AND permissions.action = 'index'

    i have created a database named openappdotorgtoolkit_development and while i
    m trying to run openappdotorg_development_dump25052006.sql in mysql i'm getting the error :
             ERROR 1064: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 4
    ERROR 1146: Table 'openappdotorgtoolkit_development.engine_schema_info' doesn't exist
    ERROR 1146: Table 'openappdotorgtoolkit_development.engine_schema_info' doesn't exist
    Query OK, 0 rows affected (0.00 sec)

    ERROR 1064: You have an error in your SQL syntax near 'ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 5
    ERROR 1146: Table 'openappdotorgtoolkit_development.organizations' doesn't existQuery OK, 0 rows affected (0.02 sec)

    ERROR 1064: You have an error in your SQL syntax near 'ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 7
    ERROR 1146: Table 'openappdotorgtoolkit_development.permissions' doesn't exist
    ERROR 1146: Table 'openappdotorgtoolkit_development.permissions_roles' doesn't exit

    please suggest me what can i do to resolve it.

     
    • openappdotorg

      openappdotorg - 2006-07-14

      Did you create openappdotorgtoolkit_development database inside your MySQL. Make sure username/pwd that you have in database.yml file is present in your MySQL DB.

      # So check database.yml, if you are using downloaded version it uses "root" user default of MySQL, make sure you have this user present

      # When you create new database its of type "ENGINE=MyISAM"

       

Log in to post a comment.