Using Sql Debug- Not sure how to fix problems

Nuke Soldier Joined: Aug 01, 2003 Posts: 10

Im getting lots of warnings and sql querys when i turned on my sql debug. But since i know nothing about mysql im not sure how to fix all these problems. I added the phpbb2 user menu block and i want to use it but ive got alot of warning errors with it.

Here are some of the sql warnings:

SQL query: DELETE FROM nuke_session WHERE time < 1059760480
SQL query: SELECT time FROM nuke_session WHERE username='172.XXX.XX.XXX'

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tnbreede/public_html/includes/sql_layer.php on line 346
SQL query: INSERT INTO nuke_session (username, time, host_addr, guest) VALUES ('172.XXX.XX.XXX', '1059761380', '172.XXX.XX.XXX', '1')
SQL query: select uname from nuke_users order by uid DESC limit 0, 1

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tnbreede/public_html/includes/sql_layer.php on line 286
SQL query: select uid from nuke_users

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tnbreede/public_html/includes/sql_layer.php on line 238
SQL query: SELECT username, guest FROM nuke_session where guest=0

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tnbreede/public_html/includes/sql_layer.php on line 238
SQL query: SELECT uid FROM nuke_users order by uid DESC limit 0, 1

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tnbreede/public_html/includes/sql_layer.php on line 286

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tnbreede/public_html/includes/sql_layer.php on line 346
SQL query: SELECT COUNT(UID) AS userCount from nuke_users WHERE user_regdate LIKE '%Aug%1%2003%'

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tnbreede/public_html/includes/sql_layer.php on line 286
SQL query: SELECT COUNT(UID) AS userCount from nuke_users WHERE user_regdate LIKE '%Jul%31%2003%'

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tnbreede/public_html/includes/sql_layer.php on line 286
SQL query: SELECT username FROM nuke_session where guest=1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tnbreede/public_html/includes/sql_layer.php on line 238
SQL query: SELECT username FROM nuke_session where guest=0

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

And at the very top of my page i have this showing:

SQL query: select radminsuper from nuke_authors where aid='SiteAdmin'

ANd in the admin section i have this showing up using the iptracker script:

SQL query: create table if not exists nuke_iptracking ( ipid int(10) NOT NULL auto_increment, date_time datetime NOT NULL, ip_address varchar(15) NOT NULL, hostname varchar(100) NOT NULL, page varchar(150) NOT NULL, PRIMARY KEY (ipid), KEY ipid (ipid) )
SQL query: create index i1iptracking on nuke_iptracking (ip_address, hostname)
SQL query: alter table nuke_iptracking add username varchar(25) after ipid
SQL query: insert into nuke_iptracking (username, date_time, ip_address, hostname, page) values('SiteAdmin', '2003-08-01 14:09:40', '172.XXX.XXX.XXX', 'CCCCCCC.ipt.aol.com', '/admin.php?op=BlocksAdmin')
SQL query: select count(*) from nuke_iptracking

ANd finally in my blocks administration i have this showing up:
SQL query: select bid, bkey, title, url, bposition, weight, active, blanguage, blockfile, view from nuke_blocks order by bposition, weight
SQL query: select bid from nuke_blocks where weight='0' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='2' AND bposition='l'

SQL query: select bid from nuke_blocks where weight='1' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='3' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='2' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='4' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='3' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='5' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='4' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='6' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='5' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='7' AND bposition='l'

SQL query: select bid from nuke_blocks where weight='6' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='8' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='7' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='9' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='8' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='10' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='0' AND bposition='r'
SQL query: select bid from nuke_blocks where weight='2' AND bposition='r'
SQL query: select bid from nuke_blocks where weight='1' AND bposition='r'
SQL query: select bid from nuke_blocks where weight='3' AND bposition='r'
SQL query: select bid from nuke_blocks where weight='2' AND bposition='r'
SQL query: select bid from nuke_blocks where weight='4' AND bposition='r'

SQL query: select bid from nuke_blocks where weight='3' AND bposition='r'
SQL query: select bid from nuke_blocks where weight='5' AND bposition='r'
SQL query: select bid from nuke_blocks where weight='4' AND bposition='r'
SQL query: select bid from nuke_blocks where weight='6' AND bposition='r'

SQL query: select bid from nuke_blocks where weight='5' AND bposition='r'
SQL query: select bid from nuke_blocks where weight='7' AND bposition='r'
SQL query: select bid from nuke_blocks where weight='6' AND bposition='r'
SQL query: select bid from nuke_blocks where weight='8' AND bposition='r'

Anyone know how to fix these problems? I also downloaded the script everything showed up fine there. Nothing missing. And i changed my show errors on the sql_layer page.

Thanks,

MK

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Those 'warnings' mean that the attempt to execute the sql query against a certain table (users) was unsuccessful. This can be for various reasons. You don't say what version of nuke you are running, but if you are running v6.5 or later, the script you are running is for pre v6.5 nuke. I know this because this statement SELECT COUNT(UID) will cause that error, since the column UID was changed to USER_ID in 6.5 and later. All of the other things you list are not errors but just successful query messages.

Nuke Soldier Joined: Aug 01, 2003 Posts: 10

I just downloaded this version a cpl days ago. Its the newest version of Php-Nuke. Not sure if the script is for it dont remember where i got it from.

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Well, as I said, the script is using pre v6.5 code. If you are using v6.5 tables it will not work. You will need to either modify it yourself or contact the author of the script as we do not support 3rd party scripts here, per se.