The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpmyadmin text file upload

Discussion in 'Database Discussions' started by Lamar, Jul 20, 2003.

  1. Lamar

    Lamar Well-Known Member

    Joined:
    Jan 9, 2002
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    When trying to upload a text file to a table, I see this:

    This is across all servers. Does anyone have a solution?

    cPanel.net Support Ticket Number: 18814
     
    #1 Lamar, Jul 20, 2003
    Last edited: Jul 20, 2003
  2. Curt

    Curt Well-Known Member

    Joined:
    Oct 16, 2001
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    6
    I am also having this problem on all servers and I would love to see a fix on this one.

    This issue only started on servers we downgrade to mysql 3 (which is all of them now). This function works perfectly on a box using phpmyadmin and mysql 4.

    I have also installed a older ver of phpmyadmin in the user web space and it works perfectly so this is clearly an issue with phpmyadmin and the downgrading to mysql3. (also only tested on cpanel 6X)

    Help please!

    cPanel.net Support Ticket Number:
     
  3. Lamar

    Lamar Well-Known Member

    Joined:
    Jan 9, 2002
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    I opened a ticket on this.

    cPanel.net Support Ticket Number: 18814
     
  4. Lamar

    Lamar Well-Known Member

    Joined:
    Jan 9, 2002
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    I ended up installing a personal copy of phpmyadmin into the user's space. It works fine.

    The tech said to try:

    log into mysql
    mysql> grant file on *.* to i-voluti; flush privileges;

    Then, try it. It still did not work.

    I received notice that it was fixed and that the tech had uploaded to a table, after I, two other webhosts, and some clients which are programmers could not get it to work.

    Just a little aggravated by this, as I did not receive a reply to my last correspondence with Cpanel concerning this issue--which was sent in 5 days ago. But, I saw the ticket was closed, as if it were resolved. I want to know what (user, database, and table) were used, and what exactly was done. When any of us try it, we receive the same error.

    cPanel.net Support Ticket Number: 18814
     
  5. youp

    youp Well-Known Member

    Joined:
    Oct 30, 2001
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    mysql> grant file on *.* to i-voluti; flush privileges;
    ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-voluti' at line 1

    ???

    cPanel.net Support Ticket Number:
     
  6. Lamar

    Lamar Well-Known Member

    Joined:
    Jan 9, 2002
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    Substitute your account's username in the place of i-voluti.

    cPanel.net Support Ticket Number:
     
  7. youp

    youp Well-Known Member

    Joined:
    Oct 30, 2001
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    your command is OK ->

    "
    root@ns2 [~]# mysql
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 2880 to server version: 4.0.13

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql> grant file on *.* to icdbe;
    Query OK, 0 rows affected (0.02 sec)

    mysql> flush privileges;
    Query OK, 0 rows affected (0.05 sec)
    "

    but i have always this error :

    Base de données icdbe_horde sur le serveur localhost
    Erreur

    requête SQL :

    USE horde

    MySQL a répondu:


    Access denied for user: 'icdbe@localhost' to database 'horde'


    ????

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page