punmail - how to create wp-table | Support Forum

Support Forum : punmail - how to create wp-table

Current User: Guest
Please consider registering

Home Forums Post/Page Update Notification punmail - how to create wp-table

punmail - how to create wp-table

Page: 1

User

Post

9:39 pm
21 Dec 2006

Martin

Guest

please, can you give some advice how to fix problem with creation of mysql table

under Manage/Notifications i got msg:
WordPress database error: [Table 'RDN.wp_punmail' doesn't exist]
SELECT post_id, COUNT(post_id) AS cnt FROM wp_punmail GROUP BY post_id;
(note, i hide my real databasename under RDN, sorry for this hiding)

hosting sql is: MySQL 5.0.26-Debian_3

thank you for any info. M

9:35 am
22 Dec 2006

Yellow Swordfish

Admin

Peterborough, England

posts 4629

I’m a little surprised. The plugin uses the ‘activation’ hook to create the table - introduced in WP 2 which is usually very successful. Still - you can use the following SQL and import it into phpMyAdmin or whatever tool your host provides (or, of course, the admirable phpMyAdmin wp plugin). Just copy and paste as is:

CREATE TABLE wp_punmail (
id bigint(20) NOT NULL auto_increment,
post_id bigint(20) NOT NULL,
email text,
PRIMARY KEY (id)
) ENGINE=MyISAM;

10:37 am
22 Dec 2006

Martin

Guest

thx, table created successfully
may be the “problem” were “strange” settings our (free)hosting server…
so thx again and sorry for this christmas surprise
M

Page: 1

Reply to Topic: punmail - how to create wp-table

About the Stuff at Yellow Swordfish forum
Currently Online: RobertB 13 Guests Maximum Online: 71	Forums: Groups: 3 Forums: 15 Topics: 1776 Posts: 11974	Members: There are 819 members There are 749 guests Yellow Swordfish has made 4629 posts	Top Posters: Mr Papa - 1256 -Radio- - 481 ovizii - 93 jfv - 80 angelic007 - 66
Administrator: Yellow Swordfish \| Moderators: Yellow Swordfish, Mr Papa, -Radio-

About the Stuff at Yellow Swordfish forum

Currently Online:

RobertB

13 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 15

Topics: 1776

Posts: 11974

Members:

There are 819 members

There are 749 guests

Yellow Swordfish has made 4629 posts

Top Posters:

Mr Papa - 1256

-Radio- - 481

ovizii - 93

jfv - 80

angelic007 - 66

Administrator: Yellow Swordfish | Moderators: Yellow Swordfish, Mr Papa, -Radio-

WP Plugins

Articles