UbitUmarov
7ffb0aca44
fix/clean error messages on MySQLUserProfiles (profilesV2)
2018-01-02 01:51:14 +00:00
UbitUmarov
d32debe618
commit what i did so far for core mutes module, befere i lose it
2017-12-11 23:58:27 +00:00
Melanie Thielker
d35ab8c86c
Donating the Avination Mute Module
...
This lived out-of-tree and therefore wasn't part of the big code
drop. It's classic Avination, tied to MySQL and a direct database
connection and I don't have the bandwidth to fix it to core methods.
However, it has all the strange mute logic that OpenSim was missing
and maybe someone can step up to make it work in an open grid context.
2017-11-14 12:12:07 +00:00
UbitUmarov
f2b54c8cf9
mantis 8200: move changes in PGSQL from last commit to a new transaction (13)
2017-11-12 09:16:32 +00:00
TomTheDragon
6a75b7c65e
PGSQL EstateStore create estate_settings_id SEQUENCE
...
Missing creation for estate_settings_id sequence causes first run
to fail unless manually added.
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-11-12 09:07:09 +00:00
TomTheDragon
56d2db3a18
Add a new experimental implementation of PGSQL FSAssets
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-11-03 05:10:37 +00:00
UbitUmarov
6bf96f83c5
mantis 8212 fix sqlite parameter prefixing
2017-07-23 14:29:11 +01:00
UbitUmarov
04eeb0e5cb
mantis 8212 do use defined sqlite connection
2017-07-22 23:33:03 +01:00
Geir Nøklebye
8f9256ea1c
PGSQL: Another missing cast in XInventoryData
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-22 16:24:52 +01:00
UbitUmarov
dd0269df48
fix passcollisions bool value on store
2017-05-13 17:22:56 +01:00
Geir Nøklebye
7cf82a71d6
PGSQL: Convert PassCollision in table prims to bool to avoid a hopeless cast that fails with newer versions of NPGSQL.
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-13 17:15:47 +01:00
Geir Nøklebye
03a38a80ab
PGSQL: Rewrote EstateStore.migrations as it errored out in version 8 leaving the database without any estate tables on first run. It also lacked primary keys on estate_map and estate_settings. Syntax requires Postgresql 9.5 or higher.
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-09 12:00:45 +01:00
Geir Nøklebye
d952d62baa
PGSQL: Add missing AgentPrefs.migrations
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-08 20:25:03 +01:00
UbitUmarov
8ef43e5fb3
take more heavy work out of opened dbconn sections
2017-05-07 22:22:28 +01:00
UbitUmarov
de55ad9545
oops closed too soon
2017-05-06 22:12:45 +01:00
UbitUmarov
c57215687f
a few more changes on mysql
2017-05-06 21:43:22 +01:00
UbitUmarov
4b2ef46de6
don't hold dbconn longer than necessart
2017-05-06 20:40:29 +01:00
UbitUmarov
76337b1d8e
another misplaced close
2017-05-06 20:38:38 +01:00
UbitUmarov
504736eb43
build const strings a compile time...
2017-05-06 20:23:55 +01:00
UbitUmarov
54eb6fc779
GZipStream does have a CopyTo()
2017-05-06 18:25:07 +01:00
UbitUmarov
eb93855d84
dispose some MemoryStreams
2017-05-06 17:47:43 +01:00
UbitUmarov
025bef4e07
fix a few wrong placement ( this is a test by the way )
2017-05-06 01:47:26 +01:00
UbitUmarov
d26a9ed0b1
fix wrong placement
2017-05-06 01:41:33 +01:00
UbitUmarov
d9038e650a
MySQLConnector is not a MS product
2017-05-06 01:25:54 +01:00
Diva Canto
ab4f870000
Change the engine of the groups table back to MyISAM, because MySQL 5.5 and older don't support full test search on InnoDB
2017-05-04 18:19:46 -07:00
Geir Nøklebye
ebcfad1a83
store the physics inertia override in the database
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-04-20 21:21:23 +01:00
Geir Nøklebye
28125202cc
update for The new Constant: integer OBJECT_REZZER_KEY = 32 + adding missing support for fields in the prims table.
...
Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2017-04-19 14:04:54 -04:00
Geir Nøklebye
fe83763c36
PGSQL: Fixed a failing query in GroupsData for deleting groups messages older than 14 days. The little known abstime function could be used for a double cast. The field TMStamp should be changed to store the data as a proper timestamp. Related to Mantis #7848 . Usually this would easily be solved using the to_timestamp function, but there is no support for it in NPGSQL as there are no very close functionality in .NET
...
Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2017-04-19 13:40:49 -04:00
UbitUmarov
44993550a8
store the physics inertia override in SQlite
2017-04-01 18:15:47 +01:00
UbitUmarov
443fc60cdf
store the physics inertia override in Mysql and add it to serializer. run prebuild is required
2017-04-01 17:49:17 +01:00
Melanie Thielker
680231d7e7
Make the MySqlGeneric layer transaction aware
2017-03-31 14:38:41 +01:00
Melanie Thielker
b16abc8166
Massive tab and trailing space cleanup
2017-01-05 19:07:37 +00:00
Melanie Thielker
53fe204eed
Create all tables ad InnoDB by default
...
MyISAM isn't properly replicated using row based replication. With the
advances in clustering, these systems are becoming more prevalent and
MyISAM isn't up to the task anymore.
2017-01-05 13:35:13 +00:00
Geir Nøklebye
af93822465
PGSQL fixed a missing cast to uuid in XInventoryData
...
Signed-off-by: Melanie Thielker <melanie@t-data.com>
2017-01-04 21:18:58 +00:00
Mandarinka Tasty
7c566dca5a
The new Constant: integer OBJECT_REZZER_KEY = 32;
...
Signed-off-by: Mandarinka Tasty <mandarinka.tasty@gmail.com>
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2016-12-04 17:18:56 +00:00
UbitUmarov
29f6e3fc7b
fix a typo in dbs region range
2016-12-01 04:08:42 +00:00
AliciaRaven
017069636a
Increase float precision for windlight needed by scripts. mySQL Migration on regionwindlight table.
...
mySQL was setup to store smaller values because the viewers editor capped input, scripts can set higher precision so settings could change on region restart. This change brings mySQL more inline with PGSQL which uses doubles for all windlight floats.
2016-11-26 01:15:10 +00:00
UbitUmarov
5202ae7bb4
revert changes to asset desc size, my bad.. this field will possible go away in future
2016-11-24 14:39:08 +00:00
UbitUmarov
7524c7729f
change asset description max size
2016-11-22 01:34:07 +00:00
UbitUmarov
d1baa3e0c3
fix some invalid string.format arguments
2016-11-09 22:39:52 +00:00
UbitUmarov
46dd899d9e
MySQLFSAssetData asset type is a int not a varchar
2016-09-27 21:29:09 +01:00
UbitUmarov
9b2f186a8c
MySQLFSAssetData on store, if a asset already exists, assume its a valid store or regions will keep retry. The other DBs do replace the item, why doesn't FS do the same?
2016-09-27 21:10:01 +01:00
UbitUmarov
092d4fb9ff
fix typo in table name, thx tglion
2016-09-18 20:00:47 +01:00
UbitUmarov
188b5030f7
restore sqlite fixes from commit 0e6874..that got lost
2016-09-17 19:46:40 +01:00
UbitUmarov
71bd3ce49f
add load baked terrain methods
2016-09-17 16:42:40 +01:00
UbitUmarov
3f9f105295
add to databases a table to store baked terrain.
2016-09-17 15:45:11 +01:00
AliciaRaven
f8ac3d9464
Minor, remove unused OSDMap declaration in MySQL profiles
2016-09-15 18:42:28 +01:00
tglion
0e68742afc
Fix some wrong handling of booleans for SeeAVs, AnyAVSounds and GroupAVSounds fields in sqlite3-database
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2016-09-05 08:39:16 +01:00
UbitUmarov
04351cc1c2
asset tests that still need UploadAttempts
2016-09-01 13:01:18 +01:00
UbitUmarov
924aaedfce
assets uploads to grid. Change the retry code. Stop using asset.UploadAttempts field that should be removed
2016-09-01 12:45:09 +01:00