I have a site running Umbraco v13 which I have upgraded from v8 via v10. I am now trying to install the latest version of Umbraco Forms - I have installed the package via Nuget and can load the Forms section in the backend, however doing so shows this error: Invalid column name 'DeleteEntries'. On checking the Installed Packages view I can see there are Pending migrations for the Umbraco Forms package, selecting the option to Run them shows a "successfully completed" message in the front-end but the console the site was run from shows the following errors: [10:35:00 INF] Create Foreign Key: ALTER TABLE [UFUserGroupFormSecurity] ADD CONSTRAINT [FK_UFUserGroupFormSecurity_UFForms_Key] FOREIGN KEY ([Form]) REFERENCES [UFForms] ([Key]) [10:35:00 ERR] Exception (9b7b8baf). Microsoft.Data.SqlClient.SqlException (0x80131904): There are no primary or candidate keys in the referenced table 'UFForms' that match the referencing column list in the foreign key 'FK_UFUserGroupFormSecurity_UFForms_Key'. Could not create constraint or index. See previous errors. Plan failed at step 7c7bc5ee-4c5b-42dc-9576-5ce6dfbddb8e Has anybody encountered this error or similar before, or has any advice on resolving it?

Hi all, Umbraco Commerce has a great discount rule engine. The only downside is that it is applied to Orders only. How do you manage displaying discounts on the frontend? A lot of shops don't just want to show the discount whenever they are in the checkout, but also on product details/ product overviews. I know there is no built in feature for this (we asked support) so that's why I was wondering how other people handle this. Thanks

Using this to discuss Content Delivery API and Blazor.

I would like to have only 1 API controller that is authenticated with a Bearer token, More or less like this implementation https://www.c-sharpcorner.com/article/jwt-token-creation-authentication-and-authorization-in-asp-net-core-6-0-with-po/ Only with the umbraco pipeline, this doesn't seem to work.

I'm looking to add a single new field to the external index. This seemed like a trivial task and quite easy in v8 but all I can seem to find so far for modern Umbraco are articles about creating new indexes. TIA, tom

Hi. Docs and code says there should be an UmbracoForms folder in App_plugins. After nuget installation of Forms 13.0.1 I do not have that folder. What might be wrong here? Also the files in Views/Partials/Forms were missing. Downloaded them from docs page though. https://cdn.discordapp.com/attachments/1206882876767997992/1206882876935634984/image.png?ex=65dda044&is=65cb2b44&hm=0314d73b87545d406bcb5592a35d82785133ac4d0ddb372d982d1290158a1e03&

I am having trouble findding the relevant info in the docs. I have a media item (PDF file), I wish to attach this to an email. How can I find the full path of the media item? I am using v10. I have the file as a content model, so I can access the id etc. I used to use umbracoFile to do this, something akin to:

Server.MapPath(trainingLogFile.GetPropertyValue("umbracoFile").ToString());

alas the property is no longert there, or I need to find it via one of the services/helpers. Thanks.

> **Back story**: Since Umbraco 11, (when it stopped shipping with the "Microsoft.Data.SqlClient" library), I haven't been able to get the SQL data-source in my Contentment package to work. Prior to this, e.g. v9/v10, I could detect whether if a connection string was SQL Server or SQLite (or even earlier SQL CE). But without adding a dependency on "Microsoft.Data.SqlClient", I can't figure out how to make a raw SQL query on a custom database connection. If I have a custom database connection string, totally separate to the Umbraco database. This could be either SQL Server or SQLite. Should it be possible to reuse any Umbraco code to run a raw SQL query against that database? As far as my google-fu goes, there are many examples for EFCore, e.g. developing your own models/context (for inside the Umbraco database) ... but nothing for a raw SQL query. > Note, if you aren't familiar with the SQL data-source in Contentment, it lets a developer enter a raw SQL query to populate a list editor, e.g. dropdown list, radiobuttons, etc. Any code snippet examples would be hugely appreciated. 🙏

Does anyone have any links to blog posts about how to do proper nuget versioning for packages? Is there a standard way package authors do this? I'm currently just manually updating the

PackageVersion

in my csproj when releasing a new version 🙈

Hey there! I'm using Umbraco 12 and I wanted to provide a "forgot password" mechanism to frontend members. I'm currently asking for the e-mail to get the MemberIdentityUser member and then using the MemberManager.GeneratePasswordResetTokenAsync(member) to get the token. I then encode it and send the e-mail with the encoded token. After clicking the link in the e-mail, a controller is called with the encoded token and the user. A token validation is performed using MemberManager.VerifyUserTokenAsync(member, _options.Tokens.PasswordResetTokenProvider, UserManager.ResetPasswordTokenPurpose, token) I've also tried MemberManager.VerifyUserTokenAsync(member, "Default", "ResetPassword", token) Both return false. I've debugged it and can confirm the token sent (before encoding) matches the received token. What am I missing here? Thank you 🙂