PHPCI icon indicating copy to clipboard operation
PHPCI copied to clipboard

can not add project ,need help!

Open yiqing95 opened this issue 9 years ago • 5 comments

when add a project which is a local project , and i left some form fields blank . the phpci is the latest version (installed from github ). I got this info: `

Add Project Sorry, there was a problem SQLSTATE[HY000]: General error: 1364 Field 'access_information' doesn't have a default value `

yiqing95 avatar Mar 16 '16 21:03 yiqing95

@yiqing95 I'm not a PHPCI project member, but it sounds like your database version (MySQL?) doesn't like something that PHP is trying to insert. If I was you I'd take a look at the project database, and add a default value for the access_information column (null, a blank string, etc)

Also, it'd help the project if you could let them know which version of PHP CI you're running.

astorm avatar Mar 17 '16 02:03 astorm

@astorm after modifying the table column (to allow null) , I created project successfully! thanks for your tip :+1:

and for building project ,I met the same problem and then modify every field which cause this error to allow null db-field-attribute .

I don't think this is a gentle solution ,but at this time it make every thing go well .

yiqing95 avatar Mar 17 '16 15:03 yiqing95

@yiqing95 If you can share how you installed the application, which version you installed, and which version of MySQL you're running, the Block8/PHPCI team should be able to fix this problem for future users.

astorm avatar Mar 17 '16 15:03 astorm

@astorm I just clone this project from github . and follow the installation instructions .
MySQL Server: 5.6.21 PHP version : 5.6.3 nts

yiqing95 avatar Mar 17 '16 15:03 yiqing95

MySQL version: Server version: 5.7.11-4-log Percona Server (GPL), Release 4, Revision 5c940e1

i got the same error: SQLSTATE[HY000]: General error: 1364 Field 'last_commit' doesn't have a default value

i think there may be a bug during mysql data migration.

liupangzi avatar Apr 20 '16 09:04 liupangzi