Notifications
Clear all

[Closed] Topic Add Error

21 Posts
10 Users
1 Likes
21.7 K Views
Robert
(@robert)
Support Team Admin
Joined: 7 years ago
Posts: 9912
Topic starter  

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.


   
Jahnuv
(@jahnuv)
New Member
Joined: 6 years ago
Posts: 1
 

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)
Support Team Admin
Joined: 7 years ago
Posts: 9912
Topic starter  
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)
New Member
Joined: 5 years ago
Posts: 2
 

Robert!

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


   
Robert
(@robert)
Support Team Admin
Joined: 7 years ago
Posts: 9912
Topic starter  
Posted by: dalejandrom

Robert!

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

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 reacted
dannycarmesi
(@dannycarmesi)
New Member
Joined: 5 years ago
Posts: 1
 

Thanks you


   
dalejandrom
(@dalejandrom)
New Member
Joined: 5 years ago
Posts: 2
 

Really appreciated, Robert.


   
AntoineJ
(@antoinej)
New Member
Joined: 5 years ago
Posts: 2
 

Why I have error ?


   
Robert
(@robert)
Support Team Admin
Joined: 7 years ago
Posts: 9912
Topic starter  

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)
Active Member
Joined: 4 years ago
Posts: 18
 

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

   
Robert
(@robert)
Support Team Admin
Joined: 7 years ago
Posts: 9912
Topic starter  

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)
Support Team Admin
Joined: 7 years ago
Posts: 9912
Topic starter  

@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)
Active Member
Joined: 4 years ago
Posts: 18
 

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

 


   
IG Guru
(@ig-guru)
Active Member
Joined: 5 years ago
Posts: 7
 

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)
Support Team Admin
Joined: 7 years ago
Posts: 9912
Topic starter  
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