500 - JDatabaseMySQL::query: 1054 - Unknown column 'ordering' in 'order clause' SQL=SELECT * FROM jos_languages WHERE published=1 ORDER BY ordering ASC

[Mark Cornell]

When i went to bed all was fine.

Woke up to this error. I have removed an entry from jos_languages for
a test lang (unknown how it got there)

I have changed the template as i read about that error.

any suggestions?

we were supposed to go live this weekend...

Thanks

[Nicholas K. Dionysopoulos]

When you upgraded from Joomla! 1.6 to 1.7, which upgrade method did you use?

-- 
Nicholas K. Dionysopoulos
Lead Developer, AkeebaBackup.com

Web: http://www.AkeebaBackup.com

Blog: http://www.dionysopoulos.me/blog

--
You received this message because you are subscribed to the Google Groups "Joomla! General Development" group.
To post to this group, send an email to joomla-de...@googlegroups.com.
To unsubscribe from this group, send email to joomla-dev-gene...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/joomla-dev-general?hl=en-GB.

[Mark Cornell]

Fresh install on new server and DB. I have however recently imported
users with joomlarra, but the site was working after that.

TIA

On Oct 12, 10:26 am, "Nicholas K. Dionysopoulos" <nikosd...@gmail.com>
wrote:

>  When you upgraded from Joomla! 1.6 to 1.7, which upgrade method did you use?
>
> --
> Nicholas K. Dionysopoulos
> Lead Developer, AkeebaBackup.com
> Web:http://www.AkeebaBackup.com
> Blog:http://www.dionysopoulos.me/blog
>
>
>
>
>
>
>
> On Wednesday, 12 October 2011 at 18:22, Mark Cornell wrote:
> > When i went to bed all was fine.
>
> > Woke up to this error. I have removed an entry from jos_languages for
> > a test lang (unknown how it got there)
>
> > I have changed the template as i read about that error.
>
> > any suggestions?
>
> > we were supposed to go live this weekend...
>
> > Thanks
>
> > --
> > You received this message because you are subscribed to the Google Groups "Joomla! General Development" group.

> > To post to this group, send an email to joomla-de...@googlegroups.com (mailto:joomla-de...@googlegroups.com).
> > To unsubscribe from this group, send email to joomla-dev-gene...@googlegroups.com (mailto:joomla-dev-gene...@googlegroups.com).

[Mark Dexter]

What version of Joomla does it show in the back end? What is the value for version_id in your #__schemas table (for extension_id = 700)? Mark

To post to this group, send an email to joomla-de...@googlegroups.com.
To unsubscribe from this group, send email to joomla-dev-gene...@googlegroups.com.

[Mark Cornell]

Joomla! 1.7.1 Stable [ Ember ] 26-Sep-2011 14:00 GMT


extension_id version_id
700 1.7.1-2011-09-20

[Mark Dexter]

OK. Please check your database to see if you have a #__associations table and if you have an ordering column in your #__languages table (pretty sure you won't have either one). These were the 1.7.0 db changes.

Then please check the access column in the #__newsfeeds table to see if it is tinyint or int. (That is one of the 1.7.1 db changes).

These symptoms are exactly what we would expect if you updated from 1.6.4 or earlier to 1.7.1. In fact, we are at this time working on a 1.7.2 release to correct this issue.

I am not aware of any way to get this situation with a new 1.7.1 installation. The only time I have seen it is with updates. But of course that doesn't mean it couldn't happen.

As a side note, this problem is exactly why we released 1.6.5 prior to releasing 1.7.0. As far as I know, updates from 1.6.5 or 1.6.6 to 1.7.0 or 1.7.1 work correctly, with the database updates.

In any case, if you edit and run the 1.7.0 and 1.7.1 files from the folder administrator/components/com_admin/sql/updates/mysql, that will update your db. You will need to change "#__" to whatever your actual table prefix is.

Good luck. Mark

[Mark Cornell]

I have done this and have no success I get a 404 component not found
but even with debug on I get no meaningful error
Mark(me)......is starting to panic...

[elin]

Did you check your database for the missing field and the schema change? 

Elin

[Nick Savov]

Just reinstall the core with Admin Tools (full reinstall not just the
patch) and that should reset things for you:
http://extensions.joomla.org/extensions/access-a-security/site-security/site-protection/14087

Kind regards,
Nick

[Mark Cornell]

Reinstalled core via admin tools and manually with no success

how can i tell what component is failing to load or is not found?

On Oct 12, 12:45 pm, "Nick Savov" <n...@iowawebcompany.com> wrote:
> Just reinstall the core with Admin Tools (full reinstall not just the

> patch) and that should reset things for you:http://extensions.joomla.org/extensions/access-a-security/site-securi...

>
> Kind regards,
> Nick
>
> I have done this and have no success I get a 404 component not found
>
>
>
>
>
>
>
> > but even with debug on I get no meaningful error
> > Mark(me)......is starting to panic...
>

> >> > � � � �extension_id � �version_id
> >> > � � � � � � � � � � � �700 � � 1.7.1-2011-09-20

>
> >> > On Oct 12, 10:52 am, Mark Dexter <dextercow...@gmail.com> wrote:
> >> > > What version of Joomla does it show in the back end? What is the
> >> value
> >> > for
> >> > > version_id in your #__schemas table (for extension_id = 700)? Mark
>
> >> > > On Wed, Oct 12, 2011 at 8:44 AM, Mark Cornell
> >> <mcornell...@gmail.com>
> >> > wrote:
> >> > > > Fresh install on new server and DB. I have however recently
> >> imported
> >> > > > users with joomlarra, but the site was working after that.
>
> >> > > > TIA
>
> >> > > > On Oct 12, 10:26 am, "Nicholas K. Dionysopoulos"
> >> <nikosd...@gmail.com>
> >> > > > wrote:

> >> > > > > �When you upgraded from Joomla! 1.6 to 1.7, which upgrade method

[Mark Cornell]

Yes, Thanks

[Swapnil Shah]

Mark,

Do you have SEF urls' enabled? Does the site work on a local machine?

Regards,

Neil
Sent from my iPhone

[Mark Cornell]

I have restored my backup (ona seperate db) from before my user import
and it seems to work just have hours of lost time (I havent given up
on the current issue yet)
I do not have SEF on I have always had issues when on.

On Oct 12, 3:56 pm, Swapnil Shah <swapnilsha...@gmail.com> wrote:
> Mark,
>
> Do you have SEF urls' enabled? Does the site work on a local machine?
>
> Regards,
>
> Neil
> Sent from my iPhone
>

[Swapnil Shah]

Then to figure out which component is not loading, in the url there should be option=com_name. That component is the one that is not loading. Hope that helps you figure out which component is not loading.

I was thinking if you had sef enabled then it might be an htaccess issue.

Regards,

Neil
Sent from my iPhone

[Mark Cornell]

I misspoke the restored copy produces in infinite loop detected in jerror

I'm the original site that you url is sub.domain.com/index.php?lang=en

[Nick Savov]

Can we get a link to the site to take a quick look?

Kind regards,
Nick

>> >>>>>>> � � � �extension_id � �version_id
>> >>>>>>> � � � � � � � � � � � �700 � �

>> 1.7.1-2011-09-20
>> >>
>> >>>>>>> On Oct 12, 10:52 am, Mark Dexter <dextercow...@gmail.com> wrote:
>> >>>>>>>> What version of Joomla does it show in the back end? What is
>> the
>> >>>>>> value
>> >>>>>>> for
>> >>>>>>>> version_id in your #__schemas table (for extension_id = 700)?
>> Mark
>> >>
>> >>>>>>>> On Wed, Oct 12, 2011 at 8:44 AM, Mark Cornell
>> >>>>>> <mcornell...@gmail.com>
>> >>>>>>> wrote:
>> >>>>>>>>> Fresh install on new server and DB. I have however recently
>> >>>>>> imported
>> >>>>>>>>> users with joomlarra, but the site was working after that.
>> >>
>> >>>>>>>>> TIA
>> >>
>> >>>>>>>>> On Oct 12, 10:26 am, "Nicholas K. Dionysopoulos"
>> >>>>>> <nikosd...@gmail.com>
>> >>>>>>>>> wrote:

>> >>>>>>>>>> �When you upgraded from Joomla! 1.6 to 1.7, which upgrade

[Swapnil Shah]

I saw that error when the db information was not correct. Once I corrected it, everything worked. 

That URL looks fishy, I am trying to recreate and see what happens

Regards, 

Neil

Sent from my iPhone

[Mark Cornell]

Original is development.lighthousecounseling.com

restored is lighthouse counseling.com/development2

thanks again for the help

[Nick Savov]

Give this a try:
http://docs.joomla.org/Infinite_loop_detected_in_JError_in_Joomla_1.7

and this:
https://www.akeebabackup.com/support/forum/akeeba-backup-support/infinite-loop-detected-in-jerror-1/limit/50/offset/0.html

Kind regards,
Nick

[elin]

Please, please check that you have the database changes that Mark asked about and if you don't have them run the appropriate sql in phpmyadmin or whatever you use.

[Mark Cornell]

The changes were in place. it seems that somehow the default for the
home menu was set to registered access?? NO idea how that happened but
a HUGE Thank You to Swapnil Shah for finding the actual cause and a
Thank You to all who helped troubleshoot

:):)