I’v stopped using CodeIgniter for 7 months, but I maintaining a product that was developed under CI.
Today I’v got a error saying “MySQL server has gone away” after a long time PHP execution.
I’v managed to solve it by, on the model that was getting me the error, *reconnect* to the database .
Before the *command* i’v added $this->db->reconnect();
$this->db->reconnect();
$this->db->insert('photoGallery', $data);
return $this->db->insert_id();
Hope it helps anyone out there.
Facebook’s HipHop Engine, When to Use it, and Getting it to Work with CodeIgniter
I’v recently posted an article mentioning Facebook Ion Auth, and a visitor from France asked me how did I installed it.
Please notice that you are at your own risk using this!
Please post a comment if you find any mistake, error, problem, issue, etc, etc!
Autor: Me!
These are the steps.
$autoload['libraries'] = array('database', 'ion_auth', 'Facebook_ion_auth');
nginx
Add the following lines on your /etc/nginx/sites-enable/domain.com or default.
# removes trailing "index" from all controllers
if ($request_uri ~* index/?$)
{
rewrite ^/(.*)/index/?$ /$1 permanent;
}
More details how to set up a nginx environment for CI.
http://wiki.nginx.org/Codeigniter
Apache
Create a .htaccess file on the root of your CI installation (in the same directory where you have system, application, etc).
RewriteEngine on
RewriteCond $1 !^(index\.php|images|robots\.txt)
RewriteRule ^(.*)$ /index.php/$1 [L]
Awesome tutorial about mod-rewrite / pretty links
http://stackoverflow.com/questions/20563772/reference-mod-rewrite-url-rewriting-and-pretty-links-explained
Thats kinda it!
Basically is a pretty url rewrite condition, for nginx must be also simple as that.
Simple as that!
On my latest work/project, with CodeIgniter, I need to use subqueries – a select inside another select.
This is a subquery library for CodeIgniter’s active record class. It lets you use active record methods to create subqueries in SQL queries. It supports SELECT, JOIN, FROM (and other statements, I guess). It also supports subqueries inside subqueries.
From: https://github.com/EllisLab/CodeIgniter/wiki/Subqueries
For that I had to download a subquery library for CodeIgniter’s available where
https://github.com/NTICompass/CodeIgniter-Subqueries.
I’v uploaded a CodeIgniter application from my localhost with Apache to a server running Nginx.
Its works perfectly on my localhost and on other server with Apache.
It’s under a subdomain, an domain and other subdomains are running PHP 100%.
This application in CI doesn’t start, and PHP is returned without being compiled.
This is what I get on /var/log/nginx/error.log:
2013/12/05 14:50:31 [error] 20139#0: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error: Class 'M_website' not found in /home/webroot/domain.com/cms/system/core/Loader.php on line 303" while reading upstream, client: 84.91.4.220, server: cms.domain.com, request: "GET /websites HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "cms.domain.com"Why the problem?
CI files were starting with
<?and not with
<?phpSolution
Had to edit /etc/php5/fpm/php.ini and set short_open_tag from Off to On and restart php-fpm.
service php5-fpm restart
This is how I solved it… simple issue to solve.