Vistors

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