Results 1 to 7 of 7

Hybrid View

  1. #1
    Join Date
    Sep 2010
    Posts
    434
    Plugin Contributions
    0

    Default About to give up

    Well, I have had enough.... 2 months developing (locally) beat my way though Zen and started to fall in love..... Then today I want to add an new catagory and get the following:

    1364 Field 'categories_description_sub' doesn't have a default value
    in:
    [insert into categories_description (categories_name, categories_description, categories_id, language_id) values ('Test', '
    Delete me

    ', '47', '1')]

    I have fallen back to the earliest DB backup but still get the same. I'm on 9h

    Any suggestions??? some days I love Zen and others......

  2. #2
    Join Date
    Jul 2005
    Location
    Upstate NY
    Posts
    22,010
    Plugin Contributions
    25

    Default Re: About to give up

    "Field 'categories_description_sub' doesn't have a default value"
    means that there is not a default value for that field, so you must enter a value for it when creating a new record in the db.

    What method were you using to create the new category?

  3. #3
    Join Date
    Sep 2010
    Posts
    434
    Plugin Contributions
    0

    Default Re: About to give up

    Hi gjh42
    Thanks for the reply but no wiser... New Zenner,
    All Im using is ADMIN - ADD CATAGORY

    I can add products Etc and site works ok.

    Please give me a simple solution if poss... ad I really don't want to start over.

  4. #4
    Join Date
    Sep 2010
    Posts
    434
    Plugin Contributions
    0

    Default Re: About to give up

    Really do need help with this...
    I did put an add on and cant recall its name but gave option if two descriptions if an help.

  5. #5
    Join Date
    Jul 2005
    Location
    Upstate NY
    Posts
    22,010
    Plugin Contributions
    25

    Default Re: About to give up

    OK, that would most likely be "Product extra fields", which will add a new field to the database. Is it operating for you now? If not, there would be no entry field in admin, but the database would still have the field which needs feeding. There should be a support thread for the mod in the forum.

  6. #6
    Join Date
    Sep 2010
    Posts
    434
    Plugin Contributions
    0

    Default Re: About to give up

    Thanks very much for you pointer and help.... it was "Short Description for Categories " I re-installed and all works now... Thankyou. Don't know if I'll use it but read somwhere it played a part in SEO so hay-ho!
    Out of interest how would I remove it safely?

 

 

Similar Threads

  1. Before I Give Up
    By realizingthedream in forum General Questions
    Replies: 13
    Last Post: 25 May 2008, 01:20 PM
  2. Ok I give up.
    By raindark in forum General Questions
    Replies: 2
    Last Post: 1 Mar 2007, 07:33 PM
  3. OK you win, I give in!
    By hive man in forum General Questions
    Replies: 1
    Last Post: 10 Jan 2007, 02:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •