This is a whole big project includes, keeping code blocks, creating teams and uploading a project, editing a project, editing code online, creating blog posts, questions and answers. It is like a personal github project. You can checkout the demo link to explore more.

Hi, Sorry after an edit, it seems a script is missing. Can you execute this script;

ALTER TABLE [dbo].[DeveloperTeamMember] ADD IsDefault bit NOT NULL CONSTRAINT Cons_DeveloperTeamMember_IsDefault DEFAULT 0 GO

After execuitng this script everything should be running as expected.

Thank you for the super quick response. That has corrected my problem. In the Login View there is a link to ‘signup-password.html’ which was not included in the download. Could you provide this file? I see that the code exists to reset passwords, so it just seems to be this file thats missing.

Ohh, the thing is actually that page is not created. You will need to create that page by yourself. Sorry for missing page. Since this project is quite old one, I prefer to fix bugs rather to improve features.

Sure I understand. Thanks again for responding so quickly. I am otherwise very happy with this project. Good job.

Thank you, it’s been quite time. Hope it helps.

When trying to add a code item the Publish throws an exception: {“Invalid column name ‘PLId’.”}

I’m validating the app, I’ll resend the application once it is ready.

I’ve updated the db scripts, it is pending now, you’ll get notified once it is approved.

When do you think this update will be approved?

Since it is a full application with source code I didn’t need to document it. Feel free to ask any question here. Yes the order for scripts are table,indexes,triggers,insert. In the web applciation solution you will see the images folder, here you will see all the medial files used in the application. If you want you can replace logo.png, favicon.png with yours.

There are numerous errors in your SQL scripts. I will attempt to paste some of the ones I found below. Hopefully they will fit in this space. Did you not test these before hand? The errors have to do with a “{” instead of a “[” and a missing column among other things that would have been caught had you actually ran these scripts. Plus your index naming conventions are not correct. They should IX_TableName_FieldNames. That’s the standard convention. Please correct the scripts and get the new ones posted asap. Thanks.

Here are the errors:

table.txt

line 32

[ShowDeleted] {bit] NOT NULL
CONSTRAINT [PK_Member] PRIMARY KEY NONCLUSTERED

{ should be [

indexes.txt

line 67

CREATE INDEX [indCodeBlockTag] ON [dbo].[CodeBlockTag] ( [PLId] ASC, [Tag] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO

PLId is not a valid column – should be Id

line 94

CREATE INDEX [indProgrammingLanguage] ON [dbo].[ProgrammingLanguage] ( [FlStatus] DESC, [CodesCount] DESC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO

The column CodesCount does not exist in the ProgrammingLanguage table

also I got these:

Warning! The maximum key length for a nonclustered index is 1700 bytes. The index ‘indForumThreadHeader’ has maximum length of 4000 bytes. For some combination of large values, the insert/update operation will fail. Warning! The maximum key length for a nonclustered index is 1700 bytes. The index ‘indForumThreadUrlHeader’ has maximum length of 4000 bytes. For some combination of large values, the insert/update operation will fail. Warning! The maximum key length for a clustered index is 900 bytes. The index ‘clIndBlog’ has maximum length of 4002 bytes. For some combination of large values, the insert/update operation will fail. Warning! The maximum key length for a clustered index is 900 bytes. The index ‘clIndTeamInvite’ has maximum length of 2000 bytes. For some combination of large values, the insert/update operation will fail.

triggers.txt

Msg 8197, Level 16, State 4, Procedure trg_ai_CodeBlockMainLang, Line 2 [Batch Start Line 57] The object ‘CodeBlockMainLang’ does not exist or is invalid for this operation. Msg 208, Level 16, State 6, Procedure trg_ai_CodeBlockBug, Line 2 [Batch Start Line 82] Invalid object name ‘trg_ai_CodeBlockBug’. Msg 208, Level 16, State 6, Procedure trg_ai_CodeBlockBugResponse, Line 2 [Batch Start Line 117] Invalid object name ‘trg_ai_CodeBlockBugResponse’. Msg 208, Level 16, State 6, Procedure trg_ai_CodeBlockComment, Line 2 [Batch Start Line 183] Invalid object name ‘trg_ai_CodeBlockComment’. Msg 208, Level 16, State 6, Procedure trg_ai_CodeBlockHelpfulMember, Line 2 [Batch Start Line 225] Invalid object name ‘trg_ai_CodeBlockHelpfulMember’. Msg 208, Level 16, State 6, Procedure trg_ai_ForumMessage, Line 2 [Batch Start Line 318] Invalid object name ‘trg_ai_ForumMessage’. Msg 207, Level 16, State 1, Procedure trg_ai_DeveloperTeam, Line 17 [Batch Start Line 565] Invalid column name ‘IsDefault’.

Sorry. Pasting the errors didn’t work well. The first error is in the table.txt file. The next 2 are from the indexes.txt file. The last one is from the triggers.txt file. The insert statements all worked. Thanks in advance for fixing these as quickly possible. Note that I could fix them myself (and I did to get this to work) but you need to support your product with proper scripts.

Sorry for inconvenience, I have fixed the scripts and combined in a single file. Since it will take time to upload you can download fixed script from this link: https://wetransfer.com/downloads/d12edfb3c3c9db79109bc88494f2803120190720064604/e4fae4

Thanks for the fast response! I ran the updated script and everything worked fine in terms of creating the database schema. However I want to first run the app locally and my SQL Server (2017) is using windows authentication. So I had to update the web.config fiel with the following line: <add name=”CodeContext” connectionString=”Data Source=LAPTOP-FAHD4MFU\HP_ENVY_2017EXPR;Initial Catalog=ToucanCodeRepo;Integrated Security=SSPI;Trusted_Connection=True;” providerName=”System.Data.SqlClient”/>

Now when running the app I get invalid column name errors in ValidCoding.Business.TeamBusiness GetLatestPublicTeams(). The invalid columns are ViewCount and TeamKeywords.

I have uploaded a zip file at the URL below with a screen shot of the error as well as my modified Web.Config file. Can you tell me what I’m doing wrong with the connection string? I’ve never had this kind of issue before with dozens of .Net database apps. Or is the schema just missing those columns?

Here’s the URL for the zip file:

I’m so sorry, This is the first time happenning to me. I don’t know how did this happen but I’m doing my best to fix the sync issue between the app and db. Here is the final db scripts which I have tested and run the application without an error. https://wetransfer.com/downloads/e3f8abbf09db6ad137d904fbf37a84da20190722180338/666c2a012d9c149d14f98748d594301520190722180338/231235

Don’t worry or get discouraged. We’ll get this right one way or another. Sorry if I sounded angry before. I’m not. I’m just glad to be of help. I’ll run the script asap and let you know how it goes. Keep up the awesome support!

For sure, thanks. I hope this time you will have the application up and running.

Success! I haven’t tested the app thoroughly yet but I am able to click on various links and every page seems to load properly. I’ll test it some more later tonight (sign up, add some code snippets, create a team, etc.) and let you know how it goes. Thanks for all your help so far.

FYI. I’ll take down the S3 link now so no one else can get it. If you should need either the jpg with the original error or my web.config file just let me know.