Re: [Fez-users] Problem Creating Community Fez 1.3 Fedora 2.2

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Hi Peter

It looks like you don't have a table in you fez db called
'workflow_sessions' and that is what is causing the problem. Eg if you go to
your your 'My Fez' link and goto the 'Active Workflows' tab you will see
this error:

Array
(
[0] => DB Error: no such table
[1] => SELECT wfses_id,wfses_date, wfses_listing FROM fez2.workflow_sessions
WHERE wfses_usr_id='1' [nativecode=1146 ** Table 'fez2.workflow_sessions'
doesn't exist]
)

include/class.workflow_status.php 531
Backtrace:

This table was in one of the upgrade scripts.. so I took the liberty of
running your updater and now you don't get that settemplatevar error
anymore. It looks like Fez/Fedora objects can now be created.

They are now showing up in the listings however. I think this may be because
you started this fez off on 1.3rc3 which was missing some config.inc.php
variables. You will need to add these (taken from a previous similar support
email): 

// these lists of roles control which roles can assume the roles of others,
e.g. the
// Community_Admin role can do all the roles an Editor can do.

@define('APP_VIEWER_ROLES',"Viewer,Community_Admin,Editor,Creator,Annotator"
);
@define('APP_EDITOR_ROLES',"Community_Admin,Editor");
@define('APP_CREATOR_ROLES',"Creator,Community_Admin,Editor");

These are in your config.inc.php-example in /setup if you want to compare
your running config.inc.php to the latest full one in the example.

If you still run into troubles after this it is probably due to some fedora
2.2 changes in other files I haven't committed to the trunk yet. I should
have them in there soon because I want to upgrade fedora on dev-repo (our
main dev server) to 2.2 today if not Monday.

Cheers,
Christiaan

On 3/5/07 10:17 PM, "Peter Lux" <pe...@ec...> wrote:

> Thanks Christiaan... I'll try that.
> 
> Just for your information on the latest trunk, in the interim I added
> the missing fields in search_keys which dealt with several of the
> issues but this is the error return if I try to create a community
> 
> "Fatal error: Call to a member function setTemplateVars() on a non-
> object in /var/www/feztrunk/workflow/enter_metadata.php on line 81"
> 
> I'm going to take a look at that but thought I would pass it along.
> 
> This is a test platform so you can see it if you care to at http://
> 137.149.66.236/feztrunk
> 
> Peter
> 
> On 3-May-07, at 1:02 AM, Christiaan Kortekaas wrote:
> 
>> Hi Peter
>> 
>> You may need to run the upgrade scripts if you are going to use the
>> latest
>> trunk. You can run them by going to http://yourfez/upgrade/index.php.
>> 
>> They database schema changes between 1.3 and 1.4 are what is
>> causing your db
>> field missing errors and the upgrade scripts add those fields etc.
>> I think
>> it still may be missing an update to the search_keys table we
>> haven't put in
>> the upgrade sql dir yet though to add a couple fields.
>> 
>> It would perhaps be safer to just use the new 2.2
>> class.fedora_api.php and
>> stay with 1.3 for now.
>> 
>> Cheers,
>> Christiaan
>> 
>> 
>> On 3/5/07 11:12 AM, "Peter Lux" <pe...@ec...> wrote:
>> 
>>> Yes, I tried trunk version 702 as well on a separate install.... same
>>> same with some other issues that  seemed approachable with the
>>> aforementioned firefighting. The main issues I was getting with trunk
>>> were invalid foreach calls and calls to non-existent db fields.
>>> Without any legacy understanding of the code development, I was left
>>> unaware if it was an issue with the code calling db fields that were
>>> now dropped or if it was a matter of renaming or creating some new db
>>> fields that got missed in the sql build.
>>> 
>>> I didn't pursue the trunk issues so posted on the "stable release
>>> version" .  I did my build following the ubuntu install directions on
>>> the wiki for fex 1.3 and fedora 2.2 and as mentioned, there are no
>>> errors showing in the sanity check so I have the sense that there is
>>> either something wrong that is not quite getting picked up in error
>>> messages. It's possible that it is a fedora issue as well but I'm not
>>> getting any errors to indicate that. I'm definitely missing
>>> something....
>>> 
>>> Since my last post, I have turned up debugging to the max on the 1.3
>>> release and still am not getting any error on the null return on a
>>> community create. Mystified.....
>>> 
>>> Thanks for the responses....every little bit helps
>>> 
>>> Peter
>>> 
>>> On 2-May-07, at 9:13 PM, Matthew Smith wrote:
>>> 
>>>> On 5/3/07, Jonathan Harker <jon...@ca...> wrote:
>>>>> As I understand it, I don't think Fez 1.3 (as released) supports
>>>>> Fedora
>>>>> 2.2, only up to 2.1. support for 2.2 is now included in the latest
>>>>> code
>>>>> from SVN, however.
>>>>> 
>>>>> Cheers,
>>>>> Jonathan.
>>>>> 
>>>> 
>>>> Of course the usual disclaimers about the untested nature of the svn
>>>> trunk apply... (Having said that, we rolled out the svn trunk to our
>>>> live UQ eSpace branch last week and it worked mostly ok after a
>>>> bit of
>>>> firefighting.)  Christiaan is also adding support for postgres
>>>> SQL as
>>>> the Fez database.
>>>> 
>>>> Matt
>>>> 
>>>> --------------------------------------------------------------------
>>>> --
>>>> ---
>>>> This SF.net email is sponsored by DB2 Express
>>>> Download DB2 Express C - the FREE version of DB2 express and take
>>>> control of your XML. No limits. Just data. Click to get it now.
>>>> http://sourceforge.net/powerbar/db2/
>>>> _______________________________________________
>>>> Fez-users mailing list
>>>> Fez...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/fez-users
>>> 
>>> 
>>> ---------------------------------------------------------------------
>>> ----
>>> This SF.net email is sponsored by DB2 Express
>>> Download DB2 Express C - the FREE version of DB2 express and take
>>> control of your XML. No limits. Just data. Click to get it now.
>>> http://sourceforge.net/powerbar/db2/
>>> _______________________________________________
>>> Fez-users mailing list
>>> Fez...@li...
>>> https://lists.sourceforge.net/lists/listinfo/fez-users
>> 
>> -- 
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Christiaan Kortekaas
>> Senior Library Systems Programmer
>> Library Technology Service
>> The University of Queensland, Australia QLD 4072
>> Telephone : (+61) (7) 3346 4337
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> 
>> 
>> 
>> ----------------------------------------------------------------------
>> ---
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> Fez-users mailing list
>> Fez...@li...
>> https://lists.sourceforge.net/lists/listinfo/fez-users
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Fez-users mailing list
> Fez...@li...
> https://lists.sourceforge.net/lists/listinfo/fez-users

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christiaan Kortekaas
Senior Library Systems Programmer
Library Technology Service
The University of Queensland, Australia QLD 4072
Telephone : (+61) (7) 3346 4337
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~