Upload Image problem

  • Resolved nechtej

    (@nechtej)


    9 months ago

    Hi, I have problem with uploading photos (I′m using backend). I simply click on “upload” in menu, choose album, click on browse , choose image, click on upload and then I get error message in the picture:

    There is the log:

    Err: on:24.06.2024 19:32:06: scrapcafeadmin (3383376): Album item usedby does not exist. ( get_album_item ) Stack: wppa-items.php:842 wppa_log() <- wppa-functions.php:6344 wppa_get_album_item() <- wppa-filter.php:876 wppa_add_usedby() <- wppa-filter.php:150 wppa_shortcode_atts() <- shortcodes.php:433 wppa_shortcodes() <- do_shortcode_tag()
    url: /wp-admin/admin.php?page=wppa_upload_photos
    Err: on:24.06.2024 19:32:02: scrapcafeadmin (3383376): Missing id in wppa_index_update() Stack: wppa-index.php:388 wppa_log() <- wppa-admin-functions.php:862 wppa_index_update() <- wppa-upload-common.php:178 wppa_insert_photo() <- wppa-upload.php:387 wppa_upload_one_item() <- wppa-upload.php:72 wppa_upload_multiple() <- wppa-admin.php:328 _wppa_page_upload()
    url: /wp-admin/admin.php?page=wppa_upload_photos
    Err: on:24.06.2024 19:32:02: scrapcafeadmin (3383376): Missing id in wppa_set_default_name() Stack: wppa-utils.php:2355 wppa_log() <- wppa-admin-functions.php:853 wppa_set_default_name() <- wppa-upload-common.php:178 wppa_insert_photo() <- wppa-upload.php:387 wppa_upload_one_item() <- wppa-upload.php:72 wppa_upload_multiple() <- wppa-admin.php:328 _wppa_page_upload()
    url: /wp-admin/admin.php?page=wppa_upload_photos
    Err: on:24.06.2024 19:32:02: scrapcafeadmin (3383376): Missing id in wppa_update_photo() Stack: wppa-wpdb-update.php:307 wppa_log() <- wppa-photo-files.php:479 wppa_update_photo() <- wppa-admin-functions.php:850 wppa_make_the_photo_files() <- wppa-upload-common.php:178 wppa_insert_photo() <- wppa-upload.php:387 wppa_upload_one_item() <- wppa-upload.php:72 wppa_upload_multiple()
    url: /wp-admin/admin.php?page=wppa_upload_photos
    Err: on:24.06.2024 19:32:02: scrapcafeadmin (3383376): Missing id in wppa_update_photo() Stack: wppa-wpdb-update.php:307 wppa_log() <- wppa-items.php:986 wppa_update_photo() <- wppa-items.php:927 wppa_get_thumbphotoxy() <- wppa-photo-files.php:474 wppa_get_photoy() <- wppa-admin-functions.php:850 wppa_make_the_photo_files() <- wppa-upload-common.php:178 wppa_insert_photo()
    url: /wp-admin/admin.php?page=wppa_upload_photos
    Err: on:24.06.2024 19:32:02: scrapcafeadmin (3383376): Missing id in wppa_update_photo() Stack: wppa-wpdb-update.php:307 wppa_log() <- wppa-items.php:986 wppa_update_photo() <- wppa-items.php:918 wppa_get_thumbphotoxy() <- wppa-photo-files.php:473 wppa_get_photox() <- wppa-admin-functions.php:850 wppa_make_the_photo_files() <- wppa-upload-common.php:178 wppa_insert_photo()
    url: /wp-admin/admin.php?page=wppa_upload_photos
    Err: on:24.06.2024 19:32:02: scrapcafeadmin (3383376): Missing id in wppa_update_photo() Stack: wppa-wpdb-update.php:307 wppa_log() <- wppa-items.php:986 wppa_update_photo() <- wppa-items.php:918 wppa_get_thumbphotoxy() <- wppa-photo-files.php:444 wppa_get_photox() <- wppa-admin-functions.php:850 wppa_make_the_photo_files() <- wppa-upload-common.php:178 wppa_insert_photo()
    url: /wp-admin/admin.php?page=wppa_upload_photos
    Err: on:24.06.2024 19:32:02: scrapcafeadmin (3383376): array ( 'id' => 776, 'album' => '126', 'ext' => 'jpg', 'name' => '08_IlonaK2.jpg', 'description' => '', 'p_order' => '0', 'mean_rating' => '', 'linkurl' => '', 'linktitle' => '', 'linktarget' => '_self', 'owner' => 'scrapcafeadmin', 'timestamp' => 1719250322, 'status' => 'publish', 'rating_count' => '0', 'tags' => '', 'alt' => '', 'filename' => '08_IlonaK2.jpg', 'modified' => 1719250322, 'location' => '', 'views' => '0', 'clicks' => '0', 'page_id' => '0', 'exifdtm' => '', 'videox' => '0', 'videoy' => '0', 'thumbx' => '0', 'thumby' => '0', 'photox' => '0', 'photoy' => '0', 'scheduledtm' => '', 'scheduledel' => '', 'custom' => '', 'stereo' => '0', 'crypt' => '2a926e7a1cb8d101', 'magickstack' => '', 'indexdtm' => '', 'panorama' => '0', 'angle' => '0', 'sname' => '', 'dlcount' => '0', 'thumblock' => '0', 'duration' => '', 'rml_id' => '', 'usedby' => '', 'misc' => '', ) Stack: wppa-wpdb-insert.php:253 wppa_log() <- wppa-admin-functions.php:824 wppa_create_photo_entry() <- wppa-upload-common.php:178 wppa_insert_photo() <- wppa-upload.php:387 wppa_upload_one_item() <- wppa-upload.php:72 wppa_upload_multiple() <- wppa-admin.php:328 _wppa_page_upload()
    url: /wp-admin/admin.php?page=wppa_upload_photos
    Err: on:24.06.2024 19:32:02: scrapcafeadmin (3383376): Could not insert into db table wppa_photos Stack: wppa-wpdb-insert.php:252 wppa_log() <- wppa-admin-functions.php:824 wppa_create_photo_entry() <- wppa-upload-common.php:178 wppa_insert_photo() <- wppa-upload.php:387 wppa_upload_one_item() <- wppa-upload.php:72 wppa_upload_multiple() <- wppa-admin.php:328 _wppa_page_upload()
    • This topic was modified 9 months ago by nechtej.

    The page I need help with: [log in to see the link]

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

    (@opajaap)

    Your database tables belonging to this plugin are not up-to-date.

    Maybe you have a ‘security’ plugin that inhibits adding or modifying db tables.
    De-activate your security plugins and de-activate / activate WP Photo ALbum Plus
    or run Photo Albums -> Settings -> Advanced settings -> Maintenance -> I -> Item 1: Setup

    Thread Starter nechtej

    (@nechtej)

    There are my plugins:

    I tried activate and deactivate plugin , but is does not help. I′m still unable to upload.
    I also tried activation from advanced settings

    Thread Starter nechtej

    (@nechtej)

    Any Ideas? @opajaap

    I dont have security plugins which prevents to change db. It could by update goes wrong? Can I fix this somehow on me own?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Can you create albums?
    Do you have any photos in the wppa system or do you have the problem with the first upload?

    Thread Starter nechtej

    (@nechtej)

    Hi, I′he been using your plugin for 3 years, I have 120 Albums and many photos in it.
    Problem starts after recent update, but Im not sure about which update exactly.

    Now I′m unable to create a new album and upload new images. Old images and albums work fine but Im also unable to comment photos.

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Please update to toays release 8.8.01.007 and try again

    Thread Starter nechtej

    (@nechtej)

    We installed update, but it didn′t help

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    To verify if your db tables are ok and up-to-date, do the following:

    Go to Advanced settings -> I: System constants.
    Download items 1 and 2: Album and Photo db table as csv file.

    Inspect them using a text editor.

    The first line of the album table should read (the sequence of the itmes may differ, but look if they all are present):

    id,name,description,a_order,main_photo,a_parent,p_order_by,cover_linktype,cover_linkpage,cover_link,owner,timestamp,modified,upload_limit,alt_thumbsize,default_tags,cover_type,suba_order_by,views,cats,scheduledtm,custom,crypt,treecounts,wmfile,wmpos,indexdtm,sname,zoomable,displayopts,upload_limit_tree,scheduledel,status,max_children,rml_id,usedby

    The first line of the photo table should read (also sequence not important):

    id,album,ext,name,description,p_order,mean_rating,linkurl,linktitle,linktarget,owner,timestamp,status,rating_count,tags,alt,filename,modified,location,views,clicks,page_id,exifdtm,videox,videoy,thumbx,thumby,photox,photoy,scheduledtm,scheduledel,custom,stereo,crypt,magickstack,indexdtm,panorama,angle,sname,dlcount,thumblock,duration,rml_id,usedby,misc

    Thread Starter nechtej

    (@nechtej)

    Hi, this is the first line:

    id,name,description,a_order,main_photo,a_parent,p_order_by,cover_linktype,cover_linkpage,owner,timestamp,modified,upload_limit,alt_thumbsize,default_tags,cover_type,suba_order_by,views,cats,scheduledtm,custom,crypt,treecounts,wmfile,wmpos,indexdtm,sname,zoomable,displayopts,upload_limit_tree,scheduledel,status,cover_link,max_children,rml_id

    the second:

    id,album,ext,name,description,p_order,mean_rating,linkurl,linktitle,linktarget,owner,timestamp,status,rating_count,tags,alt,filename,modified,location,views,clicks,page_id,exifdtm,videox,videoy,thumbx,thumby,photox,photoy,scheduledtm,scheduledel,custom,stereo,crypt,magickstack,indexdtm,panorama,sname,dlcount,thumblock,duration,angle,rml_id

    It looks like usedby is missing and in photos is missing usedby and misc

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    I did the following test on my dev site:
    Using phpMyAdmin, i removed columns usedby and misc from the photos db table an verifierd they were gone.

    Then i ran Advanced settings -> Maintenance -> I -> Item 1: Setup, and they re-appeared.

    So, when you run maintenance proc Setup, the db shgould be up-to-date.
    If you have access to phpMyAdmin, you can add them manually

    If not successful: Ask your hosting provider why you can no longer add columns to data bases.

    Thread Starter nechtej

    (@nechtej)

    Hi again,

    sorry for the delay, I tried to add columns to table album with no luck, see screen bellow, sorry its not in english:

    • This reply was modified 8 months ago by nechtej.
    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Change the data types mediumtext to text

    If not enough, you can also change text to tinytext for a few items like timestamp, modified, scheduledtm etc, but not for custom and description

    After changes made, do the setup from the settingspage or de- and re-activate the plugin, or try to add the missing columns again

    Thread Starter nechtej

    (@nechtej)

    It works! Thank You

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Good! I will automatically change the datatypes (more than just the ones you did manually) to make them take less space, when upgrading to the next version, to prevent this kind of issues in the future.

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘Upload Image problem’ is closed to new replies.