please guide me how to install drupal on a database with these server variables
| auto_increment_increment | 2 |
| auto_increment_offset | 1 |

i installed drupal 6.14 on this server

and it create the id with +2 values instead of +1

it generates evry row in table with +2 id

like user table structure

uid name pass
0
1 user1 21a350caaf1df67c3685593d7826d2df
3 user2 21232f297a57a5a743894a0e4a801fc3

and another node table :

nid vid type
1 1 page
3 3 page
5 5 page

now i want to know .. is this the serious problem? if it is then how to sort it out? or iis it right to let it generate id's like this.

Comments

meranakliid’s picture

meranakliid commented

any idea???

meranakliid’s picture

meranakliid commented

i discussed it wid our server administrator .. according to them they set 'auto-increment-increment = 2' cz of some db replication and they cant set it to 1 .. so we need to setup accordingly. actually i dont know much about the db replications.

is there in way to install drupal or some kind of patch to sort it out???

scor’s picture

scor commented
Status: Active » Closed (duplicate)

see #118066: Drupal install does not work with different auto increment settings.