Clear gift certificate queue

[jurjenruben]

Thanks for your reply.
Database noob here...

This is what I have for the coupon_gv_customer:


This is what I have for the coupon_gv_queue:


What should I alter? I have 2 GV's queued.
Hope you can help me out.
Thanks!

[fairestcape]

In phpMyAdmin, you need to display the CONTENT, not the STRUCTURE. Click on the folder icon NEXT TO the table name - not the name itself.

[jurjenruben]

Ah, thanks!

[Florin]

Sorry to post in this old thread but I accidentally deleted (dropped) the customer_id in phpmyadmin from zen_coupon_gv_customer and zen_coupon_gv_queue
(ALTER TABLE `zen_coupon_gv_customer` DROP
`customer_id`
and the same for the other one), is there anything I can do to put it back? Thanks.

[Florin]

I restored it from a backup :) And I emptied both tables and I got rid of the gift certificate queue waiting approval ...