ignore add votes

[erbi]

I don't why system ignore hand added votes? If reset votes and add votes, database display 55 added votes, but extension display 0
Use joomla 3.4, last version

[Edvard]

Hi,

Do you add votes in the database manually?

[erbi]

No, not add manually

[Edvard]

Please provide more details about the issue.

What you do?
What you expect to happen?
What happens instead?

Thanks!

[erbi]

People votes via web page and via SMS. SMS votes go to cell phone, not to joomla extension. SMS votes manualy add to poll. Example:
via web 50 votes, I add 20 SMS votes = total 70 votel. In list of questions (back end admin page) display 70 votes, but in graph (button details) display only 50 votes (front page).
Maybe I found solution...
If I add votes via sexy polling extension and clisk SAVE, and now klick EXIT, added votes are saved, but not display in graph.
If add votes via sexy polling extension and click SAVE & EXIT save added votes and now dispaly in graph.

[Edvard]

Hi,

Good to hear that you have find a solution. Not sure what is going on exactly, but seems like something to do with browser cache on the front end.

Thanks!

[erbi]

I don't know, but look graph on 3 separately computers and 3 different browsers

[erbi]

My last post not solved problem. Today manualy add new votes (via component). Chart display normaly. Next step is running automaticaly (via cronjob), because answers move to another poll.

Code: Select all

$nz1 = 131;
$nz2 = 132;
$nz3 = 133;
$nz4 = 134;

// connect to database
$servername = "localhost";
$username = "**************";
$password = "*****************";
$dbname = "*****************";

   $conn = new mysqli($servername, $username, $password, $dbname);
   if ($conn->connect_error) {
      die("Not connected: " . $conn->connect_error . "\n");
   }
   
   $sql = "UPDATE xlpix_sexy_answers SET id_poll=5 WHERE id=$nz1 OR id=$nz2 OR id=$nz3 OR id=$nz4 OR id=$nz5";
   
   $conn->close();


All answers success moved to another poll, in administrator display all votes, but graph (front page) display only wotes which added users, without my admin added.
Example:
users voted 50x, I add 20 votes. In admin page display 70 votes, front page graph diaplay 50 votes

[Edvard]

Hi,

Are all answers published?

The query which selects answers to render on front-end is:

SELECT `id`,`name` FROM `#__sexy_answers` WHERE `id_poll` = '$polling_id' AND published = '1'

Thanks!

[erbi]

Yes, all votes are published. Votes added with admin joomla all have the same date. If change this date (
for one vote) 24 hours ago, graph display one vote more.

[erbi]

Maybe now found solution. In poll seting set date to - (minus), because don't like to display date in frame End votes.

Now set date to d.m.y and graph display all votes.