Edit Admins

Regular Joined: Oct 15, 2007 Posts: 87

Hi, I've been working on a friends site, trying to set it up for him. Everything went well and has been running great for the last 2 months with no problems. Well last week he asked me to make a buddy of his an admin and I set him up through sentinels and set him up in the "Edit Admins" button in the ACP.

All went well for a week and he had limited access in the ACP. Well he ended up having some comp problems and needed to wipe his HD. When he went to log in again, he had came back and I guess changed his User login which when he went to login the ACP, he got pass the sentinel and went to login with his new password, and it didn't work. So he tried his original password and didn't work. So he contacted the site owner and he tried getting in the "Edit Admins" section of his site and it came up with a blank white page. So he contacted me to take a look and I tried setting up the error reporting to see if there was any errors that were going on. The error reports show nothing wrong.

So I tried uploading all new clean fresh files and again, nothing. If anyone has any ideas on what might be the problem would be good. I have exhausted all idea's that I can come up with.

I did do a search on these forums to see if it was a known problem or if there were issues like this in the past, but I didn't see anything.

Side note: The site owner and I can still login with no problems. That also seems to be the only blank page issue we have. He is also running RN V2.20.01. And the issue page is /admin.php?op=mod_authors

registered · Posted: Sun Aug 31, 2008 2:34 pm

It's possible he isn't allowed to use Edit Admins unless he is the God admin

Posted: Sun Aug 31, 2008 2:54 pm

I have been in the GOD admin. Nobody can add or remove admins. Its just a blank white page as if it doesn't exist.

Since all the file are clean fresh file, I am wondering, could it be something in the DB?

registered · Posted: Mon Sep 01, 2008 12:53 pm

corpse, PM me your email address or send me an email at montego { AT } montegoscripts &DOT& come and I'll send you our latest (in QA testing ) version of the authors.php script. I just want to see if we had fixed this or not. Thx.

Posted: Mon Sep 01, 2008 2:15 pm

PM sent, thanks for the reply.

Posted: Mon Sep 01, 2008 2:53 pm

Ok, still doing it even with the latest RN file. Take a look at this thread:

http://www.ravenphpscripts.com/postx16288-0-0.html

Try uploading with binary instead of ascii if your target server is linux.

There just shouldn't be any reason for this to not work.

Posted: Mon Sep 01, 2008 3:15 pm

Just did it. I also uploaded all I just tried uploading in binary, ascii, upload all the admin files again, and nothing. this is really puzzling.

Posted: Mon Sep 01, 2008 5:30 pm

Try the database logging that is set up in rnconfig. With a white screen it sure sounds to me like you are getting a db error in the background.

Posted: Tue Sep 02, 2008 5:16 am

This is what I am getting in the dblog file.

Code:







*** YES, THIS IS A BLANK FILE - MAKE SURE PERMISSIONS ARE 666 SO IT CAN BE WRITTEN TO ***








September 2, 2008, 5:02 am SQL was: SELECT Default_Theme FROM nuke_config WHERE 1;


querycount = 1





September 2, 2008, 5:02 am SQL was: SELECT id FROM nuke_banned_ip WHERE ip_address='60.188.160.222'


querycount = 2





September 2, 2008, 5:02 am SQL was: SELECT ip_address FROM nuke_banned_ip WHERE ip_address='60.188.160.*'


querycount = 3





September 2, 2008, 5:02 am SQL was: SELECT * FROM nuke_mail_config


querycount = 4





September 2, 2008, 5:02 am SQL was: SELECT * FROM `nuke_config`


querycount = 5





September 2, 2008, 5:02 am SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnst_config`


querycount = 6





September 2, 2008, 5:02 am SQL was: SELECT * FROM `nuke_nsnst_ip2country` WHERE (`ip_lo`<='1186767070' AND `ip_hi`>='1186767070') AND `c2c`='01'


querycount = 7





September 2, 2008, 5:02 am SQL was: SELECT user_password FROM nuke_users WHERE username='ME'


querycount = 8





September 2, 2008, 5:02 am SQL was: SELECT * FROM nuke_users WHERE username='ME' AND user_password='***Altered***'


querycount = 9





September 2, 2008, 5:02 am SQL was: SELECT * FROM `nuke_nsnst_blockers` ORDER BY `blocker`


querycount = 10





September 2, 2008, 5:02 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ips` WHERE `ip_addr` = '60.*.*.*' OR `ip_addr` = '60.188.*.*' OR `ip_addr` = '60.188.160.*' OR `ip_addr` = '60.188.160.222'


querycount = 11





September 2, 2008, 5:02 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ranges` WHERE `ip_lo`<='1186767070' AND `ip_hi`>='1186767070'


querycount = 12





September 2, 2008, 5:02 am SQL was: SELECT * FROM `nuke_authors` WHERE `aid`='ME'


querycount = 13





September 2, 2008, 5:02 am SQL was: SELECT * FROM `nuke_nsnst_protected_ranges` WHERE `ip_lo`<='1186767070' AND `ip_hi`>='1186767070'


querycount = 14





September 2, 2008, 5:02 am SQL was: DELETE FROM `nuke_session` WHERE `host_addr`='none' OR `host_addr`='none' OR `host_addr`='60.188.160.222'


querycount = 15





September 2, 2008, 5:02 am SQL was: DELETE FROM `nuke_bbsessions` WHERE `session_ip`='00000000' OR `session_ip`='00000000' OR `session_ip`='46bca0de'


querycount = 16





September 2, 2008, 5:02 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ips` WHERE `ip_addr`='60.*.*.*'


querycount = 17





September 2, 2008, 5:02 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ips` WHERE `ip_addr`='60.188.*.*'


querycount = 18





September 2, 2008, 5:02 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ips` WHERE `ip_addr`='60.188.160.*'


querycount = 19

I did edit it to remove the Username, real IP, and password that I am using. Other then that, I didnt touch anything.

Posted: Tue Sep 02, 2008 5:45 am

Well, within my 2.20.01 system, the query count is between 70 - 80 queries. What is odd, in my test system, the very next set of queries after the last bit of session handling, drops into the checks for banners. I am pretty sure this is in my themeheader. Therefore, I suspect that you might not even be getting through all of mainfile.php.

You may want to try re-uploading, in a similar fashion, both admin.php and mainfile.php. Had you modified any of these two files at all?

Posted: Tue Sep 02, 2008 6:40 am

Yes, when it first started, I re-uploaded fresh files of RN and that didn't work. As for modifying them, no, I just used stock files on his site.

Well I uploaded fresh files of what you suggested in Binary, and still not working.

Posted: Tue Sep 02, 2008 7:15 am

As M. said, something is stopping you short. If your php programs are all in synch with the distribution then the main thing remaining is your table structures. Problem is, if you have a table structure issue then you should be seeing a SQL error of some sort in the dblog.

Reading back to the start of the thread, I think we need to confirm some things. The only error you are seeing is when you try to get into the edit admins screen? If you load a home page instead it completes? If that's so you should, as M. said, be seeing a lot more queries in your dblog. You could try setting db error reporting to errors only in rnconfig as that will keep the superfluous stuff out. Turn it on on a separate screen right before you try to get into edit admins on a second screen. Then see if anything shows in dblog.

Posted: Tue Sep 02, 2008 9:17 am

fkelly wrote:

As M. said, something is stopping you short. If your php programs are all in synch with the distribution then the main thing remaining is your table structures. Problem is, if you have a table structure issue then you should be seeing a SQL error of some sort in the dblog.

Reading back to the start of the thread, I think we need to confirm some things. The only error you are seeing is when you try to get into the edit admins screen? If you load a home page instead it completes? If that's so you should, as M. said, be seeing a lot more queries in your dblog. You could try setting db error reporting to errors only in rnconfig as that will keep the superfluous stuff out. Turn it on on a separate screen right before you try to get into edit admins on a second screen. Then see if anything shows in dblog.

Okay, I reset the rnconfig to errors only, also cleaned out the dblog so it was fresh. I loaded up the main page, (index page). Thats where I started the logging. I clicked the button to go into the ACP, and then I clicked the edit admins. Then I left it on that page and went back into the FTP and pulled the dblog.

This is what I got out of it.

Code:




*** YES, THIS IS A BLANK FILE - MAKE SURE PERMISSIONS ARE 666 SO IT CAN BE WRITTEN TO ***


September 2, 2008, 9:04 am SQL was: SELECT Default_Theme FROM nuke_config WHERE 1;


querycount = 1





September 2, 2008, 9:04 am SQL was: SELECT id FROM nuke_banned_ip WHERE ip_address='60.188.160.222'


querycount = 2





September 2, 2008, 9:04 am SQL was: SELECT ip_address FROM nuke_banned_ip WHERE ip_address='60.188.160.*'


querycount = 3





September 2, 2008, 9:04 am SQL was: SELECT * FROM nuke_mail_config


querycount = 4





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_config`


querycount = 5





September 2, 2008, 9:04 am SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnst_config`


querycount = 6





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_ip2country` WHERE (`ip_lo`<='1186767070' AND `ip_hi`>='1186767070') AND `c2c`='01'


querycount = 7





September 2, 2008, 9:04 am SQL was: SELECT user_password FROM nuke_users WHERE username='**EDITED**'


querycount = 8





September 2, 2008, 9:04 am SQL was: SELECT * FROM nuke_users WHERE username='**EDITED**' AND user_password='**EDITED**'


querycount = 9





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_blockers` ORDER BY `blocker`


querycount = 10





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ips` WHERE `ip_addr` = '60.*.*.*' OR `ip_addr` = '60.188.*.*' OR `ip_addr` = '60.188.160.*' OR `ip_addr` = '60.188.160.222'


querycount = 11





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ranges` WHERE `ip_lo`<='1186767070' AND `ip_hi`>='1186767070'


querycount = 12





September 2, 2008, 9:04 am SQL was: SELECT pwd FROM nuke_authors WHERE aid='**EDITED**'


querycount = 13





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_excluded_ranges` WHERE `ip_lo`<='1186767070' AND `ip_hi`>='1186767070'


querycount = 14





September 2, 2008, 9:04 am SQL was: SELECT `c2c` FROM `nuke_nsnst_ip2country` WHERE `ip_lo`<='1186767070' AND `ip_hi`>='1186767070 LIMIT 0,1'


querycount = 15





September 2, 2008, 9:04 am SQL was: INSERT INTO `nuke_nsnst_tracked_ips` (`user_id`, `username`, `date`, `ip_addr`, `ip_long`, `page`, `user_agent`, `refered_from`, `x_forward_for`, `client_ip`, `remote_addr`, `remote_port`, `request_method`, `c2c`) VALUES ('3', '**EDITED**', '1220367878', '60.188.160.222', '1186767070', '/admin.php', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1', 'on site', 'none', 'none', '60.188.160.222', '3680', 'GET', 'us')


querycount = 16





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_config`


querycount = 17





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsngr_users` WHERE (`edate`<'1220367878' AND `edate`!=0) AND `trial`=0


querycount = 18





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsngr_users` WHERE (`edate`<'1220972678' AND `edate`!=0) AND `notice`=0


querycount = 19





September 2, 2008, 9:04 am SQL was: SELECT * FROM nuke_config


querycount = 20





September 2, 2008, 9:04 am SQL was: SELECT user_password FROM nuke_users WHERE user_id='3'


querycount = 21





September 2, 2008, 9:04 am SQL was: SELECT * FROM nuke_authors


querycount = 22





September 2, 2008, 9:04 am SQL was: SELECT name, pwd FROM nuke_authors WHERE aid='**EDITED**'


querycount = 23





September 2, 2008, 9:04 am SQL was: SELECT whoiswhere FROM nuke_urinfo_conf


querycount = 24





September 2, 2008, 9:04 am SQL was: DELETE FROM nuke_session WHERE time < '1220366978'


querycount = 25





September 2, 2008, 9:04 am SQL was: SELECT time FROM nuke_session WHERE uname='**EDITED**'


querycount = 26





September 2, 2008, 9:04 am SQL was: UPDATE nuke_session SET uname='**EDITED**', time='1220367878', host_addr='60.188.160.222', guest='0' WHERE uname='**EDITED**'


querycount = 27





September 2, 2008, 9:04 am SQL was: DELETE FROM nuke_urinfo_where WHERE time < '1220366978'


querycount = 28





September 2, 2008, 9:04 am SQL was: SELECT time FROM nuke_urinfo_where WHERE username = '**EDITED**'


querycount = 29





September 2, 2008, 9:04 am SQL was: SELECT * FROM nuke_modules WHERE title = ''


querycount = 30





September 2, 2008, 9:04 am SQL was: UPDATE nuke_urinfo_where SET username = '**EDITED**', time = '1220367878', module = '' WHERE username = '**EDITED**'


querycount = 31





September 2, 2008, 9:04 am SQL was: DELETE FROM nuke_session WHERE time < '1220364278'


querycount = 32





September 2, 2008, 9:04 am SQL was: SELECT time FROM nuke_session WHERE uname='**EDITED**'


querycount = 33





September 2, 2008, 9:04 am SQL was: UPDATE nuke_session SET uname='**EDITED**', time='1220367878', host_addr='60.188.160.222', guest='0' WHERE uname='**EDITED**'


querycount = 34





September 2, 2008, 9:04 am SQL was: SELECT * FROM nuke_blocks WHERE bposition='l' AND active=1 ORDER BY weight ASC


querycount = 35





September 2, 2008, 9:04 am SQL was: SELECT t1.invisible, t2.main_module FROM nuke_sommaire AS t1, nuke_main AS t2 limit 1


querycount = 36





September 2, 2008, 9:04 am SQL was: SELECT user_password FROM nuke_users WHERE user_id='3'


querycount = 37





September 2, 2008, 9:04 am SQL was: SELECT COUNT(*) FROM nuke_bbprivmsgs WHERE privmsgs_to_userid='3' AND (privmsgs_type='5' OR privmsgs_type='1')


querycount = 38





September 2, 2008, 9:04 am SQL was: SELECT title, custom_title, view, active FROM nuke_modules WHERE active='1' AND inmenu='1' ORDER BY custom_title ASC


querycount = 39





September 2, 2008, 9:04 am SQL was: SELECT groupmenu, module, url, url_text, image, new, new_days, class, bold FROM nuke_sommaire_categories ORDER BY id ASC


querycount = 40





September 2, 2008, 9:04 am SQL was: SELECT groupmenu, name, image, lien, hr, center, bgcolor, invisible, class, bold, new, listbox, dynamic FROM nuke_sommaire ORDER BY groupmenu ASC


querycount = 41





September 2, 2008, 9:04 am SQL was: SELECT title, custom_title FROM nuke_modules WHERE active='1' AND inmenu='0' ORDER BY title ASC


querycount = 42





September 2, 2008, 9:04 am SQL was: SELECT title, custom_title FROM nuke_modules WHERE active='0' ORDER BY title ASC


querycount = 43





September 2, 2008, 9:04 am SQL was: SELECT tooltip FROM nuke_urinfo_conf


querycount = 44





September 2, 2008, 9:04 am SQL was: SELECT user_id FROM nuke_users WHERE user_id > 1


querycount = 45





September 2, 2008, 9:04 am SQL was: SELECT user_id FROM nuke_users_temp


querycount = 46





September 2, 2008, 9:04 am SQL was: SELECT anonview FROM nuke_urinfo_conf


querycount = 47





September 2, 2008, 9:04 am SQL was: SELECT usersorder FROM nuke_urinfo_conf


querycount = 48





September 2, 2008, 9:04 am SQL was: SELECT uname, guest, host_addr FROM nuke_session WHERE guest = '0' ORDER BY time DESC


querycount = 49





September 2, 2008, 9:04 am SQL was: SELECT aid FROM nuke_authors WHERE aid = '**EDITED**' AND name IS NOT 'God' AND radminsuper = '1'


querycount = 50





September 2, 2008, 9:04 am 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''God' AND radminsuper = '1'' at line 1


SQL was: SELECT aid FROM nuke_authors WHERE aid = '**EDITED**' AND name IS NOT 'God' AND radminsuper = '1'


 remote addr: 60.188.160.222


September 2, 2008, 9:04 am SQL was: SELECT pic, king FROM nuke_urinfo WHERE view = '**EDITED**'


querycount = 51





September 2, 2008, 9:04 am SQL was: SELECT whoiswhere FROM nuke_urinfo_conf


querycount = 52





September 2, 2008, 9:04 am SQL was: SELECT module FROM nuke_urinfo_where WHERE username = '**EDITED**'


querycount = 53





September 2, 2008, 9:04 am SQL was: SELECT tooltip FROM nuke_urinfo_conf


querycount = 54





September 2, 2008, 9:04 am SQL was: SELECT tooltip FROM nuke_urinfo_conf


querycount = 55





September 2, 2008, 9:04 am SQL was: SELECT COUNT(user_id) AS userCount FROM nuke_users WHERE user_regdate LIKE '%Sep%02%2008%'


querycount = 56





September 2, 2008, 9:04 am SQL was: SELECT COUNT(user_id) AS userCount FROM nuke_users WHERE user_regdate LIKE '%Sep%01%2008%'


querycount = 57





September 2, 2008, 9:04 am SQL was: SELECT uname FROM nuke_session WHERE guest = '1'


querycount = 58





September 2, 2008, 9:04 am SQL was: SELECT uname FROM nuke_session WHERE guest = '0'


querycount = 59





September 2, 2008, 9:04 am SQL was: SELECT dispavatar, avatarmaxsize FROM nuke_urinfo_conf


querycount = 60





September 2, 2008, 9:04 am SQL was: SELECT user_id, user_avatar, user_avatar_type FROM nuke_users WHERE username = '**EDITED**'


querycount = 61





September 2, 2008, 9:04 am SQL was: SELECT config_value FROM nuke_bbconfig WHERE config_name = 'avatar_path'


querycount = 62





September 2, 2008, 9:04 am SQL was: SELECT config_value FROM nuke_bbconfig WHERE config_name = 'avatar_gallery_path'


querycount = 63





September 2, 2008, 9:04 am SQL was: SELECT config_value FROM nuke_bbconfig WHERE config_name = 'allow_avatar_upload'


querycount = 64





September 2, 2008, 9:04 am SQL was: SELECT config_value FROM nuke_bbconfig WHERE config_name = 'allow_avatar_remote'


querycount = 65





September 2, 2008, 9:04 am SQL was: SELECT config_value FROM nuke_bbconfig WHERE config_name = 'allow_avatar_local'


querycount = 66





September 2, 2008, 9:04 am SQL was: SELECT privmsgs_to_userid FROM nuke_bbprivmsgs WHERE privmsgs_to_userid = '3' AND (privmsgs_type = '5' OR privmsgs_type = '1')


querycount = 67





September 2, 2008, 9:04 am SQL was: SELECT privmsgs_to_userid FROM nuke_bbprivmsgs WHERE privmsgs_to_userid = '3' AND privmsgs_type = '0'


querycount = 68





September 2, 2008, 9:04 am SQL was: SELECT lastusers FROM nuke_urinfo_conf


querycount = 69





September 2, 2008, 9:04 am SQL was: SELECT username, user_regdate FROM nuke_users ORDER BY user_id DESC LIMIT 0, 5


querycount = 70





September 2, 2008, 9:04 am SQL was: SELECT tooltip FROM nuke_urinfo_conf


querycount = 71





September 2, 2008, 9:04 am SQL was: SELECT tooltip FROM nuke_urinfo_conf


querycount = 72





September 2, 2008, 9:04 am SQL was: SELECT tooltip FROM nuke_urinfo_conf


querycount = 73





September 2, 2008, 9:04 am SQL was: SELECT tooltip FROM nuke_urinfo_conf


querycount = 74





September 2, 2008, 9:04 am SQL was: SELECT tooltip FROM nuke_urinfo_conf


querycount = 75





September 2, 2008, 9:04 am SQL was: SELECT gender FROM nuke_urinfo_conf


querycount = 76





September 2, 2008, 9:04 am SQL was: SELECT alt, vel FROM nuke_urinfo_conf


querycount = 77





September 2, 2008, 9:04 am SQL was: SELECT displaymode, maxifauto FROM nuke_urinfo_conf


querycount = 78





September 2, 2008, 9:04 am SQL was: SELECT count FROM nuke_counter WHERE type = 'total' AND var = 'hits'


querycount = 79





September 2, 2008, 9:04 am SQL was: SELECT tooltip FROM nuke_urinfo_conf


querycount = 80





September 2, 2008, 9:04 am SQL was: SELECT bposition FROM nuke_blocks WHERE blockfile = 'block-UR_Info.php'


querycount = 81





September 2, 2008, 9:04 am SQL was: SELECT tooltip FROM nuke_urinfo_conf


querycount = 82





September 2, 2008, 9:04 am SQL was: SELECT * FROM nuke_users WHERE username='**EDITED**' AND user_password='**EDITED**'


querycount = 83





September 2, 2008, 9:04 am SQL was: SELECT topicid FROM nuke_topics


querycount = 84





September 2, 2008, 9:04 am SQL was: SELECT topicimage, topictext FROM nuke_topics WHERE topicid='1'


querycount = 85





September 2, 2008, 9:04 am SQL was: SELECT sid, title FROM nuke_stories WHERE topic='1' ORDER BY sid DESC LIMIT 0,9


querycount = 86





September 2, 2008, 9:04 am SQL was: UPDATE nuke_counter SET count=count+1 WHERE (type='total' AND var='hits') OR (var='FireFox' AND type='browser') OR (var='Windows' AND type='os')


querycount = 87





September 2, 2008, 9:04 am SQL was: SELECT * FROM nuke_groups


querycount = 88





September 2, 2008, 9:04 am SQL was: SELECT year FROM nuke_stats_year WHERE year='2008'


querycount = 89





September 2, 2008, 9:04 am SQL was: SELECT hour FROM nuke_stats_hour WHERE (year='2008') AND (month='09') AND (date='02')


querycount = 90





September 2, 2008, 9:04 am SQL was: UPDATE nuke_stats_year SET hits=hits+1 WHERE year='2008'


querycount = 91





September 2, 2008, 9:04 am SQL was: UPDATE nuke_stats_month SET hits=hits+1 WHERE (year='2008') AND (month='09')


querycount = 92





September 2, 2008, 9:04 am SQL was: UPDATE nuke_stats_date SET hits=hits+1 WHERE (year='2008') AND (month='09') AND (date='02')


querycount = 93





September 2, 2008, 9:04 am SQL was: UPDATE nuke_stats_hour SET hits=hits+1 WHERE (year='2008') AND (month='09') AND (date='02') AND (hour='09')


querycount = 94





September 2, 2008, 9:04 am SQL was: SELECT user_regdate, COUNT(user_regdate) FROM nuke_users where user_regdate IN('Sep 02, 2008', 'Sep 01, 2008') GROUP BY user_regdate LIMIT 0,2


querycount = 95





September 2, 2008, 9:04 am SQL was: SELECT qid FROM nuke_queue


querycount = 96





September 2, 2008, 9:04 am SQL was: SELECT radminsuper FROM nuke_authors WHERE aid='**EDITED**'


querycount = 97





September 2, 2008, 9:04 am SQL was: SELECT title, admins FROM nuke_modules ORDER BY title ASC


querycount = 98





September 2, 2008, 9:04 am SQL was: SELECT name FROM nuke_authors WHERE aid='**EDITED**'


querycount = 99





September 2, 2008, 9:04 am SQL was: SELECT radminsuper, admlanguage FROM nuke_authors WHERE aid='**EDITED**'


querycount = 100





September 2, 2008, 9:04 am SQL was: SELECT admins FROM nuke_modules WHERE title='News'


querycount = 101





September 2, 2008, 9:04 am SQL was: SELECT name FROM nuke_authors WHERE aid='**EDITED**'


querycount = 102





September 2, 2008, 9:04 am SQL was: SELECT main_module from nuke_main


querycount = 103





September 2, 2008, 9:04 am SQL was: SELECT uname FROM nuke_session WHERE guest=1


querycount = 104





September 2, 2008, 9:04 am SQL was: SELECT uname FROM nuke_session WHERE guest=0


querycount = 105





September 2, 2008, 9:04 am SQL was: SELECT title FROM nuke_modules WHERE active='1'


querycount = 106





September 2, 2008, 9:04 am SQL was: SELECT anid, aid, title, time, alanguage FROM nuke_autonews ORDER BY time ASC


querycount = 107





September 2, 2008, 9:04 am SQL was: SELECT sid, aid, title, time, topic, informant, alanguage, topicname FROM nuke_stories left join nuke_topics ON topicid=topic ORDER BY time DESC LIMIT 0,20


querycount = 108





September 2, 2008, 9:04 am SQL was: SELECT pollID, pollTitle FROM nuke_poll_desc WHERE artid=0 ORDER BY pollID DESC LIMIT 1


querycount = 109





September 2, 2008, 9:04 am SQL was: SELECT lid, title FROM nuke_downloads_downloads ORDER BY hits DESC LIMIT 0,10


querycount = 110





September 2, 2008, 9:04 am SQL was: SELECT * FROM nuke_banner WHERE type='0' AND active='1'


querycount = 111





September 2, 2008, 9:04 am 1054 : Unknown column 'type' in 'where clause'


SQL was: SELECT * FROM nuke_banner WHERE type='0' AND active='1'


 remote addr: 60.188.160.222


September 2, 2008, 9:04 am SQL was: SELECT bid, imageurl, clickurl, alttext FROM nuke_banner WHERE type='0' AND active='1' LIMIT 0,1


querycount = 112





September 2, 2008, 9:04 am 1054 : Unknown column 'type' in 'where clause'


SQL was: SELECT bid, imageurl, clickurl, alttext FROM nuke_banner WHERE type='0' AND active='1' LIMIT 0,1


 remote addr: 60.188.160.222


September 2, 2008, 9:04 am SQL was: UPDATE nuke_banner SET impmade=impmade+1 WHERE bid=''


querycount = 113





September 2, 2008, 9:04 am SQL was: SELECT Default_Theme FROM nuke_config WHERE 1;


querycount = 1





September 2, 2008, 9:04 am SQL was: SELECT id FROM nuke_banned_ip WHERE ip_address='60.188.160.222'


querycount = 2





September 2, 2008, 9:04 am SQL was: SELECT ip_address FROM nuke_banned_ip WHERE ip_address='60.188.160.*'


querycount = 3





September 2, 2008, 9:04 am SQL was: SELECT * FROM nuke_mail_config


querycount = 4





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_config`


querycount = 5





September 2, 2008, 9:04 am SQL was: SELECT `config_name`, `config_value` FROM `nuke_nsnst_config`


querycount = 6





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_ip2country` WHERE (`ip_lo`<='1186767070' AND `ip_hi`>='1186767070') AND `c2c`='01'


querycount = 7





September 2, 2008, 9:04 am SQL was: SELECT user_password FROM nuke_users WHERE username='**EDITED**'


querycount = 8





September 2, 2008, 9:04 am SQL was: SELECT * FROM nuke_users WHERE username='**EDITED**' AND user_password='**EDITED**'


querycount = 9





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_blockers` ORDER BY `blocker`


querycount = 10





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ips` WHERE `ip_addr` = '60.*.*.*' OR `ip_addr` = '60.188.*.*' OR `ip_addr` = '60.188.160.*' OR `ip_addr` = '60.188.160.222'


querycount = 11





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ranges` WHERE `ip_lo`<='1186767070' AND `ip_hi`>='1186767070'


querycount = 12





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_authors` WHERE `aid`='**EDITED**'


querycount = 13





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_protected_ranges` WHERE `ip_lo`<='1186767070' AND `ip_hi`>='1186767070'


querycount = 14





September 2, 2008, 9:04 am SQL was: DELETE FROM `nuke_session` WHERE `host_addr`='none' OR `host_addr`='none' OR `host_addr`='60.188.160.222'


querycount = 15





September 2, 2008, 9:04 am SQL was: DELETE FROM `nuke_bbsessions` WHERE `session_ip`='00000000' OR `session_ip`='00000000' OR `session_ip`='46bca0de'


querycount = 16





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ips` WHERE `ip_addr`='60.*.*.*'


querycount = 17





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ips` WHERE `ip_addr`='60.188.*.*'


querycount = 18





September 2, 2008, 9:04 am SQL was: SELECT * FROM `nuke_nsnst_blocked_ips` WHERE `ip_addr`='60.188.160.*'


querycount = 19

Everything else on the site works just fine. I haven't seen any other problems then this one that we are discussing. As for when this error started happening. I have no idea, it was fine that I know of just till a few days ago. I used it about a week ago and worked fine. Was able to add a new admin, but then that admin changed his password in the User options, that's when he noticed he couldn't log into admin and contacted the site owner and in turn he contacted me.

Other then what I have stated in this post and the others, there is nothing else I can say that might have caused these problems for I haven't been working on his site for a few months.

Posted: Tue Sep 02, 2008 9:36 am

First, if you set dblogging to 1 instead of 2 in rnconfig you should only get errors listed ... which saves us from having to pick a needle out a haystack.

Second you have two errors that I see:

Code:

September 2, 2008, 9:04 am 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''God' AND radminsuper = '1'' at line 1


SQL was: SELECT aid FROM nuke_authors WHERE aid = '**EDITED**' AND name IS NOT 'God' AND radminsuper = '1'

and,

Code:

September 2, 2008, 9:04 am 1054 : Unknown column 'type' in 'where clause'


SQL was: SELECT * FROM nuke_banner WHERE type='0' AND active='1'


 remote addr: 60.188.160.222


September 2, 2008, 9:04 am SQL was: SELECT bid, imageurl, clickurl, alttext FROM nuke_banner WHERE type='0' AND active='1' LIMIT 0,1

If you look in the INSTALLATION/sql directory of your distribution you will find the "official" definitions of the banners and authors table. I'd print those two out and go into PHPmyadmin and make sure that my tables matched exactly in structure. Alternatively you can run a tool like MYSQLdiff which is mentioned in many threads here. Or post the table definitions here I suppose. I believe the banners table was changed in a recent RN release and you may have missed the upgrade sql.

Posted: Wed Sep 03, 2008 6:02 am

Good catch fkelly! I was wondering yesterday if maybe these tables needed a repair done. I would try that too using phpMyAdmin.

Posted: Wed Sep 03, 2008 6:04 am

Sorry about that, that was my mistake.

I ended up comparing the database tables with the rn_core.sql files I found in the /INSTALLATION/sql/ folder.

Both look fine, You can even take a look, but every thing seems to be in order.

RN-Core:

Code:

CREATE TABLE $prefix.`_banner` (


`bid` int(11) NOT NULL auto_increment, 


`cid` int(11) NOT NULL default '0', 


`name` varchar(50) NOT NULL default '', 


`imptotal` int(11) NOT NULL default '0', 


`impmade` int(11) NOT NULL default '0', 


`clicks` int(11) NOT NULL default '0', 


`imageurl` varchar(100) NOT NULL default '', 


`clickurl` varchar(200) NOT NULL default '', 


`alttext` varchar(255) NOT NULL default '', 


`date` datetime default NULL, 


`dateend` datetime default NULL, 


`position` int(10) NOT NULL default '0', 


`active` tinyint(1) NOT NULL default '1', 


`ad_class` varchar(5) NOT NULL default '', 


`ad_code` text NOT NULL, 


`ad_width` int(4) default '0', 


`ad_height` int(4) default '0', 


PRIMARY KEY  (`bid`), 


KEY `bid` (`bid`), 


KEY `cid` (`cid`)) TYPE=MyISAM AUTO_INCREMENT=1 ;

Ours:

Code:

CREATE TABLE IF NOT EXISTS `nuke_banner` (


  `bid` int(11) NOT NULL auto_increment,


  `cid` int(11) NOT NULL default '0',


  `name` varchar(50) NOT NULL default '',


  `imptotal` int(11) NOT NULL default '0',


  `impmade` int(11) NOT NULL default '0',


  `clicks` int(11) NOT NULL default '0',


  `imageurl` varchar(100) NOT NULL default '',


  `clickurl` varchar(200) NOT NULL default '',


  `alttext` varchar(255) NOT NULL default '',


  `date` datetime default NULL,


  `dateend` datetime default NULL,


  `position` int(10) NOT NULL default '0',


  `active` tinyint(1) NOT NULL default '1',


  `ad_class` varchar(5) NOT NULL default '',


  `ad_code` text NOT NULL,


  `ad_width` int(4) default '0',


  `ad_height` int(4) default '0',


  PRIMARY KEY  (`bid`),


  KEY `bid` (`bid`),


  KEY `cid` (`cid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

That was the Banners there, this is the authors here.

RN-Core:

Code:

CREATE TABLE IF NOT EXISTS $prefix.`_authors` (


`aid` varchar(25) NOT NULL default '',


`name` varchar(50) default NULL, 


url` varchar(255) NOT NULL default '', 


`email` varchar(255) NOT NULL default '', 


`pwd` varchar(40) default NULL, `counter` 


int(11) NOT NULL default '0', 


`radminsuper` tinyint(1) NOT NULL default '1', 


`admlanguage` varchar(30) NOT NULL default '', 


PRIMARY KEY  (`aid`) ) TYPE=MyISAM;

Ours:

Code:

CREATE TABLE IF NOT EXISTS `nuke_authors` (


  `aid` varchar(25) NOT NULL default '',


  `name` varchar(50) default NULL,


  `url` varchar(255) NOT NULL default '',


  `email` varchar(255) NOT NULL default '',


  `pwd` varchar(40) default NULL,


  `counter` int(11) NOT NULL default '0',


  `radminsuper` tinyint(1) NOT NULL default '1',


  `admlanguage` varchar(30) NOT NULL default '',


  PRIMARY KEY  (`aid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;

So overall, I am not sure where those errors are coming from as everything seems fine. I didn't display the dumps for the nuke Authors for security reasons. I also had no dumps for the "Banners table". Wasn't sure if there should be any.

Posted: Wed Sep 03, 2008 6:29 am

See my previous note. Please try and do a Repair on these two tables.

Posted: Wed Sep 03, 2008 7:08 am

Tried MySQLDiff and have an error with that on the index page.

Quote:

The configured Path for Session files () is not writeable!

But you guys are saying that the table are wrong. I just dropped the tables and recreated them using the core files and dropped in the information I got from the nuke authors and still a no go.

registered · Posted: Wed Sep 03, 2008 7:29 am

Code:




SQL was: SELECT aid FROM nuke_authors WHERE aid = '**EDITED**' AND name IS NOT 'God' AND radminsuper = '1'

Is that right? Shouldn't it be "name != 'God'" ???? That isn't valid SQL. You can't say "IS NOT 'GOD'".

For this one:

Code:




September 2, 2008, 9:04 am 1054 : Unknown column 'type' in 'where clause' 


SQL was: SELECT * FROM nuke_banner WHERE type='0' AND active='1' 


 remote addr: 60.188.160.222 


September 2, 2008, 9:04 am SQL was: SELECT bid, imageurl, clickurl, alttext FROM nuke_banner WHERE type='0' AND active='1' LIMIT 0,1

Just like it says, there is no 'type' column in banners, at least going by what you posted. What file is generating those SQL statements?

Posted: Wed Sep 03, 2008 5:34 pm

Gremmie wrote:

Code:




SQL was: SELECT aid FROM nuke_authors WHERE aid = '**EDITED**' AND name IS NOT 'God' AND radminsuper = '1'

Is that right? Shouldn't it be "name != 'God'" ???? That isn't valid SQL. You can't say "IS NOT 'GOD'".

For this one:

Code:




September 2, 2008, 9:04 am 1054 : Unknown column 'type' in 'where clause' 


SQL was: SELECT * FROM nuke_banner WHERE type='0' AND active='1' 


 remote addr: 60.188.160.222 


September 2, 2008, 9:04 am SQL was: SELECT bid, imageurl, clickurl, alttext FROM nuke_banner WHERE type='0' AND active='1' LIMIT 0,1

Just like it says, there is no 'type' column in banners, at least going by what you posted. What file is generating those SQL statements?

I don't know what I did, but I got it working. I manually did the nuke tables for banners and for authors, and it worked. The SQL dropping was not doing it or doing something wrong.

As for why this happened, I don't know. For that banner error to come up, I went into the ACP to generate that error.

Posted: Wed Sep 03, 2008 8:37 pm

I don't get it. There is no type field in nuke_banners. You posted identical tables. What did you manually do exactly?

It looks like you are using old code or something. What theme are you using?