editing/viewing articles produces error

Guest

Using PHP Nuke 6.0 with the fixes from their site. If I (as admin) attempt to edit an article, the article is not displayed for editing, instead I see the following error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/html/includes/sql_layer.php on line 301
Unknown column '6ec60304427035c83fbf86ae6fe1cebf' in 'where clause'
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/html/includes/sql_layer.php on line 301
You have an error in your SQL syntax near '' at line 1

If anyone tries to click Read More... or comments? for the article on the main page, then it just bounces back to the main page.

Any help would be greatly appreciated. I have tried totally reinstalling the site (files and databases) but the problem returned as soon as I posted the first article.

Thank you!

GnomeSkull
http://gnome.ath.cx

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Hi, can you enable debug mode for nuke and give us the sql statement where it bombs?

Guest

sorry, i did not even know about debug mode. i enabled it though, and just before the error message previously stated, there is this query:

SQL query: SELECT catid, title, hometext, bodytext, topic, notes, ihome, alanguage, acomm FROM nuke_stories where sid=6ec60304427035c83fbf86ae6fe1cebf

currently there is only one record in that table, with sid=1

hope this helps!

Thanks!
GnomeSkull

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Which fixes did you implement for nuke 6?

Posted: Thu Jan 30, 2003 12:43 pm

I would think that is likely irrelevant, since I was getting the same error before the fixes. But the fixes were from this page:

http://phpnuke.org/modules.php?name=Downloads&d_op=viewdownload&cid=9

Specifically the "PHP-Nuke 6.0 Fixes" and "Themes Fix".

Like I said, I had encountered the problem, and then wiped out the whole thing and started over. Then I got the error again, so I tried those fixes on the off chance it would help. Of course it did not.

Thank you for your efforts thus far. Let me know what else you need to know.

GnomeSkull
http://gnome.ath.cx

Posted: Thu Jan 30, 2003 1:16 pm

I can't find that string in my 6.0 News index.php, can you search for it in yours and post the section where it appears? If you find it post it starting one or two lines above and one or two below.

Seearch for SELECT catid, title, hometext, bodytext, topic, notes, ihome, alanguage, acomm

Guest

i looked in my main index.php, not found. But maybe i am looking in the wrong file. To be clear, this error occurs when I click "Edit" beside a story. Normally the article would be opened for editing, but this error is displayed and all the fields are empty. Can you tell me the path of the file I should be searching if not just index.php at the root of the site?

Thank you!

GnomeSkull
http://gnome.ath.cx

Posted: Thu Jan 30, 2003 1:36 pm

I meant the index.php of the News module but since you say it's part of the main page then what theme are you using?

Guest

I looked in /modules/News/index.php also, not found there either. I have tried switching themes, the error persists across the other few I tried. The default theme is Kaput, if that matters.

Thanks!

GnomeSkull
http://gnome.ath.cx

Guest

The URL of the edit page I am receiving the error on is http://gnome.ath.cx/admin.php?op=EditStory&sid=1 (clicked from http://gnome.ath.cx/admin.php).

Nuke Cadet Joined: Jan 30, 2003 Posts: 1 Location: Canada

OK... I don't know how or why, but after sitting on the page all day, I was poking around and suddenly realized the error was gone. Thank you for you responses, but the problem seems to have dissipated on its own. Any idea where it could have been coming from, let me know. Don't want it to happen again.

Thanks!

GnomeSkull
http://gnome.ath.cx (back in business!)