Mautic Community Forums

Segment Update By Page Hit Problem In Mautic Detected

Your software
My Mautic version is: v2.16.0
My PHP version is: 7.3.15

Your problem
My problem is:
Mautic does not update segments on page hit
I got this problem for so long and it’s not working still
If I click the link second-time segment updates but users can’t be clicking link twice in real life for their campaign and segment to be updated.

These errors are showing in the log:
[[2020-03-17 11:20:06] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘REPLACE INTO mauf1_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from mauf1_campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':dateAdded as date_added, :message as reason from mauf1_campaign_lead_event_log ’ at line 2

strong text
Steps I have tried to fix the problem:
I created my campaign and choose appropriate segment it didn’t work until click link more than 1 for segment to update

Hey,
Questions:

  1. Did you update mautic or fresh install ?
  2. Did you try clearing cache ?
  3. Can you run php app/console doctrine:schema:update --dump-sql to see if there any db update required.

It happened after 4 days of first installation
i once has issue with the installation said database error site not available no i cleared the installation and started all over again.
I have build many campaigns in this one
When i started testing only the first campaigns worked to move users to lead and pending confirmation others didn’t work and my campaign heavily depend on segments.
Am not too technicall but i will run the cron job you specified and post the result.

Currently i have an installation working just fine on 2.15

Okay, please try the doctrine command i stated in previous one, also let me know mysql version as well.

Thanks my hosting provider was down yesterday so i could try the suggestion
but i added the cron job now what next do i do as in how do i go about it now

ahh you didn’t have to add cron job but run this command directly in order to check if there was any unimplemented changes for database. if you implemented cron job can you please check if there are some logs related to this cron which could prpvide some insight ?

i use cpanel i dont know how to run this command
i installed mautic on new host same problem
contact not going to next segment except the visit page twice by clicking link in email
Please how do i fix it wasted much time on it already.
Aslso There was even a campaign now working cant i track page visit directly without a user clicking link in email as long as that contact has been previously
identified through a contact form?

Tell me how you plan to install shared hosting or VPS?

Do you have cpanel Femsphil ? You would if you have a shared or dedicated hosting
You won’t have a Cpanel if you are using any VPS less than $25

Now let’s say you have Cpanel
Just go over to your Cpanel and login
Then search for Softaculous
Search for Mautic
it will guide with installation very simple
and you need to take note is user name and password to login directly without c panel always.

Tell me how you plan to install shared hosting or vps? but recommend shared if you are just starting out

A post was split to a new topic: Mautic setup tutorial video?

I tried installing on my godaddy shared hosting, it was pretty simple though, i was able to use one click install. and then add cron using cron update section, like you said you did.
for the cache I could delete directory using file manager.
for running command I had to contact support becuase they don’t allow ssh access directly, but I think your way should have worked too. in that case you should have run:

php app/console doctrine:schema:update --dump-sql --force

this command(mind that you will need to specify full path, instead of just app/console).