RuntimeException - This query failed: SELECT directus_tables.* FROM directus_tables
#1143
Comments
|
Hi @vhexs I've tried to reproduce this issue using almost your setup except windows 7 64bit, and I couldn't replicate. So I have some questions:
I'd like to help you resolve this. |
|
Another question, is You can check by execute one of these query: SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;Or perhaps in your mysql config file (my.ini). |
|
@wellingguzman Sorry for my late reply, my GitHub notifications are full of things I need to stop watching. Directus created the following tables:
I ended up deleting Directus from my project directory, so I'll quickly reinstall it and see if anything's changed (and so I can post the config file if it doesn't). NO_ZERO_IN_DATE and NO_ZERO_DATE are both enabled on MySQL. And finally, yes, I was using a sub-directory - should I try again without it? Update: Okay, I reinstalled it and I still have the same issue. All the dependencies are met (except for the optional image/thumbnail plugin. My <?php
date_default_timezone_set('America/New_York');
define('API_VERSION', 1);
/**
* DIRECTUS_ENV - Possible values:
*
* 'production' => error suppression, nonce protection
* 'development' => no error suppression, no nonce protection (allows manual viewing of API output)
* 'staging' => no error suppression, no nonce protection (allows manual viewing of API output)
* 'development_enforce_nonce' => no error suppression, nonce protection
*/
define('DIRECTUS_ENV', 'development');
// MySQL Settings
define('DB_HOST', 'localhost');
define('DB_NAME', 'directusnew');
define('DB_USER', 'directusnew');
define('DB_PASSWORD', 'pTZZjL3cLSnsL5da');
define('DB_PREFIX', '');
define('DB_HOST_SLAVE', ''); //Leave undefined to fall back on master
define('DB_USER_SLAVE', '');
define('DB_PASSWORD_SLAVE', '');
// Url path to Directus
define('DIRECTUS_PATH', '/SparkWare-Website-wordpress/directus-master/');
$host = 'www.example.com'; // (Make it work for CLI)
if(isset($_SERVER['SERVER_NAME'])) {
$host = $_SERVER['SERVER_NAME'];
}
define('ROOT_URL', '//' . $host);
if (!defined('ROOT_URL_WITH_SCHEME')){
//Use this for emailing URLs(links, images etc) as some clients will trip on the scheme agnostic ROOT_URL
define('ROOT_URL_WITH_SCHEME', 'https://' . $host);
}
// Absolute path to application
define('APPLICATION_PATH', realpath(dirname(__FILE__) . '/..'));
//Memcached Server, operates on default 11211 port.
define('MEMCACHED_SERVER', '127.0.0.1');
//Namespaced the memcached keys so branches/databases to not collide
//options are prod, staging, testing, development
define('MEMCACHED_ENV_NAMESPACE', 'staging');
define('STATUS_DELETED_NUM', 0);
define('STATUS_ACTIVE_NUM', 1);
define('STATUS_DRAFT_NUM', 2);
define('STATUS_COLUMN_NAME', 'active'); |
|
@wellingguzman Thanks for fixing it! I'll update to the new version now 👍 Dammit, it still won't work for me. I'm going to try setting my SQL_MODE to use zero dates. In the mean time, I decided it might be a good idea if I sent my PHP error log too, might give some more info about the problem. Sorry to bother you! Setting my SQL_MODE to only STRICT_ALL_TABLES didn't work either. I don't know why this is happening. I did notice in the PHP log that the slashes in the filenames are mixed up. Not sure if that matters or not, but some were |
|
@wellingguzman I just tried a fresh install of Directus from the latest release tag and getting this issue with AWS RDS MySQL. |
|
Hey @DaveBlooman, can please send me any logs, if any, on Are the rest of the table created? |
|
@wellingguzman I resolved my issue. For some reason, when supplying a config.php, it creates an error, but if you leave that file out, run the provisioning via the web UI, it works fine, even though the same file is output. My use case is that I build Amazon Machine Images with code already in, this was the first time i tried the AMI with a new fresh database. I guess there is something for the docs, always run through the web UI with a new database, or provision the database first. |
|
Hey @DaveBlooman, What was the actual problem, I didn't get it. So you meant that you created the How did you create all the core tables, such as I'd love to see what was the actual issue. |
|
I had previous done a setup of Directus in an AWS account by going through the web installer. Once I knew what files i needed, i automated the process and bake amazon images. I attempted to use the existing image with a new database. This didn't work, so i assumed it must be the config.php existence causes Directus to assume a bunch of things, the DB has everything setup for example. I guess I should have a step to setup the DB before Direcuts attempts to start, but i don't intend to setup a third CMS right now. |
Version Info
Expected Behavior
Loading home page after installation
Actual Behavior
Get the following on my page (not in a log):
Steps to Reproduce
Logs or Screenshots
See above
The table
directus_tablesdoesn't exist and wasn't automatically created.The text was updated successfully, but these errors were encountered: