Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Database Done but i can't create tables and o

Apache
teresa
2008-12-23
2013-06-05
  • teresa
    teresa
    2008-12-23

    Hello,

    I managed to reach on the installing step. But when i tried to click install button, i got a message saying that database is Done but i could not create tableThat i had to have super Privileges to do so, yet i had created a username to the database for hrm and gave it all the privileges. So what what could be the problem? Iam using a Cpanel

    I have tried to read other posts with the same problem but failed to see reply with positive response to the problem.

    Your support will be highly appreciated

    Thanks

    Ronnie

     
    • Mafaz Mazeen
      Mafaz Mazeen
      2009-08-19

      HI

      This may happen if the non privilage user going to create a new user.
      user should have access to 'mysql' schema going to access the 'mysql' schema to see any existing users.
      So give access to that user and see whether you can install

       
  • how to create data table without SQL server in ASP.NET 2.0 and C#. This is very useful for storing temporary data.Add a GridView control, two lable controls, three textbox controls and button control in the page
    Create datatable structure.

    private DataTable CreateDataTable()
    {
    DataTable myDataTable = new DataTable();

    DataColumn myDataColumn;

    myDataColumn = new DataColumn();
    myDataColumn.DataType = Type.GetType("System.String");
    myDataColumn.ColumnName = "id";
    myDataTable.Columns.Add(myDataColumn);

    myDataColumn = new DataColumn();
    myDataColumn.DataType = Type.GetType("System.String");
    myDataColumn.ColumnName = "username";
    myDataTable.Columns.Add(myDataColumn);

    myDataColumn = new DataColumn();
    myDataColumn.DataType = Type.GetType("System.String");
    myDataColumn.ColumnName = "firstname";
    myDataTable.Columns.Add(myDataColumn);

    myDataColumn = new DataColumn();
    myDataColumn.DataType = Type.GetType("System.String");
    myDataColumn.ColumnName = "lastname";
    myDataTable.Columns.Add(myDataColumn);

    return myDataTable;
    }

     
  • If Database table is created then he or she can easily create other tables if he or she has properly understand the creation of table.