Smiley error in mysql

Bienvenido, Invitado

Smiley error in mysql

(1 viendo) (1) Invitado

Página:
1
2
3

TEMA: Smiley error in mysql

Smiley error in mysql hace 1 año, 5 meses #16624

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.

Deadly_Paradox
DESCONECTADO
Visitante
Temas: 18
Karma: 1

Responder Citar

Re: Smiley error in mysql hace 1 año, 5 meses #16637

I have just fixed two bugs with the simileys, maybe one of them caused this error. Download the com, reinstall and try	JoniJnm DESCONECTADO Administrador Temas: 4167 Karma: 144
Edita tu perfil! Responder Citar

Re: Smiley error in mysql hace 1 año, 5 meses #16642

Thanks for the fast respons ~~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	Deadly_Paradox DESCONECTADO Visitante Temas: 18 Karma: 1
Última Edición: hace 1 año, 5 meses Por Deadly_Paradox. Responder Citar

Re: Smiley error in mysql hace 1 año, 5 meses #16651

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	JoniJnm DESCONECTADO Administrador Temas: 4167 Karma: 144
Edita tu perfil! Responder Citar

Re: Smiley error in mysql hace 1 año, 5 meses #16654

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	Deadly_Paradox DESCONECTADO Visitante Temas: 18 Karma: 1
Última Edición: hace 1 año, 5 meses Por Deadly_Paradox. Responder Citar

Re: Smiley error in mysql hace 1 año, 5 meses #16655

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

Deadly_Paradox
DESCONECTADO
Visitante
Temas: 18
Karma: 1

Responder Citar

Re: Smiley error in mysql hace 1 año, 5 meses #16659

Thanks, fixed, reinstall	JoniJnm DESCONECTADO Administrador Temas: 4167 Karma: 144
Edita tu perfil! Responder Citar

Re: Smiley error in mysql hace 1 año, 5 meses #16660

What is fixed... i don't see a difference	Deadly_Paradox DESCONECTADO Visitante Temas: 18 Karma: 1
Última Edición: hace 1 año, 5 meses Por Deadly_Paradox. Responder Citar

Re: Smiley error in mysql hace 1 año, 5 meses #16662

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	JoniJnm DESCONECTADO Administrador Temas: 4167 Karma: 144
Edita tu perfil! Responder Citar