Announcement

Collapse
No announcement yet.

Moving to a new host and have one error in db

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Moving to a new host and have one error in db

    I moved two db's to my dedicated server one was over 1 gig that went smooth surprisingly. Now i have one small 24mb db and I get error at customeavtars table. I can move all the db with no problem but I have narrowed it down to the customeavatars.

    This is the error i get

    PHP Code:
    INSERT INTO `customavatar` (`userid`, `filedata`, `dateline`, `filename`, `visible`, `filesize`, `width`, `height`, `importcustomavatarid`, `filedata_thumb`, `width_thumb`, `height_thumb`) VALUES (3650x47494638396196006400f7fd000101010908100a100a0b1111130a09100d1016160a1415161616240b2200192526240a08250d1025140b241815310705320d1035160b331a122e182c2c200d26221725331a34230c36251637311a2626242a293127302a293134342925312730353227363434140f4815106215304b15396c2f1b41323545243b6412550c1c403310620b25441935413526631c3363261c405519437132474c314e6537645a3a646a451a0f431b2c4c2b17442b22422c32463626443936552c21532d325636265438326a16116e172360331b653929421b40433b42403e52523e414f3a62633a47633d6257411c52492f55603b61431b6c48336863364c4a4e53556657625356636f6a534b655a637062556c696f133c8418458d1b51aa1d629b1b63b227508d2355ad3566913369af185bc51a68d11c76ea235cc32c70cd2579e84959844059a75468864a70ab665b8470758c707aa04679c7487ee836865654877579805c7981723b84873a80b51d84f53385d52d90f43da0f65688905b87a059a09f54a5a77[...] 

  • #2
    We need to see the complete error.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      I'm trying to recreate the error through phpmyadmin but the server is being stubborn. here is the error through SSH i am getting. Just the customeavatars is a bit over 2mb so I dont think its packet size. Like i said i moved over a 1 gig db just before this one with out a problem..



      Code:
      ERROR 1153 (08S01) at line 54: Got a packet bigger than 'max_allowed_packet' bytes

      Comment


      • #4
        Honestly that is way too large a file for an avatar.

        Your PHP does not have enough memory allocated to it to complete this operation. Ask your host to increase the 'memory_limit' variable in php.ini to at least 32M.

        To temporarily up your limits edit your includes/config.php file and add these lines right under the <?php line:

        ini_set('memory_limit', 32 * 1024 * 1024);
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          This is what its set to right now in the php.ini Its been set this way and still unable to import the customeavatars.

          memory_limit = 32M

          Comment


          • #6
            Sorry, I have you the wrong setting. You or your host will need to increase the 'max_allowed_packet' in my.cnf, then restart MySQL. I recommend at least 32M for this setting. If that doesn't work, try 64M.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              Well I gave up on it and just took a good customeavatars table from another Vb and dropped the one that was giving me problems and replaced with the one. Then backed up db through SSH and moved it to the new server. Everyone lost there avatars it looks like. Oh well but thanks for the help..

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X