Like Posts

[vbgamer45]

I would drop the table smfsc_like_post it saying it already exists I think double check

[lesmond]

I would drop the table smfsc_like_post it saying it already exists I think double check

I did, the mod keeps putting it back, and the error comes up again!

[vbgamer45]

Try this attached file

[lesmond]

Thanks,
Sorry another DB error this time...

Code Select Expand

Duplicate column name 'liked_timestamp'
File: /home/xxxx/public_html/forum2/Packages/temp/installer/install.php
Line: 230
The 2 tables were created by the mod again.

I copied the members and posts tables from the other forum, would that make a difference?

[vbgamer45]

Try

[lesmond]

Thank you very much, working fine now, no errors

[vbgamer45]

Great glad that helped.

[lesmond]

Sorry to Bother again, I have another error

Code Select Expand

https:// xxxx.com/forums/index.php?action=likepostsstatsajax

Database Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
 'xxxx_smf2826.mem.real_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

File: /home/xxxx/public_html/forums/Sources/LikePosts/DB/LikePostsStatsDB.php
This happens when the 'Like Stats' link is clicked in the menu, and shows the spinning wheel on the following page...

[vbgamer45]

See if this file helps
Copy to /home/xxxx/public_html/forums/Sources/LikePosts/DB/

[lesmond]

 

Code Select Expand

Database Error: Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxx_smf2826.a.id_attach' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

File: /home/xxxx/public_html/forums/Sources/LikePosts/DB/LikePostsStatsDB.php
Line: 58

[vbgamer45]

Try this file

[lesmond]

 No file there

[vbgamer45]

Here now

[lesmond]

Thanks @vbgamer45 until I click on 'Most Like Giving user' then ....

Code Select Expand

Database Error: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxx_smf2826.a.id_attach' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

File: /home/xxxxx/public_html/forums/Sources/LikePosts/DB/LikePostsStatsDB.php
Line: 372

[vbgamer45]

Try this file

[lesmond]

Try this file

Thats got it this time.  Thank you very much

[vbgamer45]

2.2.4 update
Fixed some group by errors in the admin area.

[Ed2]

Trying to install Like Posts in a obsolete theme and get this error screen. Not sure if I should proceed.

Thanks

[vbgamer45]

If not using that theme safe to ignore.

[Ed2]

I am using the "balanced" theme