Problem: Getting Errors

Error 1 :
Failed Process to create tables in the database failed. It could be because of incompatible type or insufficient space. If any tables are created, drop those tables. Please check and restart installation process

Error 2 :
Inserting system data into newly created tables…
Some error occured while inserting data into newly created tables. Please drop all original tables with “_bkp” extension (e.g. osdate_glblsettings_bkp means you should drop osdate_glblsettings). Then rename the “_bkp” tables back to original name (e.g. osdate_glblsettings_bkp to be renamed as osdate_glblsettings). Check the issue and restart installation process

Osdate installation returns these error message when it can’t create tables in your database or can’t populate them with Data.

Resolution :
Open your tables.sql file ( Located in sql subdirectory of your osdate folder) and replace all the TYPE=MyISAM to ENGINE=MyISAM.  You can open the file in Notepad, and use Find/replace ( Control+H)

16 Comments


  1. Works for me, thanks!

    Reply

  2. I thought I had osdate 2.5 installed on my server until sample_data.sql decided it wasnt going to install itself either. Has anyone come across this problem yet? HELP!

    Reply
    • Akash Jain

      Have you tried importing the sample_data.sql to your database using phpmyadmin.

      Reply
  3. cbs

    This works perfectly.

    I am doing a fresh install of oSdate 2.5.4 and had the same database creation failures.

    Thank you!

    Reply

  4. Wow,
    Great trick!
    wonderful debugging.
    work for me.

    Reply

  5. Worked for me thanks for the debugging!

    Reply

  6. Thanks, works like a charm

    Reply
  7. Henri

    Thanks!

    Reply

  8. After I import the file sample_data.sql, the error flowing:
    Error
    SQL query:

    ##
    ## Dumping data for table `[prefix]_adminemails`
    ##
    INSERT INTO `[prefix]_adminemails` ( `id` , `email` )
    VALUES ( 5, ‘info@domain.com’ ) ;

    MySQL said:

    #1146 – Table ‘apprewar_giantrewards.[prefix]_adminemails’ doesn’t exist

    Has anyone give me any method to resolve this ? Thanks

    Reply

  9. Thankyou very much Akash!!!!!!!!!!!!!
    I installed http://www.JVIntroductions.com a while ago. (Which is on it’s own hosting account).

    I have wanted to install several sites for different purposes but due to this problem have been stuck for months. I was trying to install on an unlimited domain hosting account and assumed that is what was causing the problem. Everything I researched was related to that.

    Eventually, I went back to basics and searched your Error 2 message.
    That lead me to you.
    If you’d like to see what sites I’m using the script for, check links from http://www.neilchantry.com . The sites will be linked to that soon.

    If you have a Paypal account, let me know I would like to offer you a small donation to show my appreciation.
    Again, Thanks
    Neil

    Reply
    • Akash Jain

      Glad that it worked for your Neil. Best of luck with your site.

      Reply
  10. Prince

    I was trying to install the OS Date website on my server but when in
    the “Step 2” part, it shows this error message…

    “Warning: Smarty error: unable to read resource:
    “install/install_step3.tpl” in
    /home/myhostname/mydomainname.com/libs/Smarty/Smarty.class.php on line
    1113″

    I have Chmod all the neccesary files and folders but to no avail.
    Please what could be wrong? Help me out! Thank you in anticipation.

    Reply

  11. Some error occured while inserting data into newly created tables. Please drop all original tables with “_bkp” extension (e.g. osdate_glblsettings_bkp means you should drop osdate_glblsettings). Then rename the “_bkp” tables back to original name (e.g. osdate_glblsettings_bkp to be renamed as osdate_glblsettings).

    Reply
  12. aca

    Hello osDate experts help me with this error i got after osdate installation

    Fatal error: Call to undefined function geoip_open() in /srv/disk8/1531469/www/adultsafrica.co.nf/includes/internal/Functions.php on line 1366

    Reply

  13. Wow! It really works for me!

    Reply
  14. viper

    hi cna you please help me on how i can add new phone number field in the register form on osdate.
    i’d really appreciate your support

    Thanks

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *