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.

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).





Comments

Popular posts from this blog

Error: ‘for’ loop initial declarations are only allowed in C99 or C11 mode - Raspberry Pi Forums

class MPU6050 has no member named begin

missing filename after '-o'