PDA

View Full Version : 8/22 SQL Error on Installation


zbert
23-08-04, 05:39 AM
There is an error during the admin insert into the user table. Field count doesn't match. It looks like the following field has been added to the user table which makes the the number of fields 26:

`user_contact` int(11) NOT NULL default '0',

It doesn't look like the Insert statement accounts for this field as there are only 25 values being inserted.

I'm not sure what the user_contact is used for but you can fix the installation problem by adding an integer value after the user_id value like so:

INSERT INTO `users` VALUES (1,12345,'admin',...

--zbert

zbert
23-08-04, 05:53 AM
My solution doesn't seem to work because I can't add users to the system now. May be better to just delete the user_contact field. I'll give it a try but it must be there for a reason.

--zbert

cyberhorse
23-08-04, 11:18 AM
This has just been changed. If you delete the user_contact field now, you will end up with users that have no contact information (about all they will have is username and password).

The sql files have been updated now, so your inserts should work the next time you grab the newest cvs version.