[Xerte] Can't create a New Project

[Patrick Lockley]

Not a problem, let me know if you have any other problems.

Thanks

Pat 

-----Original Message-----
From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of John Mendes
Sent: 24 October 2008 14:42
To: Xerte discussion list
Subject: Re: [Xerte] Can't create a New Project

Sorry, you right, maybe because of http.conf I had problems. I did the
configuration after or later and because that I had others results.

Thanks a lot.

Kind regards,

John Mendes.



2008/10/24 Patrick Lockley <Patrick.Lockley at nottingham.ac.uk>:
> Hi John,
>
> The http.conf shouldn't affect anything.
>
> As for the tables - they always have a value - I never put a NULL in 
> any field.
>
> Pat
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of John Mendes
> Sent: 23 October 2008 13:56
> To: Xerte discussion list
> Subject: Re: [Xerte] Can't create a New Project
>
> Hi Patrick,
>
> I found my mistake. I give allow in http.conf to write at xeter folder
>
> <Directory "E:/Apache/htdocs/xerte" >
>    Options Indexes FollowSymLinks
>    AllowOverride All
>    Order allow,deny
>    Allow from all
> </Directory>
>
> When I try create a new project, the SQL try write NULL at a 
> field/column that deny NOT NULL (templatedetails.number_of_uses and 
> templatedetails.date_accessed). Then, I changed it to allow NULL
>
> I changed at SQL (basic.sql), maybe you need confirm if I did right, 
> because for me it does works now.
>
> Thanks Patrick,
>
> Kind regards,
>
> John Mendes.
>
>
>
> 2008/10/23 Patrick Lockley <Patrick.Lockley at nottingham.ac.uk>:
>> Hello,
>>
>> Fixed the upload (thank you).
>>
>> The message you are seeing is an echo from the code in 
>> website_code/php/templates/new_template.php
>>
>> So on your configuration (lines 48-49 of the above file)
>>
>> $query_for_template_rights = "INSERT INTO " .
>> $site->database_table_prefix . "templaterights 
>> (template_id,user_id,role, folder) VALUES (\"" .
>> ($maximum_template_id+1) . "\",\"" .  $_SESSION['login_id'] . "\", 
>> \"creator\" ,\"" . $row_root['folder_id'] . "\")";
>>
>> Hasn't worked, or has returned a false value.
>>
>> Given the values below try running the query automatically on your 
>> database
>>
>> INSERT INTO
>> templatedetails(template_id,creator_id,template_type_id,date_created,
>> d
>> at
>> e_modified,access_to_whom,template_name) VALUES
>> ("1","112","8","2008-10-23","2008-10-23","Private","hhhh")
>>
>> Could you check your database as well to see if the templatedetails 
>> table has been modified by the query before this one.
>>
>> I'm away for a day after 12:30 GMT so won't be available till 
>> tomorrow
>
>> afternoon.
>>
>> Thanks
>>
>> Pat
>>
>> -----Original Message-----
>> From: xerte-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of John 
>> Mendes
>> Sent: 23 October 2008 11:30
>> To: Xerte discussion list
>> Subject: Re: [Xerte] Can't create a New Project
>>
>> Patrick,
>>
>> I reinstall but the problem is still there. I can't create a new 
>> project.
>>
>> Forbidden
>>
>> You don't have permission to access /xerte/*edit_FAILED-Failed to 
>> create new template record for the database INSERT INTO 
>> templatedetails (template_id, creator_id, template_type_id, 
>> date_created, date_modified, access_to_whom, template_name) VALUES 
>> ("1","112",
>> "8","2008-10-23","2008-10-23","Private","hhhh") on this server.
>>
>>
>> http://website.ac.uk/xerte/*edit_FAILED-Failed%20to%20create%20new%20
>> t
>> em
>> plate%20record%20for%20the%20database%20INSERT%20INTO%20templatedetai
>> l
>> s%
>> 20(template_id,%20creator_id,%20template_type_id,%20date_created,%20d
>> a
>> te
>>
>
_modified,%20access_to_whom,%20template_name)%20VALUES%20("1","112",%20"
>> 8","2008-10-23","2008-10-23","Private","hhhh")
>>
>> Kind regards,
>>
>> John Mendes.
>>
>>
>>
>> 2008/10/23 John Mendes <johnafmendes at gmail.com>:
>>> Patrick,
>>>
>>> your zip file has a mistake. You put a new version inside of the 
>>> test
>
>>> folder and now there is a two version in the same zip file.
>>>
>>>
>>> Kind regards,
>>>
>>> John Mendes.
>>>
>>>
>>>
>>> 2008/10/23 John Mendes <johnafmendes at gmail.com>:
>>>> Hi,
>>>>
>>>> thanks, I will reinstall again.
>>>>
>>>> Kind regards,
>>>>
>>>> John Mendes.
>>>>
>>>>
>>>>
>>>>
>>>> 2008/10/23 Patrick Lockley <Patrick.Lockley at nottingham.ac.uk>:
>>>>> New version uploaded if you wish to reinstall.
>>>>>
>>>>> -----Original Message-----
>>>>> From: xerte-bounces at lists.nottingham.ac.uk
>>>>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Patrick

>>>>> Lockley
>>>>> Sent: 23 October 2008 10:29
>>>>> To: Xerte discussion list
>>>>> Subject: RE: [Xerte] Can't create a New Project
>>>>>
>>>>> Hi John,
>>>>>
>>>>> Sorry bug in the code / everyone with an install at present.
>>>>>
>>>>> Please check the following files.
>>>>>
>>>>> Website_code/scripts/javascript_library.js
>>>>>
>>>>> Change var site_url to be your site's url
>>>>>
>>>>> Webbsite_code/scripts/properties_tab.js
>>>>>
>>>>> Change iframe src ="http://ltdev......
>>>>>
>>>>> To iframe src=" to your url
>>>>>
>>>>> Sincere apologises all
>>>>>
>>>>> Pat
>>>>>
>>>>> -----Original Message-----
>>>>> From: xerte-bounces at lists.nottingham.ac.uk
>>>>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of John 
>>>>> Mendes
>>>>> Sent: 23 October 2008 09:47
>>>>> To: xerte at lists.nottingham.ac.uk
>>>>> Subject: [Xerte] Can't create a New Project
>>>>>
>>>>> Hi all,
>>>>>
>>>>> I did download yesterday 22/10/2008 of xerte, and when I tried to 
>>>>> create a new project or new rss feed I had received a message:
>>>>>
>>>>> Forbidden
>>>>>
>>>>> You don't have permission to access /toolkits/edit_FAILED-Failed 
>>>>> to
>
>>>>> create new template record for the database INSERT INTO 
>>>>> templatedetails (template_id, creator_id, template_type_id, 
>>>>> date_created, date_modified, access_to_whom, template_name) VALUES

>>>>> ("1","112",
>>>>> "5","2008-10-23","2008-10-23","Private","ss") on this server.
>>>>> Apache/1.3.31 Server at ltdev.nottingham.ac.uk Port 80
>>>>>
>>>>> But I don't understand why try post at LTDEV.NOTTINGHAM.AC.UK ?
>>>>>
>>>>> http://ltdev.nottingham.ac.uk/toolkits/edit_FAILED-Failed%20to%20c
>>>>> r
>>>>> e
>>>>> ate%
>>>>> 20new%20template%20record%20for%20the%20database%20INSERT%20INTO%2
>>>>> 0
>>>>> t
>>>>> empl
>>>>> atedetails%20(template_id,%20creator_id,%20template_type_id,%20dat
>>>>> e
>>>>> _
>>>>> crea
>>>>>
>>
>
ted,%20date_modified,%20access_to_whom,%20template_name)%20VALUES%20("1"
>>>>> ,"112",%20"5","2008-10-23","2008-10-23","Private","ss")
>>>>>
>>>>> Someone could be help me please?
>>>>>
>>>>> Kind regards,
>>>>>
>>>>> John Mendes.
>>>>> _______________________________________________
>>>>> Xerte mailing list
>>>>> Xerte at lists.nottingham.ac.uk
>>>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>>> _______________________________________________
>>>>> Xerte mailing list
>>>>> Xerte at lists.nottingham.ac.uk
>>>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>>> _______________________________________________
>>>>> Xerte mailing list
>>>>> Xerte at lists.nottingham.ac.uk
>>>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>>>
>>>>
>>>
>> _______________________________________________
>> Xerte mailing list
>> Xerte at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>> _______________________________________________
>> Xerte mailing list
>> Xerte at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte