Just copy the table stuff from the installer and create the table manually.
You mean I can just transplant the code for the table from the installer file to a different file? I’ll have to look at that particular file and see what’s going on? Where is it supposed to go?
All it does is create a new table, you can do that manually using phpmyadmin.
OK. Major confession. I don’t have the slightest idea how to create a new table using phpmyadmin. I’ve never done something like that before.
Whats the plugin actually called, where is it and I’ll tell you the how ?
Hey podz,
The plugin is wp-photos. The table I need to work with is somehow in wp-photos-installer.php but I don’t really know what I’m doing here. Thanks for offeirng help!
This must be a bug ….
I too have checked the other thread, I’ve stared at the syntax, tried moving things around, and all I get is this obtuse message:
“#1064 – You have an error in your SQL syntax.”
To make a table, open up phpmyadmin, click on your database. Once you see the list of the tables, above that is an SQL tab.
Click that and you’ll see a box.
Paste in the creation code, and click go.
If all is well, the table gets added to the existing database.
This is the code I tried (and I tried several variants all to no avail):
"CREATE TABLE $tablephotos ( "
."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, "
."photographer varchar(50) default NULL, "
."preview smallint(6) NOT NULL default '0', "
."post smallint(6) NOT NULL default '0', "
."PRIMARY KEY (ID) "
.")"
For reference:
MySQL 4.0.18
phpMyAdmin 2.5.3
Sorry !
Podz,
I appreciate everything you tried and are trying. No worries. I’m sure if this is a bug that needs to be fixed, that Alex (and others) will be working to get it fixed. I’ll just have to be patient. 🙂
Has anyone figured out what the bug is that is being discussed here? I’m back to trying to get wp-photos to work in my wordpress. My problem is still the same as the original post and I’m newbie enough that I don’t know how to use phpmyadmin to create a table — nor would I know what file or where in the file to place the table (assuming I figured out how to create it).
Anonymous
Take out the surrounding quotes when posting it in phpmyadmin, and substitute the variable $tablephotos for whatever it should be, like this:
CREATE TABLE tablenamehere (
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,
photographer varchar(50) default NULL,
preview smallint(6) NOT NULL default '0',
post smallint(6) NOT NULL default '0',
PRIMARY KEY (ID)
)
