whoops there was an error (index.php)

[post2meet]

[post2meet]

please help me

[post2meet]

admin panel is working fine

[dclipca]

@post2meet what was the issue? Never encountered this error. Sorry for the late reply.

[post2meet]

when i open 127,0,01 it seem like this

[dclipca]

@post2meet most likely you have set up the database incorrectly. Start from scratch with the instructions from https://github.com/eckmarcommunity/eckmar/blob/master/INSTALLATION.md.

[Gralien]

Agree.

On Thu, Jun 29, 2023, 1:31 PM Dan Clipca @.***> wrote:

@post2meet https://github.com/post2meet most likely you have set up the database in a wrong way. Following the instructions on https://github.com/eckmarcommunity/eckmar again.

— Reply to this email directly, view it on GitHub https://github.com/eckmarcommunity/eckmar/issues/65#issuecomment-1613772773, or unsubscribe https://github.com/notifications/unsubscribe-auth/AXSCEGG3J46IOTRVQNZ34IDXNXQYNANCNFSM6AAAAAAZWEQPUE . You are receiving this because you are subscribed to this thread.Message ID: @.***>

[post2meet]

when i open 127,0,01 it seem like this

let me try 1 more time

@post2meet most likely you have set up the database incorrectly. Start from scratch with the instructions from https://github.com/eckmarcommunity/eckmar/blob/master/INSTALLATION.md.

[Tarun-developer]

The error you encountered (SQLSTATE[42000]: Syntax error or access violation: 1055) is a common error in SQL databases, and it is usually related to the GROUP BY clause and how it's used with aggregate functions.

Starting from SQL mode ONLY_FULL_GROUP_BY in MySQL version 5.7.5, MySQL enforces the standard SQL behavior for the GROUP BY clause. In this mode, when using GROUP BY, all non-aggregated columns in the SELECT statement must be included in the GROUP BY clause. This is to ensure that the result is unambiguous and to prevent potentially incorrect results.

For example, consider the following table "purchases":

purchases
--------------------------------
id | vendor_id | purchase_amount
--------------------------------
1  | 1         | 100
2  | 1         | 150
3  | 2         | 200

And the "vendors" table:

vendors
----------------------
id | vendor_name | vendor_level
----------------------
1  | Vendor A    | 2
2  | Vendor B    | 3

If you run the following SQL query in MySQL 5.7.5 or later with ONLY_FULL_GROUP_BY mode enabled:

SELECT vendors.id, COUNT(purchases.id) AS purchase_count
FROM vendors
JOIN purchases ON vendors.id = purchases.vendor_id
GROUP BY vendors.id;

You will encounter the error:

Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'marketplace.purchases.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

To resolve this issue, you should include all non-aggregated columns from the SELECT statement in the GROUP BY clause:

SELECT vendors.id, COUNT(purchases.id) AS purchase_count
FROM vendors
JOIN purchases ON vendors.id = purchases.vendor_id
GROUP BY vendors.id, vendors.vendor_name, vendors.vendor_level;

In this case, we've included "vendors.vendor_name" and "vendors.vendor_level" in the GROUP BY clause to satisfy the requirement of ONLY_FULL_GROUP_BY mode.

Keep in mind that the SQL mode behavior might vary based on the specific version of the SQL database you are using. It's essential to be aware of the SQL mode settings and version compatibility while writing SQL queries, especially when dealing with the GROUP BY clause and aggregate functions.

[tonymontana808]

when i open 127,0,01 it seem like this

you can remove code which show sellers statics becuase everyone need custom own page not default one issue will be resolved also request to develoers to upgrade mysql datababase version and laravel version and some repo is outdated like carbon

[Gralien]

You'll need to go back through the SQL issues. This has been solved.

On Tue, Aug 8, 2023, 7:07 PM tonymontana808 @.***> wrote:

when i open 127,0,01 it seem like this

[image: Capture] https://user-images.githubusercontent.com/134465661/249285676-b40a93e4-45e1-4c86-924f-e19f8a04d106.JPG

you can remove code which show sellers statics becuase everyone need custom own page not default one issue will be resolved also request to develoers to upgrade mysql datababase version and laravel version and some repo is outdated like carbon

— Reply to this email directly, view it on GitHub https://github.com/eckmarcommunity/eckmar/issues/65#issuecomment-1670549369, or unsubscribe https://github.com/notifications/unsubscribe-auth/AXSCEGBYVQVR6PGWAQ2PMLTXULWENANCNFSM6AAAAAAZWEQPUE . You are receiving this because you commented.Message ID: @.***>