Laravel renameColumn results in an invalid SQL query
0
I am renaming a column with Laravel like so:
$table->renameColumn('salesforce_id', 'sfdc_parent_id');
This ends up with me getting a SQL that looks like this:
ALTER TABLE websites
CHANGE salesforce_id sfdc_parent_id VARCHAR(255) DEFAULT ''NULL''
The double single quotes around the NULL valid make this query invalid.
Is this a bug is is something else going wrong here? I am currently using MariaDB:
0.3.10-MariaDB Homebrew
Surprisingly enough this only happens when I reverse the migration.
What could be going on here?
mysql sql laravel laravel-5.5
asked Nov 26 '18 at 9:32
Stephan-vStephan-v
6,144850112
add a comment |
0
I am renaming a column with Laravel like so:
$table->renameColumn('salesforce_id', 'sfdc_parent_id');
This ends up with me getting a SQL that looks like this:
ALTER TABLE websites
CHANGE salesforce_id sfdc_parent_id VARCHAR(255) DEFAULT ''NULL''
The double single quotes around the NULL valid make this query invalid.
Is this a bug is is something else going wrong here? I am currently using MariaDB:
0.3.10-MariaDB Homebrew
Surprisingly enough this only happens when I reverse the migration.
What could be going on here?
mysql sql laravel laravel-5.5
asked Nov 26 '18 at 9:32
Stephan-vStephan-v
6,144850112
not sure , is this the problem. is there doctrine/dbal installed ?
– Emtiaz Zahid
Nov 26 '18 at 9:41
Did the original column have a default value?
– Jerodev
Nov 26 '18 at 10:11
Hope this link helps: https://stackoverflow.com/questions/26522292/how-can-i-rename-column-in-laravel-using-migration
– Sanjay Singh Chouhan
Nov 26 '18 at 10:11
I removed MariaDB and switched back to MySQL. There is an issue with MariaDB in combination with the renameColumn. That is why there are double single quotes around the null default. It works now. Laravel does not officially support MariaDB anyways.
– Stephan-v
Nov 26 '18 at 12:01
1
See github.com/laravel/framework/issues/22050.
– Jonas Staudenmeir
Nov 26 '18 at 12:09
add a comment |
0
0
0
0
I am renaming a column with Laravel like so:
$table->renameColumn('salesforce_id', 'sfdc_parent_id');
This ends up with me getting a SQL that looks like this:
ALTER TABLE websites
CHANGE salesforce_id sfdc_parent_id VARCHAR(255) DEFAULT ''NULL''
The double single quotes around the NULL valid make this query invalid.
Is this a bug is is something else going wrong here? I am currently using MariaDB:
0.3.10-MariaDB Homebrew
Surprisingly enough this only happens when I reverse the migration.
What could be going on here?
mysql sql laravel laravel-5.5
asked Nov 26 '18 at 9:32
Stephan-vStephan-v
6,144850112
I am renaming a column with Laravel like so:
$table->renameColumn('salesforce_id', 'sfdc_parent_id');
This ends up with me getting a SQL that looks like this:
ALTER TABLE websites
CHANGE salesforce_id sfdc_parent_id VARCHAR(255) DEFAULT ''NULL''
The double single quotes around the NULL valid make this query invalid.
Is this a bug is is something else going wrong here? I am currently using MariaDB:
0.3.10-MariaDB Homebrew
Surprisingly enough this only happens when I reverse the migration.
What could be going on here?
mysql sql laravel laravel-5.5
mysql sql laravel laravel-5.5
asked Nov 26 '18 at 9:32
Stephan-vStephan-v
6,144850112
asked Nov 26 '18 at 9:32
Stephan-vStephan-v
6,144850112
asked Nov 26 '18 at 9:32
Stephan-vStephan-v
6,144850112
asked Nov 26 '18 at 9:32
Stephan-vStephan-v
6,144850112
asked Nov 26 '18 at 9:32
Stephan-vStephan-v
6,144850112
6,144850112
not sure , is this the problem. is there doctrine/dbal installed ?
– Emtiaz Zahid
Nov 26 '18 at 9:41
Did the original column have a default value?
– Jerodev
Nov 26 '18 at 10:11
Hope this link helps: https://stackoverflow.com/questions/26522292/how-can-i-rename-column-in-laravel-using-migration
– Sanjay Singh Chouhan
Nov 26 '18 at 10:11
I removed MariaDB and switched back to MySQL. There is an issue with MariaDB in combination with the renameColumn. That is why there are double single quotes around the null default. It works now. Laravel does not officially support MariaDB anyways.
– Stephan-v
Nov 26 '18 at 12:01
1
See github.com/laravel/framework/issues/22050.
– Jonas Staudenmeir
Nov 26 '18 at 12:09
add a comment |
not sure , is this the problem. is there doctrine/dbal installed ?
– Emtiaz Zahid
Nov 26 '18 at 9:41
Did the original column have a default value?
– Jerodev
Nov 26 '18 at 10:11
Hope this link helps: https://stackoverflow.com/questions/26522292/how-can-i-rename-column-in-laravel-using-migration
– Sanjay Singh Chouhan
Nov 26 '18 at 10:11
I removed MariaDB and switched back to MySQL. There is an issue with MariaDB in combination with the renameColumn. That is why there are double single quotes around the null default. It works now. Laravel does not officially support MariaDB anyways.
– Stephan-v
Nov 26 '18 at 12:01
1
See github.com/laravel/framework/issues/22050.
– Jonas Staudenmeir
Nov 26 '18 at 12:09
not sure , is this the problem. is there doctrine/dbal installed ?
– Emtiaz Zahid
Nov 26 '18 at 9:41
not sure , is this the problem. is there doctrine/dbal installed ?
– Emtiaz Zahid
Nov 26 '18 at 9:41
Did the original column have a default value?
– Jerodev
Nov 26 '18 at 10:11
Did the original column have a default value?
– Jerodev
Nov 26 '18 at 10:11
Hope this link helps: https://stackoverflow.com/questions/26522292/how-can-i-rename-column-in-laravel-using-migration
– Sanjay Singh Chouhan
Nov 26 '18 at 10:11
Hope this link helps: https://stackoverflow.com/questions/26522292/how-can-i-rename-column-in-laravel-using-migration
– Sanjay Singh Chouhan
Nov 26 '18 at 10:11
I removed MariaDB and switched back to MySQL. There is an issue with MariaDB in combination with the renameColumn. That is why there are double single quotes around the null default. It works now. Laravel does not officially support MariaDB anyways.
– Stephan-v
Nov 26 '18 at 12:01
I removed MariaDB and switched back to MySQL. There is an issue with MariaDB in combination with the renameColumn. That is why there are double single quotes around the null default. It works now. Laravel does not officially support MariaDB anyways.
– Stephan-v
Nov 26 '18 at 12:01
1
1
See github.com/laravel/framework/issues/22050.
– Jonas Staudenmeir
Nov 26 '18 at 12:09
See github.com/laravel/framework/issues/22050.
– Jonas Staudenmeir
Nov 26 '18 at 12:09
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53478152%2flaravel-renamecolumn-results-in-an-invalid-sql-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53478152%2flaravel-renamecolumn-results-in-an-invalid-sql-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
not sure , is this the problem. is there doctrine/dbal installed ?
– Emtiaz Zahid
Nov 26 '18 at 9:41
Did the original column have a default value?
– Jerodev
Nov 26 '18 at 10:11
Hope this link helps: https://stackoverflow.com/questions/26522292/how-can-i-rename-column-in-laravel-using-migration
– Sanjay Singh Chouhan
Nov 26 '18 at 10:11
I removed MariaDB and switched back to MySQL. There is an issue with MariaDB in combination with the renameColumn. That is why there are double single quotes around the null default. It works now. Laravel does not officially support MariaDB anyways.
– Stephan-v
Nov 26 '18 at 12:01
1
See github.com/laravel/framework/issues/22050.
– Jonas Staudenmeir
Nov 26 '18 at 12:09