Weird. You must have a post.php page, since the script creates the URL using $_SERVER[‘REQUEST_URI’]. I’m not sure how this could happen.
Well, you can create the table manually in phpMyAdmin or MySQL directly using this query:
CREATE TABLE wp_exhibit (
ID int(11) NOT NULL auto_increment,
post_ID int(11) NOT NULL default '0',
photo varchar(100) NOT NULL default '',
thumb varchar(100) default NULL,
caption text,
preview smallint(6) NOT NULL default '0',
PRIMARY KEY (ID) "
);
Be sure that the table name, “wp_exhibit”, uses the prefix of your WordPress database (“wp_”) and that “photos” is specified as the table name in your Exhibit config. Otherwise, change them to match.
Anonymous
i too am having this problem. i’m not too savy with phpMYadmin, but i get this error when i insert that query
“You have to choose at least one Column to display”
Anonymous
i think i was doing this wrong.
i tried again on the SQL page instead of the Query page and got this
“#1064 – You have an error in your SQL syntax near ‘”
)’ at line 8 “
this is what i posted in
CREATE TABLE wp_exhibit (
ID int(11) NOT NULL auto_increment,
post_ID int(11) NOT NULL default '0',
photo varchar(100) NOT NULL default '',
thumb varchar(100) default NULL,
caption text,
preview smallint(6) NOT NULL default '0',
PRIMARY KEY (ID) "
);
Ok, forget all that.
Go back to the Exhibit installation instructions:
Edit an existing post (or draft) and click on the link in the Exhibit area to create the required database table (if it doesn’t already exist).
In other words, do not click the link from a new blank post, or it won’t work.
Anonymous
ah ha! that worked. the formatting looks a little messed up though.
Without a URL to look at, I can only guess that you haven’t made changes to the CSS or config files so that Exhibit integrates well within your site.
how do you give exhibit a URL to look at?
