[Plugin: NextGEN Gallery] – Cannot add a gallery

Do you get any error ? Can you have a look into your databse (PHPMyadmin) are the “ngg” tables created ?

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

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’”

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

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?

i just did it!
i reviewed phpmyadmin steps
thank you very much for your help

It’s better to complete reinstall (uninstall & install) again…

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.

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.

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)

thanks alex! will make sure those are my settings and will let you know if it’s working fine