Default values on install

[Brent Peterson]

Migrating modules DB structure...

[1/19] Installing FCom_Core: 0.1.2 ... 0.1.0; ^0.1.1; ^0.1.2; [2/19] Installing FCom_Cms: 0.1.3 ... 0.1.0; SQLSTATE[HY000]: General error: 1364 Field 'node_name' doesn't have a default value: REPLACE INTO fcom_cms_nav (id,id_path) VALUES (1,1)

[Brent Peterson]

I added a value to that column then moved on [1/18] Installing FCom_Cms: 0.1.3 ... *0.1.0; SQLSTATE[HY000]: General error: 1364 Field 'full_name' doesn't have a default value: REPLACE INTO fcom_cms_nav (id,id_path) VALUES (1,1)

[Brent Peterson]

Unchecking default values in db

[Brent Peterson]

ALTER TABLE sellvana.fcom_category CHANGE COLUMN sort_order sort_order INT(10) UNSIGNED NOT NULL D

[Brent Peterson]

Even after I put a default sort order I get the following error

Migrating modules DB structure...

[1/16] Installing FCom_Catalog: 0.2.16 ... *0.2.6; SQLSTATE[HY000]: General error: 1364 Field 'sort_order' doesn't have a default value: REPLACE INTO fcom_category (id,id_path) VALUES (1,1)

When I go back to look at the table it has been reverted

[Mosses Akizian]

Thanks for the report Brent. We'll take a look and get a fix out real quick.

[Boris Gurvich]

Can't reproduce it on either windows or linux installation.. is it "develop" branch?

[Boris Gurvich]

Which MySQL server version you have?

[Boris Gurvich]

I have no idea why it works on my copy :) please pull and try again.

[Brent Peterson]

This was on my mac, (apache, mysql)I will try on linux

[Boris Gurvich]

can you pull and try again with the Mac?

[Brent Peterson]

I dropped my DB and recreated and now I have a website!

[Brent Peterson]

I pulled again on develop, dropped db and recreated and now I have a website!