Bienvenido, Invitado
Nombre de Usuario: Contraseña: Recordarme
  • Página:
  • 1
  • 2
  • 3

TEMA: Smiley error in mysql

Re: Smiley error in mysql 9 años 3 meses ago #16667

  • Deadly_Paradox
  • Avatar de Deadly_Paradox
  • Offline
  • Visitante
  • Mensajes: 18
  • Gracias recibidas 1
  • Karma: 1
Same problem as before,
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/www/vhosts/www.mc-tl.nl/libraries/joomla/database/database/mysql.php on line 344 JDatabaseMySQL Object ( [name] => mysql [_nullDate] => 0000-00-00 00:00:00 [_nameQuote] => ` [_sql] => SELECT * FROM jos_kide_iconos ORDER BY ordering [_errorNum] => 1054 [_errorMsg] => Unknown column 'ordering' in 'order clause' SQL=SELECT * FROM jos_kide_iconos ORDER BY ordering [_table_prefix] => jos_ [_resource] => Resource id #26 [_cursor] => [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_utf] => 1 [_quoted] => Array ( ) [_hasQuoted] => [_errors] => Array ( ) ) 1
But i'll try again with the change in order.. just a moment.
El administrador ha desactivado la escritura pública.

Re: Smiley error in mysql 9 años 3 meses ago #16692

  • Deadly_Paradox
  • Avatar de Deadly_Paradox
  • Offline
  • Visitante
  • Mensajes: 18
  • Gracias recibidas 1
  • Karma: 1
buenos días Joni,
The change
ALTER TABLE `jos_kide_iconos` ADD `ordering` INT( 11 ) NOT NULL DEFAULT '0'
is made and everything is working like a charm :woohoo:
I have also made some changes in the CSS so it looks better integrated in our site.
When our server contact comes back from his holiday he will make some changes so i get more access and he's going to install phpMyAdmin.
As i said, it was a nice shoutbox but now everything works it's a great shoutbox :P
Muchas gracias again for all your help and time to fix the problem and keep up the good work
Última Edición: 9 años 3 meses ago por Deadly_Paradox.
El administrador ha desactivado la escritura pública.

Re: Smiley error in mysql 9 años 3 meses ago #16778

  • LorDPSYCHO
  • Avatar de LorDPSYCHO
  • Offline
  • Visitante
  • Mensajes: 6
  • Karma: 0
I have some problems with the smilies as well. When i want to use smilies like in Yahoo Messenger it doesn't work, it will just show the firs one .. for example : ) : ) ) it will just show the smiling one and a paranthesys, same for ; ) ; ) ), > : D > : D < .. and so forth. Can this be fixed so whenever i want the Hug smily > : D < i don't get the devil > : D one and a <
El administrador ha desactivado la escritura pública.

Re: Smiley error in mysql 9 años 3 meses ago #16779

  • Deadly_Paradox
  • Avatar de Deadly_Paradox
  • Offline
  • Visitante
  • Mensajes: 18
  • Gracias recibidas 1
  • Karma: 1
Hola Psycho¡

How did you add the yahoo smileys?
You have to add the smileys in the "iconos" map on your server and then edit them in the Joomla backend.
If you only want to use the yahoo smileys select all of the standard smileys and delete them from the backend and then add the yahoo smileys one by one.
When you add them you must give them a code to work.
If you just add them with the rest in place using the same code as another one the system takes the first code in the system and that is always what was already there before you added the other ones.
El administrador ha desactivado la escritura pública.
Los siguientes usuarios han agradecido: JoniJnm

Re: Smiley error in mysql 9 años 3 meses ago #16782

  • JoniJnm
  • Avatar de JoniJnm
  • Offline
  • Administrador
  • Mensajes: 4579
  • Gracias recibidas 544
  • Karma: 160
Fixed, LorDPSYCHO.

Download the com and replace the file helper/kide.php
El administrador ha desactivado la escritura pública.

Re: Smiley error in mysql 9 años 3 meses ago #16829

  • Deadly_Paradox
  • Avatar de Deadly_Paradox
  • Offline
  • Visitante
  • Mensajes: 18
  • Gracias recibidas 1
  • Karma: 1
Hola Joni¡
I have another question about the smileys.
When we use the shoutbox (only noticed it in com) the smileys from the other users only show after i refreshed the page, this is the same at the other users site so i can rule out the possibility of an fault in the Opera browser.
We have to tweak the backend a little because there are some minor difficulties but just in case this has nothing to do with it i'll ask if this is just something i overlooked.
Otherwise the shoutbox is working perfect ;)
El administrador ha desactivado la escritura pública.

Re: Smiley error in mysql 9 años 3 meses ago #16843

  • JoniJnm
  • Avatar de JoniJnm
  • Offline
  • Administrador
  • Mensajes: 4579
  • Gracias recibidas 544
  • Karma: 160
Install the latest version and try :)
El administrador ha desactivado la escritura pública.

Re: Smiley error in mysql 9 años 3 meses ago #16847

  • Deadly_Paradox
  • Avatar de Deadly_Paradox
  • Offline
  • Visitante
  • Mensajes: 18
  • Gracias recibidas 1
  • Karma: 1
Thanks again, i will try it one of these days (when i have some spare time).
El administrador ha desactivado la escritura pública.

Re: Smiley error in mysql 9 años 3 meses ago #16901

  • Deadly_Paradox
  • Avatar de Deadly_Paradox
  • Offline
  • Visitante
  • Mensajes: 18
  • Gracias recibidas 1
  • Karma: 1
I've downloaded the newest version but before i install it... are the changes i made like the CSS and our own smilyes kept as they are or do i have to redo all of it?
El administrador ha desactivado la escritura pública.
  • Página:
  • 1
  • 2
  • 3
Tiempo de carga de la página: 0.083 segundos