Hello.
Yesterday I upgraded my server with Emoncms following the guide, and now I have a problem in the database:
>Todo: - These changes need to be applied
>database schema
>ALTER TABLE `input` ADD `record` tinyint (1) NOT NULL DEFAULT''
I do not work any more input, but I have access to old data.
I have tried several times to update the database, with this result:
>Success: - Following the changes not have been applied
>database schema
>ALTER TABLE `input` ADD `record` tinyint (1) NOT NULL DEFAULT''
but if I try to access my back getting this error:
>Todo: - These changes need to be applied
>database schema
>ALTER TABLE `input` ADD `record` tinyint (1) NOT NULL DEFAULT''
How can I fix??
Re: SOLVED: Database error after upgrade
Im not sure why its not running, can you login to mysql on your machine and run ALTER TABLE `input` ADD `record` tinyint (1) NOT NULL DEFAULT '' manually?
or you could try:
ALTER TABLE `input` ADD `record` tinyint(1) DEFAULT 0
Re: SOLVED: Database error after upgrade
Hello Tristan.
I login into mySQL from the command line, and I sent:
USE emoncms;
ALTER TABLE `input` ADD `record` tinyint (1) DEFAULT 0;
ALTER TABLE MODIFY input `record` tinyint (1) DEFAULT 0;
Now it works.
Thank you very much.
Re: SOLVED: Database error after upgrade
Great good to hear