Quote
maybe a defect of the mysql table so that the auto-inc counter is corrupt?
Quote
ALTER TABLE fusion_users AUTO_INCREMENT = _YOUR_MAXIMUM_USER_ID_
<?php
$result = dbquery("SELECT MAX(user_id) FROM ".DB_USERS);
$id = dbarray($result);
$maxid = $id['MAX(user_id)'] + 1;
$result = dbquery("ALTER TABLE ".DB_USERS." AUTO_INCREMENT = ".$maxid);
if ($result) {
echo "Success :)<br />New AUTO_INCREMENT = ".$maxid;
} else {
echo "Something went wrong :(<br />Please try again";
}
?
Category Forum
Modifications and Requests - 8Labels
None yet
Statistics
7 participants
Notifications
You are not receiving notifications from this thread.
Related Questions