SQL Server Error - Printable Version

SQL Server Error - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: SQL Server Error (/showthread.php?tid=61697)

SQL Server Error - jlq10 - 05-06-2015

Hey Guys,

I'm trying to configure a WISP installation. I have downloaded the appropriate SQL Server PHP Extension for Windows and i'm using the sqlsvr driver in CodeIgniter. I'm not getting any connection errors, but I am getting the following error:

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 65488 bytes) in D:\webapps\ci-3.0.0\database\DB_driver.php on line 147

I have upped the memory limit in php.ini from 128 mb to 256 mb, but that didn't seem to fix it, just gave me the same error. This is also a brand new installation, so all i've done is download CodeIgniter with just the welcome controller, and have not added any database code. I get the error when I try to add the 'database' option to the autoload array.

Any ideas?

Thanks,

Lee

RE: SQL Server Error - Narf - 05-07-2015

Line 147 is a comment block ...

RE: SQL Server Error - ivantcholakov - 05-07-2015

Indeed, https://github.com/bcit-ci/CodeIgniter/blob/3.0.0/system/database/DB_driver.php#L147

RE: SQL Server Error Have the same issue need the solution - tulasiram - 08-08-2018

(05-06-2015, 06:12 PM)jlq10 Wrote: Hey Guys,

I'm trying to configure a WISP installation. I have downloaded the appropriate SQL Server PHP Extension for Windows and i'm using the sqlsvr driver in CodeIgniter. I'm not getting any connection errors, but I am getting the following error:

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 65488 bytes) in D:\webapps\ci-3.0.0\database\DB_driver.php on line 147

I have upped the memory limit in php.ini from 128 mb to 256 mb, but that didn't seem to fix it, just gave me the same error. This is also a brand new installation, so all i've done is download CodeIgniter with just the welcome controller, and have not added any database code. I get the error when I try to add the 'database' option to the autoload array.

Any ideas?

Thanks,

Lee

RE: SQL Server Error - hicham - 09-18-2018

i have the same problem with c1.3.1.9 !

any suggestion ?

thanks

RE: SQL Server Error - snelledre - 09-18-2018

I'm using the standaard sqldrv with mussel 2014 and 2016 with no problem.

Code:
$db['default'] = array(

    'dsn'    => '',

    'hostname' => 'name server\SQLEXPRESS',  //if you using sqlexpress like me

    'port' => '1433',

    'username' => 'your username',

    'password' => 'your password',

    'database' => 'Your database',

    'dbdriver' => 'sqlsrv',

    'dbprefix' => '',

    'pconnect' => FALSE,

    'db_debug' => (ENVIRONMENT !== 'production'),

    'cache_on' => FALSE,

    'cachedir' => '',

    'char_set' => 'utf8',

    'dbcollat' => 'utf8_general_ci',

    'swap_pre' => '',

    'encrypt' => FALSE,

    'compress' => FALSE,

    'stricton' => FALSE,

    'failover' => array(),

    'save_queries' => TRUE

);

RE: SQL Server Error - Gurutechnolabs - 09-29-2018

Hello,

I got your problems. I have one solution for that hopefully it will help you.

Change the memory_limit option in your php.ini as per your needs. or script on a live server then contact to your server provider, for Change memory limit options.