PDA

View Full Version : Error in CVS dotproject.sql


patrick24601
04-12-04, 07:47 AM
I found this /* in the CVS dotproject.sql. This was preventing my entire database from getting created properly. Was this on purpose?

CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`user_contact` int(11) NOT NULL default '0',
`user_username` varchar(255) NOT NULL default '',
`user_password` varchar(32) NOT NULL default '',
`user_parent` int(11) NOT NULL default '0',
`user_type` tinyint(3) not null default '0',
`user_company` int(11) default '0',
`user_department` int(11) default '0',
/* `user_first_name` varchar(50) default '',
`user_last_name` varchar(50) default '',
`user_email` varchar(255) default '',
`user_phone` varchar(30) default '',
`user_home_phone` varchar(30) default '',
`user_mobile` varchar(30) default '',

patrick24601
04-12-04, 07:52 AM
OK. I see that there is an ending comment set later in the query. I see that those columns are not supposed to be there.

But when I use the lost password function it goes and looks for the user_email column and it does not exists.

Man I am lost.

patrick24601
04-12-04, 07:54 AM
Nevermind. If I would have looked down 10 posts I would have seen the solution.