Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
corpse
Regular
Regular


Joined: Oct 15, 2007
Posts: 84
Location: U.S.A.

PostPosted: Sun Aug 31, 2008 10:21 am Reply with quote

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
 
View user's profile Send private message Send e-mail Visit poster's website
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Sun Aug 31, 2008 2:34 pm Reply with quote

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

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
corpse
PostPosted: Sun Aug 31, 2008 2:54 pm Reply with quote

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?
 
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9449
Location: Arizona

PostPosted: Mon Sep 01, 2008 12:53 pm Reply with quote

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.

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
corpse
PostPosted: Mon Sep 01, 2008 2:15 pm Reply with quote

PM sent, thanks for the reply.
 
montego
PostPosted: Mon Sep 01, 2008 2:53 pm Reply with quote

Ok, still doing it even with the latest RN file. Take a look at this thread:
Only registered users can see links on this board! Get registered or login!

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.
 
corpse
PostPosted: Mon Sep 01, 2008 3:15 pm Reply with quote

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.
 
fkelly
Former Moderator in Good Standing


Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Mon Sep 01, 2008 5:30 pm Reply with quote

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.
 
View user's profile Send private message Visit poster's website
corpse
PostPosted: Tue Sep 02, 2008 5:16 am Reply with quote

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.
 
montego
PostPosted: Tue Sep 02, 2008 5:45 am Reply with quote

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?
 
corpse
PostPosted: Tue Sep 02, 2008 6:40 am Reply with quote

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.
 
fkelly
PostPosted: Tue Sep 02, 2008 7:15 am Reply with quote

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.
 
corpse
PostPosted: Tue Sep 02, 2008 9:17 am Reply with quote

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.
 
fkelly
PostPosted: Tue Sep 02, 2008 9:36 am Reply with quote

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.
 
montego
PostPosted: Wed Sep 03, 2008 6:02 am Reply with quote

Good catch fkelly! I was wondering yesterday if maybe these tables needed a repair done. I would try that too using phpMyAdmin.
 
corpse
PostPosted: Wed Sep 03, 2008 6:04 am Reply with quote

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.
 
montego
PostPosted: Wed Sep 03, 2008 6:29 am Reply with quote

See my previous note. Please try and do a Repair on these two tables.
 
corpse
PostPosted: Wed Sep 03, 2008 7:08 am Reply with quote

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.
 
Gremmie
Former Moderator in Good Standing


Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Wed Sep 03, 2008 7:29 am Reply with quote

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?

_________________
Only registered users can see links on this board! Get registered or login! - An Event Calendar for PHP-Nuke
Only registered users can see links on this board! Get registered or login! - A Google Maps Nuke Module 
View user's profile Send private message
corpse
PostPosted: Wed Sep 03, 2008 5:34 pm Reply with quote

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.
 
Gremmie
PostPosted: Wed Sep 03, 2008 8:37 pm Reply with quote

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?
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©