Injader
Forums > Help Forum > Database Error

< Show us your site! : Migrating a Wordpress blog >

Andranneth
Permalink

Created: July 27, 2008 04:18

Database Error

I am not sure if it's really only since I upgraded to 2.0, but today I saw it.
One of my Content Areas give me a Database Error when I try to view the page. Strangely, the other one is fine, and I know the area id is right - the link worked before.
I'll probably do a little testing to see if it had to do with the fact that this Content Area is the latest one that got created or something.

Here is the Error message:

Database Error

Query failed: Unknown column 'file_area_id' in 'field list'.

Your query was: SELECT id AS item_id, title, seo_title, hits AS item_count, file_area_id AS area_id FROM maj_uploads WHERE is_siteimage = 'N' AND is_avatar = 'N' ORDER BY item_count DESC LIMIT 10

Source: areacontent::popular; Line: 447


Tags: None.

Ben's avatar

Ben
Permalink


1

Created: July 27, 2008 11:48

Sorry about this, Andranneth. Looks like something I missed in the changes for version 2. Could you check the area template for that area and see if you can find any instances of the following variables:

$ cmsPopularSFC
$ cmsPopularSFD

(but without the space after the dollar symbol)

For the time being, I suggest removing those variables from your template. I'll get the problem fixed and release it as part of 2.0.1.
Andranneth's avatar

Andranneth
Permalink


2

Created: July 27, 2008 19:34

That did it. Thank you!

You do not have access to post comments in this area.