Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2007
    Posts
    555
    Plugin Contributions
    0

    Default Problems with editing catagories etc

    I have just imported a database and have lost my old database info.

    I now get this when you go to the site

    1054 Unknown column 'categories_description_sub' in 'field list'
    in:
    [SELECT categories_description, categories_description_sub FROM categories_description WHERE categories_id= 0 AND language_id = 1]

    How do I get rid of this?

    I also can't edit categories in admin and get this message as well...

    Can anyone help?

    Thanks

  2. #2
    Join Date
    Nov 2007
    Posts
    555
    Plugin Contributions
    0

    Default Re: Problems with editing catagories etc

    http://www.ampmgraphics.com/demo/

    here it is

    can anyone help?

  3. #3
    Join Date
    Nov 2007
    Posts
    555
    Plugin Contributions
    0

    Default Re: Problems with editing catagories etc

    Oddly...I have installed the short categories patch and this has sorted out the text and images on the home page

    Does this mean that all the database text and info is somewhere out there

    Can I retrieve it???

  4. #4
    Join Date
    Nov 2007
    Posts
    555
    Plugin Contributions
    0

    Default Re: Problems with editing catagories etc

    Anyone???


  5. #5
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,269
    Plugin Contributions
    3

    Default Re: Problems with editing catagories etc

    Without knowing IN GREAT DETAIL whet you did, it is impossible to help.

    The error suggests the code is looking for a column in the database that does not exist, so you probably have some additional module code that relies on that column being present, or it was present at some point and the fact that you...

    have just imported a database and have lost my old database info
    ... means just that... you have LOST the data.

    When you say "imported a database", what exactly did you do and why?
    20 years a Zencart User

  6. #6
    Join Date
    Nov 2007
    Posts
    555
    Plugin Contributions
    0

    Default Re: Problems with editing catagories etc

    Quote Originally Posted by schoolboy View Post
    Without knowing IN GREAT DETAIL whet you did, it is impossible to help.

    The error suggests the code is looking for a column in the database that does not exist, so you probably have some additional module code that relies on that column being present, or it was present at some point and the fact that you...



    ... means just that... you have LOST the data.

    When you say "imported a database", what exactly did you do and why?
    I imported the database from my old (but current) shop site as I thought it would just add into (orders etc) that and not loose data and pages etc.

 

 

Similar Threads

  1. Problems with IH2, attributes etc
    By murphys in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 13 Sep 2009, 11:42 AM
  2. Problems with Editing products
    By lamapa516 in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 28 Aug 2008, 09:46 PM
  3. Lil problems with color etc..
    By MB1 in forum Templates, Stylesheets, Page Layout
    Replies: 8
    Last Post: 28 Jun 2006, 07:17 PM

Posting Permissions

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