Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › Unable to style form or generate shortcode
- This topic has 14 replies, 2 voices, and was last updated 7 years, 6 months ago by
Ernest Marcinko.
-
AuthorPosts
-
November 21, 2018 at 8:44 pm #20046
ralphlemouf
ParticipantI’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.
November 22, 2018 at 10:26 am #20062Ernest Marcinko
KeymasterHi,
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.November 22, 2018 at 6:03 pm #20069ralphlemouf
ParticipantI’ve tried that and it won’t let me. Please see error in screen shot.
November 23, 2018 at 11:34 am #20074Ernest Marcinko
KeymasterHi,
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 managerAfter 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.
November 23, 2018 at 4:22 pm #20077ralphlemouf
ParticipantI 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.
November 23, 2018 at 4:27 pm #20079Ernest Marcinko
KeymasterHi,
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.
November 23, 2018 at 4:32 pm #20080ralphlemouf
Participantmy user has privledges, whats the user name I should grant to?
November 23, 2018 at 4:38 pm #20081Ernest Marcinko
KeymasterHi,
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.
November 23, 2018 at 4:42 pm #20082ralphlemouf
Participantnope. still the same thing. prefix is wp_
November 23, 2018 at 4:45 pm #20083Ernest Marcinko
KeymasterIn 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.
November 23, 2018 at 5:37 pm #20085ralphlemouf
Participantin which table do I import?
November 23, 2018 at 6:02 pm #20086ralphlemouf
Participantalso I’m getting this error
—
— Database:wp
—— ——————————————————–
—
— Table structure for tablewp_ajaxsearchpro
—CREATE TABLE
wp_ajaxsearchpro(
idint(11) NOT NULL,
nametext NOT NULL,
datamediumtext
) 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
November 24, 2018 at 8:03 am #20088Ernest Marcinko
KeymasterHi,
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.
November 25, 2018 at 5:34 am #20095ralphlemouf
ParticipantMy 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.
November 26, 2018 at 10:03 am #20100Ernest Marcinko
KeymasterYou cannot access this content.
-
AuthorPosts
- The topic ‘Unable to style form or generate shortcode’ is closed to new replies.