14,601 questions
Score of 4
4 answers
187 views
Mariadb function does not work in version 11.8
I created liquibase script to run a mariadb function.
the script was running without any issue in mariadb 10.6 (SIT)
however, when I run it in another server ( UAT ) that has been migrated to 11.8.3 ...
- reputation score 7122
Advice
0
votes
2
replies
84
views
Best way to have a Galera node that does nothing
So, I have four devices running WordPress, with their DBs synced using Galera over Tailscale, but I wanted to know if there's a way to add a fifth DB-only node that participates in voting but doesn't ...
- reputation score 1
Score of -1
1 answer
130 views
Tags in Django With MariaDB [closed]
I'm trying to make a website and part of that is having tags much like this site has. I'm trying this:
def index(request):
storylist = Story.objects.order_by("id")
tagslist = []
...
- reputation score 19
Best practices
0
votes
1
replies
75
views
Designing a modular ERP with Symfony + MariaDB + Bootstrap – best practices?
I’m currently working on an ERP project at Göhltec and I’d like to get some input from the community regarding architecture and best practices.
**Stack we’re using**
Backend: Symfony (API-first ...
- reputation score 13
Score of 1
2 answers
157 views
how to calculate concurrent call by cdr
I have two tables
table testlist20230519_20
cdrid
starttime
endtime
641EA5F600041BC4
1684425611.337
1684425619.687
641EA5F600041BC5
1684425612
1684425618
641EA5F600041BC6
1684425610.082
1684425617.436
...
- reputation score 33
Advice
1
vote
5
replies
175
views
Node.js MariaDB: "Incorrect number of arguments" or syntax error on INSERT, but SELECT works
I am building a basic REST API using Express and the mariadb connector. My GET route works perfectly and returns the data from the database, but I am struggling with the POST route. Every time I try ...
user32739011
Score of -1
1 answer
88 views
Mariadb 11.8 returns NULL for FROM_UNIXTIME(0)
I am trying to figure out why FROM_UNIXTIME(0) returns NULL instead of 1970-01-01 00:00:00.
I am running the following inside MariaDB:
SELECT FROM_UNIXTIME(0);
My sql_mode is NO_ENGINE_SUBSTITUTION.
I ...
- reputation score 11
Advice
1
vote
3
replies
92
views
How to migrate existing custom versioning (validFrom/validUntil) to MariaDB system versioning?
I have a MariaDB 11.8.6 database with 142 tables.
Most tables have two additional columns:
validFrom DATETIME(3) - tracks when the record was created.
validUntil DATETIME(3) - tracks when the record ...
- reputation score 87
Score of 0
1 answer
123 views
How to change MariaDB port?
I’ve installed MariaDB (11.4.9) next to MYSQL (5.7) in wamp (3.4) as the new relational database engine to test my applications.
I had an issue with the connection ports. As MySQL uses port 3306, my ...
- reputation score 783
Best practices
2
votes
7
replies
158
views
Blob data in MariaDb - where/how is it stored?
I've searched for this answer a dozen different ways and found answers that dance around the answer that I am interested in.
Concerning blob data in MariaDb or MySQL - I want to store an arbitrary ...
- reputation score 1
Score of 5
1 answer
155 views
MariaDB import csv file that doesn't have commas at the end of lines [closed]
I'm trying to import a CSV file to a MariaDB table using this query:
load data local infile 'C:\\Users\\Kevin\\Downloads\\TCGToday.csv'
into table tcgtoday
fields terminated by ','
optionally enclosed ...
- reputation score 53
Advice
0
votes
3
replies
199
views
mediadb_docker mediawiki MYSQL_DATABASE
services:
wiki:
image: mediawiki
container_name: ---
restart: always
ports:
- 8080:80
volumes:
- images:/var/www/html/images
mariadb:
image: mariadb
...
- reputation score 1
Score of 4
1 answer
103 views
Program in GNU GCC Error access database: SQL: TLS/SSL error: SSL is required, but the server does not support it [duplicate]
I'm trying to create a program that connects to a MariaDB server. The code works perfectly if I use the library that comes with the server, but when I use the updated version compiled from the MariaDB ...
- reputation score 89
Score of -2
1 answer
111 views
Dynamic query is producing duplicate columns
I created the following dynamic query to get some information from my Olympic table:
DROP TEMPORARY TABLE IF EXISTS temp_min_year;
CREATE TEMPORARY TABLE temp_min_year AS
SELECT Sport, Event, Gender, ...
- reputation score 55
Score of 3
2 answers
174 views
SQL count multiple columns and combine columns count
I have a table with a column 'requested_lang' and 'origin_lang'.
requested_lang
origin_lang
English
Dutch
NULL
Dutch
English
English
NULL
Dutch
NULL
English
Dutch
English
Currently I am counting the ...
- reputation score 66