Database Error PHP Codeigniter on my online server HELP

mldarshana

Well-known member
  • Apr 2, 2007
    34,059
    1,404
    113
    ආශ්චර්ය අභියස :nerd:
    machan oka denna one phpmyadmin eke privileges eken neda?mage server eke phpmyadmin privileges eka pennanne naha.eka nisa mama sql query ekak dunna mehema,

    "GRANT ALL PRIVILEGES ON *.* TO 'MYUSERNAME'@'%' WITH GRANT OPTION; "

    ethakota mehema awa,

    "#1470 - String 'MYUSERNAME' is too long for user name (should be no longer than 16)"

    cPanel eke databases walata gihin karanna puluwan
     

    san1020

    Well-known member
  • Jun 8, 2011
    3,496
    506
    113
    ලැප ඉදිරියේ
    machan me code eka koheda daann one?controller ekeda?

    machan codeigniter forum eketh mama meka damma.hena welawak yanawa ban monawata hari reply karanna.epa wenawa:sorry:

    1,2,3 controller eke error ekak thiyenawa nam eka display karaganna neh oni

    3,4 php,ini file eke mama hithanne true/false dala balanna .

    meka gaththe codeigniter forum eken
     

    SaNDun

    Well-known member
  • May 4, 2006
    12,677
    811
    113
    In La Srinka
    machan mama dan paid hosting ekak aran uba kiwwa widiyata kala.eth ara error ekama thamai enne ban.mokada e?
    ara man issellath kiwwa wage teamviewer dala remote support ekak ganin. methana thread 100k dammath wedak na oya error eka on location test karala balanne nathuwa.
     

    Xeroxeen

    Member
    May 20, 2013
    1,935
    73
    0
    ~Logical Address~
    ara man issellath kiwwa wage teamviewer dala remote support ekak ganin. methana thread 100k dammath wedak na oya error eka on location test karala balanne nathuwa.

    owu eka aththa machan.meka office eke wadak ban.ekai case eka.oofice machine ekata teamweaver daana baha.dakkoth iawarai.mama machan meka codeigniter forum eke dammama ekkenke mehema php file ekak website ekata daala server connection eka check karanna kiwwa.

    Code:
    <?php
    $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
    if (!$link) {
        die('Could not connect: ' . mysql_error());
    }
    echo 'Connected successfully';
    mysql_close($link);
    ?>

    mehema daala baluwama 'Connected successfully' kiyala enawa.e kiyanne ban uth kiyanawa meka codeigniter issue ekak kiyala.server issue ekak nemei.mama mokda ban karanne?dan site eka iwara wenna onna menna.meka server eke wada karanne nahane :(
     

    SaNDun

    Well-known member
  • May 4, 2006
    12,677
    811
    113
    In La Srinka


    owu eka aththa machan.meka office eke wadak ban.ekai case eka.oofice machine ekata teamweaver daana baha.dakkoth iawarai.mama machan meka codeigniter forum eke dammama ekkenke mehema php file ekak website ekata daala server connection eka check karanna kiwwa.

    Code:
    <?php
    $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
    if (!$link) {
        die('Could not connect: ' . mysql_error());
    }
    echo 'Connected successfully';
    mysql_close($link);
    ?>

    mehema daala baluwama 'Connected successfully' kiyala enawa.e kiyanne ban uth kiyanawa meka codeigniter issue ekak kiyala.server issue ekak nemei.mama mokda ban karanne?dan site eka iwara wenna onna menna.meka server eke wada karanne nahane :(
    ow math okama thamai mulinma karala balanne. server eke awulak nam ara code eka dala db connection eka gahuwama weda karanna widiyak na. e kiyanne aniwa codeigniter eke issue ekak.

    oka ithin apita pena kiyanna ba kollo. aniwa on site ma step by step check karala awula thiyenne kothanada kiyala hoyaganna wenawa.

    oya office eke weda karanne windows & server eka linux nam. oya site eke files wala windows characters (carriage return) write wela thiyenawada balanna. samahara welawata oya char case hindath linux waladi awul enawa.

    eka balanna file eke full content ekama notepad/dreamviewer cut paste karala. ara file eka delete karala dala. e thibuna name ekenma aluthen save karanna.
     

    Xeroxeen

    Member
    May 20, 2013
    1,935
    73
    0
    ~Logical Address~
    ow math okama thamai mulinma karala balanne. server eke awulak nam ara code eka dala db connection eka gahuwama weda karanna widiyak na. e kiyanne aniwa codeigniter eke issue ekak.

    oka ithin apita pena kiyanna ba kollo. aniwa on site ma step by step check karala awula thiyenne kothanada kiyala hoyaganna wenawa.

    oya office eke weda karanne windows & server eka linux nam. oya site eke files wala windows characters (carriage return) write wela thiyenawada balanna. samahara welawata oya char case hindath linux waladi awul enawa.

    eka balanna file eke full content ekama notepad/dreamviewer cut paste karala. ara file eka delete karala dala. e thibuna name ekenma aluthen save karanna.

    ela machan mama ehema karala balannan.habai localhost eke wada karanawa machan.uba kiyanne file eke content eka copy karala aith paste karanna kiyalada?mata eka poddak therune naha machan?
     

    SaNDun

    Well-known member
  • May 4, 2006
    12,677
    811
    113
    In La Srinka
    ela machan mama ehema karala balannan.habai localhost eke wada karanawa machan.uba kiyanne file eke content eka copy karala aith paste karanna kiyalada?mata eka poddak therune naha machan?
    ow. oka karanna wenne program eke sequence ekata. mulinma run wena file eke idala ekin ekata initialize wena file eka check karanna wenawa. samahara welawata db config file ekema wennath puluwan awula aththe.

    karanne mehemai. file eka notepad/dw open karanawa. content eka cut karala new file ekak open karala ekata paste karanwa. ara original file name eka copy karagena e file eka delete karanawa.

    ara aluthen open karala content paste karapu file eka ara copy karapu filename ekenma apahu original location eke save karanawa.
     

    Xeroxeen

    Member
    May 20, 2013
    1,935
    73
    0
    ~Logical Address~
    ow. oka karanna wenne program eke sequence ekata. mulinma run wena file eke idala ekin ekata initialize wena file eka check karanna wenawa. samahara welawata db config file ekema wennath puluwan awula aththe.

    karanne mehemai. file eka notepad/dw open karanawa. content eka cut karala new file ekak open karala ekata paste karanwa. ara original file name eka copy karagena e file eka delete karanawa.

    ara aluthen open karala content paste karapu file eka ara copy karapu filename ekenma apahu original location eke save karanawa.

    ok machan.mama karanne netbeans thamai IDE eka widiyata use karanne.eken kaloth awulda machan?
     

    SaNDun

    Well-known member
  • May 4, 2006
    12,677
    811
    113
    In La Srinka
    ok machan.mama karanne netbeans thamai IDE eka widiyata use karanne.eken kaloth awulda machan?
    mata loku sure ekak thiyenawa othana awula thiyenne windows char ekak kothanaka hari file ekaka write wela thiyena hinda ethanin ehata linux waladi hariyata code eka execute wenne nathi hinda kiyala.

    e hinda puluwan nam notepad or dw use karala oka karanna balanna
     
    • Like
    Reactions: Xeroxeen

    Xeroxeen

    Member
    May 20, 2013
    1,935
    73
    0
    ~Logical Address~
    mata loku sure ekak thiyenawa othana awula thiyenne windows char ekak kothanaka hari file ekaka write wela thiyena hinda ethanin ehata linux waladi hariyata code eka execute wenne nathi hinda kiyala.

    e hinda puluwan nam notepad or dw use karala oka karanna balanna

    ela machan :D thanks rep+
     

    Gihanlasita

    Member
    May 21, 2007
    392
    3
    0
    machan

    $db['default']['dbdriver'] = 'mysqli'; change to

    $db['default']['dbdriver'] = 'mysql';

    then try.

    mysqli db driver class may not supported by your hosting provider
     
    Last edited:

    Xeroxeen

    Member
    May 20, 2013
    1,935
    73
    0
    ~Logical Address~
    Finally could solve the issue :D

    awula wela thibbe mukuth nemei Codeigniter wala model files names okkoma lowercase wenna one.mamauppercase letters daala thibila.eth eka localhost xampp eke nam wada kala.eth samaharawita linux environment eke awulak athi wada karanna.anyway again thanks all the people who commented here :)