while i was testing my new mysql forum i put it in a test folder, when it was working properly i changed it back to the other folder. this is when things started going wrong. the main page loaded fine, with all the forums and stuff.. but i couldnt get in to the forums.. it was still trying to use the access database? so i changed the folders back again and they worked fine again.. then i delete the "forums" folder on the root of my server.. but i could still access it?!
so i deleted everything. then i reuploaded snitz, resent all the data from the access database to the mysql database.
when i loaded it up everything looked fine.. except none of the settings were carried across.. colour schemes.. images.. etc.. it just looked like a default snitz forum with my original data on it.. then i made a post, which worked fine.. then i went back to the forum - where it says how many times the thread has been read it was blank? and every previous post on the forum said "Edited by - on" at the bottom
ive gone back to access. any help would be greatly appreciated because we are running out of space on our server and access takes up far too much space!<
quote:Originally posted by FourARSEDSheep ive gone back to access. any help would be greatly appreciated because we are running out of space on our server and access takes up far too much space!
So does an access db require more space than a mySQL db, for the same number of posts / members?<
Got the following error having followed the steps at the start of this topic:
quote:Error
SQL-query :
LOAD DATA LOCAL INFILE 'C:\\WINDOWS\\TEMP\\php465.tmp' INTO TABLE `forum_badwords` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
MySQL said:
The used command is not allowed with this MySQL version
Is it at all possible to use the converted database with other forums? Ie. Invision or phpBB? Or does this require another method? Thanks
Yes, you will not be able to use Invision or phpBB with the Snitz table structure Snitz uses. You will have to ask/search at their site if the provide a converter which organizes the Snitz data for use with other forums.<
While it's fresh in my mind thought I'd post this little gotcha on conversions to mySQL.
I did a conversion earlier this week and there were complaints that the badword filter wasn't working correctly afterwards. Turns out they had several filters loaded with a space after the text so that words like assume didn't get filtered. This in itself wasn't an issue. However the field for the badwords in the database is type VARCHAR and theres an interesting "feature" of mySQL that trims all trailing spaces from data in VARCHAR fields, so consequently these filters were no longer working correctly.
Fairly simple fix was to delete that field and redefine it as type text which retains the trailing space (I tried CHAR but for some reason mySQL kept chaing it to VARCHAR even though I had explictly said CHAR in my CREATE statement.)<
I've converted my access database to mysql, and I'm having a problem with the connect string. I'm hoping someone can point me in the right direction. Currently I'm getting the following error message:
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed.
Open the www.miltonhog.ca home page, and then look for links to the information you want. HTTP 500.100 - Internal Server Error - ASP error Internet Information Services
How I converted my Access DB to mySQL - A guide
Posted - 14 February 2004 : 13:39:23
