• Resolved joswaks21

    (@joswaks21)


    Hello.
    I wanted to create a new album in WPPA after 4-5 months. After pressing the create album button, the message “Could not create album. Sorry, cannot continue” will appear. I tried to reinitialize the plugin, disable and enable plugin, try the plugin and wordpress in older versions, try others solutions on this forum but nothing helped.

    And i can’t import photos from my ftp server in albums too…

    Wordpress version : 5.6.1
    Wppa version : 7.7.02.006
    PHP version : 7.4.14

    Can you help me please, i don’t want to create a new website :/
    And sorry for my english.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Jacob N. Breetvelt

    (@opajaap)

    This error means that it could not create a new entry in the db table wppa_albums.
    Pls make sure your wp database is ok. You may also check the server error log for any error happened at the moment you try to create a new album.

    Thread Starter joswaks21

    (@joswaks21)

    Actually it’s a database bug.
    The server error log say :

    Notice: Undefined index: 2ndnaNZnHn in /home/users6/f/fsb1794/www/normandierallye/wp-includes/comment.php on line 675

    Notice: Trying to access array offset on value of type null in /home/users6/f/fsb1794/www/normandierallye/wp-includes/comment.php on line 675

    And it say an error in my db table : [Unknown column ‘zoomable’ in ‘field list’]

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Unknown column ‘zoomable’ in ‘field list’

    This makes sense.

    Run Table VIII-A1: Setup. (click the Doit! button)

    Thread Starter joswaks21

    (@joswaks21)

    That say errors in db table:
    Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
    ALTER TABLE wp_wppa_albums ADD COLUMN zoomable tinytext NOT NULL

    ALTER TABLE wp_wppa_albums ADD COLUMN displayopts tinytext NOT NULL

    ALTER TABLE wp_wppa_albums ADD COLUMN upload_limit_tree tinytext NOT NULL

    ALTER TABLE wp_wppa_photos ADD COLUMN angle smallint(5) NOT NULL default ‘0’`

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    These are strange errors, because data type tinytext is only 255 characters max.
    Ask your hosting provider or try optimize the album table (in phpMyAdmin).

    If you can not fix it, i can help you but i need admin access to your site to do that.

    You may mail me here: opajaap at opajaap dot nl

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    I can imagine that you do not want me to have access to your site.
    If you do the following, i can probably investigate it on my test site.

    Photo Albums -> Settings admin page, Table XII, first item, click: Download wp_wppa_albums.csv and mail me the .csv file. Then i can see if there is something wrong in the table.

    Thread Starter joswaks21

    (@joswaks21)

    Hello,

    Thank you for help. After seen my db table and my ftp server my website is so big. So i gonna create a new website, i have seen the plugin works correctly in a second website.

    Thanks again

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Ok, so this item can be closed. Please come back again when you experiece any issue in your new site.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Can’t create album and upload photos’ is closed to new replies.