WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ambertat_sims.wp_enposts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_enposts WHERE post_date < '2017-09-22 02:38:24' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

Warning for people who edit sims and hoods in SimPE

It has come to my attention that some people have misunderstood how to make and restore game backups, and have been trying to use SimPE’s .bak files to fix problems. The .bak files should only be used to restore an object, recolour or hack you have been working on - never ever your game data! Game data includes anything in My Documents\EA Games\The Sims 2\Neighborhoods, such as Sims, Lots, Hoods etc. Even if it a mistake you made just that moment in editing a sim in SimPE, and you haven’t played in between times, you still need to go back to a proper full backup, because you may miss out one of the files that has been affected by your edit, and your data will be out of sync.

A safe backup is a complete copy of an entire Neighborhood folder and its contents - eg My Documents\EA Games\The Sims 2\Neighborhoods\N001, and to restore safely from that, you need to first completely delete the folder you are replacing so that any new files that were made during your last play session are gone. Simply overwriting the folder is not safe.

You can do the above manually, or you can use SimPE’s backup manager, in the Neighborhood Browser.

Future releases of SimPE will not have automatic .bak creation on by default, to try and avoid any more confusion

Inge Jones.

Comments are closed.