Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Database issue

Quote Reply
Database issue
Hi,

I'm trying to adjust some records/sites in my website after a huge website movement/upgrade.

Everything was working fine but I just encountered an error and I don't exactly where do I need to look for...

I'm getting this message when trying to edit a record.

Code:
  • Failed to execute query: 'UPDATE lsql_Links SET Zona = ? , isPopular = ? , Status = ? , Contact_Email = ? , ExpiryDate = ? , Mod_Date = ? , ExpiryNotify = ? , Votes = ? , isChanged = ? , Date_Checked = ? , Build_Detailed_Page = ? , isGaleria = ? , URL = ? , Description = ? , Timestmp = NOW() WHERE ID = ?': Data truncated for column 'Zona' at row 1


I double check it paths and db info and everything seems to be fine.

Any ideas? Do I need to repair my table/database?

Thanks in advance for your help!
Quote Reply
Re: [Jesus] Database issue In reply to
While I'm still searching for a solution it seems there was another issue similar to this previously

https://www.gossamer-threads.com/...ks_in_admin_P184153/

Last edited by:

Jesus: May 17, 2019, 7:33 AM
Quote Reply
Re: [Jesus] Database issue In reply to
I figured out.

There was a missing value in the Zona field. That was causing the issue.