Reset AutoIncrement Number in MySQL

To reset your autoincrement number, you can simply run the following SQL:

ALTER TABLE 'table_name' AUTO_INCREMENT = X

Where X is the ID number you want to set the increment start point to, so running

ALTER TABLE 'table_name' AUTO_INCREMENT = 0

resets the ID increment process, and

ALTER TABLE 'table_name' AUTO_INCREMENT = 1023

Would set the start seed to 1023 - sometimes useful for making things looked "used", for example with order systems.

Making changes to overall_header.php in phpBB do not take effect

I have been, for some time, trying to make changes to the code in the header file for phpBB. These were not changes for functionality, rather links required to other parts of the site.

Anyway, I had made the changes locally in my local copy of the overall_header.php file of the prosilver theme, but I ftp'd them up, the changes didn't happen.

Frustrated, I spent some time checking what phpBBs admin area said was in the file using the built in editor, and it said my changes were done.

However, what it doesn't say is that once you've made any changes to page files or style documents, you have to run the PURGE ALL feature from the admin control panel to flush out cached copies!

Ran that, and hey presto, fixed.

Person [user@example.com] on behalf of Another Person [user@otherexample.com]

Today I had a query whereby a user was sending emails after outlook had been reinstalled, and was getting this in the emails he was sending, even if it was from his normal account.

The problem seemed to be that the default email being sent from was incorrect, so setting the correct mailbox cured it.