Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Variable is undefined: 'strDbTable'
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Variable is undefined: 'strDbTable'

 Post Reply Post Reply
Author
oorubenoo View Drop Down
Newbie
Newbie
Avatar

Joined: 22 December 2011
Location: Florida
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote oorubenoo Quote  Post ReplyReply Direct Link To This Post Topic: Variable is undefined: 'strDbTable'
    Posted: 24 June 2016 at 7:06pm
My prior website got hacked I went ahead and downloaded the newest version, and when I try to install to convert the database (v8 to v11) i get this error message:

Microsoft VBScript runtime error '800a01f4'

Variable is undefined: 'strDbTable'

/forum2/includes/global_variables_inc.asp, line 343

under database_settings.asp I see:

'Set up the database table name prefix

'(This is useful if you are running multiple forums from one database)

strDbTable = "tbl"


but when i accessed the database there is nothing that's just tbl. any help would be appreciated

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: 27 June 2016 at 8:01am
I suspect that the issue is caused by not replacing the files in the 'database' folder with those from the latest version.

To fix the issue;

1. Replace all the files in your forum including those in the 'database' folder with those from the latest version.

2. Make sure you have write permissions enabled on the 'database' folder so that the upgrade wizard can write to the files in this folder required for the forum setup/upgrade.

3. Go to your forum in your web browser were you will have the upgrade wizard run and follow the on screen instructions.

Full upgrade instructions for the SQL Server version can be found on the page below;

https://www.webwiz.net/web-wiz-forums/kb/sql-server-upgrade.htm
Back to Top
oorubenoo View Drop Down
Newbie
Newbie
Avatar

Joined: 22 December 2011
Location: Florida
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote oorubenoo Quote  Post ReplyReply Direct Link To This Post Posted: 28 June 2016 at 7:04pm
Bruce,

I ended up converting over to MySQL Server 5.0.96 ; but i'm not able to connect its stating:


Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the Forum Administrator.

Support Error Code:- err_mySQL_db_connection
File Name:- database_connection.asp
Forum Version:- 11.05

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


Any idea? Also, if we open a web hosting with your company can you finish the implemnetation of the upgrade for us?
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: 30 June 2016 at 8:10am
The error means the myODBC 5.1 driver required for Classic ASP to be able to connect to a mySQL database is not installed on the server.

You would need to have the myODBC 5.1 driver installed on the web server.

If you were to host the forum with us we provide a Web Wiz Forums Migration Service for £19.95 that includes upgrading to the latest version.
Back to Top
 Post Reply Post Reply

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.