PHP errors, when transfering WordPress site

  • BlackLotuss

    (@blacklotuss)


    11 years, 1 month ago

    OK so I transferred a site from one hosting to another the site works and is online but it generates so much errors that the error log got about 10GB in size over less than 24 hours, I cannot figure out what the problem exactly is and due to the gigantic log file I cannot even pase it here or on pastebin so here it is on dropbox (about 1 hour of logs):

    https://www.dropbox.com/s/0zvjm0ywjenc0v8/error_log

    Anyone have any clues as to what is the problem?

    Didn’t do much to be honest just fixed the mySQL setting in the config file and set a new /home/ path for wp-super-cache plugin (the line that is in the config – since it used to be /home/www.touhou.si/ and now it is /home/touhousi/public_html).

    Cheers,
    BlackLotuss

Viewing 4 replies - 1 through 4 (of 4 total)
  • Greg

    (@jgs)

    11 years, 1 month ago

    Quite a nasty log, that’s for sure. It looks like the bulk of that 150meg file is the database looping.

    From the entry just before the INSERT error, looks like a MySQL issue with the max_allowed_packet being set too low (default 1M).

    There are some instructions on how to adjust that here:
    http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html

    Thread Starter BlackLotuss

    (@blacklotuss)

    11 years, 1 month ago

    Thank you, I’ll notify the hoster and hope that he can fix the problem. Hopefully setting this feature a bit higher will do the job.

    Thank you!

    Thread Starter BlackLotuss

    (@blacklotuss)

    11 years, 1 month ago

    BTW if you perhaps know, does this have anything to do with the fact that the mySQL DB is over 10MB in size, I mean would trimming it down help at all?

    Cheers

    Greg

    (@jgs)

    11 years, 1 month ago

    I don’t think 10mb is unreasonable. If you wanted to look at trimming it down some, you could delete your revisions if they’re not needed. And if you’re curious as to how many you have, you can run a simple query from the MySQL console to check.

    mysql> SELECT COUNT(*) FROM PREFIX_posts WHERE post_type = “revision”;

    (replace PREFIX with your DB prefix, if you used one).

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘PHP errors, when transfering WordPress site’ is closed to new replies.