Forums / Customization from the Admin / Problems with editing catagories etc

Problems with editing catagories etc

Locked

Views: 1,028

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
17 May 2010, 4:03 PM
#1
pb4 avatar

pb4

Totally Zenned

Join Date:
Nov 2007
Posts:
555
Plugin Contributions:
0

Problems with editing catagories etc

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

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

18 May 2010, 7:43 AM
#2
pb4 avatar

pb4

Totally Zenned

Join Date:
Nov 2007
Posts:
555
Plugin Contributions:
0

Re: Problems with editing catagories etc

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

here it is

can anyone help? :cry:

18 May 2010, 8:11 AM
#3
pb4 avatar

pb4

Totally Zenned

Join Date:
Nov 2007
Posts:
555
Plugin Contributions:
0

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 :dontgetit

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

Can I retrieve it??? :mellow:

18 May 2010, 2:00 PM
#4
pb4 avatar

pb4

Totally Zenned

Join Date:
Nov 2007
Posts:
555
Plugin Contributions:
0

Re: Problems with editing catagories etc

Anyone???

:(

18 May 2010, 5:22 PM
#5
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

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

19 May 2010, 9:52 AM
#6
pb4 avatar

pb4

Totally Zenned

Join Date:
Nov 2007
Posts:
555
Plugin Contributions:
0

Re: Problems with editing catagories etc

schoolboy:

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.