Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Thursday 5:16 am
Add a reply View Replies (1)

Resolved SQL error updating profile image

  1. cloudfaction
    cloudfaction
  2. General
  3. Monday, November 06 2017, 09:15 AM
updating profile image in frondend gives sql error

SQLSTATE[HY000]: General error: 1364 Field 'caption' doesn't have a default value.

we have been at this for some time now, but i cannot solve this.

J 3.6.5 / EP 1.4.4 ( i know old versions, cannot update yet)

it has worked, without problems.... but for some reason it does not any more.
  1. account
  2. update profile
Responses (1)
admin
admin Accepted Answer
Admin
Hi,
probably your host provider have updated mysql server.

Try to launch this SQL query from a panel like PhpMyAdmin:


ALTER TABLE `#__jsnsocial_photos` CHANGE COLUMN `caption` text NOT NULL DEFAULT '';
  1. more than a month ago
  2. General
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.