[Plugin: PhotoContest Plugin] getting an error when adding a new contest

  • Resolved Ovidiu

    (@ovidiu)


    14 years, 6 months 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/

Viewing 15 replies - 1 through 15 (of 15 total)
  • seanx820

    (@seanx820)

    14 years, 5 months 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….

    Thread Starter Ovidiu

    (@ovidiu)

    14 years, 5 months ago

    nope, it seems the author is updating the plugin but I haven’t seen him respond in this forum 🙁

    frekel

    (@frekel)

    14 years, 5 months 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

    frekel

    (@frekel)

    14 years, 5 months 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.

    frekel

    (@frekel)

    14 years, 5 months 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

    Thread Starter Ovidiu

    (@ovidiu)

    14 years, 5 months ago

    Just checked again: I had 1.2.3.1 🙁 any other hints?

    frekel

    (@frekel)

    14 years, 5 months 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_)

    Thread Starter Ovidiu

    (@ovidiu)

    14 years, 5 months 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

    frekel

    (@frekel)

    14 years, 5 months 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)

    Thread Starter Ovidiu

    (@ovidiu)

    14 years, 5 months ago

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

    tamata

    (@tamata)

    14 years, 5 months 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

    frekel

    (@frekel)

    14 years, 5 months 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?

    tamata

    (@tamata)

    14 years, 5 months 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

    frekel

    (@frekel)

    14 years, 5 months 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

    frekel

    (@frekel)

    14 years, 5 months ago

    Just released version 1.3.5 where auto-upgrading is fixed.

    Please read the ‘readme.txt’ file!

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘[Plugin: PhotoContest Plugin] getting an error when adding a new contest’ is closed to new replies.