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
