- Posts: 1
- Thank you received: 0
I try change the language ...
-
istvanszabo
Inactive member - Topic Author
- New Member
Less
More
10 years 9 months ago #37382
by istvanszabo
I try change the language ... was created by istvanszabo
Error:
1054 Unknown column 'extra_query' in 'field list' SQL=SELECT DISTINCT update_site_id, type, location, last_check_timestamp, extra_query FROM q1iqs_update_sites WHERE update_site_id IN (SELECT update_site_id FROM q1iqs_update_sites_extensions WHERE extension_id IN (600))
?
1054 Unknown column 'extra_query' in 'field list' SQL=SELECT DISTINCT update_site_id, type, location, last_check_timestamp, extra_query FROM q1iqs_update_sites WHERE update_site_id IN (SELECT update_site_id FROM q1iqs_update_sites_extensions WHERE extension_id IN (600))
?
Please Log in to join the conversation.
-
ivan.milic
Support Staff - Moderator
Less
More
- Posts: 14116
- Thank you received: 1639
10 years 9 months ago #37391
by ivan.milic
Replied by ivan.milic on topic I try change the language ...
You used some old language pack. Maybe database fix will help. Go to 'Extension manager', 'Database' tab if thre is button saying something like 'click here to repair database' click on it
The following user(s) said Thank You: istvanszabo
Please Log in to join the conversation.
-
Wouter
Inactive member - New Member
Less
More
- Posts: 3
- Thank you received: 0
10 years 7 months ago - 10 years 7 months ago #38853
by Wouter
Replied by Wouter on topic I try change the language ...
I`m getting the same error with
1054 Unknown column 'extra_query' in 'field list' SQL=SELECT DISTINCT update_site_id, type, location, last_check_timestamp, extra_query FROM sq5ys_update_sites WHERE update_site_id IN (SELECT update_site_id FROM sq5ys_update_sites_extensions WHERE extension_id IN (600))
but i can`t fix the database
By the way i used the corpored template
1054 Unknown column 'extra_query' in 'field list' SQL=SELECT DISTINCT update_site_id, type, location, last_check_timestamp, extra_query FROM sq5ys_update_sites WHERE update_site_id IN (SELECT update_site_id FROM sq5ys_update_sites_extensions WHERE extension_id IN (600))
but i can`t fix the database
By the way i used the corpored template
Last edit: 10 years 7 months ago by Wouter.
Please Log in to join the conversation.
-
Wouter
Inactive member - New Member
Less
More
- Posts: 3
- Thank you received: 0
10 years 7 months ago #38855
by Wouter
Replied by Wouter on topic I try change the language ...
I also get this
Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3).
Table 'sq5ys_update_sites' does not have column 'extra_query'. (From file 3.2.2-2013-12-22.sql.)
Table 'sq5ys_updates' does not have column 'extra_query'. (From file 3.2.2-2013-12-22.sql.)
Table 'sq5ys_updates' does not have column 'version' with type 'varchar(32)'. (From file 3.2.2-2014-01-18.sql.)
Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3).
Table 'sq5ys_update_sites' does not have column 'extra_query'. (From file 3.2.2-2013-12-22.sql.)
Table 'sq5ys_updates' does not have column 'extra_query'. (From file 3.2.2-2013-12-22.sql.)
Table 'sq5ys_updates' does not have column 'version' with type 'varchar(32)'. (From file 3.2.2-2014-01-18.sql.)
Please Log in to join the conversation.
-
ivan.milic
Support Staff - Moderator
Less
More
- Posts: 14116
- Thank you received: 1639
10 years 7 months ago #38866
by ivan.milic
Replied by ivan.milic on topic I try change the language ...
Please Log in to join the conversation.
-
Wouter
Inactive member - New Member
Less
More
- Posts: 3
- Thank you received: 0
10 years 7 months ago - 10 years 7 months ago #38869
by Wouter
Replied by Wouter on topic I try change the language ...
Yes maybe solved the atabase schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3).
but the main problem still exist
( can`t install language pack with the build in installer)
1054 Unknown column 'extra_query' in 'field list' SQL=SELECT DISTINCT update_site_id, type, location, last_check_timestamp, extra_query FROM sq5ys_update_sites WHERE update_site_id IN (SELECT update_site_id FROM sq5ys_update_sites_extensions WHERE extension_id IN (600))
I fulled read the step by step manual how to install the template.
what can be the problem ?
but the main problem still exist
( can`t install language pack with the build in installer)
1054 Unknown column 'extra_query' in 'field list' SQL=SELECT DISTINCT update_site_id, type, location, last_check_timestamp, extra_query FROM sq5ys_update_sites WHERE update_site_id IN (SELECT update_site_id FROM sq5ys_update_sites_extensions WHERE extension_id IN (600))
I fulled read the step by step manual how to install the template.
what can be the problem ?
Last edit: 10 years 7 months ago by Wouter.
Please Log in to join the conversation.
Time to create page: 0.235 seconds