 | | |
| | |
| | |
|
|
 | |
Précédente
|
| | |
|
| |
 | | |
|
|
| zomby |
 |
Inscrit(e) le : 2006-10-11
10 messages
|
|
|
I get an error at installation for the SqlProvider...creating database, is it normal ?
|
|
|
|
| |
|
| anonymous |
|
Inscrit(e) le : 0001-01-01
0 messages
|
|
|
Off course it is not normal
I just installed it on 2 different servers without any error
Could you please post the entire error?
Thanks
Francis
|
|
|
|
| |
|
| zomby |
|
Inscrit(e) le : 2006-10-11
10 messages
|
|
|
Salut Francis,
j'ai finalement réussi à loader le module (L'erreur de SQL n'est pas survenu au 2 e essaie), mais lorsque j'ajoute le DVD Module à ma nouvelle page, voici l'erreur qui semble être une erreur de conversion d'un string en integer...ce qui est compréhensible.
Pour ton info je roule sur DNN 4.3.5 et j'ai aussi installé ton Language pack full...vraiment super. Il y a des heures de travail la-dessus !
Merci d'avoir répondu si rapidement !
 |
Erreur critique.
Conversion from string "" to type 'Integer' is not valid. |
|
|
|
|
| |
|
| anonymous |
|
Inscrit(e) le : 0001-01-01
0 messages
|
|
|
SVP peux tu essayer de le supprimer et de le réinstaller
|
|
|
|
| |
|
| zomby |
|
Inscrit(e) le : 2006-10-11
10 messages
|
|
|
Salut Franchis,
J'ai désinstaller et en rechargeant le module j'ai eu encore la même erreur qu'au début pour SQL !!!
| Début |
Début de traitement SQL |
| Info |
Traitement en cours01.00.00.SqlDataProvider |
| Début |
Début de traitement de script Sql : 01.00.00.SqlDataProvider |
| Erreur |
Erreur pendant la génération SQL : System.Data.SqlClient.SqlException: Line 36: Incorrect syntax near '('. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Table **/ /** Create Table DNNMTL_DVD_Inventory **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[DNNMTL_DVD_Inventory]') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.[DNNMTL_DVD_Inventory]( [ModuleID] [int] NOT NULL, [dvdinventoryid] [int] IDENTITY(1,1) NOT NULL, [type] [int] NULL, [subtitle3] [int] NULL, [subtitle2] [int] NULL, [subtitle1] [int] NULL, [directed] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [rating] [int] NULL, [producer] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [picture] [varchar](5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [languuage3] [int] NULL, [languuage2] [int] NULL, [languuage1] [int] NULL, [dvdtitle] [varchar](300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [dvdid] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [datemod] [smalldatetime] NOT NULL, [datein] [smalldatetime] NOT NULL, [company] [int] NULL, [comment] [varchar](8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [userid] [int] NOT NULL, [userin] [int] NULL, [portalid] [int] not NULL, CONSTRAINT [PK_DNNMTL_DVD_Inventory] PRIMARY KEY CLUSTERED ( [dvdinventoryid] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] end System.Data.SqlClient.SqlException: Line 17: Incorrect syntax near '('. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Table DNNMTL_DVD_Inventory_company **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[DNNMTL_DVD_Inventory_company]') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.[DNNMTL_DVD_Inventory_company]( [ModuleID] [int] NOT NULL, [itemid4] [int] IDENTITY(1,1) NOT NULL, [dvd_company] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_DNNMTL_DVD_Inventory_company] PRIMARY KEY CLUSTERED ( [itemid4] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] end System.Data.SqlClient.SqlException: Line 14: Incorrect syntax near '('. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Table DNNMTL_DVD_Inventory_language **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[DNNMTL_DVD_Inventory_language]') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.[DNNMTL_DVD_Inventory_language]( [ModuleID] [int] NOT NULL, [itemid2] [int] IDENTITY(1,1) NOT NULL, [dvd_language] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_DNNMTL_DVD_Inventory_language] PRIMARY KEY CLUSTERED ( [itemid2] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] end System.Data.SqlClient.SqlException: Line 18: Incorrect syntax near '('. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Table DNNMTL_DVD_Inventory_rating **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[DNNMTL_DVD_Inventory_rating]') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.[DNNMTL_DVD_Inventory_rating]( [ModuleID] [int] NOT NULL, [itemid3] [int] IDENTITY(1,1) NOT NULL, [dvd_rating] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_DNNMTL_DVD_Inventory_rating] PRIMARY KEY CLUSTERED ( [itemid3] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] end System.Data.SqlClient.SqlException: Line 17: Incorrect syntax near '('. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Table DNNMTL_DVD_Inventory_type **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[DNNMTL_DVD_Inventory_type]') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.[DNNMTL_DVD_Inventory_type]( [ModuleID] [int] NOT NULL, [itemid] [int] IDENTITY(1,1) NOT NULL, [dvd_type] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_DNNMTL_DVD_Inventory_type] PRIMARY KEY CLUSTERED ( [itemid] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] end
As-tu une idée pourquoi ça me refait ça ?
Merci |
|
|
|
|
| |
|
| anonymous |
|
Inscrit(e) le : 0001-01-01
0 messages
|
|
|
je check ca je te revien dans le courant de la semaine
|
|
|
|
| |
|
| anonymous |
|
Inscrit(e) le : 0001-01-01
0 messages
|
|
|
peux tu essayer de le supprimer et de le réinstaller la version attaché a se message...
|
|
|  | Vous connecter pour télécharger l'attachement |
|
|
|
| |
|
| zomby |
|
Inscrit(e) le : 2006-10-11
10 messages
|
|
|
Je veux bien, mais je n'ai pas les droits de télécharcher ton fichier je crois. J'ai l'erreur suivante:
"You Do Not Have Permission To View The Requested File"
|
|
|
|
| |
|
| anonymous |
|
Inscrit(e) le : 0001-01-01
0 messages
|
| |
| |
|
| zomby |
|
Inscrit(e) le : 2006-10-11
10 messages
|
|
|
Malheureusement, encore la même erreur à l'installation de la BD
| Début |
Début de traitement SQL |
| Info |
Traitement en cours01.00.00.SqlDataProvider |
| Début |
Début de traitement de script Sql : 01.00.00.SqlDataProvider |
| Erreur |
Erreur pendant la génération SQL : System.Data.SqlClient.SqlException: Line 36: Incorrect syntax near '('. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Table **/ /** Create Table DNNMTL_DVD_Inventory **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[DNNMTL_DVD_Inventory]') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.[DNNMTL_DVD_Inventory]( [ModuleID] [int] NOT NULL, [dvdinventoryid] [int] IDENTITY(1,1) NOT NULL, [type] [int] NULL, [subtitle3] [int] NULL, [subtitle2] [int] NULL, [subtitle1] [int] NULL, [directed] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [rating] [int] NULL, [producer] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [picture] [varchar](5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [languuage3] [int] NULL, [languuage2] [int] NULL, [languuage1] [int] NULL, [dvdtitle] [varchar](300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [dvdid] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [datemod] [smalldatetime] NOT NULL, [datein] [smalldatetime] NOT NULL, [company] [int] NULL, [comment] [varchar](8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [userid] [int] NOT NULL, [userin] [int] NULL, [portalid] [int] not NULL, CONSTRAINT [PK_DNNMTL_DVD_Inventory] PRIMARY KEY CLUSTERED ( [dvdinventoryid] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) end System.Data.SqlClient.SqlException: Line 17: Incorrect syntax near '('. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Table DNNMTL_DVD_Inventory_company **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[DNNMTL_DVD_Inventory_company]') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.[DNNMTL_DVD_Inventory_company]( [ModuleID] [int] NOT NULL, [itemid4] [int] IDENTITY(1,1) NOT NULL, [dvd_company] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_DNNMTL_DVD_Inventory_company] PRIMARY KEY CLUSTERED ( [itemid4] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) end System.Data.SqlClient.SqlException: Line 14: Incorrect syntax near '('. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Table DNNMTL_DVD_Inventory_language **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[DNNMTL_DVD_Inventory_language]') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.[DNNMTL_DVD_Inventory_language]( [ModuleID] [int] NOT NULL, [itemid2] [int] IDENTITY(1,1) NOT NULL, [dvd_language] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_DNNMTL_DVD_Inventory_language] PRIMARY KEY CLUSTERED ( [itemid2] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) end System.Data.SqlClient.SqlException: Line 18: Incorrect syntax near '('. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Table DNNMTL_DVD_Inventory_rating **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[DNNMTL_DVD_Inventory_rating]') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.[DNNMTL_DVD_Inventory_rating]( [ModuleID] [int] NOT NULL, [itemid3] [int] IDENTITY(1,1) NOT NULL, [dvd_rating] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_DNNMTL_DVD_Inventory_rating] PRIMARY KEY CLUSTERED ( [itemid3] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) end System.Data.SqlClient.SqlException: Line 17: Incorrect syntax near '('. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Table DNNMTL_DVD_Inventory_type **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[DNNMTL_DVD_Inventory_type]') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.[DNNMTL_DVD_Inventory_type]( [ModuleID] [int] NOT NULL, [itemid] [int] IDENTITY(1,1) NOT NULL, [dvd_type] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_DNNMTL_DVD_Inventory_type] PRIMARY KEY CLUSTERED ( [itemid] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) end |
| Tterminer |
Exécution SQL terminée : fichier 01.00.00.SqlDataProvider |
| |
|
|
|
|
| |
|
| anonymous |
|
Inscrit(e) le : 0001-01-01
0 messages
|
|
|
quel est la version de DNN que tu utilise et quel est la version de SQL que tu as???
|
|
|
|
| |
|
| zomby |
|
Inscrit(e) le : 2006-10-11
10 messages
|
|
|
J'utilise SQL Server 2005 avec le plus récent DNN soit 4.3.5 et ton language pack FR-ca
|
|
|
|
| |
|
| zomby |
|
Inscrit(e) le : 2006-10-11
10 messages
|
|
|
Excuse-moi SQL Server 2000....
|
|
|
|
| |
|
| anonymous |
|
Inscrit(e) le : 0001-01-01
0 messages
|
|
|
J ai installer SQL 2000 et j’ai tester se script dans le querry analyzer et je n’est pas eu de problème.
Laisse moi si l’installation se passe bien et si le module est stable SVP
Merci
Francis
voir attachement
|
|
| | Vous connecter pour télécharger l'attachement |
|
|
|
| |
|
| zomby |
|
Inscrit(e) le : 2006-10-11
10 messages
|
|
|
 Salut Francis,
En effet ton dernier correctif s'est installé sans erreur, sauf que j'ai remarqué que tu ne créais pas de Primary key sur tes tables..est-ce voulu ? Il me semble que tes scripts avant créaient (entre autre) la primary key sur le champs "dvdInventoryId" de la table "DNNMTL_DVD_Inventory".
J'ai ajouté quand même ton module sur une des mes pages pour le tester....J'ai tout de suite tenté d'ajouter un DVD mais SANS AJOUTER les LANGUES et autres (les settings de base). J'ai eu l'erreur suivante en sauvegardant.
 |
Erreur: inconnue.
DotNetNuke.Services.Exceptions.ModuleLoadException: Conversion from string "" to type 'Integer' is not valid. ---> System.InvalidCastException: Conversion from string "" to type 'Integer' is not valid. ---> System.FormatException: Input string was not in a correct format. at Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat) at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) --- End of inner exception stack trace --- at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) at DNNMTL.Modules.DVD_Inventory.EditDVD_Inventory.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace --- |
J'ai donc regardé tes Stored Procedure et j'ai remarqué que les parametre "INT" causait probablement l'erreur de conversion de "String empty à INT".
J'en ai déduit que je devais d'abord créer les configurations de base avant d'ajouter un DVD à la liste !
Et ça a marché !!!!!!!
Suggestions : Peut-être pourrais-tu inscrire une couple d'enregistrements dans ton script de BD (ex: mettre 2 langues par défaut, 2 Compagnie), ainsi il n'y aurait jamais d'erreur de conversion si jamais le User tentait d'ajouter un DVD sans faire les configurations de base.
C'est super ton Module...beau travail !
p.s Je suis programmeur .NET aussi de mon côté mais je n'ai fais qu'un module très BASIC pou tester.
Tiens-moi au courant si tu y apporte des correctifs et Merci beaucoup !
|
|
|
|
| |
| | |
| | |
|
|
| |
Précédente
|
| | |
|
|
|
|
| |
|
|
Politique du Forum
Ce forum est dédié aux discussions à propos de DotNetNuke Web Application Framework.
Pour le bénéfice de la communauté de DNN Montréal, SVP suivre le guide de conduite suivant.
1. Aucune publicité. Ceci inclut la promotion commerciale et non commerciale qui ne
sont pas reliées au produit DotNetNuke Web Application Framework.
2. Aucun langage vulgaire ne sera toléré.
3. Aucun racisme, ou préjugé ne sera toléré.
4. Les administrateurs ont le dernier mot sur les discussions et les commentaires.
|
|
|