Problem With Adding New Field

[pallage]

Hello,

I'm getting a database error when I try to add a new field listing within the "Manage Listing Fields" section. I'm trying to add a new textbox and I enter the following info:

name: cname
title: Contact Name
show on pages: listing details (clicked the check box)
required: yes
field type: text
field length: 100
field value: Full Name

Regardless if I enter a defualt value or not, I get the following error message:

Error: Field 'values' doesn't have a default value
INSERT INTO `dir_link_fields` (`name`, `type`, `length`, `required`, `adminonly`, `pages`, `default`, `order`) VALUES ('contact', 'text', '100', '1', '0', '2', 'Full Name', '6')


Just wondering if anyone else know what the issue may be.

Thanks

[pallage]

Nevermind. I found the issue. I made the following change in my.ini for mysql:

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_ SUBSTITUTION"

for

sql-mode=""


It did the trick.

[Simon Gooffin]

Hi,
Welcome to our support forums. We are glad you have solved this issues yourself. Thanks for sharing the solution.

[pallage]

thanks for the welcome