Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Will Not Connect
 New Topic
 Printer Friendly
Author  Topic Next Topic  

leatherlips
Senior Member

USA
1838 Posts

Posted - 14 April 2016 :  07:05:54  Show Profile  Visit leatherlips's Homepage  Reply with Quote
A few days ago I attempted to delete some posts from a spammer. I used a mod I installed years ago to delete all posts from a user. I messed up and clicked the wrong button and instead deleted all posts in a forum.

I had my host restore my files from the day before this happened to have the original database back. I have since tried to connect the config.asp file to the database but it will not work. I get a 500 Error Page.

What is weird is that I also have a script on the homepage of my website that shows the top 10 posts. Those posts show up in the script.

Any idea of what I am doing wrong?

My forum is at http://mangionemagic.com/forum/default.asp

Thanks.

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 14 April 2016 :  08:25:11  Show Profile  Visit HuwR's Homepage
You need to get rid of the generic 500 error display (or ask your host to disable it temporarily) so that we can determine the actual error

Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts

Posted - 14 April 2016 :  09:25:59  Show Profile  Visit leatherlips's Homepage
Got it. Here is the error:

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/forum/inc_func_common.asp, line 223

That line is:

my_conn.execute (strSql)

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD

Edited by - leatherlips on 14 April 2016 09:28:53
Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts

Posted - 14 April 2016 :  10:03:50  Show Profile  Visit leatherlips's Homepage
Figured it out. I had to reset the read/write permissions. Thanks!

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 14 April 2016 :  10:40:06  Show Profile  Visit HuwR's Homepage
glad it's sorted
Go to Top of Page

Maxime
Average Member

France
521 Posts

Posted - 14 April 2016 :  19:20:32  Show Profile  Visit Maxime's Homepage
Good evening,

Always back up the database before

Cordially,
Maxime

Taxation consists in so plucking the goose to get the most out of feathers with the least possible cries.(Jean-Baptiste Colbert)

Go to Top of Page
   Topic Next Topic  
 New Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.13 seconds. Powered By: Snitz Forums 2000 Version 3.4.07