Web Wiz NewsPad - problem integrating WebWizForums into NewsPad

Print Page | Close Window

problem integrating WebWizForums into NewsPad

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz NewsPad
Forum Description: Support forum for the Web Wiz NewsPad application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24215
Printed Date: 28 March 2026 at 4:56pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: problem integrating WebWizForums into NewsPad

Posted By: jameswcollett
Subject: problem integrating WebWizForums into NewsPad
Date Posted: 19 August 2007 at 4:27pm

I have just downloaded and installed the latest current demo versions of WebWizForums (v9.03) and NewsPad (v1.01).

The feature to integrate these two apps appears to be live in the demo versions but it is not working and I should like to check whether this is a feature that is meant to work only in the paid-for versions.

I first installed WebWizForums, by the book, including shifting the database to a safe location and changing the Admin username and password. I left the option to integrate NewsPad switched off at this point because NewsPad was not yet installed.

Then I installed NewsPad, again by the book, nothing fancy, again changing the Admin username and password and moving the database to a safe location.

I returned to WebWizForums and switched on the feature to integrate NewsPad. This seemed okay.

Then I returned to my NewsPad installation and attempted to activate the feature to integrate WebWizForums. When I clicked the test button, the following error message was displayed in the popup:-

+++

The database conbnection has been tested.

A connection to the database has been established but an error has occurred while attempting to open the database table.

Please check you are connecting to a Web Wiz Forums database, and that the table prefix is correct.

Error details:-
Microsoft JET Database Engine
The Microsoft Jet database engine cannot find the input table or query 'Author'. Make sure it exists and that its name is spelled correctly.

+++

I'm sad to get stumped at this early stage and would like to check these two apps out properly.

Any advice greatfully received.

-------------
Look up, not down.

Replies:

Posted By: jameswcollett
Date Posted: 19 August 2007 at 4:32pm

I've also just had a go at creating a test newsletter and got this following error:-

+++

Server Error in Forum Application
An error has occurred while executing SQL query on database.
Please contact the Newsletter Administrator.

Support Error Code:- err_Access_web_wiz_forums_group_data
File Name:- admin_newsletter_details.asp

Error details:-
Microsoft JET Database Engine
Syntax error in FROM clause.

+++

I guess this is related to the initial error...?

-------------
Look up, not down.

Posted By: Aber28
Date Posted: 01 September 2007 at 6:11am

EXACT issue with me! :( we need to solve this A.S.A.P.!

Posted By: WebWiz-Bruce
Date Posted: 01 September 2007 at 9:53am

The error in the first post in due to the fact a table prefix hasn't been entered.

Make sure you have entered :-

tbl

As the database table prefix if using a standard install of web wiz forums.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: jameswcollett
Date Posted: 01 September 2007 at 10:03am

It's official - I'm daft!

But I cannot find where to set this "table prefix" thing now. For a kickoff is this a forum or newspad setting. Then is it a setting accessed via the admin control panel or is it a tweak in a config file?

I was vaguely up to speed on this when I was installing ten days ago! Seems like a lifetime already.

Please help.

*** STOP PRESS *** 01-SEP-2007

It looks like I have found it - it is in the Newspad admin section.

The advice above says that I need to make the table prefix "tbl" if it is a standard install, which is indeed the case. So I entered "tbl" in the text field and updated the settings. The the test button gave the result:-

Test Database Connection
The database conbnection has been tested. The database connection was sucessful

So I guess I am on the home strecth now.

So thanks for that!

However, I should note that in the admin page where I set this up it reads:-

Database Table Prefix:
You only need to alter this in the rare case that you have changed the database table

prefix for your Web Wiz Forums database tables.

So I had left it blank (i.e. did not alter it) because I had not made any changes, and that is why the test failed. I think that this instruction is quite misleading. Or have I missed some documentation that clarifies this apparent contradiction?

-------------
Look up, not down.

Posted By: WebWiz-Bruce
Date Posted: 01 September 2007 at 10:39am

Looks like a typo in the Access version.

In the database the table should have been setup with the default value 'tbl' which would have meant the instructions were correct as it would have displayed 'tbl' by default in this textbox.

The database has been updated to amend this so other don't get stuck with the same problem. Will also look at updating the instructions to make it clear what the default value should be.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: jameswcollett
Date Posted: 01 September 2007 at 10:53am

Thanks for that clarification.

I thought maybe a default value had gone astray.

-------------
Look up, not down.

Posted By: Aber28
Date Posted: 01 September 2007 at 11:11am

Thanks a lot borg for the clarification.

Posted By: duplo1
Date Posted: 28 September 2007 at 2:48pm

I have changed the PREFIX according to my SQL Server Database (dbo.tbl) and I still get the error message.

Posted By: WebWiz-Bruce
Date Posted: 28 September 2007 at 5:00pm

It won't be dbo.tbl, DBO is the database user who owns the table, you need to enter just tbl without the dbo. part.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: duplo1
Date Posted: 28 September 2007 at 5:32pm

I have tried that as well. And it does not work. I get the same error message as described before.

Posted By: WebWiz-Bruce
Date Posted: 28 September 2007 at 6:52pm

The error message list previously is a JET database engine error for an Access database, and you said you are using SQL Server, so unless you have selected the wrong database type it would not be possible for you to have a JET database error.

Make sure you have selected the correct database type in NewsPad, and if you still have an issue start a new topic on the issue giving as much detail are possible including the error message.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: duplo1
Date Posted: 28 September 2007 at 7:03pm

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid object name 'tblAuthor'.

I am using SQL Server !

Posted By: WebWiz-Bruce
Date Posted: 28 September 2007 at 7:19pm

OK that is a different error message to that in the previous posts on Access.

This error means that it is connecting to an SQL Server database but can not find the table tblAuthor.

Make sure that you are connecting to the Web Wiz Forums database, and not another database or the NewsPad database and that it contains the table tblAuthor.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: duplo1
Date Posted: 28 September 2007 at 9:27pm

Believe me, there is a table AUTHOR in the database. That is why I don't understand this error message.

Christoph