Solved Problem with writing new posts

Hi,

Recently I changed my host company and transfer all information to a new one.
I think after that I start getting this problem when I try to make new post, answer in some topic and etc:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 'test')' at line 1 SQL=INSERT INTO fresh_kunena_messages_text (mesid, message) VALUES (, 'test')

I though that maybe is from my Joomla 2.5 site and after that I migrated to J3.4, but have the same problem.

Can you help me with solving this issue?
I will be really thankfull!

Thank you in advance!

Anyone who can help me or have some idea about this? I really need to keep my forum alive...

Looks like the migration hasn't got the right tables.

Go to yoursite.com/administrator/index.php?option=com_kunena&view=tools&layout=diagnostics

And see if there any issue's.

I think you need to check the tables from the old site. And do the exporting again

Hi,

Thank you for answer.
I try this page in my new joomla 3.4 site and have this errors:



But when I click on this 3 issues there is nothing happened.
How can I fix this?

Ok, I found there was 3 categories without aliases.
I add aliases to this 3 categories and now all test are passed with this checking configuration, but I still have the same problem:
Can't make new topis, can't answer too.
Do you have any other idea about this?
Maybe if there is configuration file for kunena, for writing new details for my new hosting, maybe this can be a problem?

Can you help me solving this, please?

Hi,

I don't have an answer from a 5 days.
Is there anything else I can do to fix this problem, because it's very important to save this forum and make it working ...

Hello, is there anyone who can help me?
If I have to pay for solving this problem - it's not a problem, just write me.
I want to solve this report asap and no one can...

1) make backup
2) Remove kunena tables
3) Install kunena
4) Check if its working
5) replace kunena table 1 by 1, by the old kunena database.
6) Until it breaks, then you know where the issue is

Hi,

Ok, I found in which tables I got this problem.
This is problem is from tables: messages and messages_text.
If I insert standard messages, messages_text tables is working perfect.
So the main problem is inside this two tables.

And I found one more problem:
If I use my table topics and after that try to create a new topic - there is a problem which told me that I didn't insert name for topic.
And if I use the standard topics table everything goes perfect.

So do you know how can I fix this two problems regarding my messages, messages_text and topics tables, because this tables contains all my data?

Ok, I found the solution.
There was a problem with Unique ID, duplicate it.

Here is the solution:

"This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available."

There are several working solutions depending on your exact scenario.

For example, as long as all of your AI or Unique identifier field are unique then you can simply alter the table and ensure this is the Primary key and set to unique value.

I solved this with this solution on one of my tables.

The other table had multiple AI int values that were the Primary field, but there were multiple values of the same kind.

The simple fix for this was to just add a column to the end of the table as Unique AI Int. Basically all MySQL is saying is it needs a unique value in each record to differentiate the rows.