Google Datatstoreは、型定義もテーブル定義もせずがんがんデータ突っ込めます。
が、デフォルトのままデータ入れていると、1500バイトを超えたところで、PHPの場合、500エラーで止まります。
エラーメッセージは、The value of property "data" is longer than 1500 bytes という感じ。
1384行目くらい 'titleformatmonth' => 'F Y年'
↓ 'titleformatmonth' => 'Y年 F'
イベント日の取得方法
それぞれの日付は下記の関数で取得します。
開始日：eo_get_schedule_start()
終了日：eo_get_the_end()
eo_get_schedule_last()というのもあるらしく引っかかりました...
eo_get_schedule_start()
修正ファイルの648行目あたりに該当箇所があります。
function eo_get_schedule_start($format='Y年n月j日',$post_id=0){
$post_id = (int) ( empty($post_id) ? get_the_ID() : $post_id);
$schedule = eo_get_event_schedule($post_id);
$schedule_start = $schedule['schedule_start'];
/**
* Filters the value returned by `eo_get_schedule_start()`
*
* @param string|DateTime $formatted_date The DateTime object or formatted returned value (as determined by $format)
* @param DateTime $end The start date of the first occurrence of this event as a DateTime object
* @param string $format The format the date should be returned in
* @param int $post_id Post ID of the event
*/
$formatted_date = apply_filters('eventorganiser_get_schedule_start', eo_format_datetime( $schedule_start, $format ), $schedule_start, $format, $post_id );
return $formatted_date;
}
$format='Y年n月j日'と自分好みの形式に設定しておきます。
eo_get_the_end()
こちらは408行目くらいです。
こちらも同様に$formatを直しておきます。
function eo_get_the_end( $format = 'Y年n月j日', $post_id = 0, $occurrence_id = 0, $deprecated = 0 ) {
global $post;
$event = $post;
if( !empty( $deprecated ) && empty( $occurrence_id ) ){
//_deprecated_argument( __FUNCTION__, '3.0.0', 'Fourth argument is depreciated. Please use the third argument, the occurrence ID, available from $post->occurrence_id' );
$occurrence_id = $deprecated;
}
$post_id = (int) ( empty($post_id) ? get_the_ID() : $post_id);
$occurrence_id = (int) ( empty($occurrence_id) && isset($event->occurrence_id) ? $event->occurrence_id : $occurrence_id);
$occurrence = eo_get_the_occurrence( $post_id, $occurrence_id );
if ( ! $occurrence ) {
return false;
}
$end = $occurrence['end'];
/**
* Filters the value returned by `eo_get_the_end()`
*
* @param string|DateTime $formatted_end The DateTime object or formatted returned value (as determined by $format)
* @param DateTime $end The end date as a DateTime object
* @param string $format The format the end date should be returned in
* @param int $post_id Post ID of the event
* @param int $occurrence_id The occurrence ID
*/
$formatted_date = apply_filters( 'eventorganiser_get_the_end', eo_format_datetime( $end, $format ), $end, $format, $post_id, $occurrence_id );
return $formatted_date;
}
It's recommended that you have full UTF-8 support configured in MySQL. If this is not done some character sets, notably emojis, cannot be used. It is possible to do this after your site is installed but it is much easier before installation.
First check if this is already configured by running the following statement, e.g. at the mysql> prompt or in phpMyAdmin:
SHOW GLOBAL VARIABLES WHERE variable_name IN ('innodb_file_format', 'innodb_large_prefix', 'innodb_file_per_table');
Variable_name Value
innodb_file_format Barracuda
innodb_file_per_table ON
innodb_large_prefix ON
If the three settings you see match the above list then no further configuration changes are needed and you can skip to Creating Moodle database.
If your settings do not match this list then you will have to edit your MySQL configuration file. On Linux this may be the file /etc/my.cnf or /etc/mysql/my.cnf, on Microsoft Windows it may be my.ini.
Note: You should back up your configuration file before changing it.
Note: You should back up your databases before making this change.
Note: Other systems using databases on this server may be impacted by this change.
Add the following settings to the configuration file:
If you have any difficulty applying these settings, see MySQL_full_unicode_support for further information.
If for some reason you cannot change to the recommended settings as described here you can continue to install Moodle, however you must select utf8 and utf8_unicode_ci for the default character set and collation respectively.
2 Moodle データベースを作成する
These are the steps to create an empty Moodle database. Substitute your own database name, user name and password as appropriate.
The instructions assume that the web server and MySQL server are on the same machine. In this case the 'dbhost' is 'localhost'. If they are on different machines substitute the name of the web server for 'localhost' in the following instructions and the 'dbhost' setting will be the name of the database server. Databases have a "Character set" and a "Collation". For Moodle, we recommend the Character Set be set to utf8mb4 and the Collation utf8mb4_unicode_ci. You may get the option to set these values when you create the database. If you are not given a choice, the default options are probably good. An install on an old server may have the wrong settings.
2.1 コマンドライン
To create a database using the 'mysql' command line client, first log into MySQL
$mysql -u root -pEnter password:
(Enter the password you previously set - or been given - for the MySQL 'root' user). After some pre-amble this should take you to the mysql> prompt.
Create a new database (called 'moodle' - substitute your own name if required).
If you have successfully configured the recommended full UTF-8 support as described above run:
...which creates a user called 'moodleuser' with a password 'yourpassword'. Make sure you invent a strong password and resist the temptation to 'GRANT ALL'.
Exit from mysql:
mysql>quit
2.2 phpMyAdmin
phpMyAdmin is a web based administration tool for MySQL. If this is available you can use it to create a new database. If you have successfully configured the recommended full UTF-8 support as described above select collation utf8mb4_unicode_ci. If you do not have the recommended full UTF-8 support select collation utf8_unicode_ci.
3 どのデータベースがどの Moodle に属しているか
If you have installed several Moodle installations on the same server, there will be several databases in your MySQL server. The names might be quite poor reflections of the content like mdl1 mdl2 _mdl3 . So how do I see which database goes with which Moodle installation? You can go in with phpMyAdmin and in the various databases check for the table "mdlcourse". There you will easily see the name of that Moodle Installation. In table mdlconfig you can see the Moodle version. The main URL for the site is not in the database except where there are absolute links.
