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

  New Posts New Posts RSS Feed - Cant get forum to work ???
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Cant get forum to work ???
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
allxtt View Drop Down
Newbie
Newbie
Avatar

Joined: 18 March 2003
Location: United Kingdom
Status: Offline
Points: 11 		Post Options Post Options   Thanks (0) Thanks(0)   Quote allxtt Quote  Post ReplyReply Direct Link To This Post Topic: Cant get forum to work ???
    Posted: 09 May 2003 at 6:57am

Hi

I have just installed the latest forum onto my database in sql2000. Tables and procedures have been added to the database but when i try to go to the default forum page I get this error. Please help, need to get this up and running asap. Thanks

Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/eaglemusicshop/forum/common.asp, line 254
Back to Top
allxtt View Drop Down
Newbie
Newbie
Avatar

Joined: 18 March 2003
Location: United Kingdom
Status: Offline
Points: 11 		Post Options Post Options   Thanks (0) Thanks(0)   Quote allxtt Quote  Post ReplyReply Direct Link To This Post Posted: 09 May 2003 at 7:11am

When I go to this link to try to login

/forum/admin/

and use Administrator and letmein i get this error

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Invalid column name 'Salt'.
/eaglemusicshop/forum/admin/common.asp, line 191

?????
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: 09 May 2003 at 7:46am

Sounds like the database is not made correctly.

Try deleting the database and re-running the SQL server setup script.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
allxtt View Drop Down
Newbie
Newbie
Avatar

Joined: 18 March 2003
Location: United Kingdom
Status: Offline
Points: 11 		Post Options Post Options   Thanks (0) Thanks(0)   Quote allxtt Quote  Post ReplyReply Direct Link To This Post Posted: 09 May 2003 at 7:50am
Hi
 
I cant delete the database cos its got all my other data in it, can i just go through and delete the webwiz tables and sp's ??
 
Thanks
James
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: 09 May 2003 at 7:53am
You'll have to then.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
allxtt View Drop Down
Newbie
Newbie
Avatar

Joined: 18 March 2003
Location: United Kingdom
Status: Offline
Points: 11 		Post Options Post Options   Thanks (0) Thanks(0)   Quote allxtt Quote  Post ReplyReply Direct Link To This Post Posted: 09 May 2003 at 7:55am

Ok, will delete all that stuff and try again, but why would it have not been made correctly in the first place. I am installing it on my local machine at the moment and have used these setting: Do they look OK? cheers

strSQLServerName = "JAMESDELL\JAMESDELL" 'Holds the name of the SQL Server
strSQLDBUserName = "eaglemus" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "banjo" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "Easymusicshop"     'Holds name of a database on the server
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: 09 May 2003 at 8:01am

Did the setup script return an error?

It could also be a permissions problem that you don't have sufficient permissions on the SQL server to create table, stored procedures, etc. or run these.

Also make sure if you have changed the table and stored procedure pre-fixes that you have done this in the SQL server setup file and the common.asp files.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
allxtt View Drop Down
Newbie
Newbie
Avatar

Joined: 18 March 2003
Location: United Kingdom
Status: Offline
Points: 11 		Post Options Post Options   Thanks (0) Thanks(0)   Quote allxtt Quote  Post ReplyReply Direct Link To This Post Posted: 09 May 2003 at 8:06am

After I added a new database username and password and applied what i thought were the correct permissions, then ran the set up, no errors were encountered, although I had tried unsuccessfully before.

It pulled a up a page saying successfully installed ... or something.

After it says that which is the next page you should go to, to configure as there was not a link?

Do you know the exact permissions I would need to give in sql server, why would it create some tables and sp's and not others ???

I know sql can be fiddly but i'm No expert... Thanks
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.