Re: [PHP] Reseting the auto-increment number in a MySQL database.
On Thu, Jun 27, 2013 at 11:47:28PM +0200, adriano wrote: > > holes in sequence of auto increment happen using transaction for > insert new record but you don't commit transaction itself > it seems that the autoincrement is incremented anyway > at least this is my case. I think what Tedd was referring to was something else. The "hole" was quite large. I've seen this behavior myself, in PostgreSQL. From one transaction to the next, there were over 10,000 skipped numbers, and only me and my wife on the system. Some sort of bug, like a spinlock that wasn't interrupted the way it should have been. I remember the system taking forever to calm down before it gave the next transaction a number way forward of the last one. I waited in front of my browser for quite some time. But I couldn't explain why. Paul -- Paul M. Foster http://noferblatz.com http://quillandmouse.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Reseting the auto-increment number in a MySQL database.
holes in sequence of auto increment happen using transaction for insert new record but you don't commit transaction itself it seems that the autoincrement is incremented anyway at least this is my case. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Migration of applications to PHP 5.4
Hello, i recently migrated my webserver from Debian Lenny (with PHP 4.x) to Wheezy with PHP 5.4. Some applications like mediawiki could be updated and they are running fine. But there are some old and beloved applications that run any more. A good example is PHPmyedit 5.7.1 http://www.phpmyedit.org/ The first page with data is displayed but all links and buttons are dead! There is no error produced by PHP and i have no idea why it is not working? I'm have only basic knowledge with PHP and would be glad to have some tips how to debug things without error. My hope is that this migration problem is known and can be fixed simply? Thanks Karsten -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php