Forum Replies Created

Viewing 15 replies - 16 through 30 (of 31 total)
  • Thread Starter brt

    (@brt)

    The plugin has a code which will periodically check the tables created by aiowps and it will cleanup any table which has more than 5000 rows,…

    5000 rows would be no problem, the problem is: all the file information (thousands-of files!) is stored in one single row. and this single row is getting so big, that database backups start silently failing.

    i do not see how mentioned cleanup process could help in this case.

    • This reply was modified 6 years, 6 months ago by brt.
    Thread Starter brt

    (@brt)

    this is the mentioned thread:
    Database backup problems because of file change detection functionality

    is there a notification when the database backup fails?

    i am using automysqlbackup and get notifications by email in case of a failing backup, maybe users just do not notice when their database backup fails? i never got a warning of failing db backups within aiowps/wordpress. the dangerous thing is, that at the beginning, when you set it up, everything may work nicely all the time until you reach the limit, and then backups will silently fail.

    + 1

    broken sites-menu

    Thread Starter brt

    (@brt)

    Awesome, you are great!

    Works like a charm 🙂

    Thank you very much!

    ng,
    Robert

    Thread Starter brt

    (@brt)

    Thank you!

    ng,
    Robert

    Thread Starter brt

    (@brt)

    i just updated the plugin and noticed that sorting by email works now,
    this is great!

    i think you already know that sorting by name is still not possible.

    i took a quick look into the code and noticed that the client requests orderby=firstname but in includes/admin/class-es-subscribers-table.php in line #439 there is: $expected_order_by_values = array( 'name', 'email', 'created_at' );

    i changed it to $expected_order_by_values = array( 'first_name', 'email', 'created_at' ); and “voila!” sorting now works on the first_name 🙂

    • This reply was modified 6 years, 11 months ago by brt.
    • This reply was modified 6 years, 11 months ago by brt.
    • This reply was modified 6 years, 11 months ago by brt.
    Thread Starter brt

    (@brt)

    great news, thank you very, very much!

    same problem here

    Thread Starter brt

    (@brt)

    ah, thank you very much for clarification!

    Thread Starter brt

    (@brt)

    yes there are 14 backups in blogid_1, but i am 100% sure that these are the backups i did manually by hitting the button “Create DB Backup now”. just have a look at the file dates, they do not follow any rule.

    in blogid_1, as in all other blogs i have set to do a automatic backup every 2 days, and keep 14 Files.

    maybe the “keep files for 14 days” mechanism works, but i have never seen any automatic backup happen.

    Thread Starter brt

    (@brt)

    ok, good to know that it can work 🙂

    is this also a multisite installation?

    i have set up automatic database on every blog with an interval of 2 days and to keep 14 Backups, and this is what i have in the backup folders:

    web/wp-content/aiowps_backups/blogid_6:
    insgesamt 156
    -rw-rw-r-- 1 root www-data 155740 Apr  9  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1397059368.zip
    
    web/wp-content/aiowps_backups/blogid_11:
    insgesamt 20
    -rw-rw-r-- 1 root www-data 20223 Apr  9  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1397063461.zip
    
    web/wp-content/aiowps_backups/blogid_10:
    insgesamt 20
    -rw-rw-r-- 1 root www-data 19579 Apr 24  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1398362732.zip
    
    web/wp-content/aiowps_backups/blogid_13:
    insgesamt 8
    -rw-rw-r-- 1 root www-data 6404 Mai  2  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1399056497.zip
    
    web/wp-content/aiowps_backups/blogid_18:
    insgesamt 8
    -rw-rw-r-- 1 root www-data 7024 Aug  8  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1407531346.zip
    
    web/wp-content/aiowps_backups/blogid_19:
    insgesamt 12
    -rw-rw-r-- 1 root www-data 12234 Sep 25  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1411657236.zip
    
    web/wp-content/aiowps_backups/blogid_16:                                                                                                          [15/4852]
    insgesamt 40
    -rw-rw-r-- 1 root www-data 39422 Feb 11  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1423688200.zip
    
    web/wp-content/aiowps_backups/blogid_25:
    insgesamt 928
    -rw-rw-r-- 1 root www-data 197749 Apr 13  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1428945667.zip
    -rw-rw-r-- 1 root www-data 746654 Apr 14  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1429035571.zip
    
    web/wp-content/aiowps_backups/blogid_23:
    insgesamt 52
    -rw-rw-r-- 1 root www-data 52781 Apr 24  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1429890407.zip
    
    web/wp-content/aiowps_backups/blogid_12:
    insgesamt 84
    -rw-rw-r-- 1 root www-data 19499 Apr 24  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1398361710.zip
    -rw-rw-r-- 1 root www-data 63706 Sep  9 00:18 XXXXXXXX-database-backup-site-name-XXXXXXXX-1441757909.zip
    
    web/wp-content/aiowps_backups/blogid_2:
    insgesamt 2980
    -rw-rw-r-- 1 root www-data  169923 Apr  9  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1397055501.zip
    -rw-rw-r-- 1 root www-data 2875964 Jan 17 20:07 XXXXXXXX-database-backup-site-name-XXXXXXXX-1453057626.zip
    
    web/wp-content/aiowps_backups/blogid_2:
    insgesamt 2980
    -rw-rw-r-- 1 root www-data  169923 Apr  9  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1397055501.zip
    -rw-rw-r-- 1 root www-data 2875964 Jan 17 20:07 XXXXXXXX-database-backup-site-name-XXXXXXXX-1453057626.zip
    
    web/wp-content/aiowps_backups/blogid_5:
    insgesamt 4288
    -rw-rw-r-- 1 root www-data 116791 Apr  9  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1397063004.zip
    -rw-rw-r-- 1 root www-data 116791 Apr  9  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1397063128.zip
    -rw-rw-r-- 1 root www-data 116791 Apr  9  2014 XXXXXXXX-database-backup-site-name-XXXXXXXX-1397063263.zip
    -rw-rw-r-- 1 root www-data 806615 Jan 17 20:07 XXXXXXXX-database-backup-site-name-XXXXXXXX-1453064878.zip
    -rw-rw-r-- 1 root www-data 806615 Jan 17 20:10 XXXXXXXX-database-backup-site-name-XXXXXXXX-1453065051.zip
    -rw-rw-r-- 1 root www-data 806623 Jan 17 20:14 XXXXXXXX-database-backup-site-name-XXXXXXXX-1453065282.zip
    -rw-rw-r-- 1 root www-data 806623 Jan 17 20:15 XXXXXXXX-database-backup-site-name-XXXXXXXX-1453065337.zip
    -rw-rw-r-- 1 root www-data 806623 Jan 17 20:17 XXXXXXXX-database-backup-site-name-XXXXXXXX-1453065427.zip
    
    web/wp-content/aiowps_backups/blogid_1:
    insgesamt 69304
    -rw-rw-r-- 1 root www-data 3690326 Mai  9  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1431131062.zip
    -rw-rw-r-- 1 root www-data 3738918 Mai 13  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1431479281.zip
    -rw-rw-r-- 1 root www-data 3763344 Mai 17  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1431827503.zip
    -rw-rw-r-- 1 root www-data 3830374 Mai 31  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1433052436.zip
    -rw-rw-r-- 1 root www-data 3816151 Jun  6  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1433585719.zip
    -rw-rw-r-- 1 root www-data 3901525 Jun 12  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1434133524.zip
    -rw-rw-r-- 1 root www-data 4563090 Jul 20  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1437343371.zip
    -rw-rw-r-- 1 root www-data 4684937 Aug  3  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1438587075.zip
    -rw-rw-r-- 1 root www-data 4871432 Aug  9  2015 XXXXXXXX-database-backup-site-name-XXXXXXXX-1439112525.zip
    -rw-rw-r-- 1 root www-data 4838664 Sep 16 20:21 XXXXXXXX-database-backup-site-name-XXXXXXXX-1442427660.zip
    -rw-rw-r-- 1 root www-data 4807999 Sep 27 03:10 XXXXXXXX-database-backup-site-name-XXXXXXXX-1443316214.zip
    -rw-rw-r-- 1 root www-data 4958457 Okt 13 08:28 XXXXXXXX-database-backup-site-name-XXXXXXXX-1444717724.zip
    -rw-rw-r-- 1 root www-data 9488707 Jan 17 20:05 XXXXXXXX-database-backup-site-name-XXXXXXXX-1453057524.zip
    -rw-rw-r-- 1 root www-data 9989405 Feb 29 14:27 XXXXXXXX-database-backup-site-name-XXXXXXXX-1456752444.zip

    i am sure this are all manual backups.

    Thread Starter brt

    (@brt)

    this is a self hosted installation.

    no i can not try to disable all other plugins.

    as i have regular database backup (automysqlbackup) this is not a top priority feature, it would just be nice to have…

    i you are sure it is just a problem on my side, just ignore it, thanks for looking into the issue!

    Thread Starter brt

    (@brt)

    Yes, i still cannot find any backups, except the manually ones.

    But something changed in the logs, now it contains this, no mentioning of Backups at all:

    [02/23/2016 6:04 PM] - SUCCESS : Cronjob_Handler - Daily cron handler got fired.
    [02/23/2016 6:04 PM] - SUCCESS : DB Cleanup - checking if a cleanup needs to be done now...
    [02/24/2016 6:28 PM] - SUCCESS : Cronjob_Handler - Daily cron handler got fired.
    [02/24/2016 6:28 PM] - SUCCESS : DB Cleanup - checking if a cleanup needs to be done now...
    [02/25/2016 7:16 PM] - SUCCESS : Cronjob_Handler - Daily cron handler got fired.
    [02/25/2016 7:16 PM] - SUCCESS : DB Cleanup - checking if a cleanup needs to be done now...
    [02/26/2016 6:46 PM] - SUCCESS : Cronjob_Handler - Daily cron handler got fired.
    [02/26/2016 6:46 PM] - SUCCESS : DB Cleanup - checking if a cleanup needs to be done now...
    [02/27/2016 6:10 PM] - SUCCESS : Cronjob_Handler - Daily cron handler got fired.
    [02/27/2016 6:10 PM] - SUCCESS : DB Cleanup - checking if a cleanup needs to be done now...
    [02/28/2016 8:15 PM] - SUCCESS : Cronjob_Handler - Daily cron handler got fired.
    [02/28/2016 8:15 PM] - SUCCESS : DB Cleanup - checking if a cleanup needs to be done now...
    Thread Starter brt

    (@brt)

    oh thank you very much for your quick reply and the hint to the fix!

    works great, problem solved 🙂

    Thread Starter brt

    (@brt)

    thank you for your quick reply, you are absolutely right, it had nothing to do with the theme.

    the reason was a filter which i added to my childthemes function.php to open authors links in a new window. after removing that part everything is fine again!

    sorry for wasting your time, and thanks alot for pointing me to the right direction!

Viewing 15 replies - 16 through 30 (of 31 total)