Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. Linux, Apache, MySQL, PHP
  4. JoomFish problem with my component

JoomFish problem with my component

Scheduled Pinned Locked Moved Linux, Apache, MySQL, PHP
databasehelpphpmysqlcom
4 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    sharkbc
    wrote on last edited by
    #1

    Hi there ! Im using Joomla 1.5 to build my site. My component(query data from database of website) work well if i don't install joomfish. After i installed Joom!Fish 2.0.4 Stable into my site for translation my component does not work(with error). My code of component as bellow:

    $query='select * from jos_content where sectionid=11 and state=1
    order by catid ';
    $database->setQuery( $query );
    $result=mysql_query($query);

    	while($row=mysql\_fetch\_object($result)){
    
                   echo 'data'.$row->title;
                    }
    

    And i see these bellow warnings if i refer to my component.

    Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\so\components\com_products\products.php on line 131

    Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\so\components\com_products\products.php on line 131

    Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\so\components\com_products\products.php on line 137

    Any ideas ! Thanks in regards !

    M 1 Reply Last reply
    0
    • S sharkbc

      Hi there ! Im using Joomla 1.5 to build my site. My component(query data from database of website) work well if i don't install joomfish. After i installed Joom!Fish 2.0.4 Stable into my site for translation my component does not work(with error). My code of component as bellow:

      $query='select * from jos_content where sectionid=11 and state=1
      order by catid ';
      $database->setQuery( $query );
      $result=mysql_query($query);

      	while($row=mysql\_fetch\_object($result)){
      
                     echo 'data'.$row->title;
                      }
      

      And i see these bellow warnings if i refer to my component.

      Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\so\components\com_products\products.php on line 131

      Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\so\components\com_products\products.php on line 131

      Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\so\components\com_products\products.php on line 137

      Any ideas ! Thanks in regards !

      M Offline
      M Offline
      Marc Firth
      wrote on last edited by
      #2

      sharkbc wrote:

      Access denied for user 'ODBC'@'localhost' (using password: NO)

      Check your configuration file as it appears you can't connect to the database using your credentials. Your new install probably overwrote the config file.

      Portfolio | Web Design, Web Hosting & IT Support

      S 2 Replies Last reply
      0
      • M Marc Firth

        sharkbc wrote:

        Access denied for user 'ODBC'@'localhost' (using password: NO)

        Check your configuration file as it appears you can't connect to the database using your credentials. Your new install probably overwrote the config file.

        Portfolio | Web Design, Web Hosting & IT Support

        S Offline
        S Offline
        sharkbc
        wrote on last edited by
        #3

        Dear Marc Firth ! The configuration file has no change(I checked). My website "works well" except my component. Thanks anyway !

        1 Reply Last reply
        0
        • M Marc Firth

          sharkbc wrote:

          Access denied for user 'ODBC'@'localhost' (using password: NO)

          Check your configuration file as it appears you can't connect to the database using your credentials. Your new install probably overwrote the config file.

          Portfolio | Web Design, Web Hosting & IT Support

          S Offline
          S Offline
          sharkbc
          wrote on last edited by
          #4

          I found solution. It now work well sharkbc Free ware

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups