Forum

Thread tagged as: Question, Error, Runway

Problem creating collections: Invalid Queary

When trying to create a new collection (my first one) it does create one but returns the following in the debugger:

Invalid query: SQLSTATE[HY000]: General error: 1364 Field 'collectionOptions' doesn't have a default value

Any ideas why this could be?

Dan Lee

Dan Lee 1 points

  • 6 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

What line comes before that?

Are you on Windows?

Dan Lee

Dan Lee 1 points

Hi Drew, here is the full debug code...

I'm on Mac OS X 10.10

0.0119  0   SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='c1518c4e153b20f18daadf677ae1bf57' LIMIT 1
0.0123  0.0004  UPDATE perch2_users SET userHash='d69077857ced3dbc440b0942d6b40e6c' WHERE userID=1
0.0125  0.0002  SELECT p.privKey FROM perch2_user_privileges p
0.0136  0.0011  SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
0.0389  0.0254  SELECT collectionID, collectionKey FROM perch2_collections WHERE collectionInAppMenu=1 ORDER BY collectionOrder ASC
0.0484  0.0095  INSERT INTO perch2_collections(collectionKey,collectionTemplate) VALUES('Resources','article.html')
0.0809  0.0325  Invalid query: SQLSTATE[HY000]: General error: 1364 Field 'collectionOptions' doesn't have a default value
0.0839  0.003   Queries: 6
Drew McLellan

Drew McLellan 2638 points
Perch Support

Does 2.7.10 help with this at all?

Dan Lee

Dan Lee 1 points

Yes updating to 2.7.10 fixes this issue.

Runway: fixes bug with creating collections with no options on some MySQL configurations