Pirate
05-08-2005, 10:57 AM
Well my funning with Mysql continues. The IT guys here don't know how to fix it so Im fucked. Basically my problem is that I can't save any data into a database. I can create them, set up tables etc but I just can't get any data into the database from the web. But I can edit them manually.
I've checked the privilages and I'm dead sure this is the problem. I got them to run the fix from yesterdays problem (http://forums.zgeek.com/showthread.php?t=39185) but now this new one has turned up. I've done some searching but all the answers are ones I don't understand because I dunno mysql that well as I only ever used phpmyadmin. They've given me root access to fix the problem myself, but I got no fucking idea what to do.
This is the error I get when going to check the database's privilages in phpmyadmin. Users having access to "deftpayments"
Error
SQL-query :
(
SELECT `User` , `Host` , `Db` , `Select_priv` , `Insert_priv` , `Update_priv` , `Delete_priv` , `Create_priv` , `Drop_priv` , `Grant_priv` , `References_priv`
FROM `db`
WHERE "deftpayments"
LIKE `Db` AND NOT (
`Select_priv` = "N" AND `Insert_priv` = "N" AND `Update_priv` = "N" AND `Delete_priv` = "N" AND `Create_priv` = "N" AND `Drop_priv` = "N" AND `Grant_priv` = "N" AND `References_priv` = "N"
)
)
UNION (
SELECT `User` , `Host` , "*" AS "Db", `Select_priv` , `Insert_priv` , `Update_priv` , `Delete_priv` , `Create_priv` , `Drop_priv` , `Grant_priv` , `References_priv`
FROM `user`
WHERE NOT (
`Select_priv` = "N" AND `Insert_priv` = "N" AND `Update_priv` = "N" AND `Delete_priv` = "N" AND `Create_priv` = "N" AND `Drop_priv` = "N" AND `Grant_priv` = "N" AND `References_priv` = "N"
)
)
ORDER BY `User` ASC , `Host` ASC , `Db` ASC ;
MySQL said:
Illegal mix of collations (utf8_bin,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'UNION'
User Host Type Privileges Grant Action Can anyone point me in the right direction to fix this?
I've checked the privilages and I'm dead sure this is the problem. I got them to run the fix from yesterdays problem (http://forums.zgeek.com/showthread.php?t=39185) but now this new one has turned up. I've done some searching but all the answers are ones I don't understand because I dunno mysql that well as I only ever used phpmyadmin. They've given me root access to fix the problem myself, but I got no fucking idea what to do.
This is the error I get when going to check the database's privilages in phpmyadmin. Users having access to "deftpayments"
Error
SQL-query :
(
SELECT `User` , `Host` , `Db` , `Select_priv` , `Insert_priv` , `Update_priv` , `Delete_priv` , `Create_priv` , `Drop_priv` , `Grant_priv` , `References_priv`
FROM `db`
WHERE "deftpayments"
LIKE `Db` AND NOT (
`Select_priv` = "N" AND `Insert_priv` = "N" AND `Update_priv` = "N" AND `Delete_priv` = "N" AND `Create_priv` = "N" AND `Drop_priv` = "N" AND `Grant_priv` = "N" AND `References_priv` = "N"
)
)
UNION (
SELECT `User` , `Host` , "*" AS "Db", `Select_priv` , `Insert_priv` , `Update_priv` , `Delete_priv` , `Create_priv` , `Drop_priv` , `Grant_priv` , `References_priv`
FROM `user`
WHERE NOT (
`Select_priv` = "N" AND `Insert_priv` = "N" AND `Update_priv` = "N" AND `Delete_priv` = "N" AND `Create_priv` = "N" AND `Drop_priv` = "N" AND `Grant_priv` = "N" AND `References_priv` = "N"
)
)
ORDER BY `User` ASC , `Host` ASC , `Db` ASC ;
MySQL said:
Illegal mix of collations (utf8_bin,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'UNION'
User Host Type Privileges Grant Action Can anyone point me in the right direction to fix this?