Sales reports broken :-(

Hi all,

I have just tried accessing my sales reports however bizarrely it takes forever to run the query and then i get this warning

Fatal error: Allowed memory size of 50331648 bytes exhausted (tried to allocate 35 bytes) in /public_html/prepare.php on line 182

any help would be great as would love to see our sales reports!


first step is to increase your memory_limit in config.local.php…

It will probably look something like:

ini_set('memory_limit', '48M');

Suggest you change 48M to 128M.

Hi, I just altered it to 128M and now i get this

Database error: Table ‘database_databasename.TABLE_PREFIXsessions’ doesn’t exist (1146)

Invalid query: SELECT * FROM TABLE_PREFIXsessions WHERE session_id = ‘1b066923d44a6afcec2c4af42eff3ffa’ AND area = ‘C’

Any ideas as now my site doesnt work :frowning:


sory for some reason when i added config.local.php back to my ftp it crashed and i needed to add

define(‘TABLE_PREFIX’, ‘cscart_’);




So your reports run now and your site is okay?