Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - problem integrating WebWizForums into NewsPad
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum Lockedproblem integrating WebWizForums into NewsPad
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
jameswcollett View Drop Down
Newbie
Newbie
Avatar

Joined: 19 August 2007
Location: United Kingdom
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jameswcollett Quote  Post ReplyReply Direct Link To This Post Topic: problem integrating WebWizForums into NewsPad
    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.
 
Back to Top
jameswcollett View Drop Down
Newbie
Newbie
Avatar

Joined: 19 August 2007
Location: United Kingdom
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jameswcollett Quote  Post ReplyReply Direct Link To This Post 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...?


Edited by jameswcollett - 19 August 2007 at 4:34pm
Back to Top
Aber28 View Drop Down
Newbie
Newbie


Joined: 07 August 2007
Status: Offline
Points: -2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Aber28 Quote  Post ReplyReply Direct Link To This Post Posted: 01 September 2007 at 6:11am
EXACT issue with me! :( we need to solve this A.S.A.P.!
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jameswcollett View Drop Down
Newbie
Newbie
Avatar

Joined: 19 August 2007
Location: United Kingdom
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jameswcollett Quote  Post ReplyReply Direct Link To This Post 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?
 


Edited by jameswcollett - 01 September 2007 at 10:33am
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jameswcollett View Drop Down
Newbie
Newbie
Avatar

Joined: 19 August 2007
Location: United Kingdom
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jameswcollett Quote  Post ReplyReply Direct Link To This Post Posted: 01 September 2007 at 10:53am

Thanks for that clarification.

I thought maybe a default value had gone astray.
 
Back to Top
Aber28 View Drop Down
Newbie
Newbie


Joined: 07 August 2007
Status: Offline
Points: -2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Aber28 Quote  Post ReplyReply Direct Link To This Post Posted: 01 September 2007 at 11:11am
Thanks a lot borg for the clarification.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.