We’re with you. JoomShaper is offering a 20% Discount on all plans due to the impact of COVID-19.

Support Offline : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

42S22 SQLSTATE [42S22]: Column not found: 1054 Unknown column 'created_on' in 'field list'

Featured Lock Resolved Bug
Hello, my english is bad. I used the Google Translate.

I updated my Joomla including Kidzy.

Now I can no longer do any front-end editing, and in the Layout Designer he no longer finds the image folders.

When I go to Media in Layout Designer, I get the following error message:

42S22 SQLSTATE [42S22]: Column not found: 1054 Unknown column 'created_on' in 'field list'

And by the way, the documentation for Kidzy has to be reworked, because the pictures of the instructions are not shown anymore.

You have let up!

many Greetings
René

Bildschirmfoto 2018-11-07 um 08.07.50.png

Bildschirmfoto 2018-11-07 um 08.08.28.png

Bildschirmfoto 2018-11-07 um 08.08.13.png

Attachments (3)

  • Bildschirmfoto 2018-11-07 um 08.07.50.png
    Bildschirmfoto 2018-11-07 um 08.07.50.png 18.7 KB
  • Bildschirmfoto 2018-11-07 um 08.08.28.png
    Bildschirmfoto 2018-11-07 um 08.08.28.png 239.5 KB
  • Bildschirmfoto 2018-11-07 um 08.08.13.png
    Bildschirmfoto 2018-11-07 um 08.08.13.png 55 KB

12 Answers

Rammstainar

More than a month ago #Permalink
Hello, can nobody help me? Did not the error occur with any other user?

Toufiq - Staff

More than a month ago #Permalink
Hi there,

Please send me the Joomla administrator access & FTP access+Database access via PM.

-Thanks

Michael Weaver

More than a month ago #Permalink
I am having the same error "Unknown column 'created_on' in 'field list'" and when I go into SP page builder and try to chose an image to insert, I get a blank page. It works if I type it in directly (ex. /images/example.jpg) but when I try to browse images the page is blank, if I go to media I get "Unknown column 'created_on' in 'field list". I saw some posts from other sites stating a similar issue and the fix was "<img src="{$INTRO_IMAGE}" align="right" alt="{$JOOMLA_TITLE}" />" unfortunately they never indicated where this code went in with page in the template.

Attachments (1)

  • eee.JPG
    eee.JPG 47.5 KB

Toufiq - Staff

More than a month ago #Permalink
I am having the same error "Unknown column 'created_on' in 'field list'" and when I go into SP page builder and try to chose an image to insert, I get a blank page. It works if I type it in directly (ex. /images/example.jpg) but when I try to browse images the page is blank, if I go to media I get "Unknown column 'created_on' in 'field list". I saw some posts from other sites stating a similar issue and the fix was "<img src="{$INTRO_IMAGE}" align="right" alt="{$JOOMLA_TITLE}" />" unfortunately they never indicated where this code went in with page in the template.


Hi there,

Please send me the Joomla administrator access & FTP access+Database access via PM.

-Thanks

Rammstainar

More than a month ago #Permalink
Hello,

i have sent you the requested data.

Many thanks for your effort.

Toufiq - Staff

More than a month ago #Permalink
Hello,

i have sent you the requested data.

Many thanks for your effort.


Hi there, Thanks for your reply. I will give you feedback as soon as possible. Thanks

Rammstainar

More than a month ago #Permalink
Hello,

so far there has been no reaction.

The problem is still there.

Why have not you done anything yet? There are problems?

Are you an official supporter?

Best regards

Toufiq - Staff

More than a month ago #Permalink
Hello,

so far there has been no reaction.

The problem is still there.

Why have not you done anything yet? There are problems?

Are you an official supporter?

Best regards


Hi there, I have sent you a package. Please check & let me know. Thanks

Andrzej Tomusiak

More than a month ago #Permalink
I have the same mistake in the pictures :(

Attachments (1)

  • error.PNG
    error.PNG 1.6 KB

Toufiq - Staff

More than a month ago #Permalink
I have the same mistake in the pictures :(


Hi there, Could you send me the Joomla administrator access via PM? Thanks

Andrzej Tomusiak

More than a month ago #Permalink
what should you do?

Toufiq - Staff

More than a month ago #Permalink
what should you do?


Hi there, Click on my profile name or profile photo you will get the send message button. It's called private message. Thanks


There are no replies made for this post yet.
Be one of the first to reply to this post!

124

Templates

331410

Community Users

Newsletter

Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. JoomShaper.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us