Support » Plugin: Shortlinks by Pretty Links - Best WordPress Link Tracking Plugin » Pretty Link was Successfully Created but No

  • Resolved noxos

    (@noxos)


    Hello,
    I’m using this plugin on different sites without problem, but on some sites there is this error or problem.

    I’m creating the link, there is this message :

    Your Pretty Link was Successfully Created

    Cool ! but no ! the link is not really created, impossible to see it on admin.php?page=pretty-link or to find it in the DB, nothing at all.

    in admin.php?page=pretty-link there is only a video Watch this video to see how to get started! nothing else.

    WP is fully clean with WP Optimze, database is clean and fixed too.

    What could be the problem and the solution ?
    Don’t hesitate, thanks for your help,
    this plugin is quite helpfull for me.

Viewing 9 replies - 1 through 9 (of 9 total)
  • I’m having the same issue.

    Plugin Author cartpauj

    (@cartpauj)

    It sounds like the database tables may not have been created properly.

    Try deactivating Pretty Link.

    Then using phpMyAdmin or a WordPress plugin like Adminer browse to your wp_options table and search for the prli_db_version row and delete it.

    Then re-activate the Pretty Link plugin again.

    If you’re not sure how to do this, your webhost may be able to assist with the above instructions.

    That worked! Thank you!

    Hello,

    I tryed to do it : no changement, still the problem
    I also deactivated plugin, canceled it and used Wp Optimize to clean DB
    At this moment there is no more the prli_db_version row
    I reinstaled plugin, and still the same the error no succes to create a link,

    Idea or other solution ?
    Thanks for your support,

    Plugin Author cartpauj

    (@cartpauj)

    I’m not sure, will you reach to us from our contact form here so we can get more details: https://prettylinkpro.com/contact/

    I am having the same issue.

    I create a pretty link and get the notice message “Your Pretty Link was Successfully Created” but it doesn’t show up within the list.

    I have deactivated the plugin, deleted the prli_db_version, activated it again but getting the same error.

    Plugin Author cartpauj

    (@cartpauj)

    @jaschaio
    Check your error logs and see if there’s any clues in there. Your web host should be able to tell you where the logs location is.

    I see a lot of these ones, with only having the plugin enabled:

    "PHP message: WordPress database error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist for query SELECT * FROM 27hsFNUsmkLj_prli_links WHERE slug='how-to-start-exercising' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, PrliAppController->redirect, PrliLink->is_pretty_link, PrliLink->is_pretty_link_slug, PrliLink->getOneFromSlug" while reading response header from upstream, client: 185.93.229.4, server: habitualmente.com, request: "GET /how-to-start-exercising/?time=America/Bogota HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock:", host: "example.org", referrer: "https://example.org/how-to-start-exercising/"

    And these ones pop up once I try to create a pretty link:

    PHP message: WordPress database error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist for query SELECT * FROM 27hsFNUsmkLj_prli_links WHERE slug='take-pictures-of-your-food/feed' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, PrliAppController->redirect, PrliLink->is_pretty_link, PrliLink->is_pretty_link_slug, PrliLink->getOneFromSlug
    PHP message: WordPress database error
    2017/02/17 21:11:42 [error] 17881#17881: *306060 FastCGI sent in stderr: "yMg1s_prli_links WHERE slug='take-pictures-of-your-food/feed' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, PrliAppController->redirect, PrliLink->is_pretty_link, PrliLink->is_pretty_link_slug, PrliLink->getOneFromSlug
    PHP message: WordPress database error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist for query SELECT * FROM 27hsFNUsmkLj_prli_links WHERE slug='take-pictures-of-your-food/feed' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, PrliAppController->redirect, PrliLink->is_pretty_link, PrliLink->is_pretty_link_slug, PrliLink->getOneFromSlug" while reading response header from upstream, client: 192.88.135.4, server: example.org, request: "GET /baja-de-peso-tomando-fotos/feed/ HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock:", host: "example.org"
    2017/02/17 21:12:02 [error] 17881#17881: *306062 FastCGI sent in stderr: "PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_groups' doesn't exist de la base de datos de WordPress para la consulta SELECT gr.* FROM 27hsFNUsmkLj_prli_groups gr ORDER BY name realizada por wp_dashboard, do_meta_boxes, PrliAppController->dashboard_widget_function, PrliGroup->getAll
    PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist de la base de datos de WordPress para la consulta SELECT slug FROM 27hsFNUsmkLj_prli_links realizada por wp_dashboard, do_meta_boxes, PrliAppController->dashboard_widget_function, PrliLinksController::setup_new_vars, PrliLink->generateValidSlug
    PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist de la base de datos de WordPress para la consulta SELECT * FROM 27hsFNUsmkLj_prli_links WHERE slug='zuqy' realizada por wp_dashboard, do_meta_boxes, PrliAppController->dashboard_widget_function, PrliLinksController::setup_new_vars, PrliLink->generateValidSlug, PrliUtils::slugIsAvailable, PrliLink->getOneFromSlug
    PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist de la base de datos de WordPress para la consulta SELECT slug FROM 27hsFNUsmkLj_prli_links realizada por wp_dashboard, do_meta_boxes, PrliAppController->dashboard_widget_function, require_once('/plugins/pretty-link/app/views/widgets/widget.php'), PrliLink->generateValidSlug
    PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist de la base de datos de WordPress para la consulta SELECT * FROM 27hsFNUsmkLj_prli_links WHERE slug='ll09' realizada por wp_dashboard, do_meta_boxes, PrliAppController->dashboard_widget_function, require_once('/plugins/pretty-link/app/views/widgets/widget.php'), PrliLink->generateValidSlug, PrliUtils::slugIsAvailable, PrliLink->getOneFromSlug" while reading upstream, client: 185.93.231.4, server: example.org, request: "GET /wp-admin/ HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock:", host: "example.org
    2017/02/17 21:12:18 [error] 17881#17881: *306066 FastCGI sent in stderr: "PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_groups' doesn't exist de la base de datos de WordPress para la consulta SELECT gr.* FROM 27hsFNUsmkLj_prli_groups gr ORDER BY name realizada por do_action('pretty-link_page_add-new-pretty-link'), WP_Hook->do_action, WP_Hook->apply_filters, PrliLinksController::new_link, PrliGroup->getAll
    PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist de la base de datos de WordPress para la consulta SELECT slug FROM 27hsFNUsmkLj_prli_links realizada por do_action('pretty-link_page_add-new-pretty-link'), WP_Hook->do_action, WP_Hook->apply_filters, PrliLinksController::new_link, PrliLinksController::setup_new_vars, PrliLink->generateValidSlug
    PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist de la base de datos de WordPress para la consulta SELECT * FROM 27hsFNUsmkLj_prli_links WHERE slug='z4ot' realizada por do_action('pretty-link_page_add-new-pretty-link'), WP_Hook->do_action, WP_Hook->apply_filters, PrliLinksController::new_link, PrliLinksController::setup_new_vars, PrliLink->generateValidSlug, PrliUtils::slugIsAvailable, PrliLink->getOneFromSlug" while reading upstream, client: 185.93.231.4, server: example.org, request: "GET /wp-admin/admin.php?page=add-new-pretty-link HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock:", host: "example.org", referrer: "https://example.org/wp-admin/"
    2017/02/17 21:12:37 [error] 17881#17881: *306070 FastCGI sent in stderr: "PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist de la base de datos de WordPress para la consulta SELECT * FROM 27hsFNUsmkLj_prli_links WHERE slug='test' realizada por do_action('toplevel_page_pretty-link'), WP_Hook->do_action, WP_Hook->apply_filters, PrliLinksController::route, PrliLinksController::create_link, PrliLink->validate, PrliUtils::slugIsAvailable, PrliLink->getOneFromSlug
    PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist de la base de datos de WordPress para la consulta SHOW FULL COLUMNS FROM <code>27hsFNUsmkLj_prli_links</code> realizada por do_action('toplevel_page_pretty-link'), WP_Hook->do_action, WP_Hook->apply_filters, PrliLinksController::route, PrliLinksController::create_link, PrliLink->create
    PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist de la base de datos de WordPress para la consulta SELECT COUNT(*) FROM 27hsFNUsmkLj_prli_links li realizada por do_action('toplevel_page_pretty-link'), WP_Hook->do_action, WP_Hook->apply_filters, PrliLinksController::route, PrliLinksController::create_link, PrliLinksController::display_links_list, PrliLink->getRecordCount
    PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist de la base de datos de WordPress para la consulta SELECT COUNT(*) FROM 27hsFNUsmkLj_prli_links li realizada por do_action('toplevel_page_pretty-link'), WP_Hook->do_action, WP_Hook->apply_filters, PrliLinksController::route, PrliLinksController::create_link, PrliLinksController::display_links_list, PrliLink->getPageCount, PrliLink->getRecordCount
    PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_links' doesn't exist de la base de datos de WordPress para la consulta SELECT li.*, (SELECT COUNT(*) FROM 27hsFNUsmkLj_prli_clicks cl WHERE cl.link_id = li.id) as clicks, (SELECT COUNT(*) FROM 27hsFNUsmkLj_prli_clicks cl WHERE cl.link_id = li.id AND cl.first_click <> 0) as uniques, gr.name as group_name FROM G9HyPHQ
    2017/02/17 21:12:37 [error] 17881#17881: *306070 FastCGI sent in stderr: "PHP message: Error Table 'kdzSjEnsxm.27hsFNUsmkLj_prli_groups' doesn't exist de la base de datos de WordPress para la consulta SELECT gr.* FROM 27hsFNUsmkLj_prli_groups gr realizada por do_action('toplevel_page_pretty-link'), WP_Hook->do_action, WP_Hook->apply_filters, PrliLinksController::route, PrliLinksController::create_link, PrliLinksController::display_links_list, require_once('/plugins/pretty-link/app/views/links/list.php'), PrliLinksHelper::groups_dropdown, PrliGroup->getAll" while reading upstream, client: 185.93.231.4, server: example.org, request: "POST /wp-admin/admin.php?page=pretty-link HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock:", host: "example.org", referrer: "https://example.org/wp-admin/admin.php?page=add-new-pretty-link"
    Plugin Author cartpauj

    (@cartpauj)

    Can you delete the prli_db_version row again, then refresh your dashboard and see if any new errors are logged?

    The “doesn’t exist” errors are just symptoms because the tables aren’t being created. Hopefully there will be some error about why the tables aren’t being created.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Pretty Link was Successfully Created but No’ is closed to new replies.