WordPress.org

1. Ovidiu
   Member
   Posted 4 weeks ago #

   getting this error when adding a new contest: `Error saving PhotoContest 'New logo for January 2010contest'.

   Can't insert into the database

   WordPress database error: [Table 'mydbname.myprefix_photocontest_admin' doesn't exist]

   INSERT INTO myprefix_photocontest_admin (post_id,start_date,end_date,upload_date,contest_path,contest_name,intro_text,num_photo,max_photos) VALUES ('43','2009-10-28','2009-12-31','2009-12-15','new_logo_for_january_2010contest','New logo for January 2010contest','Blablarnblablarnblabla','0','1')
   `

   I deactivated and reactivated the plugin and the tables do not get created, any idea?

   where is the sql code that creates the needed tables upon plugin activation? if you give me that code, I'll use phmyadmin to create them...

   http://wordpress.org/extend/plugins/wp-photocontest/

2. seanx820
   Member
   Posted 3 weeks ago #

   did you ever get a response from the creator? I am trying to figure out why mine won't work. I get this error

   Missing template file. Please read the readme file!

   Even though I thought I followed the directions exactly....

3. Ovidiu
   Member
   Posted 3 weeks ago #

   nope, it seems the author is updating the plugin but I haven't seen him respond in this forum :-(

4. frekel
   Member
   Posted 2 weeks ago #

   Sorry, the author (me ;) didn't know about the support forum... but I'm here and will try to answer all questions within 24 hours!!

   Greets,
   Frank

5. frekel
   Member
   Posted 2 weeks ago #

   Ovidiu,

   It looks like you have version 1.3 which was on the wordpress while it isn't close to releasing...

   Please revert back to the 1.2.3.1 version.

   The SQL code is in the lib/wp-photocontest.functions.php file.
   In the 'real' 1.3 version, I will provide an seperate sql file.

6. frekel
   Member
   Posted 2 weeks ago #

   seanx820,

   Did you follow the follwing directions:

   Copy page.php or index.php to skins/aqua/template.tpl
   Open template.tpl (in wordpress or your favorite editor)
   Replace from:
   <?php if ( have_posts() ) : while ( have_posts() ) : the_post(); ?>
   to:
   

   <?php endwhile; else: ?>
   <p><?php _e('Sorry, no posts matched your criteria.'); ?></p>
   <?php endif; ?>

   (and anything in between)

   with
   [WP-PHOTOCONTEST CONTENT]

   See for more information about The Loop: http://codex.wordpress.org/The_Loop

7. Ovidiu
   Member
   Posted 2 weeks ago #

   Just checked again: I had 1.2.3.1 :-( any other hints?

8. frekel
   Member
   Posted 2 weeks ago #

   For now, you can use these sql codes:

   WP PhotoContest V1.2.3.1 dbDump

   DON'T FORGET TO CHANGE [WP_PREFIX] to your prefix (myprefix_)

9. Ovidiu
   Member
   Posted 2 weeks ago #

   Ok, used that, worked just fine.

   Btw. could you add some options the create new photo contest?
   i.e. I'd like all photo contests to be subpages of a page called contest :-9

10. frekel
    Member
    Posted 2 weeks ago #

    Ok, you mean that when creating a photocontest, you can select the parent, instead of the homepage?

    For now, you can goto the page after creating a photocontest and select the parent page there. (I know this isn't user-friendly, so let me see if I can add that option)

11. Ovidiu
    Member
    Posted 2 weeks ago #

    jepp, you got that right. would be a huge help to have that option.

12. tamata
    Member
    Posted 2 weeks ago #

    Hello, thanks for the nice plugin. I'd like to use it but I cannot configure the page inside my template.
    I know maybe you cannot do it but if you have time to check what's happend in my website I'll appreciate it.
    Its not an online page but u can see at this address:
    http://www.yemanja.it/?page_id=581

    On the first page all works but when you enter to upload or visit the pictures all the widget and the template is wrong.
    Is it possible to fit your plugin in there?
    Thanks a lot
    fabio

13. frekel
    Member
    Posted 2 weeks ago #

    @tamata Did create the template.tpl inside the skins directory (see how in the 6th post)?

    If so, tell me which theme you use (if you have edited your theme, send me the page.php and index.php by email: anti spam @ van der stad . nl)

    Greets,
    Frank

    Note: Can you create a new thread when replying?

14. tamata
    Member
    Posted 2 weeks ago #

    Sorry Frank but I'm new about this things. I'll try to follow your instruction to create a new template and we see( do you think also a newbie is able to do?). I also tried to open a new thread but there are too many and the risk to loose your answer.
    Thanks
    fabio

15. frekel
    Member
    Posted 2 weeks ago #

    No problem.

    If you follow the instrcutions, even a newbie can create the template.
    But if it fails, don't worry; send the page.php and index.php file by email and I will create the template for you.

    Greets,
    Frank

16. frekel
    Member
    Posted 1 week ago #

    Just released version 1.3.5 where auto-upgrading is fixed.

    Please read the 'readme.txt' file!

Reply

You must log in to post.