1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Error on importing style on localhost

Discussion in 'Troubleshooting and Problems' started by ToDie4, Mar 15, 2011.

  1. ToDie4

    ToDie4 Well-Known Member

    Yesterday everything was fine and dandy on my dev site, now suddenly out of the blue I am getting this error message when trying to import a style on localhost.

    I've been searching the net trying to fix it myself but am now even more lost than when I started, has anyone else had this before and does anyone have any idea what's gone wrong please?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The initial line in the error report just indicates there was a problem connecting to the server: "Lost connection to MySQL server during query"

    I sometimes have issues with XAMPP but a restart usually solves it.
     
  3. ToDie4

    ToDie4 Well-Known Member

    I've tried that, I've even tried the extreme of shutting down the PC and turning off the main supply for 20 seconds to clear the internal memory, still having the same problem.

    Weird thing is, I click import and the darn things waits for about 2 seconds then I get the dreaded error page, is there some sort of limit to how many styles XenForo can have in the database at once?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

  5. Mike

    Mike XenForo Developer Staff Member

    If it's happening quickly, then that probably indicates MySQL is crashing. That said, it can be controlled by the wait_timeout configuration in MySQL (http://dev.mysql.com/doc/refman/5.0/en/gone-away.html).

    Another option is the max_allowed_packet size in MySQL, which I suppose could come up with a large number of styles (based on how we store properties).
     
  6. ToDie4

    ToDie4 Well-Known Member

    I have 15 Styles installed and expect to have as many as 15o in due course.

    I have been reading up on increasing the packet size but I'm drowning in all the techno-mumbo-jumbo, no site seems to state nice and clearly add this to this, which is what people like myself need really. Can either of you lads lead me right on this please?
     
  7. ToDie4

    ToDie4 Well-Known Member

    Okay, think I've got it sussed, I think I've set the packet size to 1024MB, not sure if I did it all correctly but my dev site is importing again. :)
     
  8. Mike

    Mike XenForo Developer Staff Member

    If it works, then that should be correct. (I really don't know why MySQL limits it to 1MB by default.)
     

Share This Page