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

XF 1.2 Help with Mysqli prepare error

Discussion in 'Troubleshooting and Problems' started by AT8500, Dec 9, 2013.

  1. AT8500

    AT8500 Member

    Last night, all the sudden this error happened. I didn't do anything (install, deinstall, update or so). Just it happened and I don't know why. I can't access forum at all.

    Also one thing that is strange is in phpmyadmin in 9 of 10 time drops connection only for database of forum and other 15 databases works OK. So I can't even see tables or do anything in phpmyadmin with this databse. Tables are there (I checked in root folder and all files are there but there is some problem with forum db, but don't know what)

    Important thing is that I didn't touch anything so error and problem just occurred from itself.

    Please help!
  2. Jeremy

    Jeremy Well-Known Member

    Does the error continually occur? Or has it been just the once?

    If you can, go to the upgrader and see if it informs you there is an upgrade to perform.
  3. AT8500

    AT8500 Member

    yes it continually occur. I can't use forum at all.
  4. Jeremy

    Jeremy Well-Known Member

    Can you access the upgrade system?
  5. AT8500

    AT8500 Member

    I can't access any part of forum.

    When try to go to /install i get this error

    I belive that problem is with SQL and not directly with forum, but my VPS support is not helping me much so maybe you could give me some tips where to look for problem. It really frustraits me. I have 15 more databases and all of them works, except this for forum. I just don't know what could happened.
    The most puzzling is that I didn't touch anything to brake down server or forum code, but it just happened without any warning or result of action I did. (
  6. Brogan

    Brogan XenForo Moderator Staff Member

    If this error happened randomly then you need to contact your host as it sounds like a server problem.

    Tables don't just disappear so if xf_deferred is missing and you didn't make any changes then something has gone drastically wrong on the server.
  7. AT8500

    AT8500 Member

    After repairing some taibles and trying to access /install i get

    is this telling you something.

    And really xf_deferred is missing on server. What I can do about it? Is there any way to fix it (create it manualy?)
  8. Jeremy

    Jeremy Well-Known Member

    Error -1 is most likely your mysql server running out of space.
  9. AT8500

    AT8500 Member

    Also little update:
    VPS did something to db and it was down for few minutes, now it is up again and running some parts that didnt work before but now I get this:

    when try to access /install

    Mysqli prepare error: Incorrect information in file: './forum2/xf_data_registry.frm'

    and this when try to access frontend of forum
    An exception occurred: Mysqli prepare error: Incorrect information in file: './forum2/xf_option.frm' in /home/admin/malezeljeznice.net/forum/library/Zend/Db/Statement/Mysqli.php on line 77

    I know that frm is extension of physical table file, but how serious is this and could it be fixed or not?

    I am communicating with support but hope that also someone heir could help with suggestions.
  10. Brogan

    Brogan XenForo Moderator Staff Member

    There's not really much more help which can be given other than what Mike has stated in the ticket.
  11. AT8500

    AT8500 Member

    OK people tnx for your replys.

    Right now i managed to pull out of this problem, installed forum in new place and now one-by one tables dumping from old db to new one. I know that they are all related in some way but could someone say exactly what tables I should dump and import if I want to keep all data from old db and which ones are not so important.

    For example I imported allready


    And things are working, in admin panel I see correct statistics, I can login with old username and password but only cant see forums listed, but in node list I see that they are all there. So I guess that I missed few tables with premissions (I did import user premissions).
    Also did chache rebuild.

    So would it be problem if someone could provide me with list of tables that I need if I want to keep old data.

    I don't minde for addons, template modification and other not so important things ( I would like to get them allm but if they are lost it is ok.). I need only data and funtionality back.
  12. Brogan

    Brogan XenForo Moderator Staff Member

    You would need most of the tables such as attachment*, conversation*, forum*, node*, permission*, profile*, thread*, user*, plus others most likely.

    Even if you do manage to get it working, it is likely that there will be incomplete or corrupt data which may be difficult to resolve.
  13. AT8500

    AT8500 Member

    hey guys just one more question. I know it is answered few times but want to be sure to not destroy this little what I managed to save and setup again.

    I did install xenForo in new folder (called "forumNEW"). My "old" forum with broken database was installed in folder called "forum".
    Now after I did set up everyting in this new forum would it be OK to rename folder "forumNEW" into "forum" and then change in xenForo settings of new forum name of main directory. Will it make any problems?

    I want to do it this way so users could access forum via old links (forum.mydomain.net and mydomain.net/forum)

    Is there anything elese I should set or watch for while before/after renaming folder.
  14. Jeremy

    Jeremy Well-Known Member

    AT8500 likes this.
  15. Rasteri

    Rasteri Member

    Hey, i had this same problem. (not enough space) Would it work if i just delete corrupted (current) MYSQL file and upload week older backup file in stead?

    I can access almost all parts of my forum, but not nodelist and stats ("front page").
  16. Brogan

    Brogan XenForo Moderator Staff Member

    As long as the backup is viable, yes.

Share This Page