What are the minimum required tables that require rows to be added to create user, so is then visible active in discourse Ive just inserted one row into user_emails insert into user_emails (user_id, email, "primary", created_at, updated_at) values (2,'user@email.com',true, now(), now()); Unsuprisingly has not appeared in the gui, but what are the minimum steps, do I need to add to some more tables, or is there some restart I need to do. Now I expect someone will say this is not the right ways to do things, and I understand that, but for me it might be as I’ll explain below (some of my assumptions may be incorrect but this is my understanding) All the import scripts that import from another database based forum expect to be able to connect to the other forum from the discourse instance. But being able to access the other forum (jforum) from live discourse instance is going to be difficult if not impossible, similarly trying to install a discourse dev environment where by old forum resides (very old server) is also not possible. I dont understand Ruby on Rails so I cant modify the existing scripts, but I do understand SQL I could use the API (I only have 5000 users) but I want to be able to plugin/method that keep the md5 password hash rather than requiring all users to reset their passwords so I don’t think I can do this using the API There is a jforum import script so I can use that to look at the SQL required to get data out of jforum no problem to then put into csv files to load into database. The bulk importers possibly provide the way to add SQL into discourse but struggling to see the SQL. Seems getting the users in is the key thing, then adding categories, topics and posts should not be so hard.

no, it will prevail over the md5 digest in the custom field. The answers to the other two questions can easily be found on this forum. If you want to save time we can do the import and/or hosting for you as a paid service.

I did search for both answers, was unable to find. In the first case it is confusing that some installs are done via editing the yaml file and then relaunching the docker , and some seem such as this are installed whilst in the docker container, its not cxlear what restart means in this case. I cant really find any pure sql in this forum Surprised there seems such a push to sale paid services for using this opensrc software , never like this when i ask questions on stackoverflow.

I love to think along, innovate and contribute. But I also need to make a living and that means that I need to draw a line somewhere, and I try to draw it where I get the idea that I’m doing work instead of innovating, contributing and thinking along. Looking up the SQL query for a user custom field is work for me, and as you’re an experienced dev I estimate that you can figure it out as well :smiley:

[image] michaeld: Looking up the SQL query for a user custom field is work for me, and as you’re an experienced dev I estimate that you can figure it out as well Well sure I can try and work it out but no harm in asking since its not can easily be found on this forum As for the other question, well it remains unclear to me. I dont expect you to do my work for me, on the other hand side i do genrally find it frustrating how documentation assumes alot from users.

OK question 2, an example of adding a custom import_pass field for user_id 5, (user_id can be seen in the user_emails table or id from users table) insert into user_custom_fields (user_id, name, value, created_at, updated_at) values (5,‘import_pass’,‘2aee1c40222c7754d4534e61452612cc’, now(), now());

[image] paultaylor: I have installed it, but how do I restart Discourse ? Okay I found it ./launcher restart app but doesnt seem to be restarting, I can enter app and connect to db, but cant connect to website. May just rebuild and start again

So I ran ./launcher rebuild app and now it is back and working. I thought this would recreate the database but it has not so I guess that is because the actual database is persisting outside of docker and rebuild just rebuilds the docker app. Also I see the dataexplorer plugin I added (by modifying the yaml file is still there). But is the passwordmigration plugin there or does it get wiped out by rebuild, there is certainly nothing in the plugs in section of the adminpage. Right I tried installing passwordmigration and then ran restart again, and once again my site is down, it does seem like passwordmigration is breaking something ? So rebuilt again, got it working (but now passwordmigration plugin missing). If I run ./launcher restart app without installing migrationpassword first it restarts okay, so does seem to be a particular problem with migrationpassword on my setup

Last time I tried, the passwordmigration plugin was incompatible with running an import, so you’ll want to install it after you do the import. It could be that it’s breaking your rebuild, but that’d be fairly surprising, as Richard uses it in his hosting. I recommend that you install it in app.yml just as you did the data explorer after you’ve done your import. rm -rf the postgres directories in /var/discourse/shared/standalone if you want to get a new database. Maybe have a look at https://meta.discourse.org/t/advanced-troubleshooting-with-docker/15927

[image] pfaffman: so you’ll want to install it after you do the import. disabling it during the import should be sufficient

Weird, dropped database and ran ./discourse-setup so had a brand new install, everything fine. Installed migrationpassword with rake and restarted, again website fails with 502 ! DataExplorer plugin still existed, so removed that, rebuilt, ok, then reinstalled migrationpassword and fails with 502 again. So confusing because clearly works for others but doesn’t work on my vanilla install. Will try to install via editing the app.yml file next.

How to create a new user in pure sql

Product Support Migration

sam (Sam Saffron) October 18, 2023, 1:10am 29

Sorry, but I am going to close this off as “please don’t do that”

Too risky, and there are many side effects you are likely to forget.

Topic		Replies	Views
Migrated password hashes support Plugin	34	12996	June 2, 2026
Reset password with custom ruby file Development	9	1026	September 27, 2023
Migrate a bbPress WordPress plugin forum to Discourse Migrating to Discourse how-to	33	13621	January 10, 2024
Best tools, materials & practices to onboard a hoarde of new users? Community Building	22	4137	January 30, 2018
Use an import script that requires MySQL Sysadmins how-to	51	13852	December 12, 2023

How to create a new user in pure sql

Related topics