About this Page
This is a discussion on Warning: main(db/mysql.php): failed to open stream: No such within the Open topics forums, part of the General category; Ok I really need some help here. It all started this morning. My webhost ( www.he.net ) upgraded my account ...

btrook · #1 (**permalink**) 07-08-2003, 11:20 PM

Ok I really need some help here. It all started this morning. My webhost (www.he.net) upgraded my account to mysql Ver 11.18 Distrib 3.23.53, for pc-linux-gnu (i686). Well ever since then, my website only shows the following:

Quote:

Warning: main(db/mysql.php): failed to open stream: No such file or directory in /home/trook/public_html/db/db.php on line 53

Warning: main(): Failed opening 'db/mysql.php' for inclusion (include_path='/usr/local/lib/php') in /home/trook/public_html/db/db.php on line 53

Fatal error: Cannot instantiate non-existent class: sql_db in /home/trook/public_html/db/db.php on line 86

Let's go back some. After they installed the new MySQL, they sent me the new password for my database. So I logged into telnet and changed it back to the old password. That's when I first saw these error messages instead of my website. So I emailed their tech support. Their tech guy said that based on the error I had the wrong password in my scripts. He suggested I change the password back to the one they gave me before and then change the passwords in my scripts. So I did. Therefore I had to edit config.php to reflect the new password. I don't think it's a password problem, but I do think it involves the config.php.

This is what my config looks like:

$dbhost = "localhost";
$dbuname = "trook";
$dbpass = "password";
$dbname = "trook";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "password";

The username and database have to be correct. I logged into the account via telnet and was able to do a show tables; on the trook database. Everything looked fine, and the files all had nuke_names. The password is set properly. The "localhost" thing I'm not too sure about. I did see that word though contained in an error message telnet gave me when I mistyped a command while viewing the database. I have no clue what the site key is, so I duped my password there (which isn't new, it was like that before when it was working on the older version of mysql).

So what I'd like to know is, does PHP Nuke 6.5 support this version of MySQL? Or is there another problem.

Oh by the way, I tried restoring an old database thinking maybe the format was correct / different but it wouldnt work since the tables were all the same.

EDIT: More info! The virtual webserver is using Linux Kernel 2.4, Apache 2, and Slackware 9 if this info helps.

EDIT #2: I also tried http://trook.com/nukesql.php but it doesn't work either. That file was supposed to make sure my database is set up properly but even it has the same error.

chatserv · #2 (**permalink**) 07-08-2003, 11:52 PM

Download the following test script, upload it to where config.php is and point your browser to it.

http://nukecops.com/downloads-file-6...tion_Test.html

btrook · #3 (**permalink**) 07-08-2003, 11:55 PM

Quote:

If everything looks good, but you still have problems, get the analyzer from NukeCops

Connection Test Script connected to your MySQL sever successfully!

Connection to your database "trook" was also successful.

There are 90 tables in your "trook" database
(by default, there are 89 fields in phpnuke 6.5 and 76 fields in phpnuke 6.0)

These are the admin names (aid) in your nuke_authors table: Ben Trook,

Now check this list of tables with your nuke.sql file:

Table: nuke_authors (22 fields)
Table: nuke_autonews (13 fields)
Table: nuke_banner (12 fields)
Table: nuke_bannerclient (7 fields)
Table: nuke_bbauth_access (14 fields)
Table: nuke_bbbanlist (4 fields)
Table: nuke_bbcategories (3 fields)
Table: nuke_bbconfig (2 fields)
Table: nuke_bbdisallow (2 fields)
Table: nuke_bbforum_prune (4 fields)
Table: nuke_bbforums (22 fields)
Table: nuke_bbgroups (6 fields)
Table: nuke_bbposts (13 fields)
Table: nuke_bbposts_text (4 fields)
Table: nuke_bbprivmsgs (11 fields)
Table: nuke_bbprivmsgs_text (3 fields)
Table: nuke_bbranks (6 fields)
Table: nuke_bbsearch_results (3 fields)
Table: nuke_bbsearch_wordlist (3 fields)
Table: nuke_bbsearch_wordmatch (3 fields)
Table: nuke_bbsessions (7 fields)
Table: nuke_bbsmilies (4 fields)
Table: nuke_bbthemes (43 fields)
Table: nuke_bbthemes_name (31 fields)
Table: nuke_bbtopics (13 fields)
Table: nuke_bbtopics_watch (3 fields)
Table: nuke_bbuser_group (3 fields)
Table: nuke_bbvote_desc (5 fields)
Table: nuke_bbvote_results (4 fields)
Table: nuke_bbvote_voters (3 fields)
Table: nuke_bbwords (3 fields)
Table: nuke_blocks (13 fields)
Table: nuke_comments (12 fields)
Table: nuke_config (55 fields)
Table: nuke_contactbook (15 fields)
Table: nuke_counter (3 fields)
Table: nuke_downloads_categories (4 fields)
Table: nuke_downloads_downloads (17 fields)
Table: nuke_downloads_editorials (5 fields)
Table: nuke_downloads_modrequest (14 fields)
Table: nuke_downloads_newdownload (12 fields)
Table: nuke_downloads_votedata (7 fields)
Table: nuke_encyclopedia (5 fields)
Table: nuke_encyclopedia_text (5 fields)
Table: nuke_ephem (6 fields)
Table: nuke_faqAnswer (4 fields)
Table: nuke_faqCategories (3 fields)
Table: nuke_headlines (3 fields)
Table: nuke_journal (10 fields)
Table: nuke_journal_comments (6 fields)
Table: nuke_journal_stats (6 fields)
Table: nuke_links_categories (4 fields)
Table: nuke_links_editorials (5 fields)
Table: nuke_links_links (14 fields)
Table: nuke_links_modrequest (9 fields)
Table: nuke_links_newlink (9 fields)
Table: nuke_links_votedata (7 fields)
Table: nuke_main (1 field)
Table: nuke_message (8 fields)
Table: nuke_modules (6 fields)
Table: nuke_optimize_gain (1 field)
Table: nuke_pages (12 fields)
Table: nuke_pages_categories (3 fields)
Table: nuke_poll_check (3 fields)
Table: nuke_poll_data (4 fields)
Table: nuke_poll_desc (6 fields)
Table: nuke_pollcomments (12 fields)
Table: nuke_popsettings (11 fields)
Table: nuke_priv_msgs (8 fields)
Table: nuke_public_messages (4 fields)
Table: nuke_queue (9 fields)
Table: nuke_quotes (2 fields)
Table: nuke_referer (2 fields)
Table: nuke_related (4 fields)
Table: nuke_reviews (12 fields)
Table: nuke_reviews_add (10 fields)
Table: nuke_reviews_comments (6 fields)
Table: nuke_reviews_main (2 fields)
Table: nuke_seccont (6 fields)
Table: nuke_sections (3 fields)
Table: nuke_session (4 fields)
Table: nuke_stats_date (4 fields)
Table: nuke_stats_hour (5 fields)
Table: nuke_stats_month (3 fields)
Table: nuke_stats_year (2 fields)
Table: nuke_stories (19 fields)
Table: nuke_stories_cat (3 fields)
Table: nuke_topics (5 fields)
Table: nuke_users (62 fields)
Table: nuke_users_temp (7 fields)

The link to the analyzer is broken.

chatserv · #4 (**permalink**) 07-09-2003, 01:17 AM

Using phpMyAdmin try loading the following table, see if it makes any difference, if it doesn't get analyzer directly from nukecops:

Code:

CREATE TABLE nuke_access (
  access_id int(10) NOT NULL auto_increment,
  access_title varchar(20) default NULL,
  PRIMARY KEY  (access_id),
  KEY access_id (access_id)
) TYPE=MyISAM;

INSERT INTO nuke_access VALUES (-1,'Deleted');
INSERT INTO nuke_access VALUES (1,'User');
INSERT INTO nuke_access VALUES (2,'Moderator');
INSERT INTO nuke_access VALUES (3,'Super Moderator');
INSERT INTO nuke_access VALUES (4,'Administrator');

btrook · #5 (**permalink**) 07-09-2003, 10:01 AM

I'm not sure how to load that table and nukecops doesnt have it anymore I tried searching it doesnt exist.

btrook · #6 (**permalink**) 07-09-2003, 10:13 AM

Ok I found the analyzer but it didnt help. It just said it found the database as well, and that my forum is out of date etc.

btrook · #7 (**permalink**) 07-09-2003, 10:33 AM

My webhost is the one who runs phpmyadmin on my server. I have no access to it, and I tried installing my own but it's too complicated for me.

I assume what you trying to determine is if i have premission to write to the database right?

chatserv · #8 (**permalink**) 07-09-2003, 11:25 AM

Usually a webhost provides phpMyAdmin through a CP, else you can install one yourself, anyway to load the table copy the following into a file, name it something like newtable.php, upload it to where config.php is and point your browser to it.

Code:

<?php

include("mainfile.php");

$db->sql_query("CREATE TABLE ".$prefix."_access (
  access_id int(10) NOT NULL auto_increment,
  access_title varchar(20) default NULL,
  PRIMARY KEY  (access_id),
  KEY access_id (access_id)
) TYPE=MyISAM");

$db->sql_query("INSERT INTO ".$prefix."_access VALUES (-1,'Deleted')");
$db->sql_query("INSERT INTO ".$prefix."_access VALUES (1,'User')");
$db->sql_query("INSERT INTO ".$prefix."_access VALUES (2,'Moderator')");
$db->sql_query("INSERT INTO ".$prefix."_access VALUES (3,'Super Moderator')");
$db->sql_query("INSERT INTO ".$prefix."_access VALUES (4,'Administrator')");

echo "Update finished!

"
    ."You should now delete this file from your server. Go to your <a href=\"index.php\">website</a>.";

?>

Even before trying to load that table try this:

In db/db.php, lines 42-48, is this code:

Code:

if ($forum_admin == 1) { 
    $the_include = "../../../db"; 
} elseif ($inside_mod == 1) { 
    $the_include = "../../db"; 
} else { 
    $the_include = "db"; 
}

chnage to:

Code:

if ($forum_admin == 1) { 
    $the_include = "../../../db"; 
} elseif ($inside_mod == 1) { 
    $the_include = "../../db"; 
} else { 
    $the_include = "/your_web_root/nuke/html/db"; 
}

change "/your_web_root/nuke/html/db" to the actual path for the directory. (workaround by Raven).

mikem · #9 (**permalink**) 07-09-2003, 11:42 AM

Isn't the _access table only needed if you use Splatt Forums?
:wink:

chatserv · #10 (**permalink**) 07-09-2003, 12:32 PM

Yes but Raven told me that while helping a few persons the site would not work until the table was added, oddly i don't have that table on my sites, i've seen weirder things though, the second workaround might do it anyway.

About this PageThis is a discussion on Warning: main(db/mysql.php): failed to open stream: No such within the Open topics forums, part of the General category; Ok I really need some help here. It all started this morning. My webhost ( www.he.net ) upgraded my account ...

Warning: main(db/mysql.php): failed to open stream: No such

About this Page
This is a discussion on Warning: main(db/mysql.php): failed to open stream: No such within the Open topics forums, part of the General category; Ok I really need some help here. It all started this morning. My webhost ( www.he.net ) upgraded my account ...