I AM A LAMER!! I use php3 files not php but for some reason there IS a .php file on my dir (I AM TERRIBLY SORRY) I was editing .php instead of php3 As far as a lamer can say this version is working pretty good compared to rc2.. Sorry. Regards, Martin Marconcini www.marconcini.com.ar "Life must be lived looking forward and can be understood only looking backward." Soren Kierkegaard

-----Original Message----- From: phpmyadmin-devel-admin@lists.sourceforge.net [mailto:phpmyadmin- devel-admin@lists.sourceforge.net] On Behalf Of Martin Marconcini Sent: Thursday, August 23, 2001 6:55 PM To: phpmyadmin-devel@lists.sourceforge.net Subject: [Phpmyadmin-devel] 2.2.0-FINAL - Not working anymore

Hi list. I was using rc2.

Smooth.

I upgraded 2day to 2.2.0 final in order to 'beta test'

I removed every file inside www.myweb.com/phpMyAdmin

And untared the php3 tar.gz I downloaded a couple of minutes ago.

I modified config adding the absolute url for http://www.myweb.com/phpMyAdmin/

Added a password (I connect as root and the database is localhost) I saved my old cfg just in case (and the user/pass is ok!)

However... I get

Error SQL-query :

mysql_connect(localhost, root, )

MySQL said:

Access denied for user: 'root@localhost' (Using password: NO)

Why is saying using password no if config has a password (I only have one server!) I repeat I didn't touch anything else on the config but the password and the absolute uri).

It WAS working w/ rc2.

I restarted (stop/start) apache... but I will keep saying using password NO. There are little chances of user stupidity due to the fact that apache configuration is untouched (and it's on the same directory than rc2)

Ideas I shall be looking for?

Thanks.

Regards,

Martin Marconcini www.marconcini.com.ar

"Life must be lived looking forward and can be understood only looking backward." Soren Kierkegaard

_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

ouf, so I may go to sleep, good :) was going to have a look at your problem :)

Go2sleep :) Seems 2 work fine... Go2Sleep.. sweat dreams... (are made of this). ;) Best Regards. Martin.

Here are some changes I made to Spanish.inc.php3 from 2.2.0 final. (I translated some more) (Spanish.inc.php2 is the original) bash-2.05# diff -a spanish.inc.php2 spanish.inc.php 44,46c44,46 < $strBookmarkQuery = 'Bookmarked SQL-query'; //to translate < $strBookmarkThis = 'Bookmark this SQL-query'; //to translate < $strBookmarkView = 'View only'; //to translate ---

$strBookmarkQuery = 'SQL-query guardado en favoritos'; $strBookmarkThis = 'Guardar este SQL-query en favoritos'; $strBookmarkView = 'Solamente ver'; 284,297c284,297 < $strAffectedRows = 'Rows affected: '; < $strDatabasesStats = 'Databases statistics';//to translate < $strDeletedRows = 'Deleted rows:'; < $strDisplayOrder = 'Display order:'; < $strDropTable = 'Drop table'; < $strExtendedInserts = 'Extended inserts'; < $strFieldsEmpty = ' The field count is empty! '; //to translate < $strFormEmpty = 'Missing value in the form !'; < $strInsertedRows = 'Inserted rows:'; < $strInstructions = 'Instructions';//to translate < $strLengthSet = 'Length/Values*'; < $strNoDatabases = 'No databases'; < $strNoDropDatabases = '"DROP DATABASE" statements are disabled.'; < $strNoModification = 'No change'; // To translate

$strAffectedRows = 'Filas afectadas: '; $strDatabasesStats = 'Estadisticas de la base'; $strDeletedRows = 'Filas Borradas'; $strDisplayOrder = 'Mostrar en este orden:'; $strDropTable = 'Borrar Tabla'; $strExtendedInserts = 'Inserts Extendidos'; $strFieldsEmpty = ' El numero de campos esta vacio! '; $strFormEmpty = 'Falta un valor en el form !'; $strInsertedRows = 'Filas Insertadas:'; $strInstructions = 'Instrucciones'; $strLengthSet = 'Longitud/Valores*'; $strNoDatabases = 'No hay bases de datos'; $strNoDropDatabases = '"BORRAR BASE DE DATOS" las sentencias estan deshabilitadas.'; $strNoModification = 'Sin cambios'; 299,300c299,300 < $strSetEnumVal = 'If field type is "enum" or "set", please enter the values using this format: \'a\',\'b\',\'c\'...<br />If you ever need to put a backslash ("\") or a single quote ("\'") amongst those values, backslashes it (for example \'\\\\xyz\' or \'a\\\'b\').'; < $strShowPHPInfo = 'Show PHP information'; // To translate

$strSetEnumVal = 'Si el tipo de campo es "enum" o "set", por favor ingrese los valores usando este formato: \'a\',\'b\',\'c\'...<br />Si alguna vez necesita poner una barra invertida("\") o una comilla simple ("\'") entre esos valores, siempre ponga una barra invertida. (Por Ejemplo \'\\\\xyz\' or \'a\\\'b\').'; $strShowPHPInfo = 'Mostrar informacion de PHP'; 302,304c302,304 < $strTables = '%s table(s)'; //to translate < $strServerChoice = 'Server Choice';//to translate < $strPmaDocumentation = 'phpMyAdmin Documentation';//to translate

$strTables = '%s tabla(s)'; $strServerChoice = 'Eleccion de Server'; $strPmaDocumentation = 'Documentacion de phpMyAdmin'; bash-2.05# diff -a spanish.inc.php2 spanish.inc.php > spanish.inc.php.diff bash-2.05# cat spanish.inc.php.diff 44,46c44,46 < $strBookmarkQuery = 'Bookmarked SQL-query'; //to translate < $strBookmarkThis = 'Bookmark this SQL-query'; //to translate < $strBookmarkView = 'View only'; //to translate

$strBookmarkQuery = 'SQL-query guardado en favoritos'; $strBookmarkThis = 'Guardar este SQL-query en favoritos'; $strBookmarkView = 'Solamente ver'; 284,297c284,297 < $strAffectedRows = 'Rows affected: '; < $strDatabasesStats = 'Databases statistics';//to translate < $strDeletedRows = 'Deleted rows:'; < $strDisplayOrder = 'Display order:'; < $strDropTable = 'Drop table'; < $strExtendedInserts = 'Extended inserts'; < $strFieldsEmpty = ' The field count is empty! '; //to translate < $strFormEmpty = 'Missing value in the form !'; < $strInsertedRows = 'Inserted rows:'; < $strInstructions = 'Instructions';//to translate < $strLengthSet = 'Length/Values*'; < $strNoDatabases = 'No databases'; < $strNoDropDatabases = '"DROP DATABASE" statements are disabled.'; < $strNoModification = 'No change'; // To translate

$strAffectedRows = 'Filas afectadas: '; $strDatabasesStats = 'Estadisticas de la base'; $strDeletedRows = 'Filas Borradas'; $strDisplayOrder = 'Mostrar en este orden:'; $strDropTable = 'Borrar Tabla'; $strExtendedInserts = 'Inserts Extendidos'; $strFieldsEmpty = ' El numero de campos esta vacio! '; $strFormEmpty = 'Falta un valor en el form !'; $strInsertedRows = 'Filas Insertadas:'; $strInstructions = 'Instrucciones'; $strLengthSet = 'Longitud/Valores*'; $strNoDatabases = 'No hay bases de datos'; $strNoDropDatabases = '"BORRAR BASE DE DATOS" las sentencias estan deshabilitadas.'; $strNoModification = 'Sin cambios'; 299,300c299,300 < $strSetEnumVal = 'If field type is "enum" or "set", please enter the values using this format: \'a\',\'b\',\'c\'...<br />If you ever need to put a backslash ("\") or a single quote ("\'") amongst those values, backslashes it (for example \'\\\\xyz\' or \'a\\\'b\').'; < $strShowPHPInfo = 'Show PHP information'; // To translate

$strSetEnumVal = 'Si el tipo de campo es "enum" o "set", por favor ingrese los valores usando este formato: \'a\',\'b\',\'c\'...<br />Si alguna vez necesita poner una barra invertida("\") o una comilla simple ("\'") entre esos valores, siempre ponga una barra invertida. (Por Ejemplo \'\\\\xyz\' or \'a\\\'b\').'; $strShowPHPInfo = 'Mostrar informacion de PHP'; 302,304c302,304 < $strTables = '%s table(s)'; //to translate < $strServerChoice = 'Server Choice';//to translate < $strPmaDocumentation = 'phpMyAdmin Documentation';//to translate

$strTables = '%s tabla(s)'; $strServerChoice = 'Eleccion de Server'; $strPmaDocumentation = 'Documentacion de phpMyAdmin';

Regards, Martin Marconcini www.marconcini.com.ar "Life must be lived looking forward and can be understood only looking backward." Soren Kierkegaard

-----Original Message----- From: phpmyadmin-devel-admin@lists.sourceforge.net [mailto:phpmyadmin- devel-admin@lists.sourceforge.net] On Behalf Of Martin Marconcini Sent: Thursday, August 23, 2001 7:59 PM To: phpmyadmin-devel@lists.sourceforge.net; phpmyadmin- users@lists.sourceforge.net Subject: [Phpmyadmin-devel] 2.2.0 Final Issue!?

Guys. Under 2.2r2 I executed (very often)

This query (I have it saved so there are no typos that may have appeared) used to work fine. MySQL/OS/Configuration is the same (indeed I ran this yesterday w/r2)

SELECT visit2.datestamp, visit2.ip, visit2.client_info, visit_type.description FROM visit2 INNER JOIN visit_type ON visit2.visit_type_id = visit_type.visit_type_id WHERE visit2.ip not like '192.168.0.99'

Now this is the result: (and the inner join?)

------------- SQL-query : [Edit]

SELECT visit2.datestamp, visit2.ip, visit2.client_info, visit_type.description FROM visit2 JOIN visit_type ON visit2.visit_type_id = visit_type.visit_type_id WHERE visit2.ip not like '192.168.0.99' LIMIT 0, 30

MySQL said:

You have an error in your SQL syntax near 'ON visit2.visit_type_id = visit_type.visit_type_id WHERE visit2.ip not like '' at line 5 ------------

What did change between r2 and final ????????? The statement is plain SQL... as you can see. I pasted the SAME query under mysql console and it worked perfectly. I got the results in no time (almost 400 records).

This time I'm not being THAT lamer.. I swear it used to work under r2. But due to the fact that I don't read all the mails in this list, something may have changed and I missed it?

Regards,

Martin Marconcini www.marconcini.com.ar

"Life must be lived looking forward and can be understood only looking backward." Soren Kierkegaard

_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

please send the real file attached, by mail or on the sourceforge tracker. Sorry, can't take 30 min to play cut'n'paste with your mail

:) :) Done, I went for the tracker at sourceforge. Regards, Martin.

Didn't have time yet to look at this. Marc Martin Marconcini a écrit :

Nobody did find anything strange in the query???