×
If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html
error code; 1054, unknown collum ‘ a.title’ in ‘where clause’
- martijn
- Topic Author
- Offline
- specialised in front end
Less
More
- Posts: 6
- Thank you received: 0
2 years 4 months ago #7096
by martijn
This message has an attachment image.
error code; 1054, unknown collum ‘ a.title’ in ‘where clause’ was created by martijn
JooDatabase version: 4.0.1
Database format: SQL
Connection type: external database
error code; 1054, unknown collum ‘ ’ in ‘where clause’ is what I get when clicking on the main menu link
Which field/collumn in my orginal database does JooDatabase choose to assign to '' ?
I have no clue how to solve it since no colum in my SQL database is called ''
Database format: SQL
Connection type: external database
error code; 1054, unknown collum ‘ ’ in ‘where clause’ is what I get when clicking on the main menu link
Which field/collumn in my orginal database does JooDatabase choose to assign to '' ?
I have no clue how to solve it since no colum in my SQL database is called ''
This message has an attachment image.
Please log in or register to see it.
Please Log in to join the conversation.
- Dirk
-
- Offline
Less
More
- Posts: 1222
- Thank you received: 226
2 years 4 months ago #7099
by Dirk
Replied by Dirk on topic error code; 1054, unknown collum ‘ a.title’ in ‘where clause’
You probably changed the main table of your database without setting the menu parameters.
I guess you have somewhere a filter or ordering directive to a field called TITLE
I guess you have somewhere a filter or ordering directive to a field called TITLE
Please Log in to join the conversation.
- martijn
- Topic Author
- Offline
- specialised in front end
Less
More
- Posts: 6
- Thank you received: 0
2 years 4 months ago #7102
by martijn
Replied by martijn on topic error code; 1054, unknown collum ‘ a.title’ in ‘where clause’
Of this main database on Joomla 4 I have not made changes to the database after it linking via the extension.
Where is that supossed "title" collum you are talking about? all my collum names of the imported database do not have such a collumn name.
Where is that supossed "title" collum you are talking about? all my collum names of the imported database do not have such a collumn name.
Please Log in to join the conversation.
- Dirk
-
- Offline
Less
More
- Posts: 1222
- Thank you received: 226
2 years 4 months ago #7104
by Dirk
Replied by Dirk on topic error code; 1054, unknown collum ‘ a.title’ in ‘where clause’
It`s a problem with joomla >4.1.
They are changing so much right now ... it sucks!
Please update to 4.2.2 and it should work.
They are changing so much right now ... it sucks!
Please update to 4.2.2 and it should work.
Please Log in to join the conversation.
- martijn
- Topic Author
- Offline
- specialised in front end
Less
More
- Posts: 6
- Thank you received: 0
2 years 4 months ago #7105
by martijn
Replied by martijn on topic error code; 1054, unknown collum ‘ a.title’ in ‘where clause’
I was already working with Joomla 4.2.3 as a base when the error ocurred, so Using the newest version could be the cause of the problem.
Is there any other way I could resolve this problem?
Is there any other way I could resolve this problem?
Please Log in to join the conversation.
- Dirk
-
- Offline
Less
More
- Posts: 1222
- Thank you received: 226
2 years 4 months ago #7106
by Dirk
Replied by Dirk on topic error code; 1054, unknown collum ‘ a.title’ in ‘where clause’
Please update to 4.2.2 and it should work.
Please Log in to join the conversation.
Moderators: Dirk, joest