Not an issue (yet- I hope!)

Posted: Mon Mar 01, 2010 6:56 am

ok, many thanks for the response Wink

Posted: Tue Mar 02, 2010 2:09 pm

Palbin wrote:

I will try and catch up on this topic tonight, but your problem doesn't look to bad.

Quote:

SHOW COLUMNS FROM nuke_nsngr_users LIKE 'uname' FAILED. MySQL reported: Table 'afnet_nuke1.nuke_nsngr_users' doesn't exist

Don't worry about this one. I will give more info tonight if you haven't figured it out.

Any joy? I struggled to look into it (pc in the kitchen, whole family sat round the table yakking so I couldn't concentrate Rolling Eyes

)

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)

Posted: Tue Mar 02, 2010 2:48 pm

Did you actually check to see if in the config.php file you have the same or a different values for $prefix and $user_prefix

Posted: Tue Mar 02, 2010 2:55 pm

I used the RN config file supplied in the distribution, I added my username, db name, password, etc. for Mysql. $prefix and $user_prefix are the same.

I'm literally (now) running some SQL into the DB to create (I hope) the missing tables.. not sure if I'm doing the correct thing...

so far, I've done the following:

Quote:

Table '.nuke_bbconfirm' doesn't exist SHOW COLUMNS FROM nuke_bbconfirm LIKE 'confirm_id'

I ran the following script in phpmyadmin:

Code:

CREATE TABLE IF NOT EXISTS `nuke_bbconfirm` ( `confirm_id` char(32) NOT NULL default '', `session_id` char(32) NOT NULL default '', `code` char(6) NOT NULL default '', PRIMARY KEY  (`session_id`,`confirm_id`) ) ENGINE=MyISAM

then:

Quote:

Table '.nuke_bbthemes_name' doesn't exist SHOW COLUMNS FROM nuke_bbthemes_name LIKE 'themes_id'

I ran the following script in phpmyadmin:

Code:

CREATE TABLE IF NOT EXISTS `nuke_bbthemes_name` ( `themes_id` smallint(5) unsigned NOT NULL default '0', `tr_color1_name` char(50) default NULL, `tr_color2_name` char(50) default NULL, `tr_color3_name` char(50) default NULL, `tr_class1_name` char(50) default NULL, `tr_class2_name` char(50) default NULL, `tr_class3_name` char(50) default NULL, `th_color1_name` char(50) default NULL, `th_color2_name` char(50) default NULL, `th_color3_name` char(50) default NULL, `th_class1_name` char(50) default NULL, `th_class2_name` char(50) default NULL, `th_class3_name` char(50) default NULL, `td_color1_name` char(50) default NULL, `td_color2_name` char(50) default NULL, `td_color3_name` char(50) default NULL, `td_class1_name` char(50) default NULL, `td_class2_name` char(50) default NULL, `td_class3_name` char(50) default NULL, `fontface1_name` char(50) default NULL, `fontface2_name` char(50) default NULL, `fontface3_name` char(50) default NULL, `fontsize1_name` char(50) default NULL, `fontsize2_name` char(50) default NULL, `fontsize3_name` char(50) default NULL, `fontcolor1_name` char(50) default NULL, `fontcolor2_name` char(50) default NULL, `fontcolor3_name` char(50) default NULL, `span_class1_name` char(50) default NULL, `span_class2_name` char(50) default NULL, `span_class3_name` char(50) default NULL, PRIMARY KEY  (`themes_id`) ) ENGINE=MyISAM;


INSERT INTO `nuke_bbthemes_name` VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');

They appear to have worked. Well, they didn't give any errors.....
I was going to continue doing this for the missing tables?

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.

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

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.

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?

Cheers

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 Wink

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: http://www.ravenphpscripts.com/posts18150-highlight-csrf+check+cheque+failed.html

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

Any suggestions?

Cheers

Andy

Posted: Thu Mar 04, 2010 4:18 am

Contact your hosting provider and ask them to turn Output Buffering on, it should be on by default.

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?

Any ideas?

Cheers

Andy

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)

Posted: Thu Mar 04, 2010 7:38 am

You should be able to set output_buffering yourself. If you run PHP with phpsuexec or suphp then add it to your local php.ini.

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?

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..

Posted: Thu Mar 04, 2010 8:24 am

it IS firefox....

I'll give it a whirl with internet exposure... thanks

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..

YOU BEAUTY! Very Happy

Seems to be working- thanks!

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

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
http://www.ravenphpscripts.com/forumssearch-search_id-newposts.html

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 Sad

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.... Rolling Eyes

about the IP issue, there is an updated IP2C in the upcoming release, maybe it will be fixed then... ?

Posted: Thu Mar 04, 2010 9:29 am

I believe so Wink

. In the meantime just add it yourself Smile

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?

And I'll see if I can disable cache in FF

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 Smile

http://kb.mozillazine.org/Firefox_:_FAQs_:_About:config_Entries

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 Smile

http://kb.mozillazine.org/Firefox_:_FAQs_:_About:config_Entries

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?

Any ideas?

Cheers [/quote]

Posted: Thu Mar 04, 2010 11:02 am

look at the Forum Permissions Control for the forum in question, make sure "Download Files" is set to ALL
Also, what theme are you using?