27 Posts
Diegohag
7 years ago
Topic

When i try to edit an user i get mysql error i know something wrong on my fields but i can´t see what thanks 

the error is the txt

Get a VIP membership
1283 Posts
Bucklash
7 years ago
5
Level 1

Hi

Isn't it telling you that you are trying to store too much data in your db column?

You can change that in fields storage after the 'standard' 'user' 'my_storage_place' ALTER.... 


or might have to add your own value to change to in the db itself

27 Posts
Diegohag
7 years ago
4
Level 2

Thanks to answer. 

I need do an app for a builder holder. 

I have 16 buildings and 20 users by builder i put all data on table users this is the problem i try to figure how can i do this. 

The alter option What do?

If i do an app for each bulding how can i put the data on profile? i´m learning about seblod if can help i apretiate. 

1283 Posts
Bucklash
7 years ago
3
Level 3

Hi

I think you might have to check the storage sizes for all of you fields as it might be that the entire row is too large.

It might be that you can make them smaller as maybe they are all set too large, i.e. a select simple that stores only 0 or 1 can be set to 'Int (11) etc...

In the DB you can adjust these

The above image shows that storage for 'document' is a varchar(255). Maybe that could be varchar(50) instead?

Have a look, see what the values are and if they are appropriate

27 Posts
Diegohag
7 years ago
2
Level 4

Maybe sql is to for me. I put all field on text see the image. 47 fields in total 

1283 Posts
Bucklash
7 years ago
1
Level 5

Hi

No image :)

27 Posts
Diegohag
7 years ago
0
Level 6

Sorry  Here is the mage

4229 Posts
Kadministrator
7 years ago
1
Level 1

If you use text type instead of varchar you should be fine as text is stored outside column

27 Posts
Diegohag
7 years ago
0
Level 2

Finish i solve. I try many things my hosting Siteground don´t allow dinamic or compact on database i rebuild the site but always same problem. Finally i change the engine from innodb to MyISAM and put compact and solved. I don´t know if better but was a sollution for now. Thanks.

Get a VIP membership