search

oqtane / oqtane.framework

CMS & Application Framework for Blazor & .NET MAUI
http://www.oqtane.org
MIT License
1.88k stars 547 forks source link

Error on mysql install #1472

Closed bobhu98 closed 3 years ago

bobhu98 commented 3 years ago

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONSTRAINT FK_Folder_Site' at line 1

sbwalker commented 3 years ago

This looks like a potential issue in the Dev branch based on some recent changes to the Controllers done after the 2.1.0 release.

sbwalker commented 3 years ago

Can you please provide the steps to reproduce. Did this happen during the initial install or after a successful install and then attempting to create another site? Need the exact details.

bobhu98 commented 3 years ago

Hi: Thanks a lot, the error happened after successful install, the first time to run the site in the debug model.

On Sun, Jun 13, 2021 at 8:07 PM Shaun Walker @.***> wrote:

Can you please provide the steps to reproduce. Did this happen during the initial install or after a successful install and then attempting to create another site? Need the exact details.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/oqtane/oqtane.framework/issues/1472#issuecomment-860291009, or unsubscribe https://github.com/notifications/unsubscribe-auth/AUOTALVEUECPNGNGC45WUN3TSVB25ANCNFSM46S273SA .

-- Warm Regards, Cell: 647 330 2728 Office: 905-940-3428

BOB HU, BROKER CENTURY 21 KING`S QUAY REAL ESTATE INC., BROKERAGE 7303 Warden Ave #101, Markham, ON L3R5Y6

https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Virus-free. www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

sbwalker commented 3 years ago

I can't reproduce. Perhaps you did not actually have a successful installation... or you changed some configuration after your initial installation?

bobhu98 commented 3 years ago

Hi: Database is mysql, download source code from github. unzip and put in the folder. First run in the debug model and get into the install setting, successful install and I check the table in the database is ok. Then rerun the in the debug model and get that error.

https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Virus-free. www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

sbwalker commented 3 years ago

Which object is null - the site or the _alias?

bobhu98 commented 3 years ago

Both, first is site, After I set the id to 1 shows the _alias is null.

On Sun, Jun 13, 2021 at 9:03 PM Shaun Walker @.***> wrote:

Which object is null - the site or the _alias?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/oqtane/oqtane.framework/issues/1472#issuecomment-860302898, or unsubscribe https://github.com/notifications/unsubscribe-auth/AUOTALRXR6PMFQCO7GBE3D3TSVIONANCNFSM46S273SA .

https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Virus-free. www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

sbwalker commented 3 years ago

It sounds like your Alias table is not populated correctly in your database.

bobhu98 commented 3 years ago

Thanks a lot. I checked the database and the site table is null. I delete the defaultconnection and try to install in mysql DB, got error: currently I use Mysql workbench 6.3 CE

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONSTRAINT FK_Folder_Site' at line 1

On Mon, Jun 14, 2021 at 7:27 AM Shaun Walker @.***> wrote:

It sounds like your Alias table is not populated correctly in your database.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/oqtane/oqtane.framework/issues/1472#issuecomment-860610353, or unsubscribe https://github.com/notifications/unsubscribe-auth/AUOTALTS6TSBKPDLNMFOCRDTSXRQVANCNFSM46S273SA .

sbwalker commented 3 years ago

I am not sure why you thought you had a successful installation previously? Was no error triggered? Is it possible to identify the line of code or class which is resulting in the error "CONSTRAINT FK_Folder_Site' at line 1"?

cnurse commented 3 years ago

I was not able to reproduce this bug. I was using the 2.1.0 release code, and MySQL build 8.0.23. I also tried with the latest code and it installed fine for me.

bobhu98 commented 3 years ago

Hi: Thanks a lot for your message, I downloaded latest mysql 8.025 and got same error:

sbwalker commented 3 years ago

I will try with 8.0.25 today

sbwalker commented 3 years ago

@bobhu98 I installed 8.0.25 today and installed the application using the latest code from the Dev branch - and it worked fine.

sbwalker commented 3 years ago

closing as multiple people are not able to reproduce

bobhu98 commented 3 years ago

Thanks a lot. After I deleted all old MySQL files and installed the latest 8.025 version the project installed successfully. I can download all themes and install them. Only small issue is that I can not change the theme in the debug model. (after selected new theme in dropdown list and click save, nothing change)

sbwalker commented 3 years ago

@bobhu98 can you explain where you were changing the theme - was it in the Site Settings or Page Settings?

bobhu98 commented 2 years ago

Hi: Where is the location of language file in Oqtane? Sometime got date format error for old language setting and need to clean the cached data.

Warm Regards, Cell: 647 330 2728

BOB HU,

bobhu98 commented 1 year ago

Hi: Is it possible to add some CRM modules to Oqtane?

-- Thanks and warm regards. BOB HU

leigh-pointer commented 1 year ago

Hi: Is it possible to add some CRM modules to Oqtane? … -- Thanks and warm regards. BOB HU

@bobhu98 you can add basically what you want. Oqtane offers itself to many possibilities. Just build it and plug it in.

bobhu98 commented 1 year ago

Thanks a lot, please let me know which one open source I can add.

BOB

On Mon, Mar 13, 2023 at 3:13 PM Leigh Pointer @.***> wrote:

Hi: Is it possible to add some CRM modules to Oqtane? … <#m-296558844202803486> -- Thanks and warm regards. BOB HU

@bobhu98 https://github.com/bobhu98 you can add basically what you want. Oqtane offers itself to many possibilities. Just build it and plug it in.

— Reply to this email directly, view it on GitHub https://github.com/oqtane/oqtane.framework/issues/1472#issuecomment-1466803510, or unsubscribe https://github.com/notifications/unsubscribe-auth/AUOTALRL77TEGA2AULIKJZDW35WW5ANCNFSM46S273SA . You are receiving this because you were mentioned.Message ID: @.***>

leigh-pointer commented 1 year ago

@bobhu98 take a look in the Module Management

modules

bobhu98 commented 1 year ago

Thanks a lot, I checked already, there are some modules for CMS but no CRM modules.

-- Thanks and warm regards. BOB HU

bobhu98 commented 1 year ago

Hi: Is it possible to add following features to oqtane:

1: Add scheduled jobs dynamically, like setting some url to run for a few hours? 2: Add CRM, Client Relation Management feature to the module? 3: Add features like making appointments dynamically? -- Thanks and warm regards. BOB HU

bobhu98 commented 1 year ago

Hi: Install the latest version 4.06 and get error(mysql 8.034):

An Error Occurred Creating The Database. This Is Usually Related To Your User Not Having Sufficient Rights To Perform This Operation. Please Note That You Can Also Create The Database Manually Prior To Initiating The Install Wizard. MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host '127.0.0.1' for user 'newUser$id2023' using method 'mysql_native_password' failed with message: Access denied for user 'newUser$id2023'@'localhost' (using password: YES) ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Access denied for user 'newUser$id2023'@'localhost' (using password: YES) at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(MySqlException ex) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticateAsync(Boolean reset, Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.AuthenticateAsync(String authMethod, Boolean reset, Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.OpenAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.NativeDriver.OpenAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.Driver.OpenAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.Driver.CreateAsync(MySqlConnectionStringBuilder settings, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.Driver.CreateAsync(MySqlConnectionStringBuilder settings, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnectionAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnectionAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlPool.TryToGetDriverAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlPool.GetConnectionAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlConnection.OpenAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlConnection.Open() at MySql.EntityFrameworkCore.Storage.Internal.MySQLDatabaseCreator.<>cDisplayClass16_0.b0(DateTime giveUp) at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>cDisplayClass12_0`2.b0(DbContext _, TState s) at MySql.EntityFrameworkCore.Storage.Internal.MySQLExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func2 operation, Func2 verifySucceeded) at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func`2 operation) at MySql.EntityFrameworkCore.Storage.Internal.MySQLDatabaseCreator.Exists(Boolean retryOnNotExists) at MySql.EntityFrameworkCore.Storage.Internal.MySQLDatabaseCreator.Exists() at Microsoft.EntityFrameworkCore.Storage.RelationalDatabaseCreator.EnsureCreated() at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.EnsureCreated() at Oqtane.Infrastructure.DatabaseManager.CreateDatabase(InstallConfig install) in C:\Projects\OqtaneMySQL\Oqtane.Server\Infrastructure\DatabaseManager.cs:line 289

-- Thanks and warm regards. BOB HU (BROKER) HOMELIFE NEW WORLD REALTY INC., BROKERAGE

Cell: 647-330-2728；Bus: 416-490-1177；

201 Consumers Rd., Ste. 205; Toronto, ON M2J4G8

*independently owned and operated

bobhu98 commented 11 months ago

Hi: I downloaded the latest version from Github, using visual studio to run the project, the database is MySQL version 8.0.35, and grant the user full control, on the first time running the application, after click the install now got following error, I also try the root user of mysql, got same error.

-- Thanks and warm regards. BOB HU (BROKER) HOMELIFE NEW WORLD REALTY INC., BROKERAGE

Cell: 647-330-2728；Bus: 416-490-1177；

201 Consumers Rd., Ste. 205; Toronto, ON M2J4G8

*independently owned and operated