WebGUI
      Click here to register.
      
irc://irc.freenode.net#webgui

iPhoneGuy: WebGUI is a pile of crap.
rizen: If WebGUI is such a pile of crap, why do you use it?
iPhoneGuy: Because it's the best pile of crap out there.

If this is what people who hate us are saying, imagine what people who love us will say. Come join us on IRC.


     Report a Bug > WebGUI Bug Tracker

collab problem

User susanb
Date 4/15/2008 5:28 pm
Severity Fatal (can't continue until this is resolved)
Version WebGUI Stable 7.4.33/0.8.3
Views 138
Rating 0    Rate [
|
]
Karma Rank 0.000000
Previous · Next
User Message
susanb

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

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

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

Unless you specifically tell it to not clear the cache, it will by default.



Back to Top
Rate [
|
]
 
 
susanb
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

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

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
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 [
|
]