#1 WordPress forum plugin created by gVectors Team

wpForo – WordPress Forum Plugin
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation

Forum

Home | Forum

wpDiscuz - WordPress Comment Plugin
  • Forums
  • Members
  • Recent Posts
Forums
General Category
Frequently Asked Qu...
Topic Add Error
 
Share:
Share
Tweet
Share
Notifications
Clear all

[Closed] Topic Add Error

Page 1 / 2 Next
    Last Post
  RSS

Robert
 Robert
(@robert)
Support Team Admin
Joined: 6 years ago
Posts: 8963
Robert - Twitter
Topic starter February 27, 2017 3:35 pm  

There are a very few hosting services with MySQL server configuration which doesn't allow wpForo to complete all tables installation on activation process. This is the main reason why you get "Topic Add Error" when you try to create a new topic:

 

Started from wpForo 1.6.0 version you can easily fix all database issues in Dashboard > Forums > Tools > Debug Tab > Tables Sub-Tab. There you can find all issues. Just click on the [Solve database problems] button and wait for fixing. It may take a few seconds or dozens of minutes depended on your database size.

 

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.


Topic Tags
add topic database error
Jahnuv
 Jahnuv
(@jahnuv)
New Member
Joined: 5 years ago
Posts: 1
April 2, 2017 9:51 pm  

Hello, I have inserted your code, except I replaced "wp_" to "_wp" ...new tables were created, but the error is still present, do you have any other solution? Thank you.

Martin.


Robert
 Robert
(@robert)
Support Team Admin
Joined: 6 years ago
Posts: 8963
Robert - Twitter
Topic starter April 3, 2017 5:48 pm  
Posted by: Jahnuv

Hello, I have inserted your code, except I replaced "wp_" to "_wp" ...new tables were created, but the error is still present, do you have any other solution?

You've created tables with incorrect table prefix. Wy you've changed "wp_" to "_wp"? I don't think your table prefix is "_wp". Could you please leave some screenshot of your WP tables?

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.


dalejandrom
 dalejandrom
(@dalejandrom)
New Member
Joined: 5 years ago
Posts: 2
June 8, 2017 6:49 am  

Robert!

I executed the sentence at my db but the issue persists. Heres my db structure 

wptable.JPG

Robert
 Robert
(@robert)
Support Team Admin
Joined: 6 years ago
Posts: 8963
Robert - Twitter
Topic starter June 9, 2017 11:12 am  
Posted by: dalejandrom

Robert!

I executed the sentence at my db but the issue persists. Heres my db structure 

wptable.JPG

Hi dalejandrom,

Please Uninstall wpForo (not deactivate), it'll remove all tables and data. Then Install it again. Then use the SQL above, I just updated and adapted for current wpForo versions. That was a little out of date. Now it should work fine.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.


dalejandrom liked
dannycarmesi
 dannycarmesi
(@dannycarmesi)
New Member
Joined: 5 years ago
Posts: 1
June 10, 2017 6:04 am  

Thanks you


dalejandrom
 dalejandrom
(@dalejandrom)
New Member
Joined: 5 years ago
Posts: 2
June 10, 2017 7:23 am  

Really appreciated, Robert.


AntoineJ
 AntoineJ
(@antoinej)
New Member
Joined: 5 years ago
Posts: 2
September 12, 2017 6:50 pm  

Why I have error ?

error.JPG

Robert
 Robert
(@robert)
Support Team Admin
Joined: 6 years ago
Posts: 8963
Robert - Twitter
Topic starter October 23, 2017 4:11 pm  

Because you've translated the SQL code too. The code is changed. For example:

CREATE TABLE IF NOT EXISTS

is changed to:

CREATE TABLE SI NO EXISTE

Please don't translate code, use it as is.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.


Studiografic31
 Studiografic31
(@studiografic31)
Active Member
Joined: 4 years ago
Posts: 18
August 14, 2018 4:35 pm  

Hello Wobert

I executed your SQL to solve my Topic ad error and the result is 

#1067 invalid default value for created

my server is using MySQL v 5.5

How can I fix this ? in PHPMYadmin ?

THX
Capture-d’écran-2018-08-14-à-18.34.25.png

Robert
 Robert
(@robert)
Support Team Admin
Joined: 6 years ago
Posts: 8963
Robert - Twitter
Topic starter August 15, 2018 9:02 am  

Hi @studiografic31,

Please execute the whole SQL at once. Also please leave a screenshot of all wpforo tables. You should add yje first line for all SQL's if you execute them separately.

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

The screenshot you've attached to your post says nothing. Its a one table structure, i don't even see which table is that.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.


Robert
 Robert
(@robert)
Support Team Admin
Joined: 6 years ago
Posts: 8963
Robert - Twitter
Topic starter August 18, 2018 1:10 pm  

@studiografic31

Ok, I see, your MySQL is very old version (we always recommend 5.6 and higher). So I made some changes in the code, please copy and try again. Don't forget the one row SQL on the top.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.


Studiografic31
 Studiografic31
(@studiografic31)
Active Member
Joined: 4 years ago
Posts: 18
August 19, 2018 10:19 am  

Allelujah ! You Rock Robert !

I am able to post new topics, delete them and work on the forum now…

I attach last Screenshot after the new SQL… thanks again

 

Capture-d’écran-2018-08-19-à-12.03.49.png

IG Guru
 IG Guru
(@ig-guru)
Active Member
Joined: 4 years ago
Posts: 7
September 6, 2018 7:31 pm  

Robert,

 

I have an active installation and the "topic error" message just started coming up.  We run the plugin on Wordpress.com so cpanel access is out.  Please help!

Andrew

IG GURU


Robert
 Robert
(@robert)
Support Team Admin
Joined: 6 years ago
Posts: 8963
Robert - Twitter
Topic starter September 7, 2018 7:56 am  
Posted by: IG Guru

Robert,

I have an active installation and the "topic error" message just started coming up.  We run the plugin on Wordpress.com so cpanel access is out.  Please help!

Andrew

IG GURU

I'm really sorry but we can't support issues on wordpress.com . We don't have business plugin there to debug. If you can install the ARI Adminer or SQL Executioner plugin and provide a screenshot of the wp_wpforo_topics table it would be very helpful.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.


Page 1 / 2 Next
  All forum topics
  Previous Topic
Next Topic  
Topic Tags:  add topic (24), database error (7),

Forum Search

Join Us!

Download wpForo plugin
on WordPress.org

wpForo Addons

wpforo-private-messages wpforo-advanced-attachments-128x128 wpforo-embeds-128x128 wpForo User Custom Fields addon wpForo – Blog Cross Posting addon wpForo Ads Manager wpForo – WooCommerce Memberships Integration wpForo Emoticons wpForo – Tenor GIFs Integration
View all Addons »

Recent Topics

  • Forum topics and pages not indexing

    By Vijiki, 1 hour ago

  • Can't send confirmation email from topics when suscribe for new topic

    By gilbau, 5 hours ago

  • Can't add shortcodes to wpForo

    By avorai, 5 hours ago

  • New Feature H1 title for tags

    By annushka, 19 hours ago

  • File in antisapm protection not deleted

    By pesimist57, 1 day ago

  • How to make URL dynamic like - post1233

    By kedy, 1 day ago

Topic Tags

  • translation49
  • css49
  • plugin conflict48
  • seo45
  • new features44
  • buddypress42
  • ultimate member40
  • avatar40
  • forum40
  • moderation38
  • login38
  • registration36
  • threaded layout35
  • cache33
  • editor32
  • menu32
  • shortcode31
  • spam29
  • phrases28
  • forum accesses28
View all tags (2162)

Recent Posts

  • RE: Can't add shortcodes to wpForo

    @avorai, Again, I don't see any relation of this issu...

    By Robert, 2 mins ago

  • RE: Can't send confirmation email from topics when suscribe for new topic

    Hi @gilbau, Your website's wp_mail() is not working, ...

    By Chris, 5 mins ago

  • RE: Forum topics and pages not indexing

    have over 70 topics but is not showing them, is only sh...

    By Vijiki, 13 mins ago

  • RE: Show Likers with their avatar

    @fawp a half crashed forum a fully crashed forum ...

    By Tutrix, 2 hours ago

  • RE: Can users be in multiple forums?

    @monimair, wpForo has secondary usergroups function so...

    By Chris, 2 hours ago

  • RE: H1 title for tags

    Hi @annushka, Your suggestion has been added to our t...

    By Chris, 2 hours ago

  • RE: wpForo 2 Major Update is Imminent!

    I would like to be added to the beta test as I am worki...

    By laurenceliew, 4 hours ago

Share:
Share
Tweet
Share
  Forum Statistics
20 Forums
9,754 Topics
49.4 K Posts
9 Online
43.4 K Members

Latest Post: Can't add shortcodes to wpForo Our newest member: tfhjj701 Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo | Copyright © 2016-2022 gVectors Team
Copyright Registration Service - Click here for more information or to register work
wpForo is Registered with the IP Rights Office
Copyright Registration Service

Ref: 4477265538
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation