Error installing second time on same server

[kristian]

Hello all,

First of all; thanks a lot for an excellent free blog system. I installed it successfully here; www.thelifeforum.com/philmis , but then something odd happened. I was going to install it a second time, on the same server, this time on www.thelifeforum.com/kriss . I got the following error message:

Code: Select all

Warning: main(): Failed opening '' for inclusion (include_path='/customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/:/customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/bundled-libs/:.:/usr/lib/php') in /customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/serendipity_genpage.inc.php on line 43

What went wrong?

Is it impossible to install it twice on the same server?

[garvinhicking]

Please try the 0.8-beta5 release, 0.7.1 is really outdated; I don't even have it installed anymore to help you debugging.

Regards,
Garvin

[kristian]

I installed the 0.8-beta release, but still got error messages. Some new ones this time

[garvinhicking]

Well, if you would now give me the new error message, I'll be helping

Regards,
Garvin

[kristian]

Sure Here it is:

Code: Select all

Query failed: 

SELECT 
                    

                    e.id,
                    e.title,
                    e.timestamp,
                    e.comments,
                    e.exflag,
                    e.author,
                    e.authorid,
                    e.trackbacks,
                    e.isdraft,
                    e.allow_comments,
                    e.last_modified,

                    a.realname AS author,
                    a.email

                    , e.body, e.extended
                    
                FROM
                    serendipity_entries AS e
                    LEFT JOIN serendipity_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN serendipity_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN serendipity_category c
                        ON ec.categoryid = c.categoryid
                    
                    WHERE isdraft = 'false' AND e.timestamp <= '1112683278'
                    GROUP BY e.id
                    ORDER BY timestamp DESC
                     LIMIT 15
/ Unknown column 'a.realname' in 'field list'

And now the other installation failed as well. That was functioning before. It seems it's a very bad idea to install two serendipitys on one server

The code here:

Code: Select all

Warning: main(): Unable to access /customers/thelifeforum.com/thelifeforum.com/httpd.www/philmis/include/compat.inc.php in /customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/serendipity_config.inc.php on line 21

Warning: main(/customers/thelifeforum.com/thelifeforum.com/httpd.www/philmis/include/compat.inc.php): failed to open stream: No such file or directory in /customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/serendipity_config.inc.php on line 21

Warning: main(): Failed opening '/customers/thelifeforum.com/thelifeforum.com/httpd.www/philmis/include/compat.inc.php' for inclusion (include_path='/customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/:/customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/bundled-libs/:.:/usr/lib/php') in /customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/serendipity_config.inc.php on line 21

Warning: main(): Unable to access /customers/thelifeforum.com/thelifeforum.com/httpd.www/philmis/include/functions.inc.php in /customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/serendipity_config.inc.php on line 189

Warning: main(/customers/thelifeforum.com/thelifeforum.com/httpd.www/philmis/include/functions.inc.php): failed to open stream: No such file or directory in /customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/serendipity_config.inc.php on line 189

Warning: main(): Failed opening '/customers/thelifeforum.com/thelifeforum.com/httpd.www/philmis/include/functions.inc.php' for inclusion (include_path='/customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/:/customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/bundled-libs/:.:/usr/lib/php') in /customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/serendipity_config.inc.php on line 189

Fatal error: Call to undefined function: serendipity_getsessionlanguage() in /customers/thelifeforum.com/thelifeforum.com/httpd.www/kriss/serendipity_config.inc.php on line 216

Another thing is it seems that running a faulty installation of serendipity crashes the MySQL database. I run my forum on the same database, and I notice that it runs SOOO slow after I have tried to access any of the two serendipity installations.

[garvinhicking]

Okay, there are two issues I draw out of your message.

First, the "missing realname" column is because you once had an intermediate CVS snapshot on your site which was buggy. You'll need to execute this SQL query:

Code: Select all

ALTER TABLE {PREFIX}authors ADD realname VARCHAR( 255 ) NOT NULL FIRST;
UPDATE {PREFIX}authors SET realname = username;

Replace {PREFIX} with your dbPrefix (like 'serendipity_')

Now the other issue: It seems that your first s9y install is on your include_path PHP setting, so the second install tries to access files frmo your first install. You should take care that no include_path setting points to any serendipity directory if you plan on running more than one. If you do have the s9y directory in your include_path you should use our "shared installation" feature which spawns multiple installations from only one central source directory. Look at the documentation on our wiki and search for "Shared install" to see how that should work.

In any case, if the server is properly set up and the files do not influence each other and you use a sperate DB (or seperate DBPrefixes) for each installation, it runs perfectly. I by myself run a host with 7 parallel s9y installations in non-shared mode and it works flawlessly...

Regards,
Garvin

[kristian]

Ok, I'm somewhat a php-analphabet, so I'm not that fast

I deleted both installs. What is the easiest way to have more than one author? Can I just install two separate installs and then make sure that the DB prefixes are different, and that will do the trick, or are there also other things to keep in mind?

Sorry for being such a n00b!

[garvinhicking]

Do you want to have 2 Blogs or just 2 Authors? Because a blog can already have multiple authors writing to the same blog via the User Management Admin panel.

For 2 Blogs the easiest way would basically be like this:

1. Unpack the serendipity .tar.gz to /customers/thelifeforum.com/thelifeforum.com/httpd.www/BLOG1/
2. Open your http://thelifeforum.com/BLOG1/ URL and install to dbPrefix "blog1_". Pay attention that the path setting defaults by Serendipity point to the path in 1.
3. Unpack the serendipity .tar.gz to /customers/thelifeforum.com/thelifeforum.com/httpd.www/BLOG2/
4. Open your http://thelifeforum.com/BLOG2/ URL and install to dbPrefix "blog2_". Pay attention that the path setting defaults by Serendipity point to the path in 3.

Then it should basically work. The only thing which may have an influence if an 'include_path' is set to /customers/thelifeforum.com/thelifeforum.com/httpd.www/BLOG1/ or /customers/thelifeforum.com/thelifeforum.com/httpd.www/BLOG2/ - this should never be needed and never happen. To check that out, create a

Code: Select all

<?php
phpinfo();
?>

script, save it as 'test.php' on your site and execute it via HTTP (http://yourhost/test.php). There look out for "include_path" and tell me what it is set to. If it includes the path mentioned above, you need to contact your System Administrator and ask him, why he did that.

Regards,
Garvin

Ok, I'm somewhat a php-analphabet, so I'm not that fast

I deleted both installs. What is the easiest way to have more than one author? Can I just install two separate installs and then make sure that the DB prefixes are different, and that will do the trick, or are there also other things to keep in mind?

Sorry for being such a n00b!

[kristian]

Hello again, and thanks a lot for so thorough help


The include_path is

.:/usr/lib/php

is that ok?

[garvinhicking]

Yes, that include_paths hould propose no problems. But make sure that no other script or .htaccess file, except the ones from Serendipity, make alterations to that include_path.

Regards,
Garvin

[kristian]

Ok, I did what you told me to, and now it works!

Thanks a lot man!

All hail to Garvin!

[kristian]

Book sent in post

[garvinhicking]

Great you got it working!

And thanks...

Regards,
Garvin