Vistors

hi, could you send an email to newstatpress @ altervista.org with a screenshot so I can see the problem? thanks

I also lost the “Visitors” log page a few weeks ago, and really could use it. Anyone out there know if there’s an issue with plugin, compatibility with updated WordPress version, clash with other plugins? I’ve been using a VPN – could that be a problem? Thanks for any help!

Thanks for the feedback. If it happens to more users, so it depends to the news changes to be conformed to the WordPress request implemented in the latest versions that maybe has a bug. I will work on it thanks

hi, just checked all my site. Wordpress version 5.6.1 and latest newstatpress version. Visitors are present unless in a site (not so much used) where normal visits are determinate as of feed RDF. This is give by wodpress function get_bloginfo('rdf_url'); that in those cases show a RDF values. Please if you have access to phpmyadmin, looks inside wp_statpress table, click on ID coulum to order by decrescent date and see if you have all record with feed RDF thanks

I have the same problem, Last visitors show, Visitors doesn’t

>nzfade are you able to see this: Please if you have access to phpmyadmin, looks inside wp_statpress table, click on ID coulum to order by decrescent date and see if you have all record with feed RDF thanks

NewStatPress v. 1.3.0 was working nice with my last WP v. 4.9.0 since May 13 2021. Then all stats disappeared, no Visitors, no Visitors through Feeds, no Pageviews, no Pageviews through Feeds, no Spiders. Yesterday I updated WP to 5.7.2 Still not working. Please let me know if there is a way to fix this. Thank you

hi, could you go to Newstatpress -> Tool -> Repair and repair the table? then go to Newstatpress -> Tool -> Optimize and the optimize the table? Now see if it works thnaks

I’ve done it. It’s not working.

hi, have you access to phpmyadmin so you can see the DB table contents?

Yes, have a look here: https://sendfile.cc/uploads/file/0.646608001623435563.png It shows only the last visitor (AhrefsBot) from 13.05.2021

hi Ok, the ID speaks: 8388607 it is the max value for auto-increment, so it is not stored nothing in DB. This is a limit of original statpress to have the key as incremental. One alternative is to increase his size. The problem is that this will stop the update in almost all site that has some data, has the operation took many times and service provider block the request for sure (I test it in my sites, so that change in table definition where not apply in new-statpress to avoid blocks on sites). Another alternative is to prune old data and set the id to start from 1 again. As you have only one record, maybe you already have the prune activated? To set again a low value the instruction to run into myphpadmis is: ALTER TABLE wp_statpress AUTO_INCREMENT = 1; You had to do this only if auto-prune ia activated otherwise there will be a collision from new data inserted and old data

hi, I didn’t prune anything but look here: https://sendfile.cc/uploads/file/0.319618001623440813.png there is nothing before 13.05 (the bot visit) so which option I can use now?

yes, you had only 1 entries at the last ID. If you did not have prune enabled, then with the table full of data, maybe the service provider had a DB problem at mysql level (but for sure you cannot have that logs to see when happened). However with the auto increment at max value you sohuld now use the command I post in the last reply on phpmyadmin to move auto increment to fist posiotion, so data can be inserted into the db again.

OK, I’m bit confused. Could you please, as you look at https://sendfile.cc/uploads/file/0.646608001623435563.png show me exactly where I’ve to insert ALTER TABLE wp_statpress AUTO_INCREMENT = 1; and all procedure. This reply was modified 4 years, 11 months ago by ned8888 .

You have to click SQL, then insert the command into the box, then click on execute button.

Well, check here what I’ve got: https://sendfile.cc/uploads/file/0.441200001623496102.png Something wrong? Not working….

No, command executed correctly. now see if you see new record in table when visiting the site

Have visited the site a couple of times. No records.

Supposing that you are not logged into the site, or if logged that newstatpress has option to track logged user, then we must look for other errors. You can try to add those line: ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); after line 10 Author URI: http://newstatpress.altervista.org ************************************************************/ ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); of newstatpress.php on edit plugin. This activate all php errors message onto the page. So browsing the site you will see on top all error message printed (if there are any). Please, remove it after the test, as all people will see eventual errors in visiting your site. If there are any erro message ,we can see if there is other problems.

Here are the errors https://sendfile.cc/uploads/file/0.477389001623510987.png

All those errors are from the theme used, not newstatpress. As you have only one record inside the wp_statpress table, you should use the Remove table from Tool or delete it from phpmyadmin and let that it will be recreated at next site access. This is an operation that erase the collected data, but you already has no data inside the table as we see from the fist phpmyadmin select. Maybe the DB size where become too big for the provider resourced (it could be around 3GB with full statpress table completed at last id). You can always see the db table size from Information panel of option

2 hours ago all data been removed > NSP > tools > remove but there is no new data coming… please explain, is the problem has to do with the compatibility example `Stat Press New Version: 1.3.5 (mine is 1.3.0) Last Updated: 5 months ago Requires WordPress Version: 3.5 or higher Compatible up to: WP 5.6.4 not compatible to WP 5.7.2 so what about 1.3.0 is it compatible to my V. 5.7.2

All my systems are with WP 5.7.2 and newstatpress 1.3.5. You should use the last newstatpress version as it changes in some points as for WordPress indication to be more secure. At this point you should try to disable the other plugins and see if it will works, just to catch a potential plugins issues (then reactivate all)

Done everything. Unfortunately it’s not working at all. Sad! What do I do?

This: function nsp_StatAppend() { is the function that add statistic in Nestatpress.php You should add those: echo "OK HERE"; starting from the beginning before an if statement, for example: if(nsp_CheckBanIP($ipAddress) == '') { return ''; } you put: echo "OK HERE"; if(nsp_CheckBanIP($ipAddress) == ”) { return ”; }` then you browse your site and inside the HTML output uou should find: OK HERE. That means that the code is reaching that point. Then you put the echo below the if block and see if it appears. If it not appears, then that if is what makes it not inserting the data. You must move down the echo at each if block until you reach: $results = $wpdb->insert( that it is the point that is not executed. When you find the point that the echo did not print OK HERE, post it so we know where there is the problem thanks

OK, few questions: 1 After checking each “if” block should I delete ‘echo “OK HERE”;’before I go to next one or will leave it there until I find the point we are looking for and then I have to restore the file (deleting ‘echo OK HERE’) 2 Where exactly I have to look for OK HERE. inside the View Page source of the site? If so where is the HTML output – 1 out of 1410 lines (Mozilla) and 1290 (Google Chrome) of HTML Page. 3 Logged into the site or not, does it matter to browse it or I can use other browser where is not logged in. 4 I found ‘$results = $wpdb->insert(‘ location. It is on line no 1152…!?

hi, 1) you can remove otherwise you will see many OK HEREOK HEREOK HEREOK HEREOK HERE in the output and you must count the number to see the position. In alternative you can put echo "POS=1"; `echo “POS=2”;’ and so on in every points and after see the last POS=x reached 2) you probably see it inside the page but the point depend from your theme so maybe it is not easy to see. You need to open as page source (CTRL+U in Firefox) and then search for text OK HERE if it is present 3) this depend if you have allowed newstatpress to store data of logged user in option. The easy way is to browse it with another browser of not logged people. 4) yes (It is line 1151 on last version)

hi, What I’ve done so far. Let me note that OK HERE I found only on line 1 before the <!DOCTYPE html> (browser Google Chrome – Web source Page), so see the pictures: Here https://sendfile.cc/uploads/file/0.060997001623785742.png OK HERE appears Here https://sendfile.cc/uploads/file/0.610458001623784305.png OK HERE doesn’t appear even if I insert echo “OK HERE”; under or above line 16,120,124,125 down, etc. Also there are errors from line 12 to 17 ….

hi, you have to start after the function nsp_StatAppend() { line 989 (ant to line 1172) as this is the routine to investigate. Put it else were will gives error depending of the point you insert it

All ‘IF blocks’ show OK HERE…..

So, if the code reach this point: $results = $wpdb->insert( $table_name, array( ‘date’ => $vdate, ‘time’ => $vtime, ‘ip’ => substr($ipAddress, 0, 39), ‘urlrequested’ => substr($urlRequested, 0, 250), ‘agent’ => substr(strip_tags($userAgent), 0, 250), ‘referrer’ => substr($referrer, 0, 512), ‘search’ => substr(strip_tags($search_phrase), 0, 250), ‘nation’ => substr($countrylang, 0, 2), ‘os’ => substr($os, 0, 30), ‘browser’ => substr($browser, 0, 32), ‘searchengine’ => substr($searchengine, 0, 16), ‘spider’ => substr($spider, 0, 32), ‘feed’ => substr($feed, 0, 8), ‘user’ => substr($login, 0, 16), ‘timestamp’ => $timestamp ), array( ‘%s’) );` ` on line 1151, then it should have add a record in db. Try adding this after that instruction: echo "ROW=".$result$." INSERTED"; this should print inside the HTML: ROW=1 INSERTED

quote: “on line 1151, then it should have add a record in db.” No record in db “Try adding this after that instruction: echo “ROW=”.$result$.” INSERTED”; this should print inside the HTML: ROW=1 INSERTED” After this the New Stat Press can’t be activated, generate Error: “Plugin could not be activated because it triggered a fatal error. Parse error: syntax error, unexpected ‘$’, expecting ‘;’ or ‘,’ in H:\root\home\cosmikwp-001\www\cosmikwp\wp-content\plugins\newstatpress\newstatpress.php on line 1174” Then I decided to check again line 1148 – last “if”before ( $results = $wpdb->insert( “if($wpdb->get_var(“SHOW TABLES LIKE ‘$table_name'”) != $table_name) { ” adding above and below ‘echo “OK HERE”; When I added above there is ‘OK HERE’ in the HTML When I added it below doesn’t show ‘OK HERE’

hi, sorry just copy/paste it in wrong manner: echo "ROW=".$result." INSERTED"; this is the right to use.

hi, Just paste it and result is ‘ROW= INSERTED’ not ‘ROW=1 INSERTED’

It not inserted a row. Execute in phpmyadmin: SELECT AUTO_INCREMENT FROM information_schema . TABLES WHERE TABLE_SCHEMA = ‘database_name’ AND TABLE_NAME =’vp_statpress’ with database_name is the name of your DB

hi, before following this instruction when I access phpmyadmin and click on the SQL and open the box see what I saw there: 1. SELECT * FROM wp_statpress WHERE 1 https://sendfile.cc/uploads/file/0.806460001624279104.png Is it wrong? And can I execute ‘SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘database_name’ AND TABLE_NAME =’vp_statpress’ next to on line 2 ?

It is good. You have to modify that proposed query into SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘database_name’ AND TABLE_NAME =’vp_statpress’ and execute this

Hi, I can’t modify and execute it. I tried different ways: put ‘database_name’ = ‘wp_cosmikwp’ and corrected your table name =’vp_statpress’ into ’wp_statpress’ but always SQL says: Errors, Errors. Please show me exactly what I have to do when you look at this: https://sendfile.cc/uploads/file/0.806460001624279104.png

hi, https://sendfile.cc/uploads/file/0.005607001624557931.png when you click onto the statpress table and then onto the SQL tabs, then you can go into the SQL windows and modify by hand that query into the one you see into the screenshot (it refers to my db and my table names that are in red signed) and execute Go (Esegui in Italian). Otherwise you can click on Modify button that will open a new Sql box where to insert the command thanks

hi, Done something: https://sendfile.cc/uploads/file/0.593822001624564904.png Please check the 3 locations in red. It changed Tables name from ’wp_statpress’ to Table: TABLES Is it OK? If so should the new stat press finally start working? Unfortunately still not working.

hi it shows that auto increment is still at max point. You should execute: ALTER TABLE wp_statpress AUTO_INCREMENT = 1; with the same manner you execute the previous command. After this, execute the previous command again and you should see a 1 result instead of 8388608

Hi, I’ve done it exactly as you advice but result is the same with error: https://sendfile.cc/uploads/file/0.730920001624701538.png

hi, from the screenshot you are inside a table called TABLES, so it did not seems to be inserted the right command.

Hi there, I found my mistake! I deactivated the start press in order to delete the rows in phpmydmin (bot visits) with increment 8388608 because somehow they are sneaking in the table and mixed with increment 1 at the moment I execute ‘ALTER TABLE wp_statpress AUTO_INCREMENT = 1;’ and ‘SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘wp_cosmikwp’AND TABLE_NAME =’wp_statpress’ and this maybe causes the Errors. Well I succeed to clean all query and after the activation of the plugin the visitors data is flowing into the table. I will monitor it and if something is going wrong I will let you know if you don’t mind. So I would like to thank you so much for the time you’ve been with me ( more than 2 weeks ). I really appreciate it. Have a nice day and keep the good work. Best regards, Ned