Serendipity Forums

I have been looking for instructions to add multiple blogs to same database.

I believe it's done by changing dbprefix.

newbie

That's exactly how it's done. You can't use the simple setup in that case, though; you have to use the expert setup, and specify a unique database prefix for each blog.

I find documentation for using the httpd.conf but I don't have access to it with shared hosting.

Where can I find the instructions for doing it with the db prefix?

Hi!

rob21 wrote:I find documentation for using the httpd.conf but I don't have access to it with shared hosting.

Where can I find the instructions for doing it with the db prefix?

Simply install s9y and choose "Expert installation" in the s9y wizard.

No need to mangle with httpd.conf for that. This is only meant for shared installations, you don't need it if you simply want to install multiple versions of Serendipity into a single database. Each s9y installation will use its own unique tables by specifying the prefix.

Regards,
Garvin

Thaanks

Any other options??

The program was installed from my web site host.

Still shouldn't be a problem, although you may not be able to install with your webhost's script.

Just FTP the Serendipity files into a new directory. Look at your existing serendipity_config_local.inc.php to figure out where the database is and what the access credentials are. Now go visit the new directory, choose "Expert installation", and enter the access credentials, new database prefix, and any other options you like.

You can even install different versions of Serendipity into the same database.

And don't let the description "Expert" bother you. It's the same as Simple, but you get to see all the options that a Simple Installation forces to default values, like the database prefix. You don't need to change anything you don't understand.

Thanks for responding

I managed to create a new database and do an expert install of the program myself.

How do I create another blog with in the database using the db prefix??

Rob21 - from the admin screen, when you first install s9y, you want to select "expert installation". The first group of installation options is marked "Database Settings". You will see options for Database type, Database host, Database user, Database password, Database name AND......... Database table prefix.... The type, host , user, password and name should match your existing database. What you what to change is the Database Table Prefix for this additional installation.

What that will do is maintain the single database, but create all the correct tables for this unique additional s9y installation.

For instance, lets say that your initial installation sets that prefix to "serendipity_". So that gives your database tables names like serendipity_entries, serendipity_whatever. Those tables are all still contained within a single database.

Now you want a second s9y install.... you want the TABLES to be contained within the same DATABASE. So you give this second database the prefix of "serendipity_second_." Now, all the tables unique to that second install have a name such as "serendipity_second_entries", and you can distinguish that 2nd install from the first due to that prefix.

Does that make sense?

It sounds like I upload all the files again to a different directory and do a complete install using all the same settings except change db table prefix.

Am I correct??

Yes, that is correct.

And of course, the path to the blog will have to match the new directory, too.

It sorta worked.

I used the same username and password for admin in both blogs but I'm locked out of the first blog.

I went into the database and there both the same.

Could it be a cookie problem? If you set them up on the same domain, you'd need to delete the authentication cookie whenever you wanted to log in to another blog.

If you can figure out how to do subdomains on your server, and you set the Serendipity admin configuration to the new subdomain, that takes care of the cookie problem.

Thanks for responding

Each blog is in its own directory
Each blog has "serendipity_admin.php in its root

I can create a subdomain for each.
blog1.mydomain.com brings up serendipity_admin.php
blog2.mydomain.com brings up serendipity_admin.php

No matter what I do I can't log into the first blog.


This error appears in the database under access/browse for both blogs:
More than one INDEX key was created for column `artifact_id`

This going beyond my abilities.

Hi!

So you can log into blog2, but not blog1? Which database prefix did you set for each blog? You should have two dataase tables like blog1_authors and blog2_authors. Check if both tables contain your login username?

Regards,
Garvin

prefixs:
serendipity_1
serendipity_2

Everything in the data base is
authors1
users1
authors2
users2
etc

Both tables have same username and password.