UberCMS Compitable with Phoenix

[Twan]

Hello,

If i want to register i get this:
Title: Field 'temp' doesn't have a default value
Text: Field 'temp' doesn't have a default value
I use UberCMS/rCMS

Please help!

 

[Wassim]

screenie would be nice

 

[Twan]

 

[Zorn192]

Open up your users table in design mode and change column 'temp' type to 'enum' and set default value at 0

 

[Twan]

Already fixed this,
Now everytime i log in i get this error from my emulator:

MySql.Data.MySqlClient.HeaderCode (0x80004005): Data truncated for column 'login_timestamp' at row 1
bij MySql.Data.Types.EntryHash.Color()
bij MySql.Data.MySqlClient.Properties.EventPrintWhere.Handle(Int32& index, Int32& target)
bij MySql.Data.Types.EntityHeader.Owns(Int32 value, Int32& type, Int32& typeOffset)
bij MySql.Data.Types.EntityHeader.CloseInfo(Int32 max, Boolean failure)
bij MySql.Data.MySqlClient.CurrencyTagRetrieve.SetGet()
bij MySql.Data.Types.AlignmentLoadView.Parameters(CommandBehavior lib)
bij MySql.Data.Types.AlignmentLoadView.Results()
bij MySql.Data.Types.BarElement.Types(String name)
bij MySql.Data.Types.LocalFormsFilter..ctor(String color, String value, Boolean flds)
bij MySql.Data.Types.AdviseManagerAsync.Onfocusin(String option)

 

[Zorn192]

Your column should look like this

You must be registered for see links

 

[Twan]

Yes it is, but now i get this error:

MySql.Data.MySqlClient.HeaderCode (0x80004005): Data truncated for column 'login_timestamp' at row 1
bij MySql.Data.Types.EntryHash.Color()
bij MySql.Data.MySqlClient.Properties.EventPrintWhere.Handle(Int32& index, Int32& target)
bij MySql.Data.Types.EntityHeader.Owns(Int32 value, Int32& type, Int32& typeOffset)
bij MySql.Data.Types.EntityHeader.CloseInfo(Int32 max, Boolean failure)
bij MySql.Data.MySqlClient.CurrencyTagRetrieve.SetGet()
bij MySql.Data.Types.AlignmentLoadView.Parameters(CommandBehavior lib)
bij MySql.Data.Types.AlignmentLoadView.Results()
bij MySql.Data.Types.BarElement.Types(String name)
bij MySql.Data.Types.LocalFormsFilter..ctor(String color, String value, Boolean flds)
bij MySql.Data.Types.AdviseManagerAsync.Onfocusin(String option)

login_timestamp is located in the table user_info

 

[Zorn192]

Duplicate your login_timestamp column and make sure the default is 0, then delete your old login_timestamp

 

[Twan]

Hmm so i have to duplicate then set the default to 0, then delete the old login_timestamp and then i add the new one?

 

[Zorn192]

Yes, this should reset the column values

 

[Twan]

What i even can do, delete user_info table and then insert it with the new values.

In the sql code if i duplicate its:
`login_timestamp` double NOT NULL DEFAULT '0',

 

[Zorn192]

That might also fix your problem, yes. But make sure to back it up first.

 

[Twan]

I mean now its this: `login_timestamp` double NOT NULL DEFAULT '0', so it is already set to 0

 

[Zorn192]

Just delete the table and add it in again then.

 

[Twan]

I every time do that, i can play it 1 time and then i have to do it again

 

[Zorn192]

Then i would recommend reverting to a backup.

 

[Twan]

Maybe it is better to choose another CMS, know a good-one?

 

[Zorn192]

Just use RevCMS, its easy to setup and the only thing you need in the db is seckey. Or you could just delete seckey form from the register page. But if you change your CMS, i recommend you get a whole new Database.

 

[Twan]

Cant you help me with the error? Has it to be 'double' it is in the code...

 

[Zorn192]

If you mean the type has to be double, just open user_info in design mode and change login_timestamp to double,

This is how mine looks:

You must be registered for see links