Title: [Plugin: NextGEN Gallery] – Cannot add a gallery Last modified: August 19, 2016 --- # [Plugin: NextGEN Gallery] – Cannot add a gallery * [thelastmuse](https://wordpress.org/support/users/thelastmuse/) * (@thelastmuse) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/) * Installed nextgen gallery v. 1.0.1. on WP 2.7 but when I tried adding a gallery, it doesn’t show that I have created any galleries. When I also tried uploading some images, they won’t upload as there’s no gallery selection shown (I have to indicate the gallery where I want the images uploaded to). When I checked the gallery folder on …wp-content/gallery/ it appears that there are gallery folders there that were created. * Help. Viewing 11 replies - 1 through 11 (of 11 total) * [Alex Rabe](https://wordpress.org/support/users/alexrabe/) * (@alexrabe) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933390) * Do you get any error ? Can you have a look into your databse (PHPMyadmin) are the “ngg” tables created ? * [mheej](https://wordpress.org/support/users/mheej/) * (@mheej) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933411) * alex: here’s i have the same error as thelastmuse. i cannot add a gallery because wordpress 2.7 is giving me this error: * =============================================================== WordPress database error: [Unknown column ‘author’ in ‘field list’] INSERT INTO wp_ngg_gallery ( name, path, title, author) VALUES (‘naga-2008-christmas-party’, ‘wp-content/gallery/ naga-2008-christmas-party’, ‘Naga 2008 Christmas Party ‘ , ‘1’) ============= ================================================== the folders are being created on wp-content gallery but i cannot upload pictures on the new gallery because it’s not showing as one of the galleries on the drop down box. i have also checked my database(phpMyadmin) and it shows wp_ngg_gallery as one of the tables. * i am using 1.0.2 version version of your nextgen gallery * looking forward for your help thank you * [Alex Rabe](https://wordpress.org/support/users/alexrabe/) * (@alexrabe) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933412) * Good information ! This means the update routine from the older version failed and didn’t update the tables. * You can add manual a new column per PHPMyAdmin with the folow parameter : * > BIGINT(20) NOT NULL DEFAULT ‘0’” * [mheej](https://wordpress.org/support/users/mheej/) * (@mheej) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933415) * thank you for your reply. * im so sorry but where exactly do i add this commands on my phpmyadmin? * please let me know thank you * [mheej](https://wordpress.org/support/users/mheej/) * (@mheej) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933418) * hi alex! * im still waiting for additional info on your instructions for adding a new column on my phpmyadmin * if you can just direct me as to where i need to add those parameters above i would appreciated it very much. * happy new year to you * thank you in advance! * oh, and will reinstalling nextgen gallery help too? * [mheej](https://wordpress.org/support/users/mheej/) * (@mheej) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933419) * i just did it! i reviewed phpmyadmin steps thank you very much for your help * [Alex Rabe](https://wordpress.org/support/users/alexrabe/) * (@alexrabe) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933420) * It’s better to complete reinstall (uninstall & install) again… * [mheej](https://wordpress.org/support/users/mheej/) * (@mheej) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933421) * sorry i was ahead of myself i can now add a gallery but now there’s another error im getting * ============================================================== WordPress database error: [Unknown column ‘imagedate’ in ‘field list’] UPDATE wp_ngg_pictures SET alttext = ‘dsci0492_1.jpg’, description = ”, imagedate = ‘2008-12-26 08:20:15’ WHERE pid = 3346 ============================================================ ======= * im presuming i have to do the same thing but i dont know what parameters to choose to fix this. * [beernews](https://wordpress.org/support/users/beernews/) * (@beernews) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933437) * Reporting that I have the same problem. I could go into phpmyadmin and make the fix though I would need to know what table and what the field name needs to be. * [Alex Rabe](https://wordpress.org/support/users/alexrabe/) * (@alexrabe) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933438) * Here are the two table structures which you need for V1.00 or higher : * **wp_ngg_pictures :** * ``` pid BIGINT(20) NOT NULL AUTO_INCREMENT , galleryid BIGINT(20) DEFAULT '0' NOT NULL , filename VARCHAR(255) NOT NULL , description MEDIUMTEXT NULL , alttext MEDIUMTEXT NULL , imagedate DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', exclude TINYINT NULL DEFAULT '0' , sortorder BIGINT(20) DEFAULT '0' NOT NULL , PRIMARY KEY pid (pid) ``` * **wp_ngg_gallery :** * ``` gid BIGINT(20) NOT NULL AUTO_INCREMENT , name VARCHAR(255) NOT NULL , path MEDIUMTEXT NULL , title MEDIUMTEXT NULL , galdesc MEDIUMTEXT NULL , pageid BIGINT(20) NULL DEFAULT '0' , previewpic BIGINT(20) NULL DEFAULT '0' , author BIGINT(20) NOT NULL DEFAULT '0' , PRIMARY KEY gid (gid) ``` * [mheej](https://wordpress.org/support/users/mheej/) * (@mheej) * [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933450) * thanks alex! will make sure those are my settings and will let you know if it’s working fine Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘[Plugin: NextGEN Gallery] – Cannot add a gallery’ is closed to new replies. ## Tags * [NexGen Gallery](https://wordpress.org/support/topic-tag/nexgen-gallery/) * 11 replies * 4 participants * Last reply from: [mheej](https://wordpress.org/support/users/mheej/) * Last activity: [17 years, 5 months ago](https://wordpress.org/support/topic/plugin-nextgen-gallery-10/#post-933450) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics