A Database Error Occurred

Envato Authors CodeCanyon
#1

Error Number: 1055

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘jokzsvrp_be_social.user_images.file_name’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT user_images.file_name, user_images.ID as imageid, user_albums.ID, user_albums.name, user_albums.description FROM user_albums LEFT OUTER JOIN user_images ON user_images.albumid = user_albums.ID WHERE user_albums.userid = ‘1’ GROUP BY user_albums.ID LIMIT 4

Filename: models/Image_model.php

Line Number: 14

I installed but have issues. rewrite is enabled
when clicking on profile i get this error - Social network

https://www.basildonexposed.co.uk/index.php/profile/admin

Have emailed support but no replies

#2

Try to get in touch with support to have your issue as resolved

#3

I have emailed a few times over past few days and not even a confirmation they will get back to me.

I am happy to give access the server if needed. but need this sorted as soon as possible, i last purchase a news script here and had no problem with install.

#4

some of the script works as it in installed, but clicking on a profile among other link throws this database error, also had an ajax pop up error when viewing image gallery from member account.

hoping for a fix soon :slight_smile:

#5

This issue is caused by a setting in your mysql.ini file. This issue normally pops up when using WAMP setups due to the default mysql configuration but sometimes on other web hosts. To fix it, try the following:

  1. This is caused by the STRICT_TRANS_TABLES SQL mode defined in the %PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini file. Removing that setting and restarting MySQL should fix the problem. Look for:

sql_mode = “STRICT_TRANS_TABLE”

And remove that setting. You may have multiple settings in this field, but just remove the STRICT_TRANS_TABLE setting and it should fix your issue.

  1. Other resources: See https://www.farbeyondcode.com/Solution-for-MariaDB-Field--xxx--doesn-t-have-a-default-value-5-2720.html

  2. If editing that file doesn’t fix the issue, see http://dev.mysql.com/doc/refman/5.6/en/option-files.html for other possible locations of config files.

Replied :slight_smile: hopefully this will work

#6

If you have emailed them multiple times then i think the support team is not trying to help you out for any other reason ?

As you have said some modules worked for you so with the one which is having a malfunctioning please check out & look if it’s conflicting with any of the code or script then have it rectified from the support team.

As with the rest if they still don’t provide any support or help then i can provide you some paid support for the work