Ask Your Question

paradigm's profile - activity

2020-03-04 02:52:05 +0200 received badge  Famous Question (source)
2020-02-24 06:19:56 +0200 received badge  Famous Question (source)
2019-11-02 21:41:51 +0200 received badge  Student (source)
2019-01-16 02:31:15 +0200 received badge  Famous Question (source)
2018-09-12 07:45:37 +0200 commented answer Will subreports ever be available in Base report builder?

I searched and found several free reporting packages, but they all seem like overkill. After going through the trouble o

2018-09-09 13:43:54 +0200 received badge  Notable Question (source)
2018-09-06 10:59:11 +0200 received badge  Popular Question (source)
2018-09-06 04:05:58 +0200 marked best answer Primary key fields are starting at 1 instead of 0

Please forgive me because this isn't actually a LO issue, (it happens in Workbench too) but I'm new at using LO with MySQL and I'm trying to figure some things out.

With auto increment on, in an INT(10) primary key field, when I enter data either though LibreOffice Base or directly through the workbench, the first record starts at 1 instead of 0 (like I'm used to). Is that supposed to happen, or is something wrong?

Specs: LibreOffice Version: 6.1.0.3 Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1 CPU threads: 6; OS: Linux 4.15; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); Calc: CL

Ubuntu version 18.04.1 LTS (Bionic Beaver)

mysql Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using EditLine wrapper

Using JDBC mysql-connector-java-8.0.12.jar

2018-09-06 04:04:56 +0200 marked best answer LibreOffice Base displays MySQL date fields off by one day

I have Base connected to my localhost MySQL server with a regular table with a date field in it. I open the table in base and enter a date into the date field, and after it updates it displays the date minus one day. When I view the database through MySQL Workbench, the dates are recorded correctly, despite continuing to come up as one day earlier when viewed through Base.

I fixed it

Incidentally, earlier I had trouble connecting to my database due to a timezone error. For some reason it had a problem with my EDT time zone. So I fixed it by adding the line "default_time_zone='+04:00'" to my mysqld.cnf. While I was writing this question I realized that my timezone is actually -4:00. I changed it and that solved the issue.

Base now shows the same time as other MySQL viewers, for now at least. However When daylight savings time ends, it's probably going to display the wrong date when viewed between 11:00pm and midnight unless I edit the timezone to -5:00, which I probably wont remember to do.

So the question remains, why should time timezone of my server effect the date data read from a field? Maybe for timestamps I could understand but for past dates that I want to record, it seems like the timezone shouldn't have any effect on how a past date is displayed. Especially when it's recorded correctly in the table. I mean, a person's birthday should be read the same no matter what timezone their server is in.

To be fair, I don't know if this is a Base issue or a JDBC issue. For testing purposes I guess I could set the timezone back to +4:00 and connect using ODBC and see if it has the same issue. But I'll have to save that for later, I've have quite enough for now.

Specs: LibreOffice Version: 6.1.0.3 Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1 CPU threads: 6; OS: Linux 4.15; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); Calc: CL

Ubuntu version 18.04.1 LTS (Bionic Beaver)

mysql Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using EditLine wrapper

Using JDBC mysql-connector-java-8.0.12.jar

2018-09-06 04:04:56 +0200 received badge  Scholar (source)
2018-09-06 03:58:44 +0200 answered a question Explained: Incomprehensible base tutorial (Automobile fuel)

I found amazing help for this in the community. There is an awesome youtube tutorial located at https://www.youtube.com

2018-09-06 03:25:33 +0200 answered a question when i download the file contains bank account numbers its automatically erase leading zeroes what i do

Right-Click on the column and chose "Format Cells" Leave it on"Number" in category and go to where it asks how many "Le

2018-09-06 03:12:35 +0200 asked a question Primary key fields are starting at 1 instead of 0

Primary key fields are starting at 1 instead of 0 Please forgive me because this isn't actually a LO issue, (it happens

2018-09-04 05:46:12 +0200 commented answer auto increment with MySQL

Using the latest version of LibreOffice. Ver 6.1.0.3, on Ubuntu 18.04.1 LTS. I'm having the same issue as the OP. I'm u

2018-08-29 16:47:06 +0200 received badge  Notable Question (source)
2018-08-29 09:26:10 +0200 received badge  Popular Question (source)
2018-08-29 07:53:17 +0200 received badge  Editor (source)
2018-08-29 07:53:17 +0200 edited question Will subreports ever be available in Base report builder?

Will subreports ever be available in Base report builder? I would like to prepare reports that include unrelated informa

2018-08-29 07:34:00 +0200 commented answer Will subreports ever be available in Base report builder?

Thanks for your input. I have included more information.

2018-08-29 07:33:39 +0200 edited question Will subreports ever be available in Base report builder?

Will subreports ever be available in Base report builder? I would like to prepare reports that include unrelated informa

2018-08-29 01:13:14 +0200 asked a question Will subreports ever be available in Base report builder?

Will subreports ever be available in Base report builder? I would like to prepare reports that include unrelated informa

2018-08-28 23:07:12 +0200 received badge  Notable Question (source)
2018-08-28 17:52:04 +0200 received badge  Popular Question (source)
2018-08-28 07:07:53 +0200 commented question LibreOffice Base displays MySQL date fields off by one day

Apparently correcting the time zone also fixed my relationships model. Previously my relationships model showed the tab

2018-08-28 06:45:13 +0200 asked a question LibreOffice Base displays MySQL date fields off by one day

LibreOffice Base displays MySQL date fields off by one day I have Base connected to my localhost MySQL server with a reg