|
Previous
·
Next
|
susanb
|
Date: 4/15/2008 5:28 pm · Subject: collab problem · Rating: 0
I'm working on my upgrade process and inadvertantly took my test site to 7.4.33. When I went to check the site, my collab system was giving a problem with request. The webgui log had this in it: FATAL - mysite - main::[[undef]] - Couldn't execute prepared statement: SELECT SQL_CALC_FOUND_ROWS asset.assetId, asset.className, assetData.revisionDate as revisionDate from Thread left join asset on Thread.assetId=asset.assetId left join Post on Post.assetId=Thread.assetId and Thread.revisionDate = Post.revisionDate left join assetData on assetData.assetId=Thread.assetId and Thread.revisionDate = assetData.revisionDate where asset.parentId='kIJjAYgZizu8RjypIZ1V1w' and asset.state='published' and asset.className='WebGUI::Asset::Post::Thread' and assetData.revisionDate=( select max(revisionDate) from assetData where assetData.assetId=asset.assetId and (status='approved' or status='archived') ) and status='approved' group by assetData.assetId order by Thread.isSticky desc, `dateUpdated` desc LIMIT 0,30 : With place holders: . Root cause: Unknown column 'dateUpdated' in 'order clause'
I backed out the change and then only upgraded to 7.3.32, and did not have the problem. I haven't had a chance to attempt to duplicate the problem, so I'm not sure if it is specific to my site or more general. Susan B
|
| Back to Top |
Rate [ | ]
|
| |
Graham
|
Date: 4/22/2008 10:23 am · Subject: Re: collab problem · Rating: 0
This is likely either a problem with your user session, or the collaboration system. Nothing has changed with that code recently though that would trigger such a problem on upgrade.
What version were you upgrading from?
|
| Back to Top |
Rate [ | ]
|
| |
susanb
|
Date: 4/22/2008 12:30 pm · Subject: Re: collab problem · Rating: 0
I was upgrading from 7.3.22.
--Susan
On Apr 22, 2008, at 8:24 AM, wrote:
>
> Graham has posted to one of your subscriptions
> http://www.plainblack.com/bugs/tracker/collab-problem/1
> This is likely either a problem with your user session, or the
> collaboration system. Nothing has changed with that code recently
> though that would trigger such a problem on upgrade.
>
> What version were you upgrading from?
>
>
>
> Unsubscribe
>
>
>
> --
>
> Plain Black, makers of WebGUI
> http://plainblack.com
|
| Back to Top |
Rate [ | ]
|
| |
susanb
|
Date: 4/24/2008 4:26 pm · Subject: Re: collab problem · Rating: 0
Figured out what it was. The old query with dateUpdated was in the cache. Clearing the cache fixed the problem. Please make clearing the File cache (the one that the button in the admin console clears) part of upgrade.pl.
Susan B
|
| Back to Top |
Rate [ | ]
|
| |
Graham
|
Date: 4/28/2008 3:21 pm · Subject: Re: collab problem · Rating: 0
Unless you specifically tell it to not clear the cache, it will by default.
|
| Back to Top |
Rate [ | ]
|
| |
susanb
|
Date: 4/28/2008 4:00 pm · Subject: Re: collab problem · Rating: 0
Hmmm, then I suspect it's a bug, cuz it didn't (multiple times). Does
the cache clearing in the upgrade script do the exact same cache
cleaning as the button in the admin console?
--Susan
On Apr 28, 2008, at 1:21 PM, wrote:
>
> Graham has posted to one of your subscriptions
> http://www.plainblack.com/bugs/tracker/collab-problem/4
> Unless you specifically tell it to not clear the cache, it will by
> default.
>
>
>
> Unsubscribe
>
>
>
> --
>
> Plain Black, makers of WebGUI
> http://plainblack.com
|
| Back to Top |
Rate [ | ]
|
| |
susanb
|
Date: 5/2/2008 4:47 pm · Subject: Re: collab problem · Rating: 0
This is definitely a bug. The upgrade script is not clearing the cache. After upgrading from 7.3.22 to 7.4.32 on multiple sites/databases, I've had to immediately go into the admin console and manually clear the cache to get multiple collabs to not display an error.
|
| Back to Top |
Rate [ | ]
|
| |
Graham
|
Date: 5/7/2008 2:44 am · Subject: Re: collab problem · Rating: 0
Did the upgrade script say it was deleting the cache?
How it your cache configured? Does it use the file cache or the database cache? If the file cache, is the cache path specified in the config file?
|
| Back to Top |
Rate [ | ]
|
| |
susanb
|
Date: 5/7/2008 11:45 am · Subject: Re: collab problem · Rating: 0
My sites use
"cacheType" : "WebGUI::Cache::FileCache"
From my upgrade run:
Getting site configs...
Processing edleadership.csuprojects.org.conf.
Preparing site for upgrade.
Deleting temp files.
Deleting file cache.
There is no cache path specified in the config file. (nor in
WebGUI.conf.original). This particular site was created in 7.3.x. The
cache is in the default location of /tmp/WebGUIcache. I don't think
any of my 20+ sites have a cache path because this is the first time
I've heard of it.
I have a full typescript of the upgrade session as well if it would be
helpful.
--Susan
On May 7, 2008, at 12:44 AM, wrote:
>
> Graham has posted to one of your subscriptions
> http://www.plainblack.com/bugs/tracker/collab-problem/7
> Did the upgrade script say it was deleting the cache?
>
> How it your cache configured? Does it use the file cache or the
> database cache? If the file cache, is the cache path specified in
> the config file?
>
>
>
> Unsubscribe
>
>
>
> --
>
> Plain Black, makers of WebGUI
> http://plainblack.com
|
| Back to Top |
Rate [ | ]
|
| |