Welcome Guest, Not a member yet? Register   Sign In
flexi auth - A user authentication library for CodeIgniter

[eluser]huesoamz[/eluser]
Hi!, first very thanks for this very usefull library, I use this for default in mysql I and dont have problems, but one of the requeriments is that the app work over PostgreSQL, I made a migration from mysql and I config the database.php

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'postgres';
$db['default']['password'] = '';
$db['default']['database'] = 'test';
$db['default']['dbdriver'] = 'postgre';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

But this return a blank page, this library support PostgreSQL?

EDIT: i change my server and this support postgreSQL, but is really a pity that this auth have a lot ofs incongruencies with Postgre this is one of them:

ERROR: column "user_accounts.uacc_email" must appear in the GROUP BY clause or be used in an aggregate function

SELECT "uacc_id", "uacc_email", "uacc_suspend", "ugrp_name", "upro_first_name", "upro_last_name" FROM "user_accounts" LEFT JOIN "user_groups" ON "user_accounts"."uacc_group_fk" = "user_groups"."ugrp_id" LEFT JOIN "demo_user_profiles" ON "user_accounts"."uacc_id" = "demo_user_profiles"."upro_uacc_fk" LEFT JOIN "demo_user_address" ON "user_accounts"."uacc_id" = "demo_user_address"."uadd_uacc_fk" GROUP BY "uacc_id"

When I List the "manage users" after login Sad

Regards.-


Messages In This Thread
flexi auth - A user authentication library for CodeIgniter - by El Forum - 04-03-2013, 07:41 AM



Theme © iAndrew 2016 - Forum software by © MyBB