|
 | |
 | seadrive | | Asp.Net User |
| Missing Tables in DotNetNuke Database | 6/11/2005 6:25:18 PM |
| 0 |   |
|
Okay, here's a weird one...
I was finally able to successfully install 3.1.0 on my machine at home,
but when the portal opens, there are messages in each of the default
modules like: "Error: <Module Name> is currently unavailable."
When I log in as host, the stack trace text is displayed in each of the
module containers. In each case, the error indicates that the SQL
data provider was unable to locate the source table in the database.
So I run Enterprise Manager, and sure enough, I don't have a table named Announcements, Links, or HTMLText. However, I do have a Banners table, and if I add a Banner module, it works just fine, no errors.
I added a Links table to the database, and of course I now get an error
that column such-and-such was not found, because I don't know what the
structure of each table is supposed to be.
FYI, I set databaseOwner="dnnuser" in the defaultProvider section of
web.config. dnnuser has System Admin rights, and dbo_owner
permission on the DotNetNuke database.
Anyone know where I can find the data definitions of the various
modules? At this point, I'd rather create the tables myself,
rather than start over (sigh).
Regards,
Steve |
| ecktwo | | Asp.Net User |
| Re: Missing Tables in DotNetNuke Database | 6/11/2005 6:59:32 PM |
| 0 | |
| |
| Geert | | Asp.Net User |
| Re: Missing Tables in DotNetNuke Database | 6/12/2005 8:04:00 AM |
| 0 | |
|
It is a problem with the module's sql scripts. This was discussed / reported here: http://forums.asp.net/951904/ShowPost.aspx
Geert Veenstra |
| seadrive | | Asp.Net User |
| Re: Missing Tables in DotNetNuke Database | 6/12/2005 2:52:18 PM |
| 0 | |
|
Okay, I've tried this so many ways now, my head is spinning...
The only way I've been able to install the Announcements module is by
copying the SQL scripts into the SQL Query Analyzer, doing a global
search and replace on {databaseOwner} (replace with [dnnuser]. <== Notice the ".") and {objectQualifier} (replace with (nothing)), and executing the modified scripts from there.
Just changing "{databaseOwner}sysobjects" to "dbo.sysobjects"
did not do the trick for me. I thought that perhaps the install
script was replacing {databaseOwner} with "[dnnuser]", without the
period between the owner name and the object name, so I tried globally
replacing all "{databaseOwner}" with "{databaseOwner}.", but that didn't work either.
I deleted the Announcements table that I had created manually before each attempt to get DNN to install the module by itself.
Maybe DNN "sees" that the module has already been installed (even
though the table was not created), and so does not process the SQL
script???
Anyway, for now, I'll just install the remaining modules manually, as I
don't have any energy left to fight with this right now...
on edit: I tried it with the FAQs module; no joy, had to install it manually. (sigh)
Regards,
Steve |
| seadrive | | Asp.Net User |
| Re: Missing Tables in DotNetNuke Database | 6/12/2005 5:21:14 PM |
| 0 | |
|
 Geert wrote: | You need to remove the module first (using the delete button in module definition).
Otherwise the module installer sees no change in the module version number and will not execute the sql script. |
|
Are you referring to the Modules list in the Recycle Bin?
Regards, Steve |
| cathal | | Asp.Net User |
| Re: Missing Tables in DotNetNuke Database | 6/12/2005 11:47:33 PM |
| 0 | |
|
| seadrive wrote: | Thanks Geert!
I've almost finished executing all the DDL scripts manually, but I'll give that a try with the remaining ones.
While manually running the scripts, I got an error on the cascading delete RI rule for the Links table, I believe. I'm going to do some more work on that today. If it looks like a bug, I'll post it here.
|
|
Steve, Are you using SQL 2000, as DNN doesn't work with SQL7. The reason I ask, is that SQL7 did not support cascading deletes. Cathal |
|
| |
Free Download:
Books:  Beginning DotNetNuke 4.0 website creation in C# 2005 with Visual Web Developer 2005 Express: from novice to professional Authors: Nick Symmonds, Nicholas Symmonds, Pages: 391, Published: 2006 Beginning DotNetNuke 4.0 Website Creation in VB 2005 with Visual Web Developer 2005 Express: From Novice to Professional Authors: Nick Symmonds, Pages: 448, Published: 2006 Professional DotNetNuke 5: Open Source Web Application Framework for ASP.NET Authors: Shaun Walker, Brian Scarbeau, Tracy Wittenkeller, Darrell Hardy, Stan Schultes, Ryan Morgan, Pages: 600, Published: 2009 Lotus Notes and Domino 6 system administrator Authors: Tony Aveyard, Karen Fishwick, Dennis Malone, Ed Tittel, Pages: 584, Published: 2003 Acronyms, Initialisms and Abbreviations Dictionary: A Guide to Acronyms, Abbreviations Contractions, Alphabetic Symbols, and Similar Condensed Appellations Authors: Mary Rose Bonk, Pamela Dear, Gale Group, Pages: 2373, Published: 1999 Web:Listing DotNetNuke Database versions in all your databases Jan 21, 2009 ... erikvb: @angstrey also: the links module has been missing a lot of TLC for a ... The first part is getting the DNN version from a DNN database. ... actually first test if it can find a DNN version table in the database, ... missing object qualifier? - Store Module [Lead: Gilles Le Pigocher ... The conflict occurred in database 'teststore', table 'pjs_Store_Cart', column ' CartID'. ... Re: missing object qualifier? ... Error Installing DNN...Invalid object name 'Version'. - Install It ... This table has one record that contains current DNN database version number, it's ether missing from your database or the DB user you are ... DNN Database Object Qualifier - AspDotNetStorefront Community ... DNN Database Object Qualifier AspDotNetStorefront ML/DNN. ... because it makes it easy to find tables and stored procs that are missing the ... All tables where deleted - ASP.NET Forums Not noly were the dnn tables missing - the whole DotNetNuke Database was gone. The dnnuser was still there. Is this a SQL inject issue? ... |
|
|
|