September 26, 2006
Settings Update Error
Uncategorized
6 Comments
Comersus Version: 705
Database type: Access
Frequency: Permanent issue
I was trying to update the store configuration settings (specifically our 'company slogan') and I received this message:
Details: Update Error in comersus_backoffice_settingsModifyExec.asp, error: [Microsoft][ODBC Microsoft Access Driver] Field 'settings.settingValue' cannot be a zero-length string. – Err.Number:-2147467259 – SQL:UPDATE settings SET settingValue='0' WHERE idSetting=201
6 Comments
Hi,
Make sure that you did not modify the BackOffice scripts. It seems that certain required setting is left empty. If you want to disable certain feature, just set as 0 (false)
[Reply]
The only Backofficelite file I tried to update was the _showorder.asp file so we could see a few extra fields on that page. Otherwise the Backofficelite files are intact. Setting #201 in our configuration is the SecureStoreGraph setting, which is set to 0. I don't know what other Backofficelite file I could look at to see how the configuration settings are being affected.
[Reply]
Hi,
Please login to backofficelite and go to Utilities > Settings
Look for an empty setting and fill that field with some value.
Then try to save those settings to see if the error appears again.
[Reply]
The only fields left blank were: pAffiliateBanner1, pAffiliateBanner2, pAmazonDevKey, pAmazonAssociateKey. I put 0's in each one from the Utilities/Settings menu, but I keep getting this error:
Details: Update Error in comersus_backoffice_settingsModifyExec.asp, error: [Microsoft][ODBC Microsoft Access Driver] Field 'settings.settingValue' cannot be a zero-length string. – Err.Number:-2147467259 – SQL:UPDATE settings SET settingValue='0' WHERE idSetting=167
When I look at the Settings table in the database, though, the 0's all 'took' and were showing up in the fields I listed above, except for pAmazonDevKey, which was still blank.
Also, I am ready to upgrade to BackOfficePlus, so if you think that might help fix things I can install that. I was waiting to install it until everything's on the cart.
[Reply]
Hi,
Are you using Ms-Access right?
If you're able to open the settings table in database, go to design view of table settings and set "Allow zero length" to YES on settingValue field.
Upgrading to backoffice plus will give you other functionalities and tools to maintain and improve your store capabilities.
[Reply]
Yay! That did it! We have a working BackofficeLite, ready to update to Plus!
Thanks!
[Reply]