AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Notifications
Clear all

[Closed] New Topics - I can't add

4 Posts
3 Users
0 Reactions
4,769 Views
Posts: 2
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@windowsappscz)
Active Member
Joined: 9 years ago
[#3426]

Hi! 
I implemented WP Foro on my page (www.windowsapps.cz/diskusni-forum/). Unfortunately, nobody can add new topics. If you try it, you give a message about error and nothing happen. Do you know, why? Everything is OK, but this is problem.
Thanks!


3 Replies
Robert
Posts: 10741
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@robert)
Support Team
Joined: 3 months ago

Hi windowsappscz,

this is an issue with your hosting MySQL database version, it seems the wpForo database tables have not been installed and created successfully, could you please execute a SQL code in hosting service phpMyAdmin database manager? Please read this topic:

https://wordpress.org/support/topic/topic-add-error/#post-8334508


Posts: 72
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@le-bear)
Estimable Member
Joined: 9 years ago

There is a serious problem with that code. Among them, "order" as column name on "wp_wpforo_forums" is a reserved word, and mysql trigger an sql syntax error. My version is 5.7.17.

I can also see other errors, "like" as column name in "wp_wpforo_profiles", which is also a reserved word, so obviously the tables are not created, as mysql refuse to execute that sql code.

Do you have an updatd SQL code to create these tables?


Robert
Posts: 10741
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@robert)
Support Team
Joined: 3 months ago

wordpress.org support forum doesn't allow to put MySQL "`" symbols. This make all reserved words as a simple text, so this is the issue. Please try this code. Make sure wpForo is installed before importing the SQL mentioned in this topic:

https://wpforo.com/community/faq/topic-add-error-2/


Share: