Support » Plugin: WP Photo Album Plus » Can not create a new photo album

  • Resolved Mats Ahlbom

    (@mats-ahlbom)


    Hello,
    I have created one first photo album, but when I now want to create a new album I got the message below:
    Do any one know whats wrong?
    BR/Mats

    Could not create album.
    Query = INSERT INTO wp_media_pilysgourme_se_wppa_albums (id, name, description, a_order, a_parent, p_order_by, main_photo, cover_linktype, cover_linkpage, owner, timestamp, upload_limit, alt_thumbsize) VALUES (‘7’, ‘New Album’, ”, ‘0’, ‘0’, ‘0’, ‘0’, ‘content’, ‘0’, ‘Mats Ahlbom’, ‘1362078941’, ‘0/0’, ‘0’)

    http://wordpress.org/extend/plugins/wp-photo-album-plus/

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

    (@opajaap)

    Run Table VIII-A1: Setup. Thsi action can ALWAYS be run to make sure the plugin is properly inialized.

    If the error persists, add in wp-config the line:

    define('WP_DEBUG', true);

    This will in most cases produce usefull errormessage(s).

    I tried to run VIII-A1 but without resolution.
    I would like add the line you suggested, but I don’t know where, where is the wp-conf located ?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    wp-config.php is in the wordpress root directory. You have initially added the db hostname and db name there.

    I have tried to find the wp-conf.php, I don’t know how to reach the root directory?
    I have now uninstalled and reinstalled the plugin, now its impossible to make any photo album at all.
    The following script coming up:
    Could not create album.
    Query = INSERT INTO wp_media_pilysgourme_se_wppa_albums (id, name, description, a_order, a_parent, p_order_by, main_photo, cover_linktype, cover_linkpage, owner, timestamp, upload_limit, alt_thumbsize) VALUES (’17’, ‘New Album’, ”, ‘0’, ‘0’, ‘0’, ‘0’, ‘content’, ‘0’, ‘Mats Ahlbom’, ‘1362603785’, ‘0/0’, ‘0’)

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    wp-config.php is in the directory where wordpress resides, i.e. the directory on the server where the sub-dir wp-content is.

    Is your database prefix indeed: wp_media_pilysgourme_se_ ?

    My web page is http://www.pilysgourme.se.
    I talked to my web hotel provided and they added the code that you sent to me, and I have copied the error message below:
    I hope you understand what this mean?

    Notice: has_cap kallades med ett argument som har upphört sedan version 2.0! Användning av användarnivåer via tillägg och teman har upphört. Använd roller och behörigheter istället. in /www/webvol12/r4/uz0ch3d1wtujkek/pilysgourme.se/public_html/wp-includes/functions.php on line 2923

    Notice: has_cap kallades med ett argument som har upphört sedan version 2.0! Användning av användarnivåer via tillägg och teman har upphört. Använd roller och behörigheter istället. in /www/webvol12/r4/uz0ch3d1wtujkek/pilysgourme.se/public_html/wp-includes/functions.php on line 2923

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_albums’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_albums CHANGE COLUMN p_order_by p_order_by int unsigned NOT NULL

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_albums’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_albums ADD COLUMN alt_thumbsize tinytext NOT NULL

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_photos’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_photos ADD COLUMN tags tinytext NOT NULL

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_photos’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_photos ADD COLUMN alt tinytext NOT NULL

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_albums’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_albums MODIFY name text CHARACTER SET utf8

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_photos’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_photos MODIFY name text CHARACTER SET utf8

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_albums’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_albums MODIFY description text CHARACTER SET utf8

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_photos’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_photos MODIFY description longtext CHARACTER SET utf8

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_photos’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_photos MODIFY linktitle text CHARACTER SET utf8

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_comments’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_comments MODIFY comment text CHARACTER SET utf8

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_iptc’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_iptc MODIFY description text CHARACTER SET utf8

    WordPress database error: [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_exif’]
    ALTER TABLE wp_media_pilysgourme_se_wppa_exif MODIFY description text CHARACTER SET utf8

    Hi, I find out that there are more error codes, do you need that to find what to do?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    [ALTER command denied to user ‘wrdprs1@p64795’@’s385.loopia.se’ for table ‘wp_media_pilysgourme_se_wppa_photos’]

    This is your problem. Ask the hosting provider to give you the rights, and run the setup procedure after you got the rights on Table VIII-A1

    Hi, Thank you very much for your valuable support now it’s working again!
    Excuse me all questions, but I think your plugin is very good and I would like to get it to work perfectly.
    When I add a photo I would like connect a link to that photo, I tried to do so in the Manage photo on Link Url: and also a link title on Link title: but I don’t get it to work. Do I need to configure this function in some place or?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Photo ALbums -> Settings admin page Table VI chek under PSO ( Photo Specific link Overrules ) where you want it to happen.

    Mr. OpaJaap,
    I have tried many photo album plugin’s for my WordPress Blog, which is at aafmua.org. None is working for me after the WordPress 3.5 release. Then I found your WPPA. I am excited about this plugin because I think it is going to work. In order to present photo albums at my site, I need your help. Your help will be greatly appreciated.
    Site URL: aafmua.org
    Theme: WorkSpace
    Here is the problem, I installed and activated your WPPA as instructed. Then I download some photos and created an album, called “TheCaddy”. I inserted the shortcode generated by WPPA onto a post called “WPPA Demo”. I got, on the post, the top menu of the album and the bottom strip of boxes, which is not moving. In the middle there is a large open area, where supposedly the slideshow was to load. When I clicked on “Start”, nothing happened. Please see the screen shots (http://aafmua.org/wppa-questions/) to see what I mean.
    Please advise. Thank you very much!

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Can not create a new photo album’ is closed to new replies.