[Librefm-bugs] [bug #26497] Can't install locally since the move from mdb2 to adodb

[David Mignot]

Follow-up Comment #3, bug #26497 (project librefm):

I got another error since i updated to revision 1432. I still had to add the
$adodb_connect_string in install.php. 

It seems the reference in "Auth" table should be changed from
"Users(username)" to "Users(uniqueid)", but I'm really not sure about that.

Here is the new error (in gnukebox/install.php):
Fatal error: Uncaught exception 'ADODB_Exception' with message 'postgres7
error: [-1: ERROR: there is no unique constraint matching given keys for
referenced table "users"] in EXECUTE("CREATE TABLE Auth ( token VARCHAR(32)
PRIMARY KEY, sk VARCHAR(32), expires INTEGER, username VARCHAR(64) REFERENCES
Users(username))") ' in /usr/share/php/adodb/adodb-exceptions.inc.php:78 Stack
trace: #0 /usr/share/php/adodb/adodb.inc.php(1036): adodb_throw('postgres7',
'EXECUTE', -1, 'ERROR: there i...', 'CREATE TABLE Au...', false,
Object(ADODB_postgres7)) #1 /usr/share/php/adodb/adodb.inc.php(1011):
ADOConnection->_Execute('CREATE TABLE Au...', false) #2
/home/idflood/workspace/librefm/trunk/gnukebox/install.php(110):
ADOConnection->Execute('CREATE TABLE Au...') #3 {main} thrown in
/usr/share/php/adodb/adodb-exceptions.inc.php on line 78

    _______________________________________________________

Reply to this item at:

  <http://savannah.nongnu.org/bugs/?26497>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.nongnu.org/