Skip to Content Skip to Menu

(JoomFish) SQL Error - Show users or sending

  • melwin
  • melwin
  • OFFLINE
  • Posts: 11
  • Thanks: 0
  • Karma: 0
16 years 2 months ago #68712 by melwin
Hi there,

im running 1.2.RC2 CB and installed uddeIM1.1.

if i push the button "Show users" at the compose tab, i get following error:

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'test'@'localhost' (using password: NO) in /home/test32/public_html/rc/administrator/components/com_uddeim/admin.shared.php on line 75

same problem, if i write directly in the To: input field.

test is not the correct username, where get uddeim this login.

best,

melwin

Post edited by: melwin, at: 2008/07/18 17:30

Post edited by: slabbi, at: 2008/07/25 19:52

Please Log in or Create an account to join the conversation.

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
16 years 2 months ago #68719 by slabbi
Replied by slabbi on topic Re:SQL Error - Show users or sending
Its fixed in uddeIM 1.2beta. You can use following code:
[code:1]function uddeIMquoteSmart($source) {
global $database;
if (get_magic_quotes_gpc()) {
$source = stripslashes($source);
}
$source = $database->getEscaped( $source );
return $source;
} [/code:1]

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in or Create an account to join the conversation.

  • melwin
  • melwin
  • OFFLINE
  • Posts: 11
  • Thanks: 0
  • Karma: 0
16 years 2 months ago #68774 by melwin
Replied by melwin on topic Re:SQL Error - Show users or sending
Thank you Slabbi!

Now the error is gone and i can choose a user from the list.

If i want send the testmessage, i get the error: [code:1]There is no user with this username![/code:1]

But i choose this from the list?!?

Can you help me ones again :)

best,

melwin

Please Log in or Create an account to join the conversation.

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
16 years 2 months ago #68780 by slabbi
Replied by slabbi on topic Re:SQL Error - Show users or sending
Maybe you should update to uddeIM 1.2beta/beta2 first since I made some changes in the handling of character sets.

Does the username contain special characters? Is the character set of your database and the character set of the database connection ok?

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in or Create an account to join the conversation.

16 years 1 month ago #68921 by spacereactor
Replied by spacereactor on topic Re:SQL Error - Show users or sending
I got the following error when i click on show users
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'demosite'@'localhost' (using password: NO) in /home/demosite/public_html/demo/administrator/components/com_uddeim/admin.shared.php on line 120

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/demosite/public_html/demo/administrator/components/com_uddeim/admin.shared.php on line 120

Currently I have joomla 1.5.4, joomfish 2 beta2, CB 1.2 RC2 and uddeIM 1.2beta/beta2
I manage to solve it by disable Joomfish - Abstraction Layer but doing that, i unable to use joomfish for my translated content.

Any help?

Post edited by: spacereactor, at: 2008/07/21 14:13

Please Log in or Create an account to join the conversation.

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
16 years 1 month ago #68927 by slabbi
Replied by slabbi on topic Re:SQL Error - Show users or sending
You are NOT using uddeIM 1.2beta2, you are using 1.2beta. Please install beta2. It uses a Joomla function (->getEscaped) instead of the native MySQL function.

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in or Create an account to join the conversation.

Moderators: beatnantslabbikrileon
Powered by Kunena Forum