Print Page | Close Window

mySQL upgrading - 500 - Internal server erro

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


Topic: mySQL upgrading - 500 - Internal server erro
Posted By: slappyJ
Subject: mySQL upgrading - 500 - Internal server erro
Date Posted: 07 June 2018 at 11:36pm
Database is mySQL...upgrading from version 11 or somewhere abouts.

I removed all of the files from the Forum folder via FTP. Uploaded all the new files (version 12.01) made the username, password etc., changes to the database_settings.asp file.

When I go to the root /forum i get this error:

500 - Internal server error.

Trying to figure out what I am doing wrong.



Replies:
Posted By: WebWiz-Bruce
Date Posted: 08 June 2018 at 5:57am
You do not manually make change to the database_settings.asp file.

Instead put back in the un-edited files in the Database folder. Make sure the folder has write permissions, and then go to your forum in your web browser.

This will then start the install/upgrade wizard which will allow you to select the correct database driver, enter your database connections details, and upgrade your forums database to the latest release.

The full details on how to upgrade the mySQL version of Web Wiz Forums can be found on the page below;

https://www.webwiz.net/web-wiz-forums/kb/mySQL-upgrade.htm" rel="nofollow - https://www.webwiz.net/web-wiz-forums/kb/mySQL-upgrade.htm


-------------
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: slappyJ
Date Posted: 11 June 2018 at 9:27pm
I deleted all the files and re-uploaded.

I can get as far as the username, password etc., but when I test the server I get the 500 error. I am assuming that I am upgrading from version 11.x but I am not sure. How can I tell what version I was running?

I am using the correct login information. If I go back to the root of the folder (../forum) and try performing the upgrade again I get the 500 error. The only way I can get it to load again is to delete all files through ftp and start over again. But I will always get stuck again on the login information screen.




Posted By: WebWiz-Bruce
Date Posted: 12 June 2018 at 7:57am
Is the upgrade wizard running?

The upgrade wizard does not ask you for your login, it asks for your database connection string. Check with your ISP what the host name, database name, and database login is.

You also need to set write permissions on the forums 'database' folder so that the upgrade wizard can write to the settings files in that folder. 


-------------
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: slappyJ
Date Posted: 12 June 2018 at 11:01pm
Yes, the upgrade wizard was running...as I said I can only get as far as the database connection string page...when I apply the settings and test I get the 500 error. My forum was running perfectly fine and no settings were changed. I got frustrated and decided to try again fresh tomorrow.

But, now I can't even get the upgrade wizard to start anymore. I have completely removed all files and re-uploaded but when I try to access the root /forum I get nothing but the 500 error every time. I have tried 3 different browsers (removed all browser history, cookies etc.) I used FileZilla FTP and have set the database folder write permissions.

I'm stuck.


Posted By: WebWiz-Bruce
Date Posted: 14 June 2018 at 5:38am
Have your web host enabled detailed error messages for your website and classic ASP.

This will then give a detailed error message instead of the generic 500 message which will tell us exactly what the issue is.


-------------
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: slappyJ
Date Posted: 15 June 2018 at 2:40am
Host is telling me that ASP is already enabled.

If ASP is enabled shouldn't I already be seeing detailed error messages?

They also told me to enable error logging through .htaccess, php.ini file or Wordpress.

Unless you can offer up another suggestion I have run out of time today and will try again tomorrow.

Thanks


Posted By: WebWiz-Bruce
Date Posted: 15 June 2018 at 9:26am
I think your host has the wrong end of the stick.

You are not asking for Classic ASP to be enabled as it already is, what you need to ask them for is to enable Classic ASP to send error messages to the web browser, and for detailed error messages to be enabled in the Windows IIS web server.

This will allow you to see a detailed error message with the line number etc. instead of the generic 500 error. This detailed error message will point us straight to the issue.

The instructions that they gave to alter the .htaccess file or the PHP.ini file would be for Apache web servers running PHP. Web Wiz Forums does not run on Apache web servers and uses Classic ASP, so this is incorrect information, as you would need to be on a Windows IIS web server to run Web Wiz Forums.

We are primarily a web hosting company, and probably give better support then the one you host provided you. If you moved your website over to us we should be able to get it up and running in minutes.


-------------
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: slappyJ
Date Posted: 22 June 2018 at 9:52pm
I am now able to get more detailed error messages.

But, I am still getting hung up on the database folder not writeable error.

I have enabled read and write permissions in FileZilla to the database folder and also changed permissions to the database folder through Windows 7.

I can test the database connection with no errors but cannot proceed.

This link shows:

Checking and Setting up the Correct Permissions on the IIS Server

https://www.webwiz.net/kb/asp_knowledgebase/server_permissions.asp

In Windows 7 I added a group IIS_IUSRS (computername\IIS_IUSRS) with full control permissions and uploaded but still cannot proceed with the update.

The frustration continues. Confused



Posted By: WebWiz-Bruce
Date Posted: 25 June 2018 at 3:13pm
You can not set permissions through FTP on a Windows server, you can only do this on a Unix/Linux server, so setting permissions in FilZilla FTP client would notwork.

Permissions need to be set directly on the server or if using a web host thy usually have a way to do this through the hosting control panel.

You need to set read and write permissions on the 'database' folder for the user that the websites application pool runs under.

If you are using application pass through rather than setting a specific user try setting the permission for the 'IUSR' account.


-------------
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: slappyJ
Date Posted: 26 June 2018 at 4:01am
I managed to get the Database Setup Wizard to complete. (For future reference to anybody else having similar issues I was able to set read write permissions to the database folder through my hosts control panel...thank you Bruce).

Checking database. Please be patient as this may take a few minutes to complete.

Congratulations, Web Wiz Forums Database setup is now complete


But, now when I try to access the homepage http://www.kleenkuip.com/forum" rel="nofollow - www.kleenkuip.com/forum I get redirected to a 404 error page located here: http://kleenkuip.com/forum/forums.html" rel="nofollow - http://kleenkuip.com/forum/forums.html

Is this a problem with my host? All the relevant files within the forum folder are where they should be.


Posted By: WebWiz-Bruce
Date Posted: 26 June 2018 at 8:09am
It looks there is an issue with the URL Rewriting.

Check with your web host they have the IIS URL Rewrite Mod installed on the server and that you do not have URL Rewrite rules that are conflicting in your websites root web.config file.

If you have conflicting URL Rewrite rules in your websites root web.config you would need to move the forum to it's own website so they do not conflict. A sub domain websites such as forum.kleenkuip.com would be fine.

The other option is to disable the forums URL Rewriting features. To do this remove the forums web.config file and then login to the admin area by going to the /admin.asp page of the forum and from the SEO section disable URL Rewriting.

Remember as well browsers cache redirects so after any changes you may need to use a different browser or reboot your computer to flush any cached redirects from your browser.


-------------
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: slappyJ
Date Posted: 27 June 2018 at 4:36am
The issue has finally been resolved!

The solution was to delete the web.config file.

Thanks for all your help Bruce. Thumbs Up



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net