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

TEMA: Smiley error in mysql

Smiley error in mysql 9 años 3 meses ago #16624

  • Deadly_Paradox
  • Avatar de Deadly_Paradox
  • Offline
  • Visitante
  • Mensajes: 18
  • Gracias recibidas 1
  • Karma: 1
Hola¡
And that is one of the few things i know in Spanish so i'm sorry.
I've just installed the Kide Shoutbox and i was happy with the first impressions.
But there is a small problem with the smileys somewhere in the mysql.php.
When i want to add a smiley i get this errormessage:
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 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
that line says:
return mysql_num_rows( $cur ? $cur : $this->_cursor );
Is this a known problem and/or is there a simple fix?
Before i break my head over it i thought i'll ask here first.
El administrador ha desactivado la escritura pública.

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

  • JoniJnm
  • Avatar de JoniJnm
  • Offline
  • Administrador
  • Mensajes: 4579
  • Gracias recibidas 544
  • Karma: 160
I have just fixed two bugs with the simileys, maybe one of them caused this error. Download the com, reinstall and try :)
El administrador ha desactivado la escritura pública.

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

  • Deadly_Paradox
  • Avatar de Deadly_Paradox
  • Offline
  • Visitante
  • Mensajes: 18
  • Gracias recibidas 1
  • Karma: 1
Thanks for the fast respons :cheer:
delete (deinstall) the old one first or just overwrite?

Edit:
I have deïnstalled the old one en reïnstalled the new one bit still the same problem.
There is something strange.
The download says it is version 0.7.2 but at the bottom of the module it says 0.7.1:huh:
But however... the problem is not solved :(
Ú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 #16651

  • JoniJnm
  • Avatar de JoniJnm
  • Offline
  • Administrador
  • Mensajes: 4579
  • Gracias recibidas 544
  • Karma: 160
I have registered in your web, if you want, i can view the the admin and try, i dont know whats the problem.

If you dont want, you can change
return mysql_num_rows( $cur ? $cur : $this->_cursor );
By
return mysql_num_rows( $cur ? $cur : $this->_cursor ) or die(print_r($this));

This will show info when add a smiley, so look the source code of the page, copy the info and paste it here
El administrador ha desactivado la escritura pública.

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

  • Deadly_Paradox
  • Avatar de Deadly_Paradox
  • Offline
  • Visitante
  • Mensajes: 18
  • Gracias recibidas 1
  • Karma: 1
That creates this error on the site when i refresh the page:
Parse error: syntax error, unexpected T_STRING in /srv/www/vhosts/www.mc-tl.nl/libraries/joomla/database/database/mysql.php on line 344


My Bad... forgot the "r" in return :blush:
Ú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 #16655

  • Deadly_Paradox
  • Avatar de Deadly_Paradox
  • Offline
  • Visitante
  • Mensajes: 18
  • Gracias recibidas 1
  • Karma: 1
A new problem occurs.
When i want to edit the smileys i get this error:
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
El administrador ha desactivado la escritura pública.

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

  • JoniJnm
  • Avatar de JoniJnm
  • Offline
  • Administrador
  • Mensajes: 4579
  • Gracias recibidas 544
  • Karma: 160
Thanks, fixed, reinstall :P
El administrador ha desactivado la escritura pública.

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

  • Deadly_Paradox
  • Avatar de Deadly_Paradox
  • Offline
  • Visitante
  • Mensajes: 18
  • Gracias recibidas 1
  • Karma: 1
What is fixed... i don't see a difference :ohmy:
Ú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 #16662

  • JoniJnm
  • Avatar de JoniJnm
  • Offline
  • Administrador
  • Mensajes: 4579
  • Gracias recibidas 544
  • Karma: 160
Sure? The problem was that you didnt have the column ordening in the table jos_kide_icons, reinstalling it should be added (check it with phpmyadmin)

If you add "die(print_r($this));" again what happends?

The last error:
[_errorMsg] => Unknown column 'ordering' in 'order clause' SQL=SELECT * FROM jos_kide_iconos ORDER BY ordering
El administrador ha desactivado la escritura pública.
  • Página:
  • 1
  • 2
  • 3
Tiempo de carga de la página: 0.081 segundos