[redwine]

Originally Posted by hotelsmadbar

Hello!

Can you help me please? I've modifid the fist step but now i can't change the next code in phpmyAdmin. I put the type (ENUM) and the value 'pending' in the field ´name´ | and put the type (ENUM) and the value 0 in the field ´total´ and the message error is:

#1062 - Duplicate entry '' for key 1

Please i need to undertans this step.

Regards,

Carlos

Then modify the “table_totals” to add a name and total for “pending”

insert into table_totals (`name`, `total`) values ('pending', 0); 

The first part of your question is how to alter the table_links and add a "pending" value to it. This is not manually done. When you login to phpmyadmin, the default values of the link_status are as follows:

link_status` enum('discard','queued','published','abuse','duplicated') NOT NULL default 'discard'

So we want to add a "pendig" value to it. We just run the following sql code from within the database (copy the sql code below and paste it in the sql window and run it):

alter TABLE table prefix_links change link_status link_status enum('discard','queued','published','abuse','duplicated','pending') NOT NULL default 'discard';

Note that the prefix is what you gave your tables upon installation of pligg. The default is "pligg_".

For the second part, just run the sql code from the table_totals (copy the sql code below and paste it in the sql window and run it):

insert into table_totals (`name`, `total`) values ('pending', 0);

let me know how it goes.