Arrow Home arrow Forums
larger font smaller font default font Fixed screen resolution Auto adjust screen size

Joomlapolis Forums  


<< Start < Prev 1 2 3 Next > End >>
(JoomFish) SQL Error - Show users or sending
Date: 2008/07/18 17:28 By: melwin Status: CB Doc subscriber  
Karma: 0  
Fresh Joomlapolitan

Posts: 11
graphgraph
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
Click here to see the profile of this user The administrator has disabled public write access.

Re:SQL Error - Show users or sending
Date: 2008/07/18 18:09 By: slabbi Status: CB Doc subscriber  
Karma: 69  
Moderator

Posts: 1172
graphgraph
Its fixed in uddeIM 1.2beta. You can use following code:
Code:

 function uddeIMquoteSmart($source) {      global $database;     if (get_magic_quotes_gpc()) {          $source stripslashes($source);      }     $source $database->getEscaped$source );     return $source;  } 


uddeIM Development
CB Language Workgroup
CB 3rd Party Developer
Click here to see the profile of this user The administrator has disabled public write access.

Re:SQL Error - Show users or sending
Date: 2008/07/19 15:29 By: melwin Status: CB Doc subscriber  
Karma: 0  
Fresh Joomlapolitan

Posts: 11
graphgraph
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:

 There is no user with this username!



But i choose this from the list?!?

Can you help me ones again

best,

melwin
Click here to see the profile of this user The administrator has disabled public write access.

Re:SQL Error - Show users or sending
Date: 2008/07/19 16:37 By: slabbi Status: CB Doc subscriber  
Karma: 69  
Moderator

Posts: 1172
graphgraph
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 Development
CB Language Workgroup
CB 3rd Party Developer
Click here to see the profile of this user The administrator has disabled public write access.

Re:SQL Error - Show users or sending
Date: 2008/07/21 16:07 By: spacereactor Status: CB Doc subscriber  
Karma: 2  
Junior Joomlapolitan

Posts: 38
graphgraph
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
Click here to see the profile of this user The administrator has disabled public write access.

Re:SQL Error - Show users or sending
Date: 2008/07/21 17:16 By: slabbi Status: CB Doc subscriber  
Karma: 69  
Moderator

Posts: 1172
graphgraph
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 Development
CB Language Workgroup
CB 3rd Party Developer
Click here to see the profile of this user The administrator has disabled public write access.

<< Start < Prev 1 2 3 Next > End >>

Documentation

Documentation Subscription Service
(updated for CB 1.2 RC2)

What?

Why?

Where?

Just click here for answers!

Click here for a yearly subscription: subscribe now

Download Latest Release

The latest stable Community Builder Release is version 1.1 for Joomla 1.0 and Mambo.
You need to be a registered member of Joomlapolis to download.

The latest release candidate of Community Builder is version 1.2 RC3, native for Joomla 1.0, 1.5 and Mambo.
It is available as "thank you" to all CB documentation subscribers at this time.

CB Login