|
Thank you kbeeveer46,
Is the solution to delete the lines of code in user.php and do what Ash says or is it just one or the other?
---------------
Ash:
The recommended fix is to open phpmyadmin and run these 2 queries.
Be sure to replace the word table_pageviews with the name of your table.
ALTER TABLE `table_pageviews` ADD KEY `select` (`pv_type`,`pv_page_id`,`pv_user_id`);";
ALTER TABLE `table_pageviews` ADD KEY `groupby` (`pv_type`,`pv_page_id`,`pv_datetime`,`pv_user_id` );";
---------------
I deleted the lines of code already and it is still not working because mysql is locked down. I will email the host to get in but I am a little weary of try the DB edit myself.
|