Uploading Photos

I have the issue of uploading photos (in the designer)- I get that little square box with default image and no photo.
I host my own server using Koozali SME Server based on based on CentOS 6.9.
I have set and checked all the php settings (60M, 60M and 1028M).
In the Sytist error log I get..
SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND CONCAT(date_date, ' ', date_time) lte* '2018-10-18 13:29:31' AND private lte* '1' ' at line 1.
(*lte the less than or equal to syntax is not accepted by this editor)
mySQL date and time format is as above and I have set the SQL format in the Admin page to match.
Any helpful suggestion will be much appreciated.

Edited Thu Oct 18, 18 12:54 AM by Terry Green

That MySQL error would not be related. Check the errors.txt or error_log file that will be in the root or your Sytist installation folder.

And how big is the file you are attempting to upload?

Edited by

Below is an extract from the error log with all entries relating to my IP - I think these are only occurring when the edited page tries to re-display.
I have tried files from 150k upwards. I am sure it has something to do with permissions within my system, but can't discover what.
My problem could be solved if the editing/upload files function would allow me to select from ALL PHOTOS and not just my computer, similar to how billboards are created.
I can upload with WinSCP and process without issues.
I'd be thankful for other any ideas that I could try.

File does not exist: /home/e-smith/files/ibays/slphotos/html/sy-photos/2018/04/23/16, referer: http://pics.shorelinedigital.com.au/sy-admin/index.php?do=allPhotos&pic_client=0&pic_upload_session=&acdc=ASC&sm=
File does not exist: /home/e-smith/files/ibays/slphotos/html/unique_photos, referer: http://pics.shorelinedigital.com.au/sy-admin/index.php?do=news&action=addDate&date_id=1324&page_under=0
File does not exist: /home/e-smith/files/ibays/slphotos/html/unique_photos, referer: http://pics.shorelinedigital.com.au/sy-admin/index.php?do=news&action=addDate&date_id=1324
File does not exist: /home/e-smith/files/ibays/slphotos/html/client_galleries/wedding_test, referer: http://pics.shorelinedigital.com.au/sy-admin/index.php?do=news&action=addDate&date_id=1326&page_under=0
File does not exist: /home/e-smith/files/ibays/slphotos/html/sy-misc/customer_01/20181021010937-atest150k.jpg, referer: http://pics.shorelinedigital.com.au/sy-admin/index.php?do=news&action=addDate&date_id=1327

Edited by

None of those errors relate to uploading to the page designer. It would be best if you can email me FTP access (username and password) so I can test it out.

Edited by