How to clean DB from old logs in Magento 1.x
How to clean DB from old logs in Magento 1.x Using MySQL truncate log_customer ; truncate log_quote ; truncate log_summary ; truncate log_summary_type ; truncate log_url ; truncate log_url_info ; truncate log_visitor ; truncate log_visitor_info ; truncate log_visitor_online ; login to shell(SSH) go with root/shell folder. execute the below command inside the shell folder php - f log . php clean enter this command to view the log data's size php -f log.php status This method will help you to clean the log data's very easy way.
To rid yourself of the annoying little black rectangle do the following, its only a work around but it does work.
Create a script, mine starts my kiosk as well so is called /home/pi/screen.sh
this script should look like:
#!/bin/bash
startx –help
while true; do chromium –kiosk –incognito –enable-plugins http://your web addresshere.html;sleep 180s;done
The 2nd line is my kiosk – you probably wont need it but I put it there anyway.
Then add the following line
@/home/pi/screen.sh
to the file:
/etc/xdg/lxsession/LXDE-pi/autostart
Reboot and watch the splash screen followed by a brief black flash and then your screenly, kiosk, or whatever your running without the black rectangle.