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
Topic Options
Post Options
Thanks(0)
