This website uses cookies to personalize your experience. By using this website you agree to our cookie policy.

Unable to style form or generate shortcode

Home Forums Product Support Forums Ajax Search Pro for WordPress Support Unable to style form or generate shortcode

Viewing 15 posts - 1 through 15 (of 15 total)
  • Author
    Posts
  • #20046
    ralphlemoufralphlemouf
    Participant

    I’m unable to generate a shortcode or find out where to generate shortcodes. Also, the customize section is missing where I can design my form.

    #20062
    Ernest MarcinkoErnest Marcinko
    Keymaster

    Hi,

    I believe these documentation sections will help you out:
    Getting started, your first search instance
    Search shortcodes
    Additionally, you can change and customize the themes under the theme options panel, on each search isntance.

    #20069
    ralphlemoufralphlemouf
    Participant

    I’ve tried that and it won’t let me. Please see error in screen shot.

    #20074
    Ernest MarcinkoErnest Marcinko
    Keymaster

    Hi,

    That could mean, that the database tables might be missing, due to a bad installation or incorrect database user privileges. I recommend re-installing the plugin, using this method:
    – First, wipe all plugin data, via the Maintenance menu
    – Then installing via the plugin manager

    After that, the tables should be present, if the database user has the proper privileges. If this does not work, then on your hosting provider, make sure to check that the database user has the priviliges to Create database table. If you use CPanel, then it should look something like this.

    #20077
    ralphlemoufralphlemouf
    Participant

    I reintalled and now I’m getting this message when I try to “ajax search pro” tab ( see screen shot )

    and the article it’s linked to, just goes to a generic page on your plugin site.

    #20079
    Ernest MarcinkoErnest Marcinko
    Keymaster

    Hi,

    That means, that the database user has no privileges to create the database tables. Make sure to check that on your cPanel settings.

    You can also create the databases manually, using an SQL file. Do you know what your table prefix is? (by default it’s wp_) Let me know, and I can generate an SQL file with the tables for you.

    #20080
    ralphlemoufralphlemouf
    Participant

    my user has privledges, whats the user name I should grant to?

    #20081
    Ernest MarcinkoErnest Marcinko
    Keymaster

    Hi,

    The database user name is configured in the wp-config.php file, within this line:

    [php]define(‘DB_USER’, ‘database_user_name’);[/php]

    That user must have the priviliges. Once set, the de-activating and activating the plugin will do the trick.

    #20082
    ralphlemoufralphlemouf
    Participant

    nope. still the same thing. prefix is wp_

    #20083
    Ernest MarcinkoErnest Marcinko
    Keymaster

    In that case, use phpMyAdmin (or equivalent database tool you have) to import the SQL file I attached. You can also copy/paste it manually and execute it if you want to, via this link.

    Please make sure you have backed up the database before anything is executed there.

    #20085
    ralphlemoufralphlemouf
    Participant

    in which table do I import?

    #20086
    ralphlemoufralphlemouf
    Participant

    also I’m getting this error


    — Database: wp

    — ——————————————————–


    — Table structure for table wp_ajaxsearchpro

    CREATE TABLE wp_ajaxsearchpro (
    id int(11) NOT NULL,
    name text NOT NULL,
    data mediumtext
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    MySQL said: Documentation

    #1813 – Tablespace for table ‘apiasf.wp_ajaxsearchpro‘ exists. Please DISCARD the tablespace before IMPORT.

    when I try to import to main wp_ when I search that field to erase I can’t find

    #20088
    Ernest MarcinkoErnest Marcinko
    Keymaster

    Hi,

    This might indicate a database issue. I have not seen an error message like this before, so I googled around, and found a few topics, here and here.

    I am not entirely sure what this is, but it looks like a database file issue/corruption, that preventing table changes. The resolutions on those topics are to remove the table files via command line, as well as dropping them via the SQL app. I think you might have to contact your hosting provider about this. I do not recommend running any commands altering the database, unless you are experienced with it. Please always have database back-ups, before doing anything to the database.

    #20095
    ralphlemoufralphlemouf
    Participant

    My database was whacked out. I just install a fresh version of WordPress on a fresh db and all good, thanks for helping me trouble shoot. Problem solved.

    #20100
    Ernest MarcinkoErnest Marcinko
    Keymaster

    You cannot access this content.

Viewing 15 posts - 1 through 15 (of 15 total)
  • The topic ‘Unable to style form or generate shortcode’ is closed to new replies.