Mario Vavti
fbe8d6144a
port db_indexes() from zap
2019-05-13 10:46:12 +02:00
Daniel Lowe
9a6531e2a2
Fix infinite loop using postgres as backend
...
unescapebin is handed a string in some cases, and it causes an infinite
loop when it does. This ensures that the argument is a resource before
loading its contents.
2019-04-21 11:14:17 +00:00
Max Kostikov
42f96dc7a6
Fix use UNIX socket file to connect DB
2019-04-10 14:13:16 +02:00
Andrew Manning
108a892a11
Remove DNS check for database connection during installation. Causes friction with Docker deployment.
2018-11-09 05:31:55 -05:00
Mario Vavti
5c4fbbebe1
refine stream filter and forum notification behaviour (mostly for performance). personal posts will be displayed in unthreaded mode and clicking a forum notification will show only the unseen items of the forum in unthreaded mode. group the filters in the widget - threaded at the top, unthreaded beneath.
2018-10-24 20:58:25 +02:00
zotlabs
cd200ee706
The channel import page seems to have missed the big theme cleanup of the last couple of years.
2018-05-01 19:38:32 -07:00
zotlabs
518db97962
never mind. dbg(1) now gives you the basic debug result and dbg(2) gives you the verbose debug option with all the results.
2018-04-14 16:56:30 -07:00
zotlabs
fdf5799857
allow dbg(2) to only return the canonical SQL used in the query and the number of results, but not log every single result. Maybe we should use 1 for this and 2 for the full results, but I didn't really want to change the way people do things today. If anybody has a strong opinion about doing this, go ahead and change it and send a note to the developer forum.
2018-04-14 16:47:51 -07:00
Klaus Weidenbach
4bf0c9e36a
✅ Add tests for non existent tables.
...
Prevent PHP warnings "Undefined variable" in dba_pdo::q();
2018-01-28 23:02:46 +01:00
Klaus Weidenbach
509844fd7e
🔥 Cleanup old database related files.
...
Remove non used database drivers, remove unused methods.
Improve documentation.
2018-01-28 23:02:15 +01:00
Mario Vavti
a86b260f73
query optimisations for notifications - use a specific index only
2018-01-28 12:09:47 +01:00
Klaus Weidenbach
8a60bb4619
Change dsn port handling in dba_pdo.
2018-01-18 23:46:49 +01:00
zotlabs
2d119c81a4
turn platform name and std_version into config variables
2017-07-13 20:18:19 -07:00
zotlabs
6c771f84ce
remove unused page_widgets.php include and provide a general function for loading sql from file to use in the cdav migration
2017-06-22 22:43:08 -07:00
zotlabs
3a00140797
remove php version checks for older ( < 5.4) code incompatibilities
2017-05-23 21:20:40 -07:00
zotlabs
1c8c7479b8
Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge
2017-05-22 03:51:58 -07:00
Mario Vavti
a44c908147
silence php warning during install
2017-05-17 11:24:27 +02:00
zotlabs
33ff7bf968
provide platform specific install script
2017-03-31 10:27:28 +02:00
zotlabs
5c63f7dd58
provide platform specific install script
2017-03-25 14:19:32 -07:00
zotlabs
6f3493bb3c
db issues
2017-03-12 15:50:47 -07:00
zotlabs
6cf17c7bcc
use array_shift - it's cleaner
2016-12-15 16:41:01 -08:00
zotlabs
83a4999dbe
issue #606 , postgres binary data handling under PDO and HHVM when passed null
2016-11-30 19:45:46 -08:00
zotlabs
793047919d
missed this from the earlier checkin
2016-11-29 02:57:29 -08:00
zotlabs
3b6248cb64
dba_pdo: return false on q() DB error like the old driver did
2016-11-17 15:15:34 -08:00
zotlabs
b5c72611b4
change log string on pdo log messages
2016-10-27 15:21:40 -07:00
zotlabs
88a68b941f
put all dns checking into one function, allow it to be ignored
2016-10-25 18:27:32 -07:00
zotlabs
084b41fc2c
first cut at edit activities
2016-10-25 16:21:56 -07:00
zotlabs
7b713e2576
pdo - fetch assoc only
2016-10-25 16:15:39 -07:00
zotlabs
25982f0475
set port if non-zero (instead of non-null)
2016-10-24 18:55:11 -07:00
zotlabs
20194bed42
this seems to work, but there are unanswered questions and is still undergoing investigation. It appears that the data stored with os_content = 1 is not being escaped in all circumstances or the scaled image data is being escaped twice.
2016-10-23 21:27:10 -07:00
zotlabs
39f0707201
fetch bytea as stream
2016-10-23 17:53:34 -07:00
zotlabs
d30892ea60
pdo hacks
2016-10-23 17:05:08 -07:00
zotlabs
04ac04e0ad
allow a dsn override to the database via the server argument. This could be used to allow unix domain sockets and other unusual configurations.
2016-10-20 17:04:43 -07:00
zotlabs
29340152b6
pdo - cleanup
2016-10-20 16:21:15 -07:00
zotlabs
e2e3b81f32
more pdo tweaks
2016-10-20 16:13:06 -07:00
zotlabs
b4b5eb5bab
pdo testing
2016-10-20 15:45:48 -07:00
zotlabs
3726b546d5
use pdo for postgres also
2016-10-19 19:24:12 -07:00
zotlabs
2702b82bc3
pdo fixes
2016-10-19 17:23:06 -07:00
zotlabs
aee4f8d2fe
pdo changes first cut
2016-10-19 16:58:26 -07:00
zotlabs
716a83d1f7
some pdo work
2016-10-17 16:12:32 -07:00
zotlabs
6532972e61
additional array checking
2016-10-13 00:30:41 -07:00
zotlabs
9bb847bb07
remove the rest of the backticks from sql queries; replace with TQUOT const which is driver dependent
2016-10-12 18:15:12 -07:00
Mario Vavti
ffee413d2d
fix dbescdate()
2016-09-28 12:43:02 +02:00
redmatrix
44a2cc872c
apply the same fix to our own DB as we did for hubzilla master and redmatrix.
2016-09-26 19:28:04 -07:00
redmatrix
cacdac16aa
next wave of nulldate fixes
2016-09-26 18:16:43 -07:00
redmatrix
d3369384d1
include port in pdo url when host is 'localhost'
2016-08-23 18:18:05 -07:00
redmatrix
1267d995ef
db statement debugging
2016-06-22 19:08:59 -07:00
redmatrix
00b4843425
provide a sort of mutex lock around db logging so it can't possibly recurse. Previous attempts to do something similar using other methods haven't worked out satisfactorily.
2016-05-31 16:16:54 -07:00
redmatrix
516c43ba15
more work associated with DBA and index.php shuffle
2016-05-24 17:54:45 -07:00
redmatrix
84ba6393ad
relocate index and db
2016-05-24 16:36:55 -07:00