PDA

View Full Version : Dooh! I need a config.php copy.


ccunnin71
05-06-2004, 09:58 AM
Ok, I have a backup at home. Just trying to get some things fixed on the website and I blew away my copy of it here at work. I know it's not that large. What 8-10 lines? If someone could copy the format up. Just put ###### in the areas for your 'mysql.####.com:3306" and then ##### for logins and passwords. I would really appreciate it. Otherwise I can wait till I get off of work.

yeah my bad. :(

Don't think it matters but I use VB3.0.1 as my sec. database.

Thanks

Ziad
05-06-2004, 12:35 PM
<?php

$dbtype = 'mysql';

$servername = 'localhost';
$dbname = '####';
$dbusername = '####';
$dbpassword = '####';

define('SD_INSTALLED', true);

?>


Save as config.php and store it under the "includes" directory.

ccunnin71
05-06-2004, 01:14 PM
Thanks subduck, you so Rock on support. Sadly, I get the generic error; Database Error.


A Database error occured, you can try fixing this problem by pressing the Refresh (javascript:window.location=window.location;) button in your browser.

An Email regarding this problem has been sent to our Technical Staff.


This sad state of affairs came from a migration of my website from one MySql database to another. Had to do with some changes in my hosting service but I moved my VB3.0.1 from MySql_A to another MySql_B. Exported the tables successfully and reimported them to the new database. I got VB3 running great no changes (other then the ones one in forums/include/config.php (the database location, user name, passwords changed).
I did VB3 first as I wanted to be sure SubDreamer could get to a working database. Well I made the adj. to the SubDreamer config.php and I get that error.

A. Do any other files contain ref. to the database location besides config.php?

B. Could some SubDreamer tables be ref. the old database?

If adj. can be made to either of the above assumptions I can likely bring my home page back from the dead.

Another option is to reinstall. Will the install scripts overwrite my old settings? I hate to do this and loose a lot of customization.

Any idea's oh SubDreamer wizard :)

Ziad
05-06-2004, 01:33 PM
What is the error message that you are getting?

ccunnin71
05-06-2004, 01:44 PM
Sadly, with the changes that I made to the database plus DNS is has not updated correctly. I am not getting any of the systems error msgs e-mailed to me. Sorry, I realize that makes this difficult.

Ziad
05-06-2004, 01:45 PM
My first guess would be that Subdreamer is trying to integrate with your old vB3 settings. Try getting to the admin panel of Subdreamer and change the vB3 settings (or just turn the usersystem off for now) and see if that works.

ccunnin71
05-06-2004, 01:59 PM
I did some searches in my database and came up with a ref. to the old name. Changed it and SubDreamer came alive... sort of. I will wait it out on the DNS change over for some of this stuff to get working right. It's certainly better starting to come back. I'll wait it out subduck. Thank you for your input.

Ziad
05-06-2004, 02:06 PM
I should have mentioned that the table 'usersystems' might have some back ref. to old database names.

If your email is not working, you can view your error messages by opening up:
'subdreamer/includes/db/mysql.php'

add this:
echo $message;
after this:
echo '<b>Database Error.</b> <br />
<p>A Database error occured, you can try fixing this problem by pressing the <a href="javascript:window.location=window.location;">Refresh</a> button in your browser.</p>
<p>An Email regarding this problem has been sent to our Technical Staff.</p>';

(make sure to change it back once you get it working, or else your users will be able to view your error messages)