Error creating new forum

[novaj]

Hi all.

I get this Javascript error when I try to create a new forum: "Your last operation resulted in an error".

In Firefox's Error Console I get this:

Code:

Error: syntax error
File: javascript::void()
Line: 1
Source code: :void()

Any ideas??

Thanks.

[mayorbrain]

Have you tried upgrading to Precurio 2.2 . This may fix this issue and the task issue.

[novaj]

I didn't know there was a 2.2 version.

I'll try to upgrade it, but I've made many changes that 2.2 version will override, I'm afraid.

I'll post the results.

Thank you.

[mayorbrain]

Oh yes, the upgrade will override those changes. You can backup your changed files and we will work on integrating the changes into v2.2. later.

[novaj]

I've upgraded to 2.2 but issues are not fixed. I get the same errors.

I've made a backup and I have upgraded the installation using the "Upgrade" tool from admin menu, but the issues are still there.

After that, I restored the backup and then I upgraded files one by one using Neatbeans Diff tool to merge 2.2 version changes and my own changes, but nothing changes: "Reject" button doesn't work and I still can't create a new forum.

The creating forum issue is thrown in application/forum/models/Forums.php, line 39

[novaj]

I've noticed that Precurio tries to insert a record in table "forums" when you try to add a forum.

The table "forums" has a field named "last_action" which has not default value and can not be setted to NULL. So if you try to insert a row in this table, you HAVE TO set a value for "last_action" field.

Precurio doesn't do it. The SQL sentence that Precurio builds is:

Code:

INSERT INTO `forums` (`title`, `creator`, `date_created`, `description`) VALUES (?, ?, ?, ?)

So we can see that Precurio doesn't set a value for "last_action" field, so the database throws an error.

To TEMPORARY fix this issue, I've changed the properties of "last_action" field in the database setting the default value to "NULL" and making it available to be NULL.

Is this a good solution? Can this fix affect to other processes?

I'm sorry for my english. I hope you could unserstand this post.

[mayorbrain]

The fix is good. I don't think it will affect anything.

*thumbs up*