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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
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"