Trackpad gestures on Asus VivoBook stopped working after using mouse

Question

The following scenario.

We have 2 scripts, both inserting into table and then using lastInsertId() to get the value from an autoincrement column.

If these 2 scripts are executed in parallel, do we know for sure that they won't mess the results?

---

In real time:

Time 1: Script 1 -> Insert. (created id = 1)

Time 1: Script 2 -> Insert. (created id = 2)

(database handles this using probably locks / semaphores)

Q1. Time 2: Script 2 -> lastInsertId() returns 1 or 2? Is it deterministic?

Q2. What about sequential inserts?

script.php

$statement1->insert('john'); // id = 1
$statement2->insert('mary'); // id = 2

echo $statement1->lastInsertId();
// is it 1 or 2? Is this also deterministic? 

Solution 1

I have an Asus UX32VD and have the same problem. If it's the same software, ASUS Smart Gesture, this might work for you as well. Do either manual or script. I'm lazy so I have a runnable script since this problem seems to occur more often than I'd like (a couple of times per week).

Manual Method

• Open task manager, locate the process "Asus Smart Gesture Center"; End the task.

Script Method

• Script: Create a .bat-file somewhere with the following code:
  Taskkill /IM AsusTPCenter.exe /F

When you run the bat-file, it will kill the process.

Both: when ending the task it seems like the other Asus processes running will detect it and start it, enabling multi-finger touch again.

---

To make the batch file:

1. Open Notepad and copy/past this command: Taskkill /IM AsusTPCenter.exe /F
2. Then click Save As and type in .bat (remove .txt)
3. Change the drop down list to All files . and click Save

That's it! When ever the problem appears, just double click the file and it will fix it!

Solution 2

I have the same problem with my vivobook. When using external mouse, touchpad gestures stop working. There seems to be no solid solution to this according to fast googling.

This happens when ASUS Smart gestures goes off for some reason. There is a folder inside ASUS install folder C:\Program Files (x86)\ASUS\ASUS Smart Gesture, but none of these programs actually restart the processes for Smart Gesture. By restarting windows WITHOUT exernal mouse plugged, I got the processes working again and there seems to be several of them related to Smart Gesture.

This is not a desired solution of course, but at least it's possible to get gestures on somehow.

Comments

[Kostanos]

The same happened to me with my Asus Zenbook after wake up. The solution below works

[Script47]

'If a sequence name was not specified for the name parameter, PDO::lastInsertId() returns a string representing the row ID of the last row that was inserted into the database.'

[DonJoe]

So if I specify name, I have guaranteed correct result? Also, could you please tell me, if I use transactions, does my question above not matter anymore?

[RiggsFolly]

Q1: The connection remembers the last insert id. So as each script has its own connection each script would remember the INSERT that happened using its comnnection

[DonJoe]

@RiggsFolly Is Q1 answer still true if i'm using persistent connection?

[homaxto]

Brilliant. It worked for me.

[kingsxi]

Wow, the Microsoft forms can't even come up with a solution other than: Update drivers and/or restart. Thanks Teknokraten!

[tangens]

Worked on my Asus Zenbook UX21A. Thanks!

[RiggsFolly]

Q2: Is it 1 or 2 It will be 2 as the connection only remembers the key of the LAST insert. So you would have to capture the key twice, once after each insert if you need to remember it