Database Error on sql Install script
dan1dyoung
I have posted in the alpha2 release post but there were a few error in
the sql install script, most have been fixed in the latest nightly but
one has escaped:
#1101 - BLOB/TEXT column 'manifest_cache' can't have a default value
on table extensions.
Thanks
Dan
dan1dyoung
Sam Moffatt
with those changes in and I didn't have an issue. Will have to revisit
it.
Sam Moffatt
http://pasamio.id.au
>
> You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> To post to this group, send an email to joomla-...@googlegroups.com.
> To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/joomla-dev-cms?hl=en-GB.
>
>
>
dan1dyoung
Running on XP/Xampp with MySql Server version: 5.1.36-community
Dan
On 16 Dec, 04:51, Sam Moffatt <pasa...@gmail.com> wrote:
> What version of MySQL are you using? I did a test run the other day
> with those changes in and I didn't have an issue. Will have to revisit
> it.
>
>
>
> On Wed, Dec 16, 2009 at 10:03 AM, dan1dyoung <dan...@dysolutions.co.uk> wrote:
> > Sorry, on the latest nightly (Using Rev 13746).
>
> > On 15 Dec, 23:59, dan1dyoung <dan...@dysolutions.co.uk> wrote:
> >> Hi,
>
> >> I have posted in the alpha2 release post but there were a few error in
> >> the sql install script, most have been fixed in the latest nightly but
> >> one has escaped:
>
> >> #1101 - BLOB/TEXT column 'manifest_cache' can't have a default value
>
> >> on table extensions.
>
> >> Thanks
>
> >> Dan
>
> > --
>
> > You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> > To post to this group, send an email to joomla-...@googlegroups.com.
> > To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
>
> - Show quoted text -
dan1dyoung
Just installed using IIS (Tried the new installer for Joomla and then
aded 1.6 after) this time rather than xampp and just downloaded the
latest nightly (13851) but still get the error on install for the
database. It creates 35 tables but NOT extensions.
Server version: 5.1.41-community
Microsoft-IIS/5.1
MySQL client version: 5.0.51a
PHP extension: mysql
Thanks
Dan
On 15 Dec, 20:51, Sam Moffatt <pasa...@gmail.com> wrote:
> What version of MySQL are you using? I did a test run the other day
> with those changes in and I didn't have an issue. Will have to revisit
> it.
>
> Sam Moffatthttp://pasamio.id.au
>
>
>
> On Wed, Dec 16, 2009 at 10:03 AM, dan1dyoung <dan...@dysolutions.co.uk> wrote:
> > Sorry, on the latest nightly (Using Rev 13746).
>
> > On 15 Dec, 23:59, dan1dyoung <dan...@dysolutions.co.uk> wrote:
> >> Hi,
>
> >> I have posted in the alpha2 release post but there were a few error in
> >> the sql install script, most have been fixed in the latest nightly but
> >> one has escaped:
>
> >> #1101 - BLOB/TEXT column 'manifest_cache' can't have a default value
>
> >> on table extensions.
>
> >> Thanks
>
> >> Dan
>
> > --
>
> > You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> > To post to this group, send an email to joomla-...@googlegroups.com.
> > To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
Sam Moffatt
MySQL has a change that breaks it? Might be useful for some other
stuff.
Sam Moffatt
http://pasamio.id.au
dan1dyoung
Not sure what you require but detail it and i will do my best, do you
mean roll back to older versions one by one until it works??
If so, what is the best way to do this cleanly??
Dan
On 26 Dec, 05:38, Sam Moffatt <pasa...@gmail.com> wrote:
> Do you mind doing some quick regressions to work out which version of
> MySQL has a change that breaks it? Might be useful for some other
> stuff.
>
> Sam Moffatthttp://pasamio.id.au
> >> > For more options, visit this group athttp://groups.google.com/group/joomla-dev-cms?hl=en-GB.-Hide quoted text -
Gergo Erdosi
I think this line causes your issue:
`manifest_cache` TEXT NOT NULL DEFAULT '',
Can you please try running the query again by replacing it with the line below?
`manifest_cache` TEXT NOT NULL,
---
Gergo Erdosi
dan1dyoung
Yes, as above this is the problem (Was on more tables but Andrew
updated them so they now work) but extensions still has the default
and causes the issue.
If i fix this and run manualy i then get the next problem as
http://groups.google.com/group/joomla-dev-cms/browse_thread/thread/522a9912c7e992d7?hl=en-GB
(Have not re-tested this on the latest nightly yet).
Dan
> >>>>> For more options, visit this group athttp://groups.google.com/group/joomla-dev-cms?hl=en-GB.-Hidequoted text -
Sam Moffatt
where MySQL have changed their code to make it a fatal error or
similar so that we can pull up the docs to see what else they changed.
Don't need to run through every version, just pick randomly versions
prior to what you have until you find one that works and then you go
for the middle version between a known working and a known breaking
and you can easily identify which release broke it and we can check
out the release notes for that release.
Sam Moffatt
http://pasamio.id.au
Gergo Erdosi
"On MS Windows the "no DEFAULT" rule is an error, while on other platforms it is often a warning. While not a bug, it's possible to get trapped by this if you write code on a lenient platform, and later run it on a strict platform:"
I think that's why some people get this error while others not.
---
Gergo Erdosi
Sam Moffatt
behaviour, strangeness!
Sam Moffatt
http://pasamio.id.au
dan1dyoung
I will hold off testing other version then. Also, there was DEFAULT
BLOB on other tables but Andrew then removed them so can this not be
removed??
Dan
On 27 Dec, 03:50, Sam Moffatt <pasa...@gmail.com> wrote:
> Ok, well thats interesting to know then. I wonder why they'd change
> behaviour, strangeness!
>
> Sam Moffatthttp://pasamio.id.au
>
>
>
> On Sun, Dec 27, 2009 at 8:22 PM, Gergo Erdosi <ge...@joomline.org> wrote:
> > I'm not really sure it's related to a specific MySQL version and above, but more likely to the platform MySQL is running on. In the reference (http://dev.mysql.com/doc/refman/5.0/en/blob.html) there is a comment which says:
>
> > "On MS Windows the "no DEFAULT" rule is an error, while on other platforms it is often a warning. While not a bug, it's possible to get trapped by this if you write code on a lenient platform, and later run it on a strict platform:"
>
> > I think that's why some people get this error while others not.
>
> > ---
> > Gergo Erdosi
>
> > On 27 Dec 2009, at 01:20, Sam Moffatt wrote:
>
> >> Yes, that is what is causing the issue, I'm just trying to work out
> >> where MySQL have changed their code to make it a fatal error or
> >> similar so that we can pull up the docs to see what else they changed.
> >> Don't need to run through every version, just pick randomly versions
> >> prior to what you have until you find one that works and then you go
> >> for the middle version between a known working and a known breaking
> >> and you can easily identify which release broke it and we can check
> >> out the release notes for that release.
>
> >> Sam Moffatt
> >>http://pasamio.id.au
>
> >> On Sun, Dec 27, 2009 at 7:00 AM, dan1dyoung <dan...@dysolutions.co.uk> wrote:
> >>> Hi Gergo,
>
> >>> Yes, as above this is the problem (Was on more tables but Andrew
> >>> updated them so they now work) but extensions still has the default
> >>> and causes the issue.
>
> >>> If i fix this and run manualy i then get the next problem as
> >>>http://groups.google.com/group/joomla-dev-cms/browse_thread/thread/52...
> >>>>>>>>> For more options, visit this group athttp://groups.google.com/group/joomla-dev-cms?hl=en-GB.-Hidequotedtext -
>
> >>>>>>>> - Show quoted text -
>
> >>>>>>> --
>
> >>>>>>> You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> >>>>>>> To post to this group, send an email to joomla-...@googlegroups.com.
> >>>>>>> To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
> >>>>>>> For more options, visit this group athttp://groups.google.com/group/joomla-dev-cms?hl=en-GB.-Hidequoted text -
>
> >>>>>> - Show quoted text -
>
> >>>>> --
>
> >>>>> You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> >>>>> To post to this group, send an email to joomla-...@googlegroups.com.
> >>>>> To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
> >>>>> For more options, visit this group athttp://groups.google.com/group/joomla-dev-cms?hl=en-GB.-Hide quoted text -
>
> >>>> - Show quoted text -
>
> >>> --
>
> >>> You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> >>> To post to this group, send an email to joomla-...@googlegroups.com.
> >>> To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
> >>> For more options, visit this group athttp://groups.google.com/group/joomla-dev-cms?hl=en-GB.
>
> >> --
>
> >> You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> >> To post to this group, send an email to joomla-...@googlegroups.com.
> >> To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
> >> For more options, visit this group athttp://groups.google.com/group/joomla-dev-cms?hl=en-GB.
>
> > --
>
> > You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> > To post to this group, send an email to joomla-...@googlegroups.com.
> > To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
Sam Moffatt
causing an error. It is one thing to remove a symptom of a problem but
if you don't realise what the cause is you're potentially doomed to
make the same mistake again. But now we know its a Windows specific
behaviour (for some reason).
Sam Moffatt
http://pasamio.id.au
dan1dyoung
Totally agree and was not pushing to change without knowing why but
wondered if Andrew already knew the answer as he removed it from the
other tables, i have just reloaded the new nightly (13865) with this
change and now it works.
It does not move and rename the config file for me (On windows so did
not set the FTP part up) and the file still has the ; missing as
reported here http://groups.google.com/group/joomla-dev-cms/browse_thread/thread/3f7d907740e7f799
Also the template does not look correct in this revision (The left
part of the top menu area is missing and the grey header background
overshoots on the right hand side), i will upload a picture when i am
back home as i can attach here.
Thanks
Dan
On Dec 27, 4:10 pm, Sam Moffatt <pasa...@gmail.com> wrote:
> It already is removed, I was just curious to work out why it was
> causing an error. It is one thing to remove a symptom of a problem but
> if you don't realise what the cause is you're potentially doomed to
> make the same mistake again. But now we know its a Windows specific
> behaviour (for some reason).
>
dan1dyoung
On 28 Dec, 08:55, dan1dyoung <dan...@dysolutions.co.uk> wrote:
> Hi Sam,
>
> Totally agree and was not pushing to change without knowing why but
> wondered if Andrew already knew the answer as he removed it from the
> other tables, i have just reloaded the new nightly (13865) with this
> change and now it works.
>
> It does not move and rename the config file for me (On windows so did
> not set the FTP part up) and the file still has the ; missing as
> reported herehttp://groups.google.com/group/joomla-dev-cms/browse_thread/thread/3f...
> > >> >>> For more options, visit this group athttp://groups.google.com/group/joomla-dev-cms?hl=en-GB.
>
> > >> >> --
>
> > >> >> You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> > >> >> To post to this group, send an email to joomla-...@googlegroups.com.
> > >> >> To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
> > >> >> For more options, visit this group athttp://groups.google.com/group/joomla-dev-cms?hl=en-GB.
>
> > >> > --
>
> > >> > You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> > >> > To post to this group, send an email to joomla-...@googlegroups.com.
> > >> > To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
> > >> > For more options, visit this group athttp://groups.google.com/group/joomla-dev-cms?hl=en-GB.-Hidequoted text -
>
> > >> - Show quoted text -
>
> > > --
>
> > > You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> > > To post to this group, send an email to joomla-...@googlegroups.com.
> > > To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
> > > For more options, visit this group athttp://groups.google.com/group/joomla-dev-cms?hl=en-GB.-Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -