table references?

Having trouble installing serendipity?
Post Reply
rickmans
Regular
Posts: 16
Joined: Mon Feb 14, 2005 7:33 pm
Location: The Netherlands
Contact:

table references?

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: table references?

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
rickmans
Regular
Posts: 16
Joined: Mon Feb 14, 2005 7:33 pm
Location: The Netherlands
Contact:

Post by rickmans »

in which file can I find the the create table of the table references?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
rickmans
Regular
Posts: 16
Joined: Mon Feb 14, 2005 7:33 pm
Location: The Netherlands
Contact:

Post by rickmans »

thanks it works (of course it did :P). Why was decided to make the prefix mandatory?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply