Member News Submission Error

Posted: Wed Jan 14, 2004 5:33 pm

When a member submits a news article everything seems to work.

However, when I go into admin mode to approve the submission I get the following message:

Quote:

Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/sitename.com/httpdocs/admin/modules/stories.php on line 1038

Now the article still gets published on the home page but the 'Waiting Contents Submission' count does not reset to 0.

I haven't been able to find any report of this error and I am wondering if anyone else has experienced it and has a solution.

Thanks,
Ron....

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Check on or about line 1182 of admin/modules/stories.php for this line of code

Code:

list($counter, $radminarticle, $radminsuper) = $db->sql_fetchrow($result);

It should be

Code:

list($counter, $radminarticle, $radminsuper) = $db->sql_fetchrow($result, $dbi);

Posted: Wed Jan 14, 2004 9:24 pm

Thank you, Raven, that fix allowed me to approve the test article and it reset 'Waiting Contents Submission' count to 0. Very Happy

Because it was just a test article I want to delete it and I am getting exactly the same message when I use the RemoveStory function in the Admin Panel Sad

Ron...

Posted: Wed Jan 14, 2004 9:30 pm

I redid your fix and now EVERYTHING is working. Smile

Thank you very, very much.

Ron...

Posted: Wed Jan 14, 2004 9:33 pm

Another satisfied customer - You're welcome!

Posted: Wed Jan 14, 2004 9:38 pm

I am sorry to be a pest, Raven, but I just went to do another test submission and I have exactly the same error as at the start of this thread.

Ahhhhh.......

Posted: Wed Jan 14, 2004 9:42 pm

Search for all occurrences of

Code:

$db->sql_fetchrow($result

in admin/modules.stories.php and replace with

Code:

$db->sql_fetchrow($result, $dbi);

Posted: Wed Jan 14, 2004 9:45 pm

This is my line 1038:

Quote:

$row = $db->$db->sql_fetchrow($db->sql_query("SELECT points FROM ".$prefix."_groups_points WHERE id='4'"));

Posted: Wed Jan 14, 2004 9:58 pm

Raven wrote:

Search for all occurrences of

Code:

$db->sql_fetchrow($result

in admin/modules.stories.php and replace with

Code:

$db->sql_fetchrow($result, $dbi);

I have done that and am still getting the error. There was 1 $resultm and a few $result2 . Should I have changed them as well?

Posted: Wed Jan 14, 2004 10:02 pm

Yes

Posted: Wed Jan 14, 2004 10:15 pm

I hate to say this but still the same problem.

I am downloading Nuke 7 again from here in case there was a glitch somewhere because I don't understand why I am getting this error. Surely I am not the only V7 using 'Submit News'?

I will let you know how I go.

Thanks for all your time and energy to this point.

Ron...

Posted: Wed Jan 14, 2004 11:20 pm

All fixed now, Raven.

The error was here:

admin/modules/stories.php line 1038: Code:
$row = $db->$db->sql_fetchrow($db->sql_query("SELECT points FROM ".$prefix."_groups_points WHERE id='4'"));

Changed to: Code:
$row = $db->sql_fetchrow($db->sql_query("SELECT points FROM ".$prefix."_groups_points WHERE id='4'"));

It was double layered (I thought I had downloaded V7 from here but it came from another site where SQL layering had been added).

Thank you once again for your time and help.