SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Urgent help needed
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

wolkenwalker
Starting Member

1 Posts

Posted - 01/03/2014 :  20:55:34  Show Profile  Reply with Quote
I've just installed the Flexi Content Extension and have now this on my startpage/ I'm using Joomla 3
I also deleted the module but still the same.

Site is:
http://www.inspectorgroup.com.au/

Any idea how to fix this?
Thank you in advance

P.s I'm not quite sure if this is the right forum but if not sorry about this.

This is the message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE fi.published = 1 AND fi.access IN (0,1,1,2,3) GROUP BY fi.id ORDER BY ftre' at line 1 SQL=SELECT fi.* FROM rhote_flexicontent_fields AS fi LEFT JOIN rhote_flexicontent_fields_type_relations AS ftrel ON ftrel.field_id = fi.id AND ftrel.type_id = WHERE fi.published = 1 AND fi.access IN (0,1,1,2,3) GROUP BY fi.id ORDER BY ftrel.ordering, fi.ordering, fi.name





http://www.inspectorgroup.com.au

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 01/04/2014 :  04:19:57  Show Profile  Visit SwePeso's Homepage  Reply with Quote
There are so many fundamental errors. I suggest you start here www.w3schools.com/sql


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 01/04/2014 :  05:04:20  Show Profile  Reply with Quote
Also this is MS SQL Server forum. You may be better off trying your luck on MySQL forums like www.dbforums.com for MySQL related help.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22761 Posts

Posted - 01/06/2014 :  02:02:23  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
You are missing a column in the JOIN

SELECT fi.* FROM rhote_flexicontent_fields AS fi LEFT JOIN rhote_flexicontent_fields_type_relations AS ftrel ON ftrel.field_id = fi.id AND ftrel.type_id = fi.type_id WHERE fi.published = 1 AND fi.access IN (0,1,1,2,3) GROUP BY fi.id ORDER BY ftrel.ordering, fi.ordering, fi.name


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 01/06/2014 :  02:40:53  Show Profile  Reply with Quote
quote:
Originally posted by madhivanan

You are missing a column in the JOIN



... and ...

For example:

Only fields in the GROUP BY (i.e. fi.id) can appear in the SELECT. Thus you cannot have SELECT fi.*

The same applies to ORDER BY, so you cannot have ORDER BY ftrel.ordering, fi.ordering, fi.name
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22761 Posts

Posted - 01/06/2014 :  03:38:24  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
quote:
Originally posted by Kristen

quote:
Originally posted by madhivanan

You are missing a column in the JOIN



... and ...

For example:

Only fields in the GROUP BY (i.e. fi.id) can appear in the SELECT. Thus you cannot have SELECT fi.*

The same applies to ORDER BY, so you cannot have ORDER BY ftrel.ordering, fi.ordering, fi.name


It is perfectly possible in MySQL which OP is using.

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 01/12/2014 :  05:04:14  Show Profile  Reply with Quote
quote:
Originally posted by madhivanan

It is perfectly possible in MySQL which OP is using.



Learnt something new today, thanks Madhi
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000