Ugrade to 1.4 Beta: Fatal Error serendipity_db_connect

tfmy2k · Post by **tfmy2k** » Wed Dec 10, 2008 7:13 am

I upgraded to 1.4 from 1.3: i am using RVSiteBuilder and JustHost's automated BLOG call system to Serendipity: after overwriting all files i get following error I did not overwrite serendipity_local.inc.php file as instructed and i could not find any .htaccess file to overwrite. After overwriting all files, when i try to login into admin, i get following error:

Fatal error: Call to undefined function serendipity_db_connect() on line 261

Please help and many thanks!

tfmy2k · Post by **tfmy2k** » Wed Dec 10, 2008 8:19 am

I tried unzipping from fresh and overwriting the files again: Now, i'm getting following errors:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /home/brainsu1/public_html/blogweb/include/db/mysql.inc.php on line 270

Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'brainsu1'@'localhost' (using password: NO) in /home/brainsu1/public_html/blogweb/include/db/mysql.inc.php on line 271

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/brainsu1/public_html/blogweb/include/db/mysql.inc.php on line 271

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/brainsu1/public_html/blogweb/include/db/mysql.inc.php on line 281

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/brainsu1/public_html/blogweb/include/db/mysql.inc.php on line 281
serendipity error: unable to connect to database - exiting.

Post by **garvinhicking** » Wed Dec 10, 2008 11:51 am

Hi!

check your serendipity_config_local.inc.php file - it must contain the valid $serendipity['dbName'] etc. parameters. It seems that file is empty in your case? It must look something like this:

Code: Select all

<?php
        /*
          Serendipity configuration file
          Written on Tue, 09 Dec 2008 11:38:13 +0100
        */

        $serendipity['versionInstalled']  = '1.4-beta2';
        $serendipity['dbName']            = 'serendipity';
        $serendipity['dbPrefix']          = 'serendipity10_';
        $serendipity['dbHost']            = '127.0.0.1';
        $serendipity['dbUser']            = 'root';
        $serendipity['dbPass']            = 'root';
        $serendipity['dbType']            = 'mysql';
        $serendipity['dbPersistent']      = false;
        $serendipity['dbCharset']         = 'utf8';

        // End of Serendipity configuration file
        // You can place your own special variables after here:
?>

tfmy2k · Post by **tfmy2k** » Wed Dec 10, 2008 9:45 pm

Many thanks for your help...the serendipity_config_local.inc.php was empty: i have modified it as follows

<?php
/*
Serendipity configuration file
Written on Tue, 09 Dec 2008 11:38:13 +0100
*/

$serendipity['versionInstalled'] = '1.4-beta2';
$serendipity['dbName'] = 'db';
$serendipity['dbPrefix'] = 'brainsu1_';
$serendipity['dbHost'] = '127.0.0.1';
$serendipity['dbUser'] = 'brainsu1_sys';
$serendipity['dbPass'] = 'password';
$serendipity['dbType'] = 'mysql';
$serendipity['dbPersistent'] = false;
$serendipity['dbCharset'] = 'utf8';

// End of Serendipity configuration file
// You can place your own special variables after here:
?>

However, now it displays the following error message, when i goto the admin page and i try to login with my user/password, however it does not accept the credentials.

Warning: Cannot modify header information - headers already sent by (output started at /home/brainsu1/public_html/blogweb/serendipity_config_local.inc.php:19) in /home/brainsu1/public_html/blogweb/include/functions_config.inc.php on line 662

Warning: Cannot modify header information - headers already sent by (output started at /home/brainsu1/public_html/blogweb/serendipity_config_local.inc.php:19) in /home/brainsu1/public_html/blogweb/include/functions_config.inc.php on line 662

Warning: Cannot modify header information - headers already sent by (output started at /home/brainsu1/public_html/blogweb/serendipity_config_local.inc.php:19) in /home/brainsu1/public_html/blogweb/serendipity_admin.php on line 11

Warning: session_regenerate_id() [function.session-regenerate-id]: Cannot regenerate session id - headers already sent in /home/brainsu1/public_html/blogweb/include/functions_config.inc.php on line 352

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/brainsu1/public_html/blogweb/serendipity_config_local.inc.php:19) in /home/brainsu1/public_html/blogweb/include/functions_config.inc.php on line 353

BTW, can you please tell me what software you used to incorporate this forum into the Serendipity website as i want to add a forum as well.

Many many thanks.

tfmy2k · Post by **tfmy2k** » Wed Dec 10, 2008 10:08 pm

I corrected the config_local file again and am now able to login into the admin, however at the top it still gives me the following errors:

Warning: Cannot modify header information - headers already sent by (output started at /home/brainsu1/public_html/blogweb/serendipity_config_local.inc.php:20) in /home/brainsu1/public_html/blogweb/include/functions_config.inc.php on line 634

Warning: Cannot modify header information - headers already sent by (output started at /home/brainsu1/public_html/blogweb/serendipity_config_local.inc.php:20) in /home/brainsu1/public_html/blogweb/include/functions_config.inc.php on line 634

Warning: Cannot modify header information - headers already sent by (output started at /home/brainsu1/public_html/blogweb/serendipity_config_local.inc.php:20) in /home/brainsu1/public_html/blogweb/include/functions_config.inc.php on line 634

Warning: Cannot modify header information - headers already sent by (output started at /home/brainsu1/public_html/blogweb/serendipity_config_local.inc.php:20) in /home/brainsu1/public_html/blogweb/serendipity_admin.php on line 11

Warning: session_regenerate_id() [function.session-regenerate-id]: Cannot regenerate session id - headers already sent in /home/brainsu1/public_html/blogweb/include/functions_config.inc.php on line 352

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/brainsu1/public_html/blogweb/serendipity_config_local.inc.php:20) in /home/brainsu1/public_html/blogweb/include/functions_config.inc.php on line 353

Also, i see no option for upgrade as outlined in the documentation. If i click on any of the options within Admin, it just logs me out.

tfmy2k · Post by **tfmy2k** » Wed Dec 10, 2008 10:16 pm

Also gives me the following error:

Warning: Smarty error: unable to read resource: "404.tpl" in /home/brainsu1/public_html/blogweb/bundled-libs/Smarty/libs/Smarty.class.php on line 1092

tfmy2k · Post by **tfmy2k** » Wed Dec 10, 2008 10:43 pm

Sorry to bother you but one more thing: when it does login, it shows up sort of very basic without graphics and when you click on any option, it automatically logs out.

kleinerChemiker · Post by **kleinerChemiker** » Wed Dec 10, 2008 10:49 pm

maybe you have a char (newline or space) before the "<?php" or after the "?>". If so, remove it.

tfmy2k · Post by **tfmy2k** » Wed Dec 10, 2008 10:50 pm

OK, i did read thru some of the other forums and found the answer, there was a space in the local_config file, which i removed, the warnings are all gone, but after i login to the ADMIN, it doesnt show any graphics, just basic text, and still it kicks me out as soon as i click on any of the menu options.

Thanks.

tfmy2k · Post by **tfmy2k** » Thu Dec 11, 2008 8:28 am

Its now giving me the following error

Warning: Smarty error: unable to read resource: "404.tpl" in /home/brainsu1/public_html/blogweb/bundled-libs/Smarty/libs/Smarty.class.php on line 1092

Please also tell me how to add a forum to my website like the one in the Serendipity website.

Many many thanks...

tfmy2k · Post by **tfmy2k** » Thu Dec 11, 2008 8:36 am

Verify Installation Integrity
htmlarea/plugins/HtmlTidy/html-tidy-config.cfg corrupt or modified: failed verification
htmlarea/plugins/PreserveScripts/php.svg corrupt or modified: failed verification
htmlarea/plugins/SpellChecker/spell-check-logic.cgi corrupt or modified: failed verification

tfmy2k · Post by **tfmy2k** » Thu Dec 11, 2008 8:40 am

Already changed the following in the config table to:
serendipityPath: /public_html/blogweb/
serendipityHTTPPath: /mywebsitename.com/blogweb/
baseURL: http://mywebsitename.com/blogweb/

Still kicking me out if i click on any option + giving me the following error:

Warning: Smarty error: unable to read resource: "404.tpl" in /home/brainsu1/public_html/blogweb/bundled-libs/Smarty/libs/Smarty.class.php on line 1092

Please help...Thanks.

Post by **garvinhicking** » Thu Dec 11, 2008 9:46 am

Hi!

You REALLY need to stop spamming the same problem again and again. This makes it hard for anyone to read here, and you will eventually not get a response.

Did you clear your cookies in the browser? It might be that old cookies are used and thus logging you out.

This looks wrong:

serendipityPath: /public_html/blogweb/
serendipityHTTPPath: /mywebsitename.com/blogweb/
baseURL: http://mywebsitename.com/blogweb/

It should be:

serendipityPath: /public_html/blogweb/
serendipityHTTPPath: /blogweb/
baseURL: http://mywebsitename.com/blogweb/

(note the proper HTTPPath).

About phpBB: This installation here is completely phpBB powered with a custom template. No serendipity is used here, blog.s9y.org is a standalone s9y-installation, and www.s9y.org a standalone cowiki installation. They simple share the same HTML and CSS.

Regards,
Garvin

tfmy2k · Post by **tfmy2k** » Thu Dec 11, 2008 8:06 pm

Many thanks for your response: Sorry about posting the problem so many times. The problem still remains, i am a complete beginner and everything is greek to me.

xexanos · Post by **xexanos** » Thu Dec 11, 2008 10:08 pm

I have the same error as tfmy2k at the beginning:

Code: Select all

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'turboboost@1'@'localhost' (using password: YES) in /data/apache/users/kilu.de/turboboost/www/blog/include/db/mysql.inc.php on line 270

Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'www-data'@'localhost' (using password: NO) in /data/apache/users/kilu.de/turboboost/www/blog/include/db/mysql.inc.php on line 271

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /data/apache/users/kilu.de/turboboost/www/blog/include/db/mysql.inc.php on line 271

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /data/apache/users/kilu.de/turboboost/www/blog/include/db/mysql.inc.php on line 281

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /data/apache/users/kilu.de/turboboost/www/blog/include/db/mysql.inc.php on line 281
serendipity error: unable to connect to database - exiting.

I have looked through my serendipity_config_local.inc.php and everything's correct there:

Code: Select all

<?php
	/*
	  Serendipity configuration file
	  Written on Thu, 11 Dec 2008 21:52:25 +0100
	*/

	$serendipity['versionInstalled']  = '1.3.1';
	$serendipity['dbName']            = 'turboboost@1-blog';
	$serendipity['dbPrefix']          = 'serendipity_';
	$serendipity['dbHost']            = 'localhost';
	$serendipity['dbUser']            = 'turboboost@1';
	$serendipity['dbPass']            = '*****';
	$serendipity['dbType']            = 'mysql';
	$serendipity['dbPersistent']      = false;
	$serendipity['dbCharset']         = 'utf8';

	// End of Serendipity configuration file
	// You can place your own special variables after here:

?>

Does anyone know a solution for my problem?

PS: Checked on space etc. too. Nothing there.