Results 1 to 15 of 15
  1. #1
    Join Date
    Apr 2010
    Posts
    25

    Default Got a packet bigger than 'max_allowed_packet'

    Hi

    I have a shop mod on my forum that I have upload items into for the members to buy.

    However, when I hit the recache option within the mod, I get a database error.

    I have downloaded the sql error file and it has highlighted the problem as

    "Got a packet bigger than 'max_allowed_packet"

    The error log file is just over 5MB, so I presume the limit needs increasing to something over 5MB

    Could somenoe be kind enough to advise where /how I change the settings please


  2. #2
    Join Date
    Mar 2007
    Posts
    332

    Default

    Hello Karl,

    I have increased max_allowed_packet to 16MB in /etc/my.cnf of your VPS server.

    Please give a try and let us know if you face any problem.
    RsyNc.
    VPS Support Team

    VPS Hosting ||Cloud Hosting 100% UPTIME!
    Follow eUKhost on Twitter || Join eUKhost Community on Facebook
    MSN: johnr @ eukhost.com
    SKYPE: john_rodricks

  3. #3

    Smile

    Quote Originally Posted by KPDub01 View Post
    Hi

    I have a shop mod on my forum that I have upload items into for the members to buy.

    However, when I hit the recache option within the mod, I get a database error.

    I have downloaded the sql error file and it has highlighted the problem as

    "Got a packet bigger than 'max_allowed_packet"

    The error log file is just over 5MB, so I presume the limit needs increasing to something over 5MB

    Could somenoe be kind enough to advise where /how I change the settings please

    Hi Karl,

    max_allowed_packet defines how large your MySQL Query/Data Packet can be. You can set max_allowed_packet in /etc/my.cnf on the server.

    Open /etc/my.cnf with the editor you like. Add "max_allowed_packet=8M" in the file and restart mysql on the server. You can set the max_allowed_packet as per your requirement.

    Hope this helps
    Cristiano
    Dedicated Server Hosting by eUKhost Ltd.
    r1soft backup plans by eUkhost Ltd.
    MSN :: cristiano @ eukhost.com
    Skype :: cristiano.dawson

  4. #4
    Join Date
    Apr 2010
    Posts
    25

    Default

    Hmmm, well that hasn't appeared to do anything.

    Although a subsequent SQL error isnt being generated - which is strange.

    Also, can I assume that the /etc directory resides in the route of my installation? I can't see it when viewing on my FTP program though.

    Not sure whether to wait 24 hours and try again to see if a new SQL error file is generated

    Although it is strange as the table size is only 122,040 bytes

  5. #5
    Join Date
    Apr 2010
    Posts
    25

    Default

    Actually, I've been reading through (the rather large error log - lol) and its referencing another table.

    There is a blank array in the corresponding entry in that table. I don't know if its applicable in this case as there are others with a blank array and the associate features seem to be working.

    Going to see if I have any archived backups (from my shared hosting days), create a new database and upload the backup in there to see if at least I can copy the array code over

  6. #6
    Join Date
    Mar 2007
    Posts
    332

    Default

    Hello Karl,

    Could you please try again to upload the database OR executing the query ?

    Also, can I assume that the /etc directory resides in the route of my installation? I can't see it when viewing on my FTP program though.
    You can not access / directory of your VPS through FTP. You will need to access your server via ssh to make any modifications.
    RsyNc.
    VPS Support Team

    VPS Hosting ||Cloud Hosting 100% UPTIME!
    Follow eUKhost on Twitter || Join eUKhost Community on Facebook
    MSN: johnr @ eukhost.com
    SKYPE: john_rodricks

  7. #7
    Join Date
    Apr 2010
    Posts
    25

    Default

    Quote Originally Posted by Rsync View Post
    Hello Karl,

    Could you please try again to upload the database OR executing the query ?
    It has worked now, whatever you did, thankyou very much

  8. #8
    Join Date
    Apr 2010
    Posts
    25

    Default

    Doh - spoke to soon. Whilst it recached the large table, it won't recache another one now.

    At least I just get a blank screen now and not a driver error - lol

  9. #9
    Join Date
    Mar 2007
    Posts
    332

    Default

    Hello Karl,

    You are
    Glad to know that your issue is resolved
    RsyNc.
    VPS Support Team

    VPS Hosting ||Cloud Hosting 100% UPTIME!
    Follow eUKhost on Twitter || Join eUKhost Community on Facebook
    MSN: johnr @ eukhost.com
    SKYPE: john_rodricks

  10. #10
    Join Date
    Apr 2010
    Posts
    25

    Default

    Okay, wanted to try to recache it in mysql, but can't use the flush table command as I dont have the reload privalege.

    Again sorry for the noob question, so where can I set it so I can have the reload privalege

    Not sure if this will work, but worth a shot

  11. #11
    Join Date
    Apr 2010
    Posts
    25

    Default

    Quote Originally Posted by Rsync View Post
    You can not access / directory of your VPS through FTP. You will need to access your server via ssh to make any modifications.
    Okay, another noob question, how do I do that - lol

  12. #12
    Join Date
    Aug 2007
    Posts
    170

    Default

    Quote Originally Posted by KPDub01 View Post
    Okay, wanted to try to recache it in mysql, but can't use the flush table command as I dont have the reload privalege.

    Again sorry for the noob question, so where can I set it so I can have the reload privalege

    Not sure if this will work, but worth a shot
    Privileges can be assigned from phpmyadmin. You can connect to phpmyadmin from your contol panel & assign privileges to your database.



  13. #13
    Join Date
    Aug 2007
    Posts
    170

    Default

    Quote Originally Posted by KPDub01 View Post
    Okay, another noob question, how do I do that - lol

    SSH can be done through SSH client like 'putty'. Simply download the putty exe & use your vps ipaddress as the Host & port 22 to connect to SSH.




  14. #14
    Join Date
    Apr 2010
    Posts
    25

    Default

    Quote Originally Posted by eukSam View Post
    Privileges can be assigned from phpmyadmin. You can connect to phpmyadmin from your contol panel & assign privileges to your database.


    Okay gone into the database and accessed the information_schema

    In the table user privaleges, for admin@locahost the is grantable field is set to YES for RELOAD

    However, there is no option to add another user to that table.

    Sorry for being completely thick

  15. #15
    Join Date
    Aug 2007
    Posts
    170

    Default

    Hello Karl,


    We have opened a ticket on our helpdesk for you. Please reply to that ticket so we can assist you in a better way.





Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •