Joined: Jun 03, 2004 Posts: 177 Location: Tamworth, UK
Posted:
Tue Mar 02, 2010 2:23 pm
I've just configured and run the table_compare utility; details below:
Code:
The database you are using for comparison is: *****
You are comparing this data base against the structure of the database represented in fieldlist240.txt
Table '*.nuke_bbconfirm' doesn't exist SHOW COLUMNS FROM nuke_bbconfirm LIKE 'confirm_id'
Table '*.nuke_bbthemes_name' doesn't exist SHOW COLUMNS FROM nuke_bbthemes_name LIKE 'themes_id'
null status not match nuke_comments pid : Base NO Your table YES
null status not match nuke_comments sid : Base NO Your table YES
field keys do not match nuke_config sitename : Base PRI Your table
default values do not match nuke_config minpass : Base 8 Your table 5
field keys do not match nuke_counter type : Base PRI Your table
field keys do not match nuke_counter var : Base PRI Your table
Table '*.nuke_faqanswer' doesn't exist SHOW COLUMNS FROM nuke_faqanswer LIKE 'id'
Table '*.nuke_faqcategories' doesn't exist SHOW COLUMNS FROM nuke_faqcategories LIKE 'id_cat'
Table '*.nuke_groups' doesn't exist SHOW COLUMNS FROM nuke_groups LIKE 'id'
Table '*.nuke_groups_points' doesn't exist SHOW COLUMNS FROM nuke_groups_points LIKE 'id'
field keys do not match nuke_nsnst_ip2country date : Base NO Your table
field keys do not match nuke_nsnst_ip2country c2c : Base PRI Your table
field keys do not match nuke_nsnst_tracked_ips user_id : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips username : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips user_agent : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips refered_from : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips date : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips page : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips c2c : Base MUL Your table
null status not match nuke_pollcomments pid : Base NO Your table YES
null status not match nuke_pollcomments pollID : Base NO Your table YES
field keys do not match nuke_stats_date year : Base PRI Your table
field keys do not match nuke_stats_date month : Base PRI Your table
field keys do not match nuke_stats_date date : Base PRI Your table
field keys do not match nuke_stats_hour year : Base PRI Your table
field keys do not match nuke_stats_hour month : Base PRI Your table
field keys do not match nuke_stats_hour date : Base PRI Your table
field keys do not match nuke_stats_hour hour : Base PRI Your table
field keys do not match nuke_stats_month year : Base PRI Your table
field keys do not match nuke_stats_month month : Base PRI Your table
field keys do not match nuke_stats_year year : Base PRI Your table
Table '*.nuke_subscriptions' doesn't exist SHOW COLUMNS FROM nuke_subscriptions LIKE 'id'
field keys do not match nuke_users name : Base NO Your table
null status not match nuke_users ublock : Base YES Your table NO
default values do not match nuke_users user_notify : Base No Default Your table 1
default values do not match nuke_users user_notify_pm : Base No Default Your table 1
null status not match nuke_users_temp requestor : Base NO Your table YES
tables processed: 163
fields processed: 1133
fields not found on your system 0
tables not found in your system: 7
so I'm guessing I need to find the details where the tables are inserted into the Db and do it manually? (If I can)
Joined: Aug 28, 2003 Posts: 6302 Location: Vsetin, Czech Republic
Posted:
Tue Mar 02, 2010 4:07 pm
Sounds good.
I'm at a loss to explain why you even have these errors as the development team and the QA team have done numerous clean installs and upgrades so it really is most bizarre.
Joined: Aug 27, 2002 Posts: 16976 Location: Kansas
Posted:
Tue Mar 02, 2010 4:59 pm
From what I can tell by these error messages, such as The database you are using for comparison is: *****, something is either not named correctly or doesn't match your configuration. You have not set the 2 systems up correctly to run the scripts from all indications.
Joined: Jun 03, 2004 Posts: 177 Location: Tamworth, UK
Posted:
Tue Mar 02, 2010 5:01 pm
it's possibly because my site isn't necessarily a "clean" install/ upgrade. The site has been running since at least 2003 on one version of Nuke or other (thanks to Raven, Bob, Chat, NukeCops, Disipal and many, MANY others (mainly on here, plus the UK support site that existed)- so some of the "upgrades" may not have been so.. "thorough". I know I've only done a few major updates to the site over that period of time; upgrading to 7.6 was one of them. Chat's patch series were never that bad...
I can read php to a certain extent- can't write it though, lol.
So there's a lot of "garbage" on the site/ server. Hopefully this will clean a lot of it up....
I ran the rest of the scripts, no real drama (on the Db)- only thing I get now is this:
Code:
field keys do not match nuke_counter type : Base PRI Your table
field keys do not match nuke_counter var : Base PRI Your table
field keys do not match nuke_nsnst_ip2country date : Base NO Your table
field keys do not match nuke_nsnst_ip2country c2c : Base PRI Your table
field keys do not match nuke_nsnst_tracked_ips user_id : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips username : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips user_agent : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips refered_from : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips date : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips page : Base MUL Your table
field keys do not match nuke_nsnst_tracked_ips c2c : Base MUL Your table
null status not match nuke_pollcomments pid : Base NO Your table YES
null status not match nuke_pollcomments pollID : Base NO Your table YES
field keys do not match nuke_stats_date year : Base PRI Your table
field keys do not match nuke_stats_date month : Base PRI Your table
field keys do not match nuke_stats_date date : Base PRI Your table
field keys do not match nuke_stats_hour year : Base PRI Your table
field keys do not match nuke_stats_hour month : Base PRI Your table
field keys do not match nuke_stats_hour date : Base PRI Your table
field keys do not match nuke_stats_hour hour : Base PRI Your table
field keys do not match nuke_stats_month year : Base PRI Your table
field keys do not match nuke_stats_month month : Base PRI Your table
field keys do not match nuke_stats_year year : Base PRI Your table
field keys do not match nuke_users name : Base NO Your table
null status not match nuke_users ublock : Base YES Your table NO
default values do not match nuke_users user_notify : Base No Default Your table 1
default values do not match nuke_users user_notify_pm : Base No Default Your table 1
null status not match nuke_users_temp requestor : Base NO Your table YES
(thought I'd already added this to the thread)
Those above likely to cause any dramas?
Joined: Jun 03, 2004 Posts: 177 Location: Tamworth, UK
Posted:
Tue Mar 02, 2010 5:02 pm
Raven wrote:
From what I can tell by these error messages, such as The database you are using for comparison is: *****, something is either not named correctly or doesn't match your configuration. You have not set the 2 systems up correctly to run the scripts from all indications.
I removed the details deliberately there.... all were the same
Joined: Jun 03, 2004 Posts: 177 Location: Tamworth, UK
Posted:
Thu Mar 04, 2010 3:51 am
I've tried updating Sentinel IP2Country; the first part, it does ok. when it attempts for the second part/ screen 2 I get
CSRF check failed.
The reason I did this is bacuase I've got users saying they can't get onto the site/ they're banned- only their IP address doesn't show up as blocked...?
Any suggestions? (Or would you like me to do this as a separate thread?)
I looked at:
Only registered users can see links on this board! Get registered or login to the forums!
which suggests adding at the bottom of RNconfig,
Code:
$disableCSRFChecking = true; // Set to "true" in order to disable Cross-Site Request Forgery (CSRF) attack protection - should ONLY use as a last resort if your environment does not allow for output buffering
from my php info:
Quote:
Directive Local Value Master Value
output_buffering no value no value
Joined: Jun 03, 2004 Posts: 177 Location: Tamworth, UK
Posted:
Thu Mar 04, 2010 4:29 am
thanks- I've raised a support ticket.
Another issue- with the attachment mod (either forums or PM's)- it uploads the attachment (I know because I can see it in the forums admin when looking), but it doesn't show in the posts?
Joined: Jun 03, 2004 Posts: 177 Location: Tamworth, UK
Posted:
Thu Mar 04, 2010 7:26 am
I've asked;
also, I edited rnconfig and changed the disableCSRF to true- ran the script again- page 1, it did- after that it should have loaded page 2- it didn't- it just returned me to the sentinel admin screen...... (so I've deactivated it again)
Joined: Jun 03, 2004 Posts: 177 Location: Tamworth, UK
Posted:
Thu Mar 04, 2010 8:02 am
update; buffering was set to on; tried again- same problem, after completing part 1, part 2 gives me the error message.
I'm wondering if I am some files missing/ permissions not set?- can someone possibly advise which files/ folders it uses, so I can check if it's there?
Joined: Dec 02, 2006 Posts: 1254 Location: Texas, USA
Posted:
Thu Mar 04, 2010 8:09 am
what browser are you using? I ask because, Firefox 3.6 has some cache problems that @ times will cause the CSRF to fail; or produce some of the other behavior you have noted..
Joined: Jun 03, 2004 Posts: 177 Location: Tamworth, UK
Posted:
Thu Mar 04, 2010 8:25 am
spasticdonkey wrote:
what browser are you using? I ask because, Firefox 3.6 has some cache problems that @ times will cause the CSRF to fail; or produce some of the other behavior you have noted..
Joined: Jun 03, 2004 Posts: 177 Location: Tamworth, UK
Posted:
Thu Mar 04, 2010 9:10 am
a few members are reporting problems still;
one has an IP address of 94.8.243.39- check in Sentinel, and it shows it as being RSV (reserved).... and it's not in the .htaccess file either (I've got at least 2 users like this)
Any ideas?
edit: looked for him in Sentinel for his username in tracked IP's; the response I get is
Quote:
monkeyboyuk (10442)
IP Addresses Date Country
none 2010-02-27 @ 18:40:57 Unknown
Last edited by AndyB on Thu Mar 04, 2010 9:18 am; edited 1 time in total
Joined: Dec 02, 2006 Posts: 1254 Location: Texas, USA
Posted:
Thu Mar 04, 2010 9:14 am
cool
I love FF, but the current version 3.6 is almost unusable, way too aggressive in pulling pages from cache. pages such as
Only registered users can see links on this board! Get registered or login to the forums!
almost always have to be refreshed to see the current version. or try editing a post twice, the second visit to "edit post" pulls your page from cache, yuk
basically, any page you have visited before, it's likely to pull it from cache... patiently waiting for an update, I checked bugzilla and there was over 800 open issues for cache, so I stopped there....
about the IP issue, there is an updated IP2C in the upcoming release, maybe it will be fixed then... ?
Joined: Jun 03, 2004 Posts: 177 Location: Tamworth, UK
Posted:
Thu Mar 04, 2010 9:40 am
I deleted the range, and the user could get access; just updated the tables again, and then asked him to log out of the site, then back in again:- he managed successfully, and it's now showing him/ tracking him......
Is it a case of the tables possibly not being updated properly?
Joined: Dec 02, 2006 Posts: 1254 Location: Texas, USA
Posted:
Thu Mar 04, 2010 9:45 am
GazJ showed me this, open a new tab and type
about:config
in the address bar... I run so many addons I didn't want to mess around, but it's there if you want to try
Only registered users can see links on this board! Get registered or login to the forums!
Joined: Jun 03, 2004 Posts: 177 Location: Tamworth, UK
Posted:
Thu Mar 04, 2010 10:24 am
spasticdonkey wrote:
GazJ showed me this, open a new tab and type
about:config
in the address bar... I run so many addons I didn't want to mess around, but it's there if you want to try
Only registered users can see links on this board! Get registered or login to the forums!
thanks- I'll look into this later.
Any ideas with regards this?
Quote:
Another issue- with the attachment mod (either forums or PM's)- it uploads the attachment (I know because I can see it in the forums admin when looking), but it doesn't show in the posts?
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