Commit Graph
49 Commits
Author SHA1 Message Date
David Goodwin 023d539fea add comment for #908 ... about sql_generate_invisible_primary_key and MySQL 8 2025-02-28 22:31:55 +00:00
David Goodwin 19b6f96544 mysql does not support DROP CONSTRAINT, looks like it is MariaDB only - see https://github.com/postfixadmin/postfixadmin/issues/591#issuecomment-1021340592 2022-12-06 19:05:34 +00:00
David Goodwin f297ce07c4 code format 2022-12-06 08:56:28 +00:00
David Goodwin 131302951e do not show version_number/0 on setup.php 2022-12-06 08:56:23 +00:00
David Goodwin 80a5a43cb6 update quota/quota2 username collation - see #690 2022-12-06 08:55:40 +00:00
David Goodwin b18ed591a2 bumping php-cs-fixer; formatting rules change slightly 2022-06-28 13:31:37 +01:00
David Goodwin 91af829108 update changelog; add changelog entry 2022-03-14 14:48:34 +00:00
David Goodwin ab496bda29 also fix collation on domain_admins.domain to be latin1_general_ci - see also #327 (else a domain admin cannot login)
See #595
2022-03-14 14:45:16 +00:00
David Goodwin c59894d2c6 formatting! 2021-05-08 20:29:26 +01:00
David Goodwin d654651468 explode on errors when performing db upgrade; try and fix #498 by updating domain created/modified columns to something MySQL might be happier with 2021-05-08 20:15:05 +01:00
David Goodwin 63f267f0fa merge in e8f3c40442 and bbec16aac1 from master -> see #475 - add primary key column to domain_admins (id autoinc.) to help people who want to use db replication 2021-04-13 21:45:10 +01:00
David Goodwin 1c456baa56 see: #475 - add domain_admins.id pk autoincrement field 2021-04-13 21:42:54 +01:00
David Goodwin 481c465712 merge e7e1ce9c28 to fix PostgreSQL tests 2021-01-19 19:24:08 +00:00
David Goodwin 2b33e8f3c3 remove conditional; should be unnecessary 2020-11-09 21:50:17 +00:00
David Goodwin ca24ff8300 perhaps improve logging - see : https://github.com/postfixadmin/postfixadmin/issues/364 2020-06-15 17:12:42 +01:00
David Goodwin 3cd62f9f4f update to phpunit v8, try changing coveralls library, update github action 2020-04-14 21:03:10 +01:00
David Goodwin ec2fbfd87f skip this query - for a new database it will run before the domain table has been created and just error 2020-02-12 21:19:49 +00:00
David Goodwin fd35dada38 try and be consistent with MySQL table types/collations - see https://github.com/postfixadmin/postfixadmin/issues/327 2020-02-12 21:15:04 +00:00
David Goodwin 80a0faa633 specify a default table collation / charset for MySQL - might help fix https://github.com/postfixadmin/postfixadmin/issues/327 2020-02-11 20:02:34 +00:00
David Goodwin 87824ef970 psalm fixes/workarounds; require PHP 5.6+ 2019-10-19 20:51:05 +01:00
David Goodwin 06513c2a14 remove quotes around table name which is not necessary as table_by_key does this 2019-02-16 19:46:31 +00:00
David Goodwin fe48b35cfd split multiple queries into single ones to keep pdo/prepared statements happy 2019-02-15 21:59:11 +00:00
Christian Boltz acf20bbc9e move comments to the beginning of upgrade.php 2019-01-28 00:47:24 +01:00
David Goodwin 66747337f9 fix formatting 2019-01-16 10:31:16 +00:00
David Goodwin 7f8fd5ec1a Merge branch 'master' into feature-try-pdo 2019-01-16 09:23:29 +00:00
David Goodwin 83a4ee39b0 more phpdoc 2019-01-16 09:23:09 +00:00
David Goodwin 26d769740c silence some psalm warnings 2019-01-16 09:19:04 +00:00
David Goodwin e9d12bf918 silence some psalm warnings 2019-01-16 09:17:56 +00:00
David Goodwin 570972944d Merge remote-tracking branch 'origin/master' into feature-try-pdo 2019-01-08 13:38:38 +00:00
David Goodwin 18312a8aaa formatting... 2019-01-07 22:02:04 +00:00
David Goodwin 020343999a Merge pull request #221 from SuperVirus/fetchmail_different_source_port
Allow different port for fetchmail
2019-01-07 21:56:28 +00:00
David Goodwin 98536f03e8 fix sqlite upgrade check; remove test database between runs; ignore lib/array_column.php from linting 2019-01-06 21:39:54 +00:00
David Goodwin 803e2342f8 fix psalm issues; reformat; rename new db functions 2019-01-06 21:32:58 +00:00
David Goodwin 1176c9ce78 reformat; fix some transition bugs 2019-01-06 21:32:58 +00:00
David Goodwin ea33d9951a try migrating to pdo 2019-01-06 21:32:58 +00:00
David Goodwin 78276534d9 remove error log prefix; use db_mysql 2019-01-03 19:36:40 +00:00
David Goodwin b2e814967f try and get working under travis ... 2018-12-29 21:45:12 +00:00
David Goodwin 4fcdba9cf4 run php-cs-fixer (code reforamt) 2018-12-28 19:31:43 +00:00
David Goodwin 166574efae add {IF_NOT_EXISTS} for sqlite tables - see #225 2018-12-28 13:08:59 +00:00
David Goodwin 74002bbf57 psalm fixes 2018-12-27 21:43:11 +00:00
Christoph 'SuperVirus' Heitkamp d35e66808b Allow different port for fetchmail 2018-12-17 13:29:07 +01:00
David Goodwin a455916a6b add password expiry stuff to the db schema upgrade script 2018-08-28 21:15:45 +01:00
David Goodwin 6100ca4cf9 try and fix #177 (add missing fields to sqlite db) 2018-05-25 09:59:31 +01:00
David Goodwin 9c7f60fa76 possible fix for sqlite schema/upgrade issues; see #177 and and #176 2018-05-23 22:10:56 +01:00
David Goodwin c147eb053b move to use db_assoc() rather than db_array() (code assumes assoc. array) 2018-02-10 21:08:29 +00:00
David Goodwin 828e3b2290 yet another datetime in the future that needs changing a little... 2018-01-30 15:53:42 +00:00
Adrien Crivelli 15df6c1d7b Reformat everything with PHP-Cs-Fixer 2018-01-26 23:54:37 +09:00
David Goodwin 2bb583a86a remove specifying MYISAM as our default db table format; use whatever the db server wants to default to 2018-01-25 21:08:26 +00:00
David Goodwin 99147d51eb move public facing stuff into public/, this allows us to stop exposing templates_c/ etc to the world 2018-01-25 20:27:09 +00:00