ice00

You can show the online visitors by using the variable %visitorsonline% with the newstatpress widget.

You cannot count click on image/banners as the plugin count only the access to the site

hi,

this is resolved in version 1.4.3

• This reply was modified 2 years, 5 months ago by ice00.

hi,

the plugin core is being rewrote from 2 months now and 1.4.0 version has a line by line PHP/Wordpress check in it!

Version 1.4.0 will be released soon as those intermediate version over the last 2 months have some issues due to the rewrote being done.

You can attend the new version.

thanks

hi,

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

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,

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

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

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,

sorry just copy/paste it in wrong manner:

echo "ROW=".$result." INSERTED";

this is the right to use.

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

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

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)

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

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)

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