MSSQL 2012 R2 installation

Results 1 to 5 of 5
  1. #1
    MMORG Fan in Ragezone KyleMarvin is offline
    MemberRank
    Nov 2011 Join Date
    AustraliaLocation
    349Posts

    MSSQL 2012 R2 installation

    Just wanted to ask

    1. What does this mean?

    Warning: mssql_query() [function.mssql-query]: message: Column name or number of supplied values does not match table definition. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

    Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

    Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'userId', table 'billcrux_phil.dbo.tblUser'; column does not allow nulls. INSERT fails. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 169

    2. why is the GameInfo00 table turns blank after 24 hrs?

    3. Any kind hearted wants to share a sample CRUD for mssql-php


    Thanks in advance.

    I re-installed xampp, then copy-pate the wed login and there came this error.


  2. #2
    Account Upgraded | Title Enabled! alan110 is offline
    MemberRank
    Dec 2007 Join Date
    240Posts

    Re: MSSQL 2012 R2 installation

    Hiya Kyle.

    M8 im running server 2011 sr2 along with msql 2012. im having no probs with .php errors on sql with my web.

    m8 try and list a few lines either side of line 161 on your reg.php and il try to help you regards alan110

  3. #3
    Developer Terrified is offline
    MemberRank
    Dec 2013 Join Date
    Six MountainsLocation
    229Posts

    Re: MSSQL 2012 R2 installation

    Quote Originally Posted by KyleMarvin View Post
    Just wanted to ask

    1. What does this mean?

    Warning: mssql_query() [function.mssql-query]: message: Column name or number of supplied values does not match table definition. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

    Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

    Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'userId', table 'billcrux_phil.dbo.tblUser'; column does not allow nulls. INSERT fails. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 169

    2. why is the GameInfo00 table turns blank after 24 hrs?

    3. Any kind hearted wants to share a sample CRUD for mssql-php


    Thanks in advance.

    I re-installed xampp, then copy-pate the wed login and there came this error.
    Kyle please check your xampp it might have a wrong configuration... i didn't experience that part. ^_^

    best regards... watch your health, its your treasure.

  4. #4
    MMORG Fan in Ragezone KyleMarvin is offline
    MemberRank
    Nov 2011 Join Date
    AustraliaLocation
    349Posts

    Re: MSSQL 2012 R2 installation

    Thanks mate... I just solved it. it was the added columns in the UserLogin Database Accounts Table... and missing in the $sql "INSERT INTO..." code. Already addressed. problem solved.
    @Terrified thanks. I revised the php code and its working.

    Quote Originally Posted by alan110 View Post
    Hiya Kyle.

    M8 im running server 2011 sr2 along with msql 2012. im having no probs with .php errors on sql with my web.

    m8 try and list a few lines either side of line 161 on your reg.php and il try to help you regards alan110

  5. #5
    Herp Derp Twisted Fate is offline
    MemberRank
    Dec 2010 Join Date
    The NetherlandsLocation
    479Posts

    Re: MSSQL 2012 R2 installation

    Thread closed upon request.



Advertisement