Sales reports broken :-(

Store Builder Questions
1

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!



regards

2

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.

3

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:



Soz

4

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_’);

define(‘DEFAULT_FILE_PERMISSIONS’, 0644);

define(‘DEFAULT_DIR_PERMISSIONS’, 0755);



Regards

5

So your reports run now and your site is okay?