#126 Install bug?

open
nobody
None
5
2002-02-15
2002-02-15
Stuart George
No

when I install i get this response when i run setup.
basically it cant even insert root password!
(i tested it on my win2k box iis5/php4/mysql, worked
ok, then tested it on my host with apache/php4/mysql..
error).

Congratulations, you have a fresh database

1050: Table 'users' already exists
table users NOT created

Installing default values

1136: Column count doesn't match value count at row 1
insert
INSERT INTO users VALUES
(1,'root','root','root@root.com','','password','1,2,3,4
,5,6,7,8,9',1,0,'0000-00-00 00:00:00','0000-00-00
00:00:00',0,'','',10,0,'','','threaded',0,0,0,4096,'','
','0')
NOT completed
Some errors, please check files in ./sql/inserts.

Discussion

  • Stuart George
    Stuart George
    2002-02-16

    Logged In: YES
    user_id=76020

    (this is with a standard setup, 4.xx not the 5-dev version.)
    just checked my user db on win2k vs my unix host.

    win2k has 2 extra fields at the end, backends+digest.
    the apache host didnt create these tables when i ran
    setup.php.

    manually added a 'root' user with same values. seems ok
    now... not sure about missing fields in user table tho.