DNN setup:

Host portal: hmc.writer.homeip.net
Child portal: boskone.hmc.gotdns.org
Portal alias' have been configured to allow local network access.
DotNetNuke is running out of the root of my webserver, not a virtual directory.

As administrator of the boskone portal, I created a vender and added banners. In the site settings I set banner advertising to site.
The only banner that would display is the default DotNetNuke banner.

I then logged into the hmc portal as host and created a host vender and added banners.
I went back to the boskone portal as admin and selected site for banner advertising. The banners then correctly displayed.

Logged in as admin to the boskone portal, I tried to edit the banners for the vendor I added. This is the error that was logged in the logviewer:

ModuleId: 385


ModuleDefId: 19


FriendlyName: Edit Banner


ModuleControlSource: Admin/Vendors/EditBanner.ascx


AssemblyVersion: 03.00.11


Method: System.Data.SqlClient.SqlCommand.ExecuteReader


FileName: 


FileLineNumber: 0


FileColumnNumber: 0


PortalID: 2


PortalName: Boskone's Sim Racing


UserID: 2


UserName: Admin


ActiveTabID: 87


ActiveTabName: Vendors


AbsoluteURL: /Default.aspx


AbsoluteURLReferrer: http://boskone.hmcomputers.local/Admin/Vendors/tabid/87/ctl/Banner/mid/385/BannerId/3/VendorId/2/Default.aspx


ExceptionGUID: bc9eeadb-a796-418d-8db3-84ef334faa04


DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider


InnerException: Invalid object name 'dnn_Banners'.


Message: Invalid object name 'dnn_Banners'.


StackTrace: 


Source: 


Server Name: HMC

Logged in as host into the hmc portal, I tried to edit the banners for the site vender. There were no errors generated in the logviewer and the only result was that the Banner Advertising section would collapse.

I know some of this has been reported before but I hope this will add a little more information to solve the problem.

I'm expriencing these same problems, site banners not getting rotated in and the following error when editing banners:

Error: Edit Banner is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'dnn_Banners'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dnn_Banners'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.UpdateBanner(Int32 BannerId, String BannerName, String ImageFile, String URL, Int32 Impressions, Double CPM, DateTime StartDate, DateTime EndDate, String UserName, Int32 BannerTypeId, String Description, String GroupName, Int32 Criteria) at DotNetNuke.Services.Vendors.BannerController.UpdateBanner(BannerInfo objBannerInfo) at DotNetNuke.Modules.Admin.Vendors.EditBanner.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace


I'll add to that, when you click Vendors, no vendors are shown. You have to select a letter or All to actually see any. This is inconsistent with how other forms within DNN function.

Me too,
"Error: Edit Banner is currently unavailable. "
Jos

From an announcement in the core team forum:

"the 3.0.11 script contains a hardcoded 'dnn_' in the UpdateBanner stored procedure. Any of you who are running DNN 3.0 in production and are using banners will need to correct it manually."

So if you have not set the objectqualifier set to dnn in web.config you must manually correct the UpdateBanner s.p.

Thanks Geert ;)
You are my friend.....
Jos