WordPress.org

1. Ovidiu
   Member
   Posted 3 years 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 years 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 years ago #
   

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

4. frekel
   Member
   Posted 3 years 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 3 years 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 3 years 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 3 years ago #
   

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

8. frekel
   Member
   Posted 3 years 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 3 years 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 3 years 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 3 years ago #
    

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

12. tamata
    Member
    Posted 3 years 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 3 years 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 3 years 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 3 years 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 3 years ago #
    

    Just released version 1.3.5 where auto-upgrading is fixed.

    Please read the 'readme.txt' file!

Topic Closed

This topic has been closed to new replies.