Cant post News

Posted: Mon Mar 05, 2007 10:07 pm

New articles aren't stored in the database...

The error I get is:

Quote:

Warning: include(modules/Your_Account/includes/mainfileend.php) [function.include]: failed to open stream: No such file or directory in /<<details removed by admin>>/mainfile.php on line 1460

Warning: include() [function.include]: Failed opening 'modules/Your_Account/includes/mainfileend.php' for inclusion (include_path='.:/usr/local/lib/php') in /<<details removed by admin>>/mainfile.php on line 1460

URL: Only registered users can see links on this board! Get registered or login!
SQL: MySQL 4.1.13a
Nuke: phpNUKE 7.6.0.3.1
Sentinel: 2.5.06

Additional modules:
4nNewsletter
Sommaire 2.1.1

and please keep in mind that I am an ABSOLUTEUTTERLYNEWBIE

Wink

Posted: Tue Mar 06, 2007 12:17 am

Not saying it doesn't exist but I've never heard of mainfileend.php. Where are you getting this distribution? What program or programs are trying to include mainfileend? That would be a good place to start for both your postings.

registered · Posted: Tue Mar 06, 2007 5:41 am

brugopolis, this post and your other one both show this same issue. I have to echo fkelly's question about where did you get this distribution and add "have you made any edits to files"?

This is not normal behaviour so either your distribution is bad or an edit has been made somewhere incorrectly.

NOTE: Do NOT post your absolutely path in your posts. Please see what I have removed from both of your posts. You do not want this kind of details of your site out in the public domain.

Posted: Tue Mar 06, 2007 10:45 am

I have not made many edits (just the ones for the modules mentioned). The fact is that I never even had a mainfileend.php file to begin with...

I got the regular patched distribution on one of the "official" sites

Posted: Tue Mar 06, 2007 2:53 pm

Better remove the path to phpinfo its not required.

Posted: Tue Mar 06, 2007 3:19 pm

You are using CNB Your Account right ?

Because thats normally in the mainfile.php

A) Mainfile.php
Open mainfile.php in a text editor and goto the end of the file.
Just before the ?> add the following code:

if ($forum_admin == 1) {
include("../../../modules/Your_Account/includes/mainfileend.php");
} elseif ($inside_mod == 1) {
include("../../modules/Your_Account/includes/mainfileend.php");
} else {
include("modules/Your_Account/includes/mainfileend.php");
}

and the rest is in modules/includes/constants.php

However, before I upgraded to RavenNuke I had a 7.6. 3.2.b testsite with CNB Your Account and that worked well without any great problems.

Check the edits you made for CNB or remove it and check the behavior of new articles.

Posted: Tue Mar 06, 2007 4:01 pm

I did test CNBYA at some time yes, I removed the code from mainfile.php, the modules/includes/constants.php did not require any changes...

The problem remains, the error message is gone but I still can't post news or change the theme for the Your Account module...

Posted: Tue Mar 06, 2007 4:11 pm

Your PHP version is 5.1 maybe thats the reason for different issues but I´m not sure.

Posted: Tue Mar 06, 2007 4:20 pm

Two other sites on the same server work just fine... Can it be somewhere in the database... If I'm not mistaken it was set up for 7.8 (I "inherited" this site from a friend)

Posted: Wed Mar 07, 2007 9:33 am

Quote:

If I'm not mistaken it was set up for 7.8 (I "inherited" this site from a friend)

That is what I was afraid of. This was not originally a virgin nuke 7.6 database.

Here is what I suggest: install a brand new (fresh) PHP-Nuke 7.6 database and then use a tool such as mySQLDiff to compare the structure of your current database structure to this fresh dn. I suspect that give the issues you are having in this thread and your other one is due to the downgrading and/or migration / conversion over from 7.8 to 7.6. You need to figure out where the differences are.

Posted: Sun Mar 11, 2007 11:33 am

The problem is that my ISP doesn't allow tools like mySQLdiff to run (I get an error 500). Is there a way to compare sql dumps on my local machine?

Posted: Sun Mar 11, 2007 8:11 pm

Quote:

Is there a way to compare sql dumps on my local machine?

Absolutely. Get yourself a copy of XAMPP (google it) and install it on your PC. This will give you a complete operating Apache, mySQL and PHP environment to work on. I personally have about 15 sites running locally on my laptop in such an environment. I NEVER deploy any change to a production site without having fully tested it locally first.

By the way, I have never seen mySQLDiff not work, even on a shared server. I suspect something did not get FTP'd fully or maybe you made an edit somewhere?

Posted: Mon Mar 12, 2007 1:38 am

Quote:

By the way, I have never seen mySQLDiff not work, even on a shared server. I suspect something did not get FTP'd fully or maybe you made an edit somewhere?

Everything got FTP'ed allright, I got the 500 when I made the path writable... I'm with Only registered users can see links on this board! Get registered or login! 's Website Basis and they seem to be very restrictive when it comes to, among lots of others, .htaccess and what you can and can't do... I will be migrating my sites pretty soon because of those restrictions 'cause it sucks not to be able to do what you thought you'd payed for...

Posted: Mon Mar 12, 2007 2:11 am

OK... While I was downloading XAMPP I manually checked some tables and I found an extra fields in the stories table... deleted it and now the news is working as it should! Thanks for all the help guys!

Posted: Mon Mar 12, 2007 2:48 am

CNBYA changes the nuke_user table so I'm quessing something in there is now out of synch. You'll find it easily enough with mySQLdiff

Posted: Mon Mar 12, 2007 6:47 am

Glad you got this working locally. That is the BEST way to handle these things. Work out what is going to work right and THEN apply it on your production site.

:clap: