[Xerte] Xerte Version 2.5

[Patrick Lockley]

Thanks John,

Could you possibly send me (off list) a copy of your phpinfo page so I
can look at your MySQL settings.

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: 17 February 2009 12:59
To: Xerte discussion list
Subject: Re: [Xerte] Xerte Version 2.5

I found too a problem when I try create a new Project. The Xerte try use
this SQL:

INSERT INTO templatedetails (template_id, creator_id, template_type_id,
date_created, date_modified, access_to_whom, template_name,
date_accessed) VALUES ("1","110",
"5","2009-02-17","2009-02-17","Private","TestProject", "");

but it show me that templatedetails.date_accessed cannot be NULL and
templatedetails.number_of_uses too.

I changed at database to accept null and it resolved the problem and now
I can create a Project.

Kind regards,

John Mendes.

==================================
MSc John Mendes

Home Page: http://johnmendes.engsoftware.com.br
SKYPE: john_mendes
e-Mail: johnafmendes at gmail.com
MSN: johnafmendes at gmail.com
Mobile Phone (UK) +44 (0) 7873 448 701
==================================



2009/2/17 Patrick Lockley <Patrick.Lockley at nottingham.ac.uk>:
> The key ID isn't vital really in that table as the original templates 
> would hopefully be distinct
>
> I've checked with our MySQL person and I will see what I can do for 
> the next version in terms of preventing this.
>
> Thanks for letting me know.
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of John Mendes
> Sent: 17 February 2009 12:29
> To: Xerte discussion list
> Subject: Re: [Xerte] Xerte Version 2.5
>
> OK, I wrote at into database the information, although I cannot wrote 
> null at display_id. Then, I wrote 0 for both lines (template_type_id 5

> and 8).
>
> Kind regards,
>
> John Mendes.
>
> ==================================
> MSc John Mendes
>
> Home Page: http://johnmendes.engsoftware.com.br
> SKYPE: john_mendes
> e-Mail: johnafmendes at gmail.com
> MSN: johnafmendes at gmail.com
> Mobile Phone (UK) +44 (0) 7873 448 701 
> ==================================
>
>
>
> 2009/2/17 Patrick Lockley <Patrick.Lockley at nottingham.ac.uk>:
>> Hello,
>>
>> Google tells me that this error happens a lot.
>>
>> >From what I can tell -
>> http://webomania.wordpress.com/2006/10/01/out-of-range-value-adjusted
>> - fo r-column-error/ - suggests that the MySQL you are using has 
>> strict type checking, and that the 5 and 8 valunes in the insert 
>> query are appearing to the database as strings, and not as integers 
>> (which is what the table has as its type). That link has a fix on it,

>> but I am unsure of what effect that will have on your database.
>>
>> I don't know enough mysql admin to help any further unfortunately.
>>
>> Has anybody else had this problem?
>>
>> 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: 17 February 2009 11:40
>> To: Xerte discussion list
>> Subject: Re: [Xerte] Xerte Version 2.5
>>
>> Hi,
>>
>> I am installing xerte online and I found this message:
>>
>> xerte/setup/page2.php
>>
>> Sorry, The query insert into
>> `originaltemplatesdetails`(`template_type_id`,`template_framework`,`t
>> e
>> mp
>> late_name`,`description`,`date_uploaded`,`display_name`,`display_id`,
>> `
>> ac
>> cess_rights`)
>> values (5,'xerte','Nottingham','A flexible template for creating 
>> interactive learning objects.','2008-04-03','Xerte Online 
>> Toolkit','null','*'),(8,'xerte','Rss','Easily create and maintain an 
>> RSS Feed.','2008-04-02','RSS Feed','null','*') has failed. MySQL 
>> reports the following error - 1264 - Out of range value adjusted for 
>> column 'display_id' at row 1
>>
>> What could be?
>>
>> Kind regards,
>>
>> John Mendes.
>>
>> ==================================
>> MSc John Mendes
>>
>> Home Page: http://johnmendes.engsoftware.com.br
>> SKYPE: john_mendes
>> e-Mail: johnafmendes at gmail.com
>> MSN: johnafmendes at gmail.com
>> Mobile Phone (UK) +44 (0) 7873 448 701 
>> ==================================
>>
>>
>>
>> 2009/2/17 Patrick Lockley <Patrick.Lockley at nottingham.ac.uk>:
>>> Hi All,
>>>
>>> Now I should be able to answer this..... but Julian's away for a
bit.
>>>
>>> I've checked our local subversion, and there is a 2.5 installer in 
>>> the
>>
>>> websites downloads folder.
>>>
>>> Here is what's new
>>>
>>>
>>> What's new in v2.5
>>>
>>> ==============
>>>
>>> Page templates v1.0, support for toolkits v1.0
>>>
>>>
>>> So people might need to hold on just a little while, because I'm not

>>> sure if I should upload it :)
>>>
>>> Pat
>>>
>>> ________________________________
>>> From: xerte-bounces at lists.nottingham.ac.uk
>>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Peter 
>>> Huppertz
>>> Sent: 17 February 2009 08:31
>>> To: xerte at lists.nottingham.ac.uk
>>> Subject: [Xerte] Xerte Version 2.5
>>>
>>> Dear List,
>>>
>>> there is new link on the Xerte homepage to download the new version 
>>> 2.5. But I think the new Version is not uploaded/linked yet, cause 
>>> it
>
>>> seems to download the "good old" version 2.1. I also deleted my
>> browser cache ...
>>> just to make sure.
>>> Also: can you give short overview what's new in this version (I 
>>> think
>
>>> I saw a changelog somewhere in the repository)?
>>>
>>> Thanks!
>>>
>>> Peter Huppertz
>>>
>>> _______________________________________________
>>> 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