sql_layer problem

Posted: Mon Jun 21, 2004 12:13 pm

A couple of months ago I installed the "order articles" mod by Raven not noticing that it was for 6.5 only. I know, I know Embarassed

Since then the latest news has disappeared from my admin home page and also i just installed a "submit content" module which is giving an error.

The content is submitted fine but the submittal form shows this error

Code:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/storebu/public_html/includes/sql_layer.php on line 238

I've checked the offending line which is this (top line)

Code:

case "MySQL":


        $rows=mysql_num_rows($res);


        return $rows;


    break;;

I originally had nukecops bundle 6.5 installed and upgraded to 6.9 (which has given me a couple of other bugs that I would like to sort out Laughing

) but if anyone could throw some light on this one for me it would be much appreciated.

Thanks

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

Set $sql_debug=1; in sql_layer.php to find the table that has the problem. That will then isolate how we fix it.

Posted: Tue Jun 22, 2004 1:49 am

This keeps the same error and nothing changes for that module however I am now seeing this on the home page above the forums block:

Code:

SQL query: SELECT t.topic_id, f.forum_name, f.forum_id, t.topic_last_post_id, t.topic_title, t.topic_poster, t.topic_views, t.topic_replies, t.topic_moved_id FROM nuke_bbtopics t, nuke_bbforums f where t.forum_id=f.forum_id ORDER BY topic_last_post_id DESC


SQL query: SELECT auth_view, auth_read FROM nuke_bbforums where forum_id = '37'


SQL query: SELECT username, user_id FROM nuke_users where user_id='2'


SQL query: SELECT poster_id, FROM_UNIXTIME(post_time, '%m/%d/%Y at %H:%i') as post_time FROM nuke_bbposts where post_id='314'


SQL query: SELECT username, user_id FROM nuke_users where user_id='1'


SQL query: SELECT auth_view, auth_read FROM nuke_bbforums where forum_id = '31'


SQL query: SELECT username, user_id FROM nuke_users where user_id='84'


SQL query: SELECT poster_id, FROM_UNIXTIME(post_time, '%m/%d/%Y at %H:%i') as post_time FROM nuke_bbposts where post_id='313'


SQL query: SELECT username, user_id FROM nuke_users where user_id='1'


SQL query: SELECT auth_view, auth_read FROM nuke_bbforums where forum_id = '13'


SQL query: SELECT username, user_id FROM nuke_users where user_id='2'


SQL query: SELECT poster_id, FROM_UNIXTIME(post_time, '%m/%d/%Y at %H:%i') as post_time FROM nuke_bbposts where post_id='312'


SQL query: SELECT username, user_id FROM nuke_users where user_id='2'


SQL query: SELECT auth_view, auth_read FROM nuke_bbforums where forum_id = '34'


SQL query: SELECT username, user_id FROM nuke_users where user_id='2'


SQL query: SELECT poster_id, FROM_UNIXTIME(post_time, '%m/%d/%Y at %H:%i') as post_time FROM nuke_bbposts where post_id='310'


SQL query: SELECT username, user_id FROM nuke_users where user_id='2'


SQL query: SELECT auth_view, auth_read FROM nuke_bbforums where forum_id = '36'


SQL query: SELECT username, user_id FROM nuke_users where user_id='1'


SQL query: SELECT poster_id, FROM_UNIXTIME(post_time, '%m/%d/%Y at %H:%i') as post_time FROM nuke_bbposts where post_id='309'


SQL query: SELECT username, user_id FROM nuke_users where user_id='2'

In the downloads module I get this above the header

Code:

SQL query: SELECT ns_dl_show_num, ns_dl_show_full, ns_dl_show_sub_cats from nuke_ns_downloads

Followed by

Code:

SQL query: SELECT ns_download_image, ns_dl_feature, ns_dl_feature_info, ns_dl_feature_one_name, ns_dl_feature_one_link, ns_dl_feature_one_info, ns_dl_feature_two_name, ns_dl_feature_two_link, ns_dl_feature_two_info, ns_dl_feature_three_name, ns_dl_feature_three_link, ns_dl_feature_three_info, ns_dl_feature_four_name, ns_dl_feature_four_link, ns_dl_feature_four_info from nuke_ns_downloads

In the stories archive module under "please select the month you want to see"

Code:

SQL query: select time from nuke_stories order by time DESC

In the "most popular" under the polls section:

Code:

SQL query: SELECT pollID, pollTitle, timeStamp, voters FROM nuke_poll_desc order by voters DESC limit 0, 30


SQL query: SELECT optionCount FROM nuke_poll_data WHERE (pollID=4) AND (voteID=0)


SQL query: SELECT optionCount FROM nuke_poll_data WHERE (pollID=4) AND (voteID=1)

In the "contact" module

Code:

SQL query: SELECT ns_cp_show_info, ns_cp_address1, ns_cp_address2, ns_cp_address3, ns_cp_address4, ns_cp_phone1, ns_cp_phone1_name, ns_cp_phone2, ns_cp_phone2_name, ns_cp_phone3, ns_cp_phone3_name, ns_cp_phone4, ns_cp_phone4_name, ns_cp_email1, ns_cp_dept1, ns_cp_email2, ns_cp_dept2, ns_cp_email3, ns_cp_dept3, ns_cp_email4, ns_cp_dept4, ns_cp_email5, ns_cp_dept5, ns_cp_email6, ns_cp_dept6, ns_cp_email7, ns_cp_dept7, ns_cp_email8, ns_cp_dept8 from nuke_ns_contact_plus

In the search module below each drop down list

Code:

SQL query: select topicid, topictext from nuke_topics order by topictext

All over the "links" page

Code:

SQL query: select cid, title, cdescription from nuke_links_categories where parentid=0 order by title

All of the other modules "submit news", "link exchange", "your account" etc seem to be working fine.

Gee, a lot of errors!

Posted: Tue Jun 22, 2004 5:05 am

Those aren't errors. You only need to post the messages by the Warning message you first posted. What are those messages? That's where the error is. After you post those few messages you can turn the debug off.

Posted: Tue Jun 22, 2004 7:13 am

SQL query: select cid, title from nuke_pages_categories order by title

That's the one that appears before the sql error.

Posted: Tue Jun 22, 2004 7:19 am

Then either that table does not exist, it may be corrupted and needs a repair, or the table does not contain the columns the query is expecting. In phpMyAdmin, run this query in an SQL window

Code:

select cid, title from nuke_pages_categories order by title

If there is an error, phpMyAdmin will reveal it.

Posted: Tue Jun 22, 2004 7:44 am

There are three category Id's 2,3 and 6. - so it is not finding the column it expects to find?

Posted: Tue Jun 22, 2004 7:46 am

Please post a link to your site and have the $sql_debug set to 1 so I can see the error. Thanks.

Posted: Tue Jun 22, 2004 7:54 am

http://www.storebuilder.co.uk/modules.php?name=Submit_Content

Posted: Tue Jun 22, 2004 8:03 am

When you ran that query in phpMyAdmin, did it produce a warning or an error?

Posted: Tue Jun 22, 2004 8:09 am

No - a normal query.

Posted: Sat Jun 26, 2004 11:24 am

And I think your new header accurately reflects where open source is headed.

I'll quite happily pay to get this routine sorted.

Tony

Posted: Sat Jun 26, 2004 1:53 pm

Tony,

Pm me your
site url, adminid/password
ftp url, id, password
phpMyAdmin url, id, password

Posted: Sun Jun 27, 2004 4:30 am

I'm not having a pop - honestly.

if it wasn't for open source I wouldn't have been able to develop my site in the way I have. Period.

But there has to be a better way of getting support when something screws up.

In this case I am certain I have done the damage myself - because the latest news items do not display in the admin homepage.

I am planning to make a serious revenue out of my site and I think (I may be deluded) that it can gain traffic to compete with some of the biggest players in Internet marketing.

I have put roughly three or four months of development into this site and most of my time has been spent searching for add on's that will do what I want. I'm a non coder, although I know enough to be very dangerous. As I just proved.

What I think you should do is get together with chatserv and the other top php guys and build a commercial support option for nuke.

Now, before everyone shoots me down in flames.

I know that a lot of hackers lurk on these and other boards just waiting for their next victim to post up that they started developing a nuke site - it's the obvious place to look.

So you offer hosting with a preinstalled nuke package. Any add on's have to be on your "approved list". If people want to hack their code then you don't offer support.

Get a trouble ticket system and you are in business.

The problem with open source is that when the next owner of a site claims that it's too much hassle and money to run a "free" support site - they just close it down and everyone is stuffed.

It's crazy to have 100's of nuke sites offering downloads and support - it's so hard to find what you need.

And it's so hard to find what you need because very few nuke sites have had the foresight to make themselves search engine friendly. That's the biggest problem.

PHP - Portal is a great idea. But we both know that it's unlikely to happen any time soon because so much work is involved.

Take the latest version of nuke, tighten it up, provide a viable upgrade path, fix the silly spelling mistakes that occur in every version, and offer custom coding for those sites that go on to make money and can afford to pay.

Set up a vote on this site and mail your registered users asking them to participate - then you'll find out if it's viable.

BTW - mail all of my server details to a complete stranger I've never met, you gotta be kidding me Wink

Posted: Sun Jun 27, 2004 7:33 am

Storebuilder wrote:

BTW - mail all of my server details to a complete stranger I've never met, you gotta be kidding me

Sorry you feel this way. You ask for support and since you are not able to figure it out, there is no other way. I have had lterally hundreds of users send this information, so my reputation preceeds me. In any event, good luck.

Posted: Sun Jun 27, 2004 9:03 am

It was a joke. There was a wink at the end. You know I respect you and your work.