I'm not an expert in this area but there must be a logical reason why my phpnuke cms and all modules within it worked fine at my old host running MySQL 3 but not here.
It obviously has to do with the different MySQL versions, but what?
Does it have something to do with the charset or collation settings? Not sure what this latin1_swedish_ci is but it seems everything should be set to UTF-8 Unicode. Why is it not by default?
I have not read anywhere yet that phpnuke is not compatable with any version of MySQL, so why am I having so many problems here getting it all to work?
My site was built by me for my family to come and keep in touch with eachother and there has been much added there by them over the years that I don't want to delete so finding a new cms or starting over with the current one is not an option. I just want things to work! I'm willing to put in the time to fix it but I need some direction.
Can anyone help?