RuntimeException on fresh installation #1138
Comments
|
hey @iamamused how did you install directus? did you use the master, development or build branch? I tested on master, development and build branch. is there something else I should know to replicate the issues besides the log? are the |
|
Ultimately it was a configuration in my mysql server. Directus didn't like the default sql_mode that was set. In api/api.php I added a set sql_mode query and then things started working correctly. |
|
@iamamused perhaps this mode was I want to know if we have issue with that or another mysql mode. Thanks. |
|
@iamamused What line did you add that code on? I'm experiencing the same issue ( #1143 ) on my installation. |
|
@iamamused maybe it was here: https://github.com/directus/directus/blob/master/api/api.php#L120 |
|
Hello, I am running: OS El Capitan 10.11.3 |
|
Looking into this a bit further... |
|
hey @anotherwebstorm, could you tell us which tables did create and what MySQL modes do you have enabled? |
|
Sure. directus_bookmarks About MySQL modes I don't exactly what you mean with this but if you could help me to know how to check them? FYI I'm now only testing on a MAMP (latest version) Environment. Thanks |
|
I also forgot to mention that I have (probably this is what you would like also to know): mcrypt support v2.5.8 They are all enabled. |
|
@anotherwebstorm Thanks, I found the issue, it's an unsupported default I will let you know as soon as that's fixed. |
|
That's awesome. |
|
@anotherwebstorm I updated the build branch, can you confirm that it fixes the issue for you too? |
|
Excelent Work. |
|
Great! Thanks for reporting the issue @anotherwebstorm Good job @wellingguzman!! |
Trying to install and get
This query failed: SELECT
directus_tables.* FROMdirectus_tablesafter configuration is complete. The config step has everything as "yes".
Here's the actual output
{
"code":0,
"class":"RuntimeException",
"message":"This query failed: SELECT
directus_tables.* FROMdirectus_tables","file":"/Users/jsambells/Documents/Projects/test/directus/api/core/Directus/Db/TableGateway/AclAwareTableGateway.php",
"line":486,
"trace":[
{
"file":"/Users/jsambells/Documents/Projects/test/directus/api/vendor/zendframework/zend-db/src/TableGateway/AbstractTableGateway.php",
"line":208,
"function":"executeSelect",
"class":"Directus\Db\TableGateway\AclAwareTableGateway",
"type":"->",
"args":[
{
}
]
},
{
"file":"/Users/jsambells/Documents/Projects/test/directus/api/vendor/zendframework/zend-db/src/TableGateway/AbstractTableGateway.php",
"line":195,
"function":"selectWith",
"class":"Zend\Db\TableGateway\AbstractTableGateway",
"type":"->",
"args":[
{
}
]
},
{
"file":"/Users/jsambells/Documents/Projects/test/directus/api/core/Directus/Bootstrap.php",
"line":259,
"function":"select",
"class":"Zend\Db\TableGateway\AbstractTableGateway",
"type":"->",
"args":[
]
},
{
"file":"/Users/jsambells/Documents/Projects/test/directus/api/core/Directus/MemcacheProvider.php",
"line":113,
"function":"Directus{closure}",
"class":"Directus\Bootstrap",
"type":"::",
"args":[
]
},
{
"file":"/Users/jsambells/Documents/Projects/test/directus/api/core/Directus/Bootstrap.php",
"line":262,
"function":"getOrCache",
"class":"Directus\MemcacheProvider",
"type":"->",
"args":[
"directus_tables",
{
},
1800
]
},
{
"function":"acl",
"class":"Directus\Bootstrap",
"type":"::",
"args":[
null
]
},
{
"file":"/Users/jsambells/Documents/Projects/test/directus/api/core/Directus/Bootstrap.php",
"line":40,
"function":"call_user_func",
"args":[
"Directus\Bootstrap::acl",
null
]
},
{
"file":"/Users/jsambells/Documents/Projects/test/directus/api/api.php",
"line":125,
"function":"get",
"class":"Directus\Bootstrap",
"type":"::",
"args":[
"acl"
]
},
{
"file":"/Users/jsambells/Documents/Projects/test/directus/index.php",
"line":13,
"args":[
"/Users/jsambells/Documents/Projects/test/directus/api/api.php"
],
"function":"require"
}
],
"traceAsString":"#0 /Users/jsambells/Documents/Projects/test/directus/api/vendor/zendframework/zend-db/src/TableGateway/AbstractTableGateway.php(208): Directus\Db\TableGateway\AclAwareTableGateway->executeSelect(Object(Zend\Db\Sql\Select))\n#1 /Users/jsambells/Documents/Projects/test/directus/api/vendor/zendframework/zend-db/src/TableGateway/AbstractTableGateway.php(195): Zend\Db\TableGateway\AbstractTableGateway->selectWith(Object(Zend\Db\Sql\Select))\n#2 /Users/jsambells/Documents/Projects/test/directus/api/core/Directus/Bootstrap.php(259): Zend\Db\TableGateway\AbstractTableGateway->select()\n#3 /Users/jsambells/Documents/Projects/test/directus/api/core/Directus/MemcacheProvider.php(113): Directus\Bootstrap::Directus{closure}()\n#4 /Users/jsambells/Documents/Projects/test/directus/api/core/Directus/Bootstrap.php(262): Directus\MemcacheProvider->getOrCache('directus_tables', Object(Closure), 1800)\n#5 [internal function]: Directus\Bootstrap::acl(NULL)\n#6 /Users/jsambells/Documents/Projects/test/directus/api/core/Directus/Bootstrap.php(40): call_user_func('Directus\Bootst...', NULL)\n#7 /Users/jsambells/Documents/Projects/test/directus/api/api.php(125): Directus\Bootstrap::get('acl')\n#8 /Users/jsambells/Documents/Projects/test/directus/index.php(13): require('/Users/jsambell...')\n#9 {main}"
}
The text was updated successfully, but these errors were encountered: