Duplicate Entry 0 for Key 1 [SOLVED] - Joomla! Forum - community, help and support
i moved devils canyon brewery new server, exported old sql , reimported @ new location.
whenever post new article not show on front page. key in table @ 0 have use sql interface , go in , manually change next number (86, 87, etc).
d
now noticed people cannot register:
mosuser::store failed
duplicate entry \'0\' key 1 sql=insert jos_users ( `id`,`name`,`username`,`email`,`password`,`gid`,`registerdate` ) values ( . . . . . . )
its database ddoesn't know has records , trying start scratch. appreciated.
whenever post new article not show on front page. key in table @ 0 have use sql interface , go in , manually change next number (86, 87, etc).
d
now noticed people cannot register:
mosuser::store failed
duplicate entry \'0\' key 1 sql=insert jos_users ( `id`,`name`,`username`,`email`,`password`,`gid`,`registerdate` ) values ( . . . . . . )
its database ddoesn't know has records , trying start scratch. appreciated.
use phpmyadmin check table.
jos_users should have "next autoindex" should next id can used.
with "operations" tab you'll form can increase "auto_increment".
(ps: before making changes it's recommended backup database).
jos_users should have "next autoindex" should next id can used.
with "operations" tab you'll form can increase "auto_increment".
(ps: before making changes it's recommended backup database).
Comments
Post a Comment