WordPress.org

Ready to get started?Download WordPress

Forums

PHP errors, when transfering WordPress site (5 posts)

  1. BlackLotuss
    Member
    Posted 1 year 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

  2. Greg
    Member
    Posted 1 year 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

  3. BlackLotuss
    Member
    Posted 1 year 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!

  4. BlackLotuss
    Member
    Posted 1 year 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

  5. Greg
    Member
    Posted 1 year 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).

Topic Closed

This topic has been closed to new replies.

About this Topic