Error Request failed with status code 400 missing or malformed jwt #139

New Issue

FanyangMengDev · 2020-02-17T06:53:02Z

FanyangMengDev commented

2020-02-17 06:53:02 +00:00

When finnaly install Vikunja with binary file, and correctly set the frontend nginx.

I still keep getting this error message.

It directly caused me cannot register and when I viewing my own Vikunja/login it displays 404.

Please help me, thank you so much in advance.

When finnaly install Vikunja with binary file, and correctly set the frontend nginx. I still keep getting this error message. It directly caused me cannot register and when I viewing my own Vikunja/login it displays 404. Please help me, thank you so much in advance.

FanyangMengDev commented

2020-02-17 07:08:43 +00:00

When I open the port which the backend binded, it just displays not found too.
Why this happened?
Really wanna have a try on Vikunja but this thing holds me back.

When I open the port which the backend binded, it just displays not found too. Why this happened? Really wanna have a try on Vikunja but this thing holds me back.

konrad commented

2020-02-17 16:49:17 +00:00

Can you show me your nginx configuration?

konrad commented

2020-02-17 16:52:27 +00:00

Am I assuming correctly you mean this message which appears when you acces the frontend for the first time:

That is a bug, it always appears when you're not logged in.
It does not prevent you from logging in though, have you tried registering/logging in despite the error message?

Am I assuming correctly you mean this message which appears when you acces the frontend for the first time: ![image](/attachments/d1154ed8-1154-4a30-97b9-27f8438bbe23) That is a bug, it always appears when you're not logged in. It does not prevent you from logging in though, have you tried registering/logging in despite the error message?

image.png

9.4 KiB

FanyangMengDev commented

2020-02-17 16:59:16 +00:00

No, it is not 401, it is 400 and the error message is displaying just like the title of this issue. I just delete all the Vikunja files cause I have been working on it for almost whole day and it drives me crazy.

From the shell it displays that the backend api has already worked well. But when I open the backend panel it displays just one sentence:"Not found". And when I type the front end url, although it can redirect to /login automatically, but it still displays error code 400 which means there is something wrong with jwt. I tried jwt code in two versions, one is just leave it without any customization, one is your config example in your offical doc site, neither of them works.

If you need to see the nginx configuration I can reproduce all of this. Please allow me a few minutes.

No, it is not 401, it is 400 and the error message is displaying just like the title of this issue. I just delete all the Vikunja files cause I have been working on it for almost whole day and it drives me crazy. From the shell it displays that the backend api has already worked well. But when I open the backend panel it displays just one sentence:"Not found". And when I type the front end url, although it can redirect to /login automatically, but it still displays error code 400 which means there is something wrong with jwt. I tried jwt code in two versions, one is just leave it without any customization, one is your config example in your offical doc site, neither of them works. If you need to see the nginx configuration I can reproduce all of this. Please allow me a few minutes.

FanyangMengDev commented

2020-02-17 17:09:47 +00:00

Is there anything wrong on your MinIO server? Cause now the download speed from my end is extremely slow which is just 10KB/s

konrad commented

2020-02-17 17:15:14 +00:00

What do you get with

curl -X GET http://[YOUR VIKUNJA URL]/api/v1/info

?

What do you get with ``` curl -X GET http://[YOUR VIKUNJA URL]/api/v1/info ``` ?

konrad commented

2020-02-17 17:17:52 +00:00

Is there anything wrong on your MinIO server? Cause now the download speed from my end is extremely slow which is just 10KB/s

Download speeds are fine on my end, what speeds do you get normally?

> Is there anything wrong on your MinIO server? Cause now the download speed from my end is extremely slow which is just 10KB/s Download speeds are fine on my end, what speeds do you get normally?

FanyangMengDev commented

2020-02-17 17:19:16 +00:00

Before install it again, I need to ask you that what should I input in this option?
I tried not to change it and change it as your official doc site config example file and it seems both of them do not working

Download speeds are fine on my end, what speeds do you get normally?

Just finished downloading it, lets forget this thing first

Before install it again, I need to ask you that what should I input in this option? I tried not to change it and change it as your official doc site config example file and it seems both of them do not working > Download speeds are fine on my end, what speeds do you get normally? Just finished downloading it, lets forget this thing first

捕获.PNG

3.7 KiB

konrad commented

2020-02-17 17:26:01 +00:00

The JWTSecret option is used to sign jwt tokens which the api gives to the user after logging in. You can leave the value empty and Vikunja will randomly generate a new secret every time it is started, that means your users would need to login again each time you restart Vikunja. For testing, it is fine to leave it empty.

The `JWTSecret` option is used to sign jwt tokens which the api gives to the user after logging in. You can leave the value empty and Vikunja will randomly generate a new secret every time it is started, that means your users would need to login again each time you restart Vikunja. For testing, it is fine to leave it empty.

konrad commented

2020-02-17 17:32:48 +00:00

If you want to use the mailer, you need to change this part

mailer:
  # Whether to enable the mailer or not. If it is disabled, all users are enabled right away and password reset is not possible.
  enabled: false

to

mailer:
  # Whether to enable the mailer or not. If it is disabled, all users are enabled right away and password reset is not possible.
  enabled: true

Can you reach the instance from the same host with

curl -X GET http://localhost:9855/api/v1/info

Also, can you show me your nginx config?

If you want to use the mailer, you need to change this part ``` mailer: # Whether to enable the mailer or not. If it is disabled, all users are enabled right away and password reset is not possible. enabled: false ``` to ``` mailer: # Whether to enable the mailer or not. If it is disabled, all users are enabled right away and password reset is not possible. enabled: true ``` Can you reach the instance from the same host with ``` curl -X GET http://localhost:9855/api/v1/info ``` Also, can you show me your nginx config?

FanyangMengDev commented

2020-02-17 17:33:46 +00:00

Just finish install the backend and this means it works well right?

1.PNG

37 KiB

konrad commented

2020-02-17 17:35:20 +00:00

This means it is running, yes. But if you still can't reach it from the outside, there's likely something wrong with you nginx config.

FanyangMengDev commented

2020-02-17 17:36:04 +00:00

https://todo.fanyangmeng.com/
Please have a look on my website, this issue still happens

https://todo.fanyangmeng.com/ Please have a look on my website, this issue still happens

FanyangMengDev commented

2020-02-17 17:41:29 +00:00

Can you reach the instance from the same host with

Sorry I did not see this message last moment, I can get it. Here is the screenshot in the attachment

> Can you reach the instance from the same host with Sorry I did not see this message last moment, I can get it. Here is the screenshot in the attachment

2.PNG

15 KiB

konrad commented

2020-02-17 17:43:58 +00:00

You need to add

        index  index.html index.htm;

after the root keyword to prevent the 404s from happening.

Also, you can remove the php-related config, that is not needed.
Take a look at the docs for a minimal example.

I took a look at your instance, it seems to be working correctly apart from the 404s.

However, I got an error 500 when trying to register which could indicate a misconfigured smtp connection. There should be additional output in the Vikunja logs about that.

You need to add ``` index index.html index.htm; ``` after the `root` keyword to prevent the 404s from happening. Also, you can remove the php-related config, that is not needed. Take a look at [the docs](https://vikunja.io/docs/reverse-proxy/) for a minimal example. I took a look at your instance, it seems to be working correctly apart from the 404s. However, I got an error 500 when trying to register which could indicate a misconfigured smtp connection. There should be additional output in the Vikunja logs about that.

FanyangMengDev commented

2020-02-17 17:49:01 +00:00

You need to add
        index  index.html index.htm;
after the root keyword to prevent the 404s from happening.

Also, you can remove the php-related config, that is not needed.
Take a look at the docs for a minimal example.

I took a look at your instance, it seems to be working correctly apart from the 404s.

However, I got an error 500 when trying to register which could indicate a misconfigured smtp connection. There should be additional output in the Vikunja logs about that.

Hi, thanks for your advice but I have already added the index index.html index.htm; to my nginx config, did you miss that? It is on the 6th line。

Just tried to make index as what you advice in docs which is index index.html index.htm;
But nothing changed, still got this error... really weird

> You need to add > ``` > index index.html index.htm; > ``` > after the `root` keyword to prevent the 404s from happening. > > Also, you can remove the php-related config, that is not needed. > Take a look at [the docs](https://vikunja.io/docs/reverse-proxy/) for a minimal example. > > I took a look at your instance, it seems to be working correctly apart from the 404s. > > However, I got an error 500 when trying to register which could indicate a misconfigured smtp connection. There should be additional output in the Vikunja logs about that. Hi, thanks for your advice but I have already added the `index index.html index.htm;` to my nginx config, did you miss that? It is on the 6th line。 Just tried to make index as what you advice in docs which is `index index.html index.htm;` But nothing changed, still got this error... really weird

konrad commented

2020-02-17 17:50:16 +00:00

Whoops, looks I overlooked it. I meant try_files $uri $uri/ /;, sorry.

Whoops, looks I overlooked it. I meant `try_files $uri $uri/ /;`, sorry.

FanyangMengDev commented

2020-02-17 17:57:28 +00:00

Whoops, looks I overlooked it. I meant try_files $uri $uri/ /;, sorry.

OMG! Sorry that I overlooked this line in the doc and now I finally can log in!!!

Just got error 500 and error 502 too, I think maybe it is the smtp's port misconfiguration. I will change it to 465 and skip verify and try again. Thank you so much!!

> Whoops, looks I overlooked it. I meant `try_files $uri $uri/ /;`, sorry. OMG! Sorry that I overlooked this line in the doc and now I finally can log in!!! Just got error 500 and error 502 too, I think maybe it is the smtp's port misconfiguration. I will change it to 465 and skip verify and try again. Thank you so much!!

FanyangMengDev commented

2020-02-17 18:05:39 +00:00

I know, I mistakely set the timezone as GMT+8, But if I wanna set timezone as Shanghai Timezone, what should I input? GMT+8:00?

konrad commented

2020-02-17 18:15:54 +00:00

BTW, could I disable registration in the config?

Yes, set enableregistration under the service section to false.

There is one thing really weird that I set logs root path is /opt/vikunja/logs and made a new folder just in the path. I do not see any log files

If you did not change the config since posting it, you need to change the log files from stdout to file, otherwise all the logs will be logged to stdout by default. You can view them in that case with systemctl status vikunja.

I know, I mistakely set the timezone as GMT+8, But if I wanna set timezone as Shanghai Timezone, what should I input? GMT+8:00?

You should be able to put Asia/Shanghai in there, if it is available on your system. You can check the available time zones on your system with ls /usr/share/zoneinfo (assuming a debian-based distro).

I just tried to reset the password and I can receive the reset email. So it is not the smtp's problem now but still has that error

There should be something in the logs, can you check that?

> BTW, could I disable registration in the config? Yes, set `enableregistration` under the `service` section to `false`. > There is one thing really weird that I set logs root path is /opt/vikunja/logs and made a new folder just in the path. I do not see any log files If you did not change the config since posting it, you need to change the log files from `stdout` to `file`, otherwise all the logs will be logged to `stdout` by default. You can view them in that case with `systemctl status vikunja`. > I know, I mistakely set the timezone as GMT+8, But if I wanna set timezone as Shanghai Timezone, what should I input? GMT+8:00? You should be able to put `Asia/Shanghai` in there, if it is available on your system. You can check the available time zones on your system with `ls /usr/share/zoneinfo` (assuming a debian-based distro). > I just tried to reset the password and I can receive the reset email. So it is not the smtp's problem now but still has that error There should be something in the logs, can you check that?

FanyangMengDev commented

2020-02-17 18:19:49 +00:00

Thank you for your fast response and efficient support. Now all things are solved and finally I can use it normally.

I am so appreciate your reply, it really helps me a lot.

Also this is really a excellent project. Thank you for opening source of it. I will keep using it definately!

Thank you for your fast response and efficient support. Now all things are solved and finally I can use it normally. I am so appreciate your reply, it really helps me a lot. Also this is really a excellent project. Thank you for opening source of it. I will keep using it definately!

FanyangMengDev commented

2020-02-17 18:21:44 +00:00

I wanna also report some feature request at the same time actually.

Add Admin panel

Admin can use this panel to manage users, and set other things maybe. But the most important feature is to manage users.

I wanna also report some feature request at the same time actually. Add Admin panel Admin can use this panel to manage users, and set other things maybe. But the most important feature is to manage users.

FanyangMengDev commented

2020-02-17 18:23:32 +00:00

BTW, if you need translate it into other language which will be good for popularize Vikunja, I would like to help you translate it into Chinese.

FanyangMengDev commented

2020-02-17 18:30:36 +00:00

Just found out that I cannot creat any lists or tasks in Chinese.

If you can make Vikunja support Chinese it will be so much appreciated

Just found out that I cannot creat any lists or tasks in Chinese. If you can make Vikunja support Chinese it will be so much appreciated

konrad commented

2020-02-17 18:30:56 +00:00

Thank you for your fast response and efficient support. Now all things are solved and finally I can use it normally.

I am so appreciate your reply, it really helps me a lot.

Also this is really a excellent project. Thank you for opening source of it. I will keep using it definately!

Thank you, I really appreciate it!

I wanna also report some feature request at the same time actually.

Thanks, I've noted it on our roadmap.

BTW, if you need translate it into other language which will be good for popularize Vikunja, I would like to help you translate it into Chinese.

That would actually be great, I'll ping you once we're ready for translations (That's a feature which would need quite some changes in the frontend, so it's not something happening soon).

> Thank you for your fast response and efficient support. Now all things are solved and finally I can use it normally. > > I am so appreciate your reply, it really helps me a lot. > > Also this is really a excellent project. Thank you for opening source of it. I will keep using it definately! Thank you, I really appreciate it! > I wanna also report some feature request at the same time actually. Thanks, I've noted it on our roadmap. > BTW, if you need translate it into other language which will be good for popularize Vikunja, I would like to help you translate it into Chinese. That would actually be great, I'll ping you once we're ready for translations (That's a feature which would need quite some changes in the frontend, so it's not something happening soon).

konrad commented

2020-02-17 18:32:10 +00:00

Just found out that I cannot creat any lists or tasks in Chinese.

If you can make Vikunja support Chinese it will be so much appreciated

You should be able to do that, what database are you using? And in which collation?

> Just found out that I cannot creat any lists or tasks in Chinese. > > If you can make Vikunja support Chinese it will be so much appreciated You should be able to do that, what database are you using? And in which collation?

FanyangMengDev commented

2020-02-17 18:36:27 +00:00

That would actually be great, I'll ping you once we're ready for translations (That's a feature which would need quite some changes in the frontend, so it's not something happening soon).

Of course. Thank you so much mate and I totally understand you. No rush and just take your time. I will be here immediately whenever you ping me because finally I found such a perfect self-hosted tool and I would be so much hornored to make some contribution.

You should be able to do that, what database are you using? And in which collation?

I am using MySQL in Ubuntu 18.04 LTS. Actually I am not understand "collation", is it meaning the system of my server?

> That would actually be great, I'll ping you once we're ready for translations (That's a feature which would need quite some changes in the frontend, so it's not something happening soon). Of course. Thank you so much mate and I totally understand you. No rush and just take your time. I will be here immediately whenever you ping me because finally I found such a perfect self-hosted tool and I would be so much hornored to make some contribution. > You should be able to do that, what database are you using? And in which collation? I am using MySQL in Ubuntu 18.04 LTS. Actually I am not understand "collation", is it meaning the system of my server?

FanyangMengDev commented

2020-02-17 18:42:13 +00:00

And when I tried to use the Android APP, after I logged in, it just keeps displaying like this. I do not know where the problem is... really weird

Screenshot_2020-02-18-02-41-22-143_io.vikunja.app.jpg

229 KiB

konrad commented

2020-02-17 18:46:22 +00:00

I am using MySQL in Ubuntu 18.04 LTS. Actually I am not understand “collation”, is it meaning the system of my server?

The collation is the charset of the mysql server. If you want to store chinese symbols in your database, it should be set to utf8mb. The default is latin1 which only supports asccii characters.

Take a look at this: https://dba.stackexchange.com/a/104866

> I am using MySQL in Ubuntu 18.04 LTS. Actually I am not understand “collation”, is it meaning the system of my server? The collation is the charset of the mysql server. If you want to store chinese symbols in your database, it should be set to `utf8mb`. The default is `latin1` which only supports asccii characters. Take a look at this: https://dba.stackexchange.com/a/104866

konrad commented

2020-02-17 18:48:03 +00:00

And when I tried to use the Android APP, after I logged in, it just keeps displaying like this. I do not know where the problem is... really weird

The app does not really work at the moment because there were breaking api changes latetly and I did not have the time yet to make the app work with the new version.

Try using the pwa instead (Just visit the frontend with either chrome or Firefox on your phone and it should give you an option to install it to your home screen.

> And when I tried to use the Android APP, after I logged in, it just keeps displaying like this. I do not know where the problem is... really weird The app does not really work at the moment because there were breaking api changes latetly and I did not have the time yet to make the app work with the new version. Try using the pwa instead (Just visit the frontend with either chrome or Firefox on your phone and it should give you an option to install it to your home screen.

FanyangMengDev commented

2020-02-17 18:49:23 +00:00

Thank you for your demonstration. But I found that I have already set the database's collation as utf8mb. Please have a look of this screenshot in phpmyadmin.

FanyangMengDev commented

2020-02-17 18:49:42 +00:00

No description provided.

3.PNG

7.1 KiB

FanyangMengDev commented

2020-02-17 18:54:19 +00:00

And when I tried to use the Android APP, after I logged in, it just keeps displaying like this. I do not know where the problem is... really weird

The app does not really work at the moment because there were breaking api changes latetly and I did not have the time yet to make the app work with the new version.

Try using the pwa instead (Just visit the frontend with either chrome or Firefox on your phone and it should give you an option to install it to your home screen.

Yes of course. I know how to use pwa actually but still thank for your explanation.

Actually when using mobile phone's browser, it has some UI problem. Some components are displaying disorderly. Hope you can fix it some day.

It would be better if the avatar can display as gravatar.

> > And when I tried to use the Android APP, after I logged in, it just keeps displaying like this. I do not know where the problem is... really weird > > The app does not really work at the moment because there were breaking api changes latetly and I did not have the time yet to make the app work with the new version. > > Try using the pwa instead (Just visit the frontend with either chrome or Firefox on your phone and it should give you an option to install it to your home screen. Yes of course. I know how to use pwa actually but still thank for your explanation. Actually when using mobile phone's browser, it has some UI problem. Some components are displaying disorderly. Hope you can fix it some day. It would be better if the avatar can display as gravatar.

InkedScreenshot_2020-02-18-02-44-21-754_org.mozilla.fi_LI.jpg

816 KiB

konrad commented

2020-02-17 19:44:53 +00:00

Actually when using mobile phone's browser, it has some UI problem. Some components are displaying disorderly. Hope you can fix it some day.

Which ones do you mean?

It would be better if the avatar can display as gravatar.

That's actually the case, the avatar you're getting means that there is no gravatar for the email you used to register.

Thank you for your demonstration. But I found that I have already set the database's collation as utf8mb. Please have a look of this screenshot in phpmyadmin.

Can you send a screenshot in english? Unfortunatly, I don't speak chinese.

Can you run these on your db: https://stackoverflow.com/a/1049958/10924593 and send me the output?

> Actually when using mobile phone's browser, it has some UI problem. Some components are displaying disorderly. Hope you can fix it some day. Which ones do you mean? > It would be better if the avatar can display as gravatar. That's actually the case, the avatar you're getting means that there is no gravatar for the email you used to register. > Thank you for your demonstration. But I found that I have already set the database's collation as utf8mb. Please have a look of this screenshot in phpmyadmin. Can you send a screenshot in english? Unfortunatly, I don't speak chinese. Can you run these on your db: https://stackoverflow.com/a/1049958/10924593 and send me the output?

FanyangMengDev commented

2020-02-18 15:55:26 +00:00

Which ones do you mean?

I sent you this screenshot last night, maybe you overlooked it?

That's actually the case, the avatar you're getting means that there is no gravatar for the email you used to register.

I can assure you that my email definitely has its own gravatar. As you can see of my avatar on this page. It is the same email.

That's actually the case, the avatar you're getting means that there is no gravatar for the email you used to register.

Actually that screenshot means that the collation of my database is utf8mb

Can you run these on your db: https://stackoverflow.com/a/1049958/10924593 and send me the output?

Please allow me few minutes and I will do it right now.

> Which ones do you mean? I sent you this screenshot last night, maybe you overlooked it? ![mobile](https://kolaente.dev/attachments/d82eee54-c8ca-4448-a95a-1dbad3b47cd7) > That's actually the case, the avatar you're getting means that there is no gravatar for the email you used to register. I can assure you that my email definitely has its own gravatar. As you can see of my avatar on this page. It is the same email. > That's actually the case, the avatar you're getting means that there is no gravatar for the email you used to register. Actually that screenshot means that the collation of my database is utf8mb > Can you run these on your db: https://stackoverflow.com/a/1049958/10924593 and send me the output? Please allow me few minutes and I will do it right now.

FanyangMengDev commented

2020-02-18 16:00:34 +00:00

To be honest, I can definitely tell you that the collation is utf8mb.

Every table of the database is that.

To be honest, I can definitely tell you that the collation is utf8mb. Every table of the database is that.

捕获.PNG

160 KiB

FanyangMengDev commented

2020-02-18 16:33:39 +00:00

I know why frontend cannot get gravatar.

{key:"getAvatarUrl",value:function(){var t=arguments.length>0&&void 0!==arguments[0]?arguments[0]:50;return"https://www.gravatar.com/avatar/".concat(this.avatarUrl,"?s=").concat(t,"&d=mp")}}]),e}(F)),rt=function(t)

I see that you set getgravatarUrl in app.d04972e7.js, and the Url is totally wrong.

You can see how to set it on this page: https://en.gravatar.com/site/implement/

https://en.gravatar.com/site/implement/images/

Now the frontend avatar Url is just : src="https://www.gravatar.com/avatar/?s=50&d=mp"

I know why frontend cannot get gravatar. ``` {key:"getAvatarUrl",value:function(){var t=arguments.length>0&&void 0!==arguments[0]?arguments[0]:50;return"https://www.gravatar.com/avatar/".concat(this.avatarUrl,"?s=").concat(t,"&d=mp")}}]),e}(F)),rt=function(t) ``` I see that you set getgravatarUrl in app.d04972e7.js, and the Url is totally wrong. You can see how to set it on this page: https://en.gravatar.com/site/implement/ https://en.gravatar.com/site/implement/images/ Now the frontend avatar Url is just : src="https://www.gravatar.com/avatar/?s=50&d=mp"

konrad commented

2020-02-18 18:04:25 +00:00

I sent you this screenshot last night, maybe you overlooked it?

I got the screenshot, it is just not clear to me how the components are broken. The ones you marked seem fine to me, apart from the llama.

To be honest, I can definitely tell you that the collation is utf8mb.

Telling from the screenshot, it seems the collation is actually utf8mb4_general_ci and not utf8mb. Take a lookt at this stackoverflow answer which explains the differences and why you should switch it.
Try running this to convert everything to utf8mb (Make a backup first!).

> I sent you this screenshot last night, maybe you overlooked it? I got the screenshot, it is just not clear to me how the components are broken. The ones you marked seem fine to me, apart from the llama. > To be honest, I can definitely tell you that the collation is utf8mb. Telling from the screenshot, it seems the collation is actually `utf8mb4_general_ci` and not `utf8mb`. Take a lookt at [this stackoverflow answer](https://stackoverflow.com/a/766996/10924593) which explains the differences and why you should switch it. Try running [this](https://dba.stackexchange.com/a/104866) to convert everything to `utf8mb` (Make a backup first!).

konrad commented

2020-02-18 18:06:55 +00:00

I see that you set getgravatarUrl in app.d04972e7.js, and the Url is totally wrong.

That is the minified version, the "real" implementation is here: https://kolaente.dev/vikunja/frontend/src/branch/master/src/models/user.js#L21

However, this seems like a bug I'm able to reproduce. I'll try to up a fix later.

> I see that you set getgravatarUrl in app.d04972e7.js, and the Url is totally wrong. That is the minified version, the "real" implementation is here: https://kolaente.dev/vikunja/frontend/src/branch/master/src/models/user.js#L21 However, this seems like a bug I'm able to reproduce. I'll try to up a fix later.

konrad commented

2020-02-18 18:12:56 +00:00

However, this seems like a bug I'm able to reproduce. I'll try to up a fix later.

I've put up a fix, it'll take a few minutes until a build is available: 683012f468

> However, this seems like a bug I'm able to reproduce. I'll try to up a fix later. I've put up a fix, it'll take a few minutes until a build is available: https://kolaente.dev/vikunja/frontend/commit/683012f468fdbad4c92ff805ffa23a8168753975

FanyangMengDev commented

2020-02-18 18:16:19 +00:00

Telling from the screenshot, it seems the collation is actually utf8mb4_general_ci and not utf8mb. Take a lookt at this stackoverflow answer which explains the differences and why you should switch it. Try running this to convert everything to utf8mb (Make a backup first!).

Just see the screenshot please.

> Telling from the screenshot, it seems the collation is actually utf8mb4_general_ci and not utf8mb. Take a lookt at this stackoverflow answer which explains the differences and why you should switch it. Try running this to convert everything to utf8mb (Make a backup first!). Just see the screenshot please.

IMG_20200219_021312.jpg

354 KiB

FanyangMengDev commented

2020-02-18 18:17:30 +00:00

However, this seems like a bug I'm able to reproduce. I'll try to up a fix later.

I've put up a fix, it'll take a few minutes until a build is available: 683012f468

Thank you so much for your hardworking mate. I will try it now

> > However, this seems like a bug I'm able to reproduce. I'll try to up a fix later. > > I've put up a fix, it'll take a few minutes until a build is available: https://kolaente.dev/vikunja/frontend/commit/683012f468fdbad4c92ff805ffa23a8168753975 Thank you so much for your hardworking mate. I will try it now

konrad commented

2020-02-18 18:23:14 +00:00

But the screenshots you sent me from the tables show that they are still in utf8mb4_general_ci.

Can you try to insert or modify an entry from within phpmyadmin and insert a chinese letter or so to see if the database is working correctly?

But the screenshots you sent me from the tables show that they are still in `utf8mb4_general_ci`. Can you try to insert or modify an entry from within phpmyadmin and insert a chinese letter or so to see if the database is working correctly?

konrad commented

2020-02-18 18:26:28 +00:00

I was able to create a task with some chinese letters on my instance:

My databse is all utf8mb4 encoded:

I was able to create a task with some chinese letters on my instance: ![image](/attachments/82bb9e03-d5ef-44c6-a416-be527382dba6) My databse is all `utf8mb4` encoded: ![image](/attachments/3c6efb34-dec0-407d-b186-48072b826ef9)

image.png

56 KiB

image.png

12 KiB

FanyangMengDev commented

2020-02-18 18:26:43 +00:00

Just test it and the gravatar is normal now! Bravo!

To the mobile UI problem.
What I mean is that the vikunja which I mark in the mobile page obsecure the username. Maybe you can make it expose less just like the PC version which will be better?

Just an advice. If you think that is not so important. It does not effect so much.

Just test it and the gravatar is normal now! Bravo! To the mobile UI problem. What I mean is that the vikunja which I mark in the mobile page obsecure the username. Maybe you can make it expose less just like the PC version which will be better? Just an advice. If you think that is not so important. It does not effect so much.

IMG_20200219_022146.jpg

232 KiB

IMG_20200219_022200.jpg

147 KiB

konrad commented

2020-02-18 18:32:58 +00:00

Yes, I'll put that in the roadmap. I kind of like the gimmick, but you're not the first to notice it's not ideal.

FanyangMengDev commented

2020-02-18 18:38:47 +00:00

Yes, I'll put that in the roadmap. I kind of like the gimmick, but you're not the first to notice it's not ideal.

LOL OK sounds great. Now I am trying to figure out what is the real problem in my database although all collations are unicode

> Yes, I'll put that in the roadmap. I kind of like the gimmick, but you're not the first to notice it's not ideal. LOL OK sounds great. Now I am trying to figure out what is the real problem in my database although all collations are unicode

FanyangMengDev commented

2020-02-18 18:51:22 +00:00

Just change the username to 孟繁阳 and the frontend just display like this

IMG_20200219_025028.jpg

170 KiB

Screenshot_2020-02-19-02-50-11-738_org.mozilla.firefox.jpg

286 KiB

Screenshot_2020-02-19-02-50-11-738_org.mozilla.firefox.jpg

FanyangMengDev commented

2020-02-18 18:54:17 +00:00

This means the collation is correct, right?

I am really confused now.

![](https://kolaente.dev/attachments/1442f123-2559-49a8-9100-8502a7a13b49) This means the collation is correct, right? I am really confused now.

konrad commented

2020-02-18 19:44:35 +00:00

It seems your collation is still utf8mb4_unicode_ci and not utf8mb4 (or utf8mb4_general_ci for that matter).
Take a look at this answer from stackoverflow to learn the differences between the two and why you should use utf8mb4 or utf8mb4_general_ci instead.

It seems your collation is still **` utf8mb4_unicode_ci`** and not **` utf8mb4`** (or `utf8mb4_general_ci` for that matter). Take a look at [this answer from stackoverflow](https://stackoverflow.com/a/766996/10924593) to learn the differences between the two and why you should use `utf8mb4` or `utf8mb4_general_ci` instead.

konrad commented

2020-04-06 20:32:53 +00:00

Closing this as it seems the original issue has been resolved.

konrad closed this issue

2020-04-06 20:33:02 +00:00

konrad referenced this issue from a commit

2024-02-07 14:00:23 +00:00

Update dependency eslint to v7.1.0 (#139)

konrad referenced this issue from a commit

2024-02-08 14:01:00 +00:00

chore(deps): update dependency electron to v23.1.1 (#139)

Sign in to join this conversation.