PHP Web Host - Quality Web Hosting For All PHP Applications $35/month $250/year (Unlimited) - $25/month - 200,000 impressions - Your Ad Could be Here - Click For Details
  Login or Register
 • Home • Downloads • Your Account • Forums • 

View next topic
View previous topic


Google
 
Web RavenPHPScripts (This Site)
Post new topic   Reply to topic
Author Message
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Mon Mar 01, 2010 6:56 am Reply with quote Back to top

ok, many thanks for the response Wink
View user's profile Send private message Visit poster's website
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Tue Mar 02, 2010 2:09 pm Reply with quote Back to top

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 )
View user's profile Send private message Visit poster's website
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Tue Mar 02, 2010 2:23 pm Reply with quote Back to top

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)
View user's profile Send private message Visit poster's website
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6302
Location: Vsetin, Czech Republic

PostPosted: Tue Mar 02, 2010 2:48 pm Reply with quote Back to top

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
View user's profile Send private message Send e-mail Visit poster's website
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Tue Mar 02, 2010 2:55 pm Reply with quote Back to top

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?
View user's profile Send private message Visit poster's website
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6302
Location: Vsetin, Czech Republic

PostPosted: Tue Mar 02, 2010 4:07 pm Reply with quote Back to top

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.
View user's profile Send private message Send e-mail Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 16976
Location: Kansas

PostPosted: Tue Mar 02, 2010 4:59 pm Reply with quote Back to top

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.
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Tue Mar 02, 2010 5:01 pm Reply with quote Back to top

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
View user's profile Send private message Visit poster's website
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Tue Mar 02, 2010 5:02 pm Reply with quote Back to top

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
View user's profile Send private message Visit poster's website
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Thu Mar 04, 2010 3:51 am Reply with quote Back to top

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


Any suggestions?

Cheers

Andy
View user's profile Send private message Visit poster's website
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6302
Location: Vsetin, Czech Republic

PostPosted: Thu Mar 04, 2010 4:18 am Reply with quote Back to top

Contact your hosting provider and ask them to turn Output Buffering on, it should be on by default.
View user's profile Send private message Send e-mail Visit poster's website
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Thu Mar 04, 2010 4:29 am Reply with quote Back to top

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
View user's profile Send private message Visit poster's website
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Thu Mar 04, 2010 7:26 am Reply with quote Back to top

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)
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 16976
Location: Kansas

PostPosted: Thu Mar 04, 2010 7:38 am Reply with quote Back to top

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.
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Thu Mar 04, 2010 8:02 am Reply with quote Back to top

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?
View user's profile Send private message Visit poster's website
spasticdonkey
RavenNuke(tm) Development Team


Joined: Dec 02, 2006
Posts: 1254
Location: Texas, USA

PostPosted: Thu Mar 04, 2010 8:09 am Reply with quote Back to top

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..
View user's profile Send private message
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Thu Mar 04, 2010 8:24 am Reply with quote Back to top

it IS firefox....

I'll give it a whirl with internet exposure... thanks
View user's profile Send private message Visit poster's website
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Thu Mar 04, 2010 8:25 am Reply with quote Back to top

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 Very Happy Very Happy Very Happy

Seems to be working- thanks!
View user's profile Send private message Visit poster's website
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Thu Mar 04, 2010 9:10 am Reply with quote Back to top

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
View user's profile Send private message Visit poster's website
spasticdonkey
RavenNuke(tm) Development Team


Joined: Dec 02, 2006
Posts: 1254
Location: Texas, USA

PostPosted: Thu Mar 04, 2010 9:14 am Reply with quote Back to top

cool 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 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... ?
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 16976
Location: Kansas

PostPosted: Thu Mar 04, 2010 9:29 am Reply with quote Back to top

I believe so Wink. In the meantime just add it yourself Smile
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Thu Mar 04, 2010 9:40 am Reply with quote Back to top

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
View user's profile Send private message Visit poster's website
spasticdonkey
RavenNuke(tm) Development Team


Joined: Dec 02, 2006
Posts: 1254
Location: Texas, USA

PostPosted: Thu Mar 04, 2010 9:45 am Reply with quote Back to top

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
Only registered users can see links on this board!
Get registered or login to the forums!
View user's profile Send private message
AndyB
Worker
Worker


Joined: Jun 03, 2004
Posts: 177
Location: Tamworth, UK

PostPosted: Thu Mar 04, 2010 10:24 am Reply with quote Back to top

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


Any ideas?

Cheers [/quote]
View user's profile Send private message Visit poster's website
spasticdonkey
RavenNuke(tm) Development Team


Joined: Dec 02, 2006
Posts: 1254
Location: Texas, USA

PostPosted: Thu Mar 04, 2010 11:02 am Reply with quote Back to top

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?
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic

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
Forums ©
 

All logos and trademarks in this site are property of their respective owner.
The comments are property of their posters, all the rest © 2002-2011 by Raven

You can syndicate our news using the file xml

CSE HTML Validator Helped Clean up This Page! [Valid RSS] valid RSS 2.0 Valid robots.txt Stop Spam Harvesters, Join Project Honey Pot

Website engines core code is © copyright by PHP-Nuke but has been heavily patched and modified by myself and others.
PHP-Nuke is a free software released under the GNU/GPL.


:: fisubice phpbb2 style by Daz :: PHP-Nuke theme by www.nukemods.com ::
:: fisubice Theme Modified by the RavenNuke™ Team ::

:: W3C CSS Compliance Validation :: W3C HTML 4.01 Transitional Compliance Validation ::

zerosum