Joomla! Issue Tracker | Joomla! CMS #22418

Closed
28 Sep 2018
Medium
Build: staging
# 22418

pjkool
28 Sep 2018

Steps to reproduce the issue

Open joomla administrator view select Content->Articles
direct url http://www.mysite.com/administrator/index.php?option=com_content
Result

Expected result

Articles view will be available.

Actual result

Error
An error has occurred.
500 Unknown column 'a.note' in 'field list' Unknown column 'a.note' in 'field list'
https://i.imgur.com/aeOSPvn.jpg

System information (as much as possible)

https://drive.google.com/file/d/1OB3j_BbmqdKPjAPwwxO7lMQdhWWBwoiV/view?usp=sharing

Additional comments

pjkool - open - 28 Sep 2018

joomla-cms-bot - change - 28 Sep 2018

Labels

Added: ?

joomla-cms-bot - labeled - 28 Sep 2018

franz-wohlkoenig - change - 28 Sep 2018

Category

⇒

com_content

SharkyKZ - comment - 28 Sep 2018

Go to Extensions -> Database and see if there's anything to fix. And please do not use development versions on live sites.

pjkool - comment - 28 Sep 2018

Hi, so, sorry for Your time, can You please help me what I have to do next.
Thank You!
there are problems;
×Error
Table 'la02_19953202.#__privacy_consents' doesn't exist

Database schema version (3.7.0-2017-02-17) does not match CMS version
(3.9.0-2018-08-29).

Table 'lnx5q_redirect_links' has the wrong type or attributes for column
'comment' with type varchar(255). (From file 3.7.0-2017-02-15.sql.)
Table 'lnx5q_content' does not have index 'idx_alias'. (From file
3.8.2-2017-10-14.sql.)
Table 'lnx5q_user_keys' should not have index 'series_2'. (From file
3.8.4-2018-01-16.sql.)
Table 'lnx5q_user_keys' should not have index 'series_3'. (From file
3.8.4-2018-01-16.sql.)
Table 'lnx5q_privacy_requests' does not exist. (From file
3.9.0-2018-05-02.sql.)
Table 'lnx5q_action_logs' does not exist. (From file
3.9.0-2018-05-05.sql.)
Table 'lnx5q_action_logs_extensions' does not exist. (From file
3.9.0-2018-05-05.sql.)
Table 'lnx5q_action_log_config' does not exist. (From file
3.9.0-2018-05-05.sql.)
Table 'lnx5q_privacy_consents' does not exist. (From file
3.9.0-2018-05-24.sql.)
Table 'lnx5q_content' does not have column 'note'. (From file
3.9.0-2018-06-02.sql.)
Table 'lnx5q_privacy_consents' does not have column 'state'. (From file
3.9.0-2018-08-12.sql.)
Table 'lnx5q_session' has the wrong type or attributes for column
'session_id' with type varbinary(192). (From file 3.9.0-2018-08-28.sql.)
Table 'lnx5q_session' has the wrong type or attributes for column 'guest'
with type tinyint(3) unsigned. (From file 3.9.0-2018-08-28.sql.)
Table 'lnx5q_session' has the wrong type or attributes for column 'time'
with type int(11). (From file 3.9.0-2018-08-28.sql.)
The Joomla! Core database tables have not been converted yet to UTF-8
Multibyte (utf8mb4).

Database schema version (in #__schemas): 3.7.0-2017-02-17.

Update version (in #__extensions): 3.10.0-dev.
Database driver: mysqli.
145 database changes were checked.
207 database changes did not alter table structure and were skipped.

Kontakt SharkyKZ (notifications@github.com) kirjutas kuupäeval R, 28.
september 2018 kell 08:54:

Go to Extensions -> Database and see if there's anything to fix. And
please do not use development versions on live sites.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
#22418 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AblAUQSU5TQZ7SUEkRunFD8U3abi0_rkks5ufbmNgaJpZM4W9rBr
.

--
Anti Kodas, PJK IT juht, 53312002

pjkool - comment - 28 Sep 2018

Maybe, I can just downgrade joomla to 3.8?
Thank You very much

Kontakt Anti Kodas (anti.kodas@pjk.ee) kirjutas kuupäeval R, 28.
september 2018 kell 11:29:

Hi, so, sorry for Your time, can You please help me what I have to do
next. Thank You!
there are problems;
×Error
Table 'la02_19953202.#__privacy_consents' doesn't exist

Database schema version (3.7.0-2017-02-17) does not match CMS version
(3.9.0-2018-08-29).

Table 'lnx5q_redirect_links' has the wrong type or attributes for
column 'comment' with type varchar(255). (From file 3.7.0-2017-02-15.sql.)

Table 'lnx5q_content' does not have index 'idx_alias'. (From file
3.8.2-2017-10-14.sql.)

Table 'lnx5q_user_keys' should not have index 'series_2'. (From file
3.8.4-2018-01-16.sql.)

Table 'lnx5q_user_keys' should not have index 'series_3'. (From file
3.8.4-2018-01-16.sql.)

Table 'lnx5q_privacy_requests' does not exist. (From file
3.9.0-2018-05-02.sql.)

Table 'lnx5q_action_logs' does not exist. (From file
3.9.0-2018-05-05.sql.)

Table 'lnx5q_action_logs_extensions' does not exist. (From file
3.9.0-2018-05-05.sql.)

Table 'lnx5q_action_log_config' does not exist. (From file
3.9.0-2018-05-05.sql.)

Table 'lnx5q_privacy_consents' does not exist. (From file
3.9.0-2018-05-24.sql.)

Table 'lnx5q_content' does not have column 'note'. (From file
3.9.0-2018-06-02.sql.)

Table 'lnx5q_privacy_consents' does not have column 'state'. (From
file 3.9.0-2018-08-12.sql.)

Table 'lnx5q_session' has the wrong type or attributes for column
'session_id' with type varbinary(192). (From file 3.9.0-2018-08-28.sql.)

Table 'lnx5q_session' has the wrong type or attributes for column
'guest' with type tinyint(3) unsigned. (From file 3.9.0-2018-08-28.sql.)

Table 'lnx5q_session' has the wrong type or attributes for column
'time' with type int(11). (From file 3.9.0-2018-08-28.sql.)

The Joomla! Core database tables have not been converted yet to
UTF-8 Multibyte (utf8mb4).

Database schema version (in #__schemas): 3.7.0-2017-02-17.

Update version (in #__extensions): 3.10.0-dev.

Database driver: mysqli.

145 database changes were checked.

207 database changes did not alter table structure and were skipped.

Kontakt SharkyKZ (notifications@github.com) kirjutas kuupäeval R, 28.
september 2018 kell 08:54:

Go to Extensions -> Database and see if there's anything to fix. And
please do not use development versions on live sites.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
#22418 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AblAUQSU5TQZ7SUEkRunFD8U3abi0_rkks5ufbmNgaJpZM4W9rBr
.

--
Anti Kodas, PJK IT juht, 53312002

--
Anti Kodas, PJK IT juht, 53312002

pjkool - comment - 28 Sep 2018

sry, for spaming, maybe this will help?
https://gist.github.com/mbabker/d7bfb4e1e2fbc6b7815a733607f89281

Kontakt Anti Kodas (anti.kodas@pjk.ee) kirjutas kuupäeval R, 28.
september 2018 kell 11:46:

Maybe, I can just downgrade joomla to 3.8?
Thank You very much

Kontakt Anti Kodas (anti.kodas@pjk.ee) kirjutas kuupäeval R, 28.
september 2018 kell 11:29:

Hi, so, sorry for Your time, can You please help me what I have to do
next. Thank You!
there are problems;
×Error
Table 'la02_19953202.#__privacy_consents' doesn't exist

Database schema version (3.7.0-2017-02-17) does not match CMS version
(3.9.0-2018-08-29).

Table 'lnx5q_redirect_links' has the wrong type or attributes for
column 'comment' with type varchar(255). (From file 3.7.0-2017-02-15.sql.)

Table 'lnx5q_content' does not have index 'idx_alias'. (From file
3.8.2-2017-10-14.sql.)

Table 'lnx5q_user_keys' should not have index 'series_2'. (From
file 3.8.4-2018-01-16.sql.)

Table 'lnx5q_user_keys' should not have index 'series_3'. (From
file 3.8.4-2018-01-16.sql.)

Table 'lnx5q_privacy_requests' does not exist. (From file
3.9.0-2018-05-02.sql.)

Table 'lnx5q_action_logs' does not exist. (From file
3.9.0-2018-05-05.sql.)

Table 'lnx5q_action_logs_extensions' does not exist. (From file
3.9.0-2018-05-05.sql.)

Table 'lnx5q_action_log_config' does not exist. (From file
3.9.0-2018-05-05.sql.)

Table 'lnx5q_privacy_consents' does not exist. (From file
3.9.0-2018-05-24.sql.)

Table 'lnx5q_content' does not have column 'note'. (From file
3.9.0-2018-06-02.sql.)

Table 'lnx5q_privacy_consents' does not have column 'state'. (From
file 3.9.0-2018-08-12.sql.)

Table 'lnx5q_session' has the wrong type or attributes for column
'session_id' with type varbinary(192). (From file 3.9.0-2018-08-28.sql.)

Table 'lnx5q_session' has the wrong type or attributes for column
'guest' with type tinyint(3) unsigned. (From file 3.9.0-2018-08-28.sql.)

Table 'lnx5q_session' has the wrong type or attributes for column
'time' with type int(11). (From file 3.9.0-2018-08-28.sql.)

The Joomla! Core database tables have not been converted yet to
UTF-8 Multibyte (utf8mb4).

Database schema version (in #__schemas): 3.7.0-2017-02-17.

Update version (in #__extensions): 3.10.0-dev.

Database driver: mysqli.

145 database changes were checked.

207 database changes did not alter table structure and were skipped.

Kontakt SharkyKZ (notifications@github.com) kirjutas kuupäeval R, 28.
september 2018 kell 08:54:

Go to Extensions -> Database and see if there's anything to fix. And
please do not use development versions on live sites.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
#22418 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AblAUQSU5TQZ7SUEkRunFD8U3abi0_rkks5ufbmNgaJpZM4W9rBr
.

--
Anti Kodas, PJK IT juht, 53312002

--
Anti Kodas, PJK IT juht, 53312002

--
Anti Kodas, PJK IT juht, 53312002

franz-wohlkoenig - comment - 28 Sep 2018

@pjkool Please ask help on the forums. This repository concerns in first Place Joomla-Core coding. For this Reason closing this Issue, thanks.

joomla-cms-bot - change - 28 Sep 2018

Closed_Date	2018-09-28 09:22:28	⇒	2018-09-28 09:22:29
Closed_By	franz-wohlkoenig	⇒	joomla-cms-bot

joomla-cms-bot - close - 28 Sep 2018

franz-wohlkoenig - change - 28 Sep 2018

Status	New	⇒	Closed
Closed_Date	0000-00-00 00:00:00	⇒	2018-09-28 09:22:28
Closed_By		⇒	franz-wohlkoenig

joomla-cms-bot - comment - 28 Sep 2018

Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/22418

Add a Comment

Older
Newer

Joomla! Issue Tracker - CMS

[#22418] - Cant open Article module

Steps to reproduce the issue

Expected result

Actual result

System information (as much as possible)

Additional comments

Add a Comment