Database Problems

[Nik]

Seems parts of this forum dont like the new version of MySQL.

I have managed to get things almost back up to date but any posts made or new user registrations in the last 24 hours may have been lost.

 

[hyb]

yup yup, avatar upload doesn't seem to work, was going to replace mine with....

 

[Nik]

Ahh yes, good old directory permissions...

I've fixed that problem now and added the avatar for you, cheers for pointing that out

 

[hyb]

few more with uploading pics in garage nik,

Warning: copy(garage/upload/garage_gallery-37-1133358214.jpg): failed to open stream: Permission denied in /mounted-storage/home8/sub002/sc11639-IFOV/www/cliotrophy/forum/includes/functions_garage.php on line 1129

Warning: getimagesize(): Unable to access garage/upload/garage_gallery-37-1133358214.jpg in /mounted-storage/home8/sub002/sc11639-IFOV/www/cliotrophy/forum/includes/functions_garage.php on line 1137

Warning: getimagesize(garage/upload/garage_gallery-37-1133358214.jpg): failed to open stream: No such file or directory in /mounted-storage/home8/sub002/sc11639-IFOV/www/cliotrophy/forum/includes/functions_garage.php on line 1137

Warning: Cannot modify header information - headers already sent by (output started at /mounted-storage/home8/sub002/sc11639-IFOV/www/cliotrophy/forum/includes/functions_garage.php:1129) in /mounted-storage/home8/sub002/sc11639-IFOV/www/cliotrophy/forum/includes/functions.php on line 851

 

[Nik]

Ok cheers, i'll have a look at that.

The garage is the thing thats caused all the problems. The changes that the garage makes to some of the queries across the site cause the queries to fail now the database is on a MySQL 5 server when it worked fine on MySQL 4....

 

[hyb]

If it aint broke...upgrade it!

 

[Nik]

Yeah, sadly I wasn't warned that moving to the new server cluster for the site hosting also had a different level of mysql..... :x I hate not being in control of this sort of stuff. Dedicated server anyone?

Still the site seems to perform much better at least #-o