[Xerte] Xerte Version 2.5

[Patrick Lockley]

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`,`te
> 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