Web Wiz Support and Community Forums : Upgrade test and errors https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 15:20:05 +0000 Sun, 29 Jan 2006 12:18:29 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18074 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Upgrade test and errors : It would probaly be even worse.All...]]> https://forums.webwiz.net/upgrade-test-and-errors_topic18074_post98379.html#98379 Author: WebWiz-Bruce
Subject: 18074
Posted: 29 January 2006 at 12:18pm

It would probaly be even worse.

All the database systems use different datatpes and require different work arounds in the database in order for them to work with the forum code.
]]> Sun, 29 Jan 2006 12:18:29 +0000 https://forums.webwiz.net/upgrade-test-and-errors_topic18074_post98379.html#98379 <![CDATA[Upgrade test and errors : Borg, it seems as though an MS...]]> https://forums.webwiz.net/upgrade-test-and-errors_topic18074_post98364.html#98364 Author: niugiovanni
Subject: 18074
Posted: 29 January 2006 at 5:17am

Borg, it seems as though an MS SQL to MySQL transition would be pretty smooth and clean contrary to Access.  Is this correct?]]> Sun, 29 Jan 2006 05:17:06 +0000 https://forums.webwiz.net/upgrade-test-and-errors_topic18074_post98364.html#98364 <![CDATA[Upgrade test and errors : These are all known issues and...]]> https://forums.webwiz.net/upgrade-test-and-errors_topic18074_post97933.html#97933 Author: WebWiz-Bruce
Subject: 18074
Posted: 23 January 2006 at 2:19pm

These are all known issues and most have been fixed for the next release.

However, mySQL can be very tempormental, so I have had to make some changes to the mySQL setup file to force it to work. This means that using an Access to mySQL convert tool will most likely mean you have a database that will not function correctly.
]]> Mon, 23 Jan 2006 14:19:11 +0000 https://forums.webwiz.net/upgrade-test-and-errors_topic18074_post97933.html#97933 <![CDATA[Upgrade test and errors : To test out the new version, I...]]> https://forums.webwiz.net/upgrade-test-and-errors_topic18074_post97861.html#97861 Author: Meson
Subject: 18074
Posted: 22 January 2006 at 4:45am

To test out the new version, I attempted to upgrade my version 7 database to mysql for v.8.  Sicne this will eb an issue with the full release version, I decided it was a good idea to do it.
 
The upgrade when fairly ok. I used one of the access upgrade scripts floating around here to upgrade teh access database. THen I used ODBC and Access to transfer the data over to MySQL (5.1). The only issue was that Access transered all the boolean fields as bit fields, whc are unreadable by mySQL. It took me a while to convert the data over to tinyint fields. There were other minor issues, mostly with the size of the transfered varchars, but nothing as exciting as the booleans.
 
Once the database was complete, the real bugs popped up. None of the admin section worked. The pages read the data fine, but I couldn't change anything. I keep getting erros like this:
 
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Technical Information (for support personnel)
  • Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
    Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
    /forums/admin_forum_configure.asp, line 151
  • Browser Type:
    Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Maxthon; .NET CLR 1.1.4322; .NET CLR 2.0.50727) 
  • Page:
    POST 473 bytes to /forums/admin_forum_configure.asp 
  • POST Data:
    forumName=Toon+Radio+Forums&siteName=Toon+Radio&siteURL=http%3A%2F%2Fwww.toonradio.net&forumPath=http%3A%2F%2Fwww.toonradio.net%2Fforum%2F&titleImage=..%2Fimages%2Fforumlogo.png&textLinks=True&activeU . . .

Since, I couldn't reset the forum permissions without manually chaning them directly in mySQL, I wnet back to the access version.
 
There was, however, some issues with the access version. These issues were also present in the mysql version, they might be in the mssql one as well.
 
Basically none of the skin stuff worked. I could edit the information in the admin area, but they wouldn't show up in the main forums nor the admin area.
 
The image path info doesn't get pulled from the database. It shows up as empty strings.
The forum path separator wasn't add to the path list. It shows up as empty strings.
The CSS file wasn't added o the pages. It shows up as empty strings.
 
I managed to fix them all manually, but you should definitely look into this.


Edited by Meson - 22 January 2006 at 4:52am]]> Sun, 22 Jan 2006 04:45:14 +0000 https://forums.webwiz.net/upgrade-test-and-errors_topic18074_post97861.html#97861