Skip to content

Instantly share code, notes, and snippets.

@ss23
Created March 16, 2012 02:01
Show Gist options
  • Save ss23/2048122 to your computer and use it in GitHub Desktop.
Save ss23/2048122 to your computer and use it in GitHub Desktop.
omfg err0r
ERROR [User Error]: Couldn't run query:
INSERT INTO "EditableFormField_versions" ("Required", "CustomRules", "CustomSettings", "Default", "CustomErrorMessage", "LastEdited", "ClassName", "Created", "Name", "Title", "Sort", "CanDelete", "CustomParameter", "ParentID", "Version", "RecordID", "AuthorID") VALUES ('1', 'a:0:{}', 'a:5:{s:10:\"RightTitle\";s:0:\"\";s:9:\"MinLength\";s:0:\"\";s:9:\"MaxLength\";s:2:\"32\";s:4:\"Rows\";s:1:\"1\";s:10:\"ShowOnLoad\";s:4:\"Show\";}', null, null, '2012-03-16 22:06:08', 'EditableTextField', '2009-08-07 09:41:44', 'EditableTextField7', 'Name: (*)', '1', '1', null, '18', 1, 7, 2)
Unknown column 'CanDelete' in 'field list'
IN POST /admin/EditForm
Line 525 in /home/www/danielappleton/steel-frame.co.nz/public/sapphire/core/model/MySQLDatabase.php
Source
======
516: }
517:
518: function databaseError($msg, $errorLevel = E_USER_ERROR) {
519: // try to extract and format query
520: if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
521: $formatter = new SQLFormatter();
522: $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
523: }
524:
* 525: user_error($msg, $errorLevel);
526: }
527:
528: /**
529: * Return a boolean type-formatted string
530: *
531: * @param array $values Contains a tokenised list of info about this data type
Trace
=====
<ul>user_error(Couldn't run query:
INSERT INTO "EditableFormField_versions" ("Required", "CustomRules", "CustomSettings", "Default", "CustomErrorMessage", "LastEdited", "ClassName", "Created", "Name", "Title", "Sort", "CanDelete", "CustomParameter", "ParentID", "Version", "RecordID", "AuthorID") VALUES ('1', 'a:0:{}', 'a:5:{s:10:\"RightTitle\";s:0:\"\";s:9:\"MinLength\";s:0:\"\";s:9:\"MaxLength\";s:2:\"32\";s:4:\"Rows\";s:1:\"1\";s:10:\"ShowOnLoad\";s:4:\"Show\";}', null, null, '2012-03-16 22:06:08', 'EditableTextField', '2009-08-07 09:41:44', 'EditableTextField7', 'Name: (*)', '1', '1', null, '18', 1, 7, 2)
Unknown column 'CanDelete' in 'field list',256)
line 525 of MySQLDatabase.php
MySQLDatabase->databaseError(Couldn't run query: INSERT INTO "EditableFormField_versions" ("Required", "CustomRules", "CustomSettings", "Default", "CustomErrorMessage", "LastEdited", "ClassName", "Created", "Name", "Title", "Sort", "CanDelete", "CustomParameter", "ParentID", "Version", "RecordID", "AuthorID") VALUES ('1', 'a:0:{}', 'a:5:{s:10:\"RightTitle\";s:0:\"\";s:9:\"MinLength\";s:0:\"\";s:9:\"MaxLength\";s:2:\"32\";s:4:\"Rows\";s:1:\"1\";s:10:\"ShowOnLoad\";s:4:\"Show\";}', null, null, '2012-03-16 22:06:08', 'EditableTextField', '2009-08-07 09:41:44', 'EditableTextField7', 'Name: (*)', '1', '1', null, '18', 1, 7, 2) | Unknown column 'CanDelete' in 'field list',256)
line 123 of MySQLDatabase.php
MySQLDatabase->query(INSERT INTO "EditableFormField_versions" ("Required", "CustomRules", "CustomSettings", "Default", "CustomErrorMessage", "LastEdited", "ClassName", "Created", "Name", "Title", "Sort", "CanDelete", "CustomParameter", "ParentID", "Version", "RecordID", "AuthorID") VALUES ('1', 'a:0:{}', 'a:5:{s:10:\"RightTitle\";s:0:\"\";s:9:\"MinLength\";s:0:\"\";s:9:\"MaxLength\";s:2:\"32\";s:4:\"Rows\";s:1:\"1\";s:10:\"ShowOnLoad\";s:4:\"Show\";}', null, null, '2012-03-16 22:06:08', 'EditableTextField', '2009-08-07 09:41:44', 'EditableTextField7', 'Name: (*)', '1', '1', null, '18', 1, 7, 2))
line 583 of Database.php
SS_Database->manipulate(Array)
line 174 of DB.php
DB::manipulate(Array)
line 1048 of DataObject.php
DataObject->write()
line 335 of EditableFormField.php
EditableFormField->populateFromPostData(Array)
line 153 of FieldEditor.php
FieldEditor->saveInto(UserDefinedForm)
line 1021 of Form.php
Form->saveInto(UserDefinedForm,1)
line 683 of LeftAndMain.php
LeftAndMain->save(Array,Form,SS_HTTPRequest)
line 329 of Form.php
Form->httpSubmission(SS_HTTPRequest)
line 143 of RequestHandler.php
RequestHandler->handleRequest(SS_HTTPRequest)
line 161 of RequestHandler.php
RequestHandler->handleRequest(SS_HTTPRequest)
line 147 of Controller.php
Controller->handleRequest(SS_HTTPRequest)
line 282 of Director.php
Director::handleRequest(SS_HTTPRequest,Session)
line 125 of Director.php
Director::direct(/admin/EditForm)
line 127 of main.php
</ul>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment