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

Mysqli statement execute error on installing a new theme

Discussion in 'Troubleshooting and Problems' started by account8226, Oct 27, 2011.

  1. account8226

    account8226 Guest


    I have this error when I create a new theme, or when I import my own theme.​

    It's quite a big problem that happen to me on beta 2.​
  2. account8226

    account8226 Guest

    EDIT : The same problem occur when I want to add a new add-on...


    EDIT 2 : In fact I have the problem each time I change something in the ACP. Except templates changes. But sometimes even with the error it's saving my changes.
  3. account8226

    account8226 Guest

    OMG I have the same problem when I want to upgrade to beta 3 ! I am stuck plz help me :(
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Try increasing the value for max_allowed_packet in your MySQL configuration file.
  5. account8226

    account8226 Guest

    OMG thanks for the awnser Brogan, where do I find it ?
  6. Brogan

    Brogan XenForo Moderator Staff Member

  7. account8226

    account8226 Guest

    I am on an hoster : PLanetHoster.

    And where is the my.cnf file ?

    And any way to cancel the upgrade ? Because now my forum is waiting for an upgrade that I can't do with this error :(
  8. Brogan

    Brogan XenForo Moderator Staff Member

    Which step did the upgrade fail at?
    If it was template rebuilding then the database has already been upgraded, in which case the only way to revert is to restore backups of the database and server files.
  9. account8226

    account8226 Guest

    It's failing before the first step. So I have to backup ? But the files on the FTP are still the same it will still ask me to upgrade.
  10. account8226

    account8226 Guest

    OMG even when I backup I have the error.
  11. Mike

    Mike XenForo Developer Staff Member

    The rough answer is that you have too many styles right now and removing one will be the simplest way to resolve it.

    If you can't get into the admin CP, you can turn on debug mode in library/config.php:

    $config['debug'] = true;

    You should be able to temporarily get back into the admin CP to remove a style. (Note that styling may be broken.) You should then pick up with the upgrade if that's what you were doing. Be sure to remove debug mode afterwards.
  12. account8226

    account8226 Guest

    Thanks so much for your help Mike, I have the forum in debug but when I remove a theme the error occur...
    EDIT : I am removing some original styles (my first theme). It's working atm :) I hope it will work.
  13. account8226

    account8226 Guest

    Hey, everything is working fine now ! Thanks you very much for your awnsers.

    I juste have a little problem I can't open my forum back since the option of the admin php doesn't works. (error 404).


    The rest of the ACP is working fine btw.
  14. account8226

    account8226 Guest

    Ok I used the file health check function and fond that a file was empty, I don't know why.

    Everything is wokring.

    Thanks Brogan and Mike, thanks it worked fine, that's why XenForo is going to be the best forum software ever !

    BTW : My forum should reach 10K members today :)
    Mike likes this.

Share This Page