| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> !man reserved variables
<1> Nothing found.
<2> ugh
<2> doesn't help :(
<2> Can someone with better SQL knowledge have a look at the following statement and say what's wrong with it
<2> SELECT m.*,md.name,md.desc ,mm.*
<2> FROM ps_cs_plrmaps as m, ps_cs_defs_maps as md
<2> LEFT JOIN ps_cs_plrmaps_cstrike as mm
<2> ON mm.plrmapid=m.plrmapid
<2> WHERE md.id=m.mapid AND m.plrid=22846 AND m.statdate='2006-05-14'
<2> MySQL says on this: ERROR 1054: Unknown column 'm.plrmapid' in 'on clause'
<2> I've simplified the expression as much as:
<2> SELECT 1
<2> FROM ps_cs_plrmaps as m, ps_cs_defs_maps as md
<2> LEFT JOIN ps_cs_plrmaps_cstrike as mm
<2> ON mm.plrmapid=m.plrmapid
<3> when im su --shell=/bin/sh; mysql -u mysql; use mysql; select * from user; says access denied WHY?
<3> mysql 4.1.11
<2> because user mysql doesn't have access to the user table
<3> so how do i make it work
<3> root gives access denied
<2> check permissions with mysql-administrator or myphpadmin or mysqlcc or whatever
<3> im in shell mode
<3> phpmyadmin doesnt work
<2> maybe mysql doesn't have access to the table file
<3> how can i check
<2> check /var/lib/mysql/mysql/* for read access from user mysql
<3> some are root root
<4> evening! is there a way to force the output strings to be utf8?
<3> ib*
<2> js1: thats bad
<2> js1: chown mysql:mysql /var/lib/mysql/* -R
<3> operation not permitted
<3> shutdown mysql?
<2> no
<2> do it as root
<2> most probably you ran myisamchk as root on those tables
<3> mdone
<2> pluesch0r: in mysql 5.0 as far as I understand utf-8 is the default encoding
<3> oh i see
<3> we are 3 root admin so :P
<3> one is newb
<3> ;)
<4> zap: yeah well .. the problem is, that i just upgraded from 4.0 to 5.0 - and my data is in latin1 ...
<4> but i really need the data to be utf8, 'cause otherwise openldap isn't able to concat ..
<2> run mysql-administrator and set default encoding to utf-8 then
<4> the default db encoding is already utf8.
<2> but openldap should really use the 'set names utf-8' command upon connecting
<4> it should. yeah. it doesn't.
<4> see http://www.openldap.org/lists/openldap-software/200312/msg00106.html
<2> otherwise you can put init-connect="SET NAMES utf-8" in your /etc/my.cnf in the [mysqld] section
<3> lready utf8.
<3> <2> but openldap should really use the
<4> but this will not change the latin1 umlauts in my database, will it?
<3> oops
<3> mysql> mysql> use mysql;
<3> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> use mysql' at line 1
<3> mysql> ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
<3> ->
<4> so .. i need some function that automagically converts latin1 umlauts to utf8.
<2> mysqldump then restore
<4> this is not an option. the php application that works with those tables is not utf8 save.
<4> i only need to represent the data as if it were utf8.
<4> so .. i need a function to do that.
<2> pluesch0r: is latin1 8-bit safe?
<4> i don't know.
<2> I mean if you store an 8-bit value, it will be retrieved same?
<3> zap: what do i do now
<4> guess so.
<2> js1: check mysql.log
<2> pluesch0r: then what's your problem?
<3> empty
<2> can't you just pipe your ldif file through iconv -f latin1 -t utf-8 ?
<4> zap: openldap specifically requesting utf8.
<2> maybe you should try the Berkley DB openldap backend then
<2> I use it and had no problems with UTF-8
<2> but
<2> in mysql5
<2> there's a file in every database directory
<4> err ... look. i've got a crm, written in PHP, storing data in latin1 in mysql. and then i've got openldap, using mysql as backend and accessing the "contacts" table, contacts being stored in latin1 by the crm app.
<2> db_opt
<2> for me it contains the database encoding but I'm not sure if that'll help you
<4> since openldap is not able to handle latin1 in the backend database, i need to change the configured openldap query in a way to have openldap only get utf8 umlauts.
<4> zap: in slapd.conf?
<5> pluesch0r: openldap should just do 'SET NAMES utf8'
<5> pluesch0r: and it will get all data in utf8
<4> it will?
<5> you don't have to store your data in any other way
<4> whoa.
<5> yes, if your data was written properly
<5> that's what charset support is all about
<5> supporting multiple character sets all around your data, clients, yadda yadda
<4> it will deliver my latin1 data in utf8 that way?
<6> hi
<5> pluesch0r: yes
<6> anyone know a tut how to change root p***word?
<2> but you have to tell mysql your database is stored in latin1
<3> mysqladmin?
<6> i as read that tut very times... but never remember that xD
<4> zap: where's that db_opt from?
<2> js1: look in /var/log/message then, if mysql.log is empty... that's strange hmm
<2> pluesch0r: /var/lib/mysql/your_database/
<5> !m malmen reset root
<1> malmen: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<4> mh, okay.
<6> tks
<6> :)
<2> So... no SQL experts here? :( I thought thats an easy question
<4> zap: what question?
<2> SELECT 1
<2> FROM ps_cs_plrmaps as m, ps_cs_defs_maps as md
<2> LEFT JOIN ps_cs_plrmaps_cstrike as mm
<2> ON mm.plrmapid=m.plrmapid
<2> mysql barfs on this: ERROR 1054: Unknown column 'm.plrmapid' in 'on clause'
<7> gday, anyone around that feels like helping a bratha out with some multimaster?
<8> zap: the ON refers to the LEFT JOIN, 'm' isnt a part of that
<8> do you really want the whole product on the m/md join?
<2> dasOp: no idea, it's no my script :-\
<2> but that used to work with mysql 4.1
<8> so you dont really know what its trying to accomplish?
<2> I can look in sources
<2> but that's kind of a pita
<9> hi, i've got a collation problem in 4.1.. i run the same query (select * from table where foo='bar' and baz='asdf') in both phpmyadmin and inside my php script, and the latter fails while the former works. i got collation errors with phpmyadmin before, looked up on google, and found that i should switch the charset of the table to something else.. but this only helped phpmyadmin.
<2> dasOp: my guess is that it tries to get all data for a single user from multiple tables
<9> any ideas if it's got to do with the default charset of the database? (ie. now that my table's utf8, it's trying to compare the sent string default as latin1 or whatever)
<9> or with anything else
<7> *heads off to make food*
<10> youho: it could be apache.
<9> gah :(
<10> look for something along the lines of default_charset
<9> but phpmyadmin runs on the same server
<10> ah.. dunno
<9> i'm figuring it's doing something in its query it's not showing me
<10> oh so you get an error during the _query_?
<9> when i execute it, yes
<9> $query = mysql_fetch_array($query) or die(); kills it
<11> is it possible to use LIMIT with in Groups?
<9> whereas i run the same thing letter-to-letetr in the pmyadmin sql console and it works perfectly :)
<9> this is so odd
<11> when i used LIMIT, it limits the whole resultset
<2> dasOp: MySQL 5.x manual contains this example: SELECT t1.name, t2.salary FROM employee AS t1 INNER JOIN info AS t2 ON t1.name = t2.name;
<10> youho: no error message?
<9> it's giving the collation error
<2> dasOp: the ON clause refers to t1 which is not part of the JOIN clause
<9> Illegal mix of collations (latin1_swedish_ci,IMPLICIT) blahblah
<12> hello
<5> youho: so fix it
<9> i did
<9> now phpmyadmin's working and the script's not :)
<10> youho: maybe pma uses some magickery.
<9> thats what i've been going on about
Return to
#mysql
or
Go to some related
logs:
infobot.config nickServ_pass
#perl
mk2fs how to
ubuntu turion kernel panic
xvinfo + Unable to open display + mplayer
avermedia hybrid ubuntu
php unexpected T_THROW
#math
rdesktop copy clipboard dapper
hid create error 2
|
|