I try change the language ...

More
10 years 9 months ago #37382 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))

?

Please Log in to join the conversation.

More
10 years 9 months ago #37391 by ivan.milic
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.

More
10 years 7 months ago - 10 years 7 months ago #38853 by Wouter
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
Last edit: 10 years 7 months ago by Wouter.

Please Log in to join the conversation.

More
10 years 7 months ago #38855 by Wouter
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.)

Please Log in to join the conversation.

More
10 years 7 months ago #38866 by ivan.milic

Please Log in to join the conversation.

More
10 years 7 months ago - 10 years 7 months ago #38869 by Wouter
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 ?
Last edit: 10 years 7 months ago by Wouter.

Please Log in to join the conversation.

Time to create page: 0.155 seconds
Powered by Kunena Forum