David Goodwin
|
08ce130d58
|
try and improve mysql db collation fix - see #591
|
2022-02-14 21:36:33 +00:00 |
|
David Goodwin
|
66c71418a6
|
mysql does not support DROP CONSTRAINT, looks like it is MariaDB only - see https://github.com/postfixadmin/postfixadmin/issues/591#issuecomment-1021340592
|
2022-01-25 16:58:35 +00:00 |
|
David Goodwin
|
52ed517f35
|
also fix collation on domain_admins.domain to be latin1_general_ci - see also #327 (else a domain admin cannot login)
|
2021-12-07 19:42:49 +00:00 |
|
David Goodwin
|
047774b250
|
reorder upgrade sql, see #561
|
2021-11-21 21:32:24 +00:00 |
|
David Goodwin
|
7dcfb00377
|
composer format
|
2021-11-10 19:48:20 +00:00 |
|
David Goodwin
|
2ab28e795d
|
fix more collation issues
|
2021-11-10 19:43:14 +00:00 |
|
David Goodwin
|
1018847cd5
|
fix formatting
|
2021-10-21 22:10:49 +01:00 |
|
David Goodwin
|
ba825ef3c1
|
see #506 and #327 - this might unify enough of our textual latin1 columns to resolve collation issues
|
2021-10-21 22:08:25 +01:00 |
|
David Goodwin
|
b271ae8cb8
|
composer format!
|
2021-05-13 13:17:07 +01:00 |
|
David Goodwin
|
8518d53906
|
merge postfixadmin_3.3 into master
|
2021-05-13 13:15:27 +01:00 |
|
David Goodwin
|
59f0b89233
|
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:11:58 +01:00 |
|
David Goodwin
|
b9ca22c918
|
change mailbox.name to be utf8mb4 too - see #484
|
2021-05-07 20:07:18 +01:00 |
|
David Goodwin
|
4e7b69e04c
|
formatting
|
2021-05-07 19:54:17 +01:00 |
|
David Goodwin
|
df34c100ea
|
schema changes for https://github.com/postfixadmin/postfixadmin/pull/484 - changing vacation.subject and vacation.text to be utf8mb4
|
2021-05-07 19:52:45 +01:00 |
|
David Goodwin
|
e8f3c40442
|
ignore this for sqlite which does not like a pk field being added
|
2021-04-13 21:26:11 +01:00 |
|
David Goodwin
|
2edabc3e03
|
phpcs insists on some brace changes
|
2021-04-13 21:19:16 +01:00 |
|
David Goodwin
|
bbec16aac1
|
see: #475 - add domain_admins.id pk autoincrement field
|
2021-04-13 21:08:49 +01:00 |
|
David Goodwin
|
e7e1ce9c28
|
fix postgresql test
|
2021-01-19 16:50:56 +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 |
|