IT Rapt

Tag: mysql

  • Cannot Add or Update a Child Row: A Foreign Key Constraint Fails

    I encountered this error when I tried to add a new child row using CakePhp. Checking around forums and coding sites, there is always one suggestion whenever somebody asks this question – make sure that the foreign key exists in the parent table. I made sure that the key exists in the parent table, but […]

  • Setting Up phpMyAdmin Configuration Storage on a Synology DiskStation

    Setting Up phpMyAdmin Configuration Storage: Import create_tables.sql from phpMyAdmin’s examples folder to MySQL. When upgrading from a previous phpMyAdmin installation then import upgrade_tables_mysql_4_1_2+.sql before importing create_tables.sql. Create user `pma` and grant access to the database `phpmyadmin` GRANT SELECT, INSERT, UPDATE, DELETE ON `phpmyadmin`.* TO ‘pma’@’localhost’; Uncomment phpMyAdmin configuration storage settings in config.inc.php/* /* Storage database […]