[Xerte] Can't create a New Project

Fri Oct 24 13:07:10 BST 2008

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%20t
> em 
> plate%20record%20for%20the%20database%20INSERT%20INTO%20templatedetail
> s% 
> 20(template_id,%20creator_id,%20template_type_id,%20date_created,%20da
> 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%20cr
>>>> e
>>>> ate%
>>>> 20new%20template%20record%20for%20the%20database%20INSERT%20INTO%20
>>>> t
>>>> empl
>>>> atedetails%20(template_id,%20creator_id,%20template_type_id,%20date
>>>> _
>>>> 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