Support » Plugin: wpForo Forum » Topic add Error 2

  • Resolved sugarsweetde

    (@sugarsweetde)



    Hello Support-Team,

    I have the same problem like this thread https://wordpress.org/support/topic/resolved-topic-add-error/.
    I also read the support post, but I do not understand the following “Please replace all wp_ prefixes in this code to your database table prefixes, if they are wp_ just use it as is:”

    I am sorry, but I am a beginner. Could you explain it for an absolute beginner?

    Your forum plug-in is great. Much better than bbpress.

    Many thanks in advance.

    Kind regards,
    Marion

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Tomdever

    (@tomdever)

    I hope you’re familiar with your hosting service cPanel and you can open phpMyAdmin Database manager. If you open this you can see table list. Just copy one of table name and leave it here and I’ll provide the replaced SQL.

    @sugarsweetde – I’m just another user but maybe this will help.

    When you set up WordPress it has a file called wp-config.php and inside that file which you edit from your host file manager cPanel or using an FTP client to download and edit, you can scroll down past the secret keys in the file and you will see a section that says:

    /**
     * WordPress Database Table prefix.
     *
     * You can have multiple installations in one database if you give each
     * a unique prefix. Only numbers, letters, and underscores please!
     */
    $table_prefix  = 'wp_'; (or whatever is between the single quotes)
    

    So when you go to your website host cPanel and under “Website” open the “MySQL” link and then you see databases with crazy names. (If more than 1 then use the one you also see higher up in the wp-config.php file ). To the right click on the door icon to access the database and in the left side list you can see the tables with the prefix – probably wp_ – before everything.

    The letters AND the _ underscore are what you need to work with.

    In the end the prefix back in the wp-config "$table_prefix = 'wp_';`. has to match the one in you database

    So if your table prefix is NOT wp_ you have to use your desktop/laptop/whatever text editor to search and replace wp_ in the script text from the post links you refer to (for example in the line …CREATE TABLE IF NOT EXISTS wp_wpforo_subscribes …) and replace it with the prefix in your wp-config. save it and then run that script as instructed in the post

    Running the SQL is done inside the open database.

    I hope I got the right idea about your problem – hope this helps

    Thank you all for so much help.

    I have found out, that some tables are missing in the SQL Database.
    Here is the link to see the screenshot: http://prntscr.com/ecjjxr

    All tables have the “wp_”
    The following tables are missing:
    wp_wpforo_likes
    wp_wpforo_posts
    wp_wpforo_subscribes
    wp_wpforo_topics
    wp_wpforo_votes

    How and where can I put in the missing tables?

    Sorry for the maybe stupid question, but I am in the beginnung with work on that.

    I would be happy for further help.

    Thank you.

    Marion

    An addition question:

    Have I put the SQL-code in the database start? I have made again 2 screenshots:

    http://prntscr.com/ecjrdg
    http://prntscr.com/ecjsxf

    In the second screenshot, is this the right place to put the SQL-code in and then push the OK-Button.

    That’s it?

    Thank you for help in advance.
    Marion

    Plugin Author gVectors Team

    (@gvectors-team)

    Please use the SQL code mentioned here:
    http://wpforo.com/community/how-to-and-troubleshooting-2/new-topics-i-cant-add/#post-7394

    Here we can’t post clean SQL, this forum code symbol conflicts with SQL symbol.

    Hello gVectors Team,

    Thank you for help. I will use the SQL code link you mentioned. But could you please check my screenshots before? Is this the right place to put it in?

    It’s a lot of work to create a Homepage and I would not destroy it with a false doing.

    Thank you.

    Hello gVectors Team,

    I use the SQL-Code your mentioned in this thread, but I it was not successful. The above mentioned tables were not added.

    This is the SQL-statement: “# MySQL lieferte ein leeres Resultat zurück (d.h. null Datensätze).” That means: SQL delivers no or empty results and no data sets.
    So nothings happens with this SQL-code.

    So I delete wpforo and try a new installation, but the above mentioned tables are still missing.

    Any help about this issue?

    Thank you.

    For other user, who probably have the same problem:

    You will find the solution here:

    https://wordpress.org/support/topic/installation-tables-missing/

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Topic add Error 2’ is closed to new replies.