I have but rather transactions always executed // i do not commit any

I have but rather transactions always executed // i do not commit any… well??? This will soon replaced by PDO but currently like this is…

	  mysql_query("BEGIN TRANSACTION");
	  
	  $result = mysql_query($q, $this->connection);
	  
	  $result1 = mysql_query($users_history, $this->connection);
	
	  mysql_query("ROLLBACK"); // transaction rolls back

Most likely your tables do not support transactions. Check table engine, is should be not Myisam but Innodb

1 Like

can convert a table from MYISAM to INNODB…? without transfer data… data to be remain…

Yes. Yes you can

https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.