Page 1 of 1

table references?

Posted: Mon Feb 28, 2005 9:58 pm
by rickmans
Since the upgrade to 8.11 (and 8.12) I have got a rather weird error. It stated that the table references does not exist (which is correct). How could this happen en how could this be fixed? For more details on the error see http://internetschoon.nl/ and scroll down.

Re: table references?

Posted: Tue Mar 01, 2005 3:20 pm
by garvinhicking
The problem is that you installed Serendipity with an empty dbPrefix. This is/was not recommended, and by now the installer no longer allows this. The best thing would be to create a dbPrefix (rename your tables manually) and then create the postgresql table prefix_references manually...

Regards,
Garvin

Posted: Tue Mar 01, 2005 4:15 pm
by rickmans
in which file can I find the the create table of the table references?

Posted: Tue Mar 01, 2005 5:11 pm
by garvinhicking
In sql/db.sql - you may need to do the same replacements like include/db/postgresql.inc.php, function serendipity_db_schema_import() does.

Regards,
Garvin

Posted: Tue Mar 01, 2005 6:03 pm
by rickmans
thanks it works (of course it did :P). Why was decided to make the prefix mandatory?

Posted: Wed Mar 02, 2005 3:10 pm
by garvinhicking
Because it was easier than to rename the 'references' table. Renaming would affect every user, and many places in our code. While requiring a prefix only requires those very little users who entered no prefix to fix their setup...

Regards,
Garvin