Great, that opened a few doors for me. Thanks! I am however still experiencing some issues getting two installs to go smoothly. The first always goes smooth, it's the second one that continues to be a little thorn in my side.
What I am doing is this:
- The first site contains no objectQualifier value, so the tables are created without any extension.
- The second, I append an objectQualifier value, authupgrade is set to false as is InstallMemberRole
- During install, I err out with this
DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database.
The stored procedure 'dbo.amg_GetPortalAliasByPortalID' doesn't exist.
- I dug a little into this and have come out with something I hope makes sense...lol
I took a look at the SQL tables that were made and found only one table was created for the second install, amg_Versions. A little further digging resulted in finding the install scripts for the database objects. In looking at the first few lines of 00.00.00.SqlDataProvider I see that table Version is renamed to {objectQualifier}Version. This seems to jive with the error I continue to see on the second site install. So, during the second install, the SQL install scripts found an existing table named versions
if exists (select * from dbo.sysobjects where id = object_id(N'Version') and OBJECTPROPERTY(id, N'IsTable') = 1)
And then continues of to:
if '{objectQualifier}' <> ''
begin
EXECUTE sp_rename N'{databaseOwner}Version', N'{objectQualifier}Version', 'OBJECT'
Now, I would hope that object qualifier is populated, since I've provided it in the config. But following this seems to point to a bug maybe? I'm still becoming familiar with the inner-workings of DNN, so instead of possibly chasing a rabbit down a hole, I'd like to see if anyone agrees/disagrees with this.
My questions are: If this is a common issue, where can I find info to help me resolve this? It seems to me at this point I can call this a bug, but I can't since I'm not that familiar with the system yet. :)
Thanks Cathal for the assist earlier! And thanks in advance to any that choose to respond.
Cheers!
Wayne