[macgyvers]

User still able to create new thread bypassing the form by doing /newthread.php?do=newthread&f=x

How to prevent this?

[MGO_TOM]

Originally Posted by macgyvers

User still able to create new thread bypassing the form by doing /newthread.php?do=newthread&f=x

How to prevent this?

There are 3 ways to create a new thread. Did you modify all 3 to use the form vs the standard new thread path?

[macgyvers]

Originally Posted by MGO_TOM

There are 3 ways to create a new thread. Did you modify all 3 to use the form vs the standard new thread path?

MGO_TOM can you enlighten me with those 3 ways and how to modify them?
Maybe a link I can read further? thanks

[MGO_TOM]

Originally Posted by macgyvers

MGO_TOM can you enlighten me with those 3 ways and how to modify them?
Maybe a link I can read further? thanks

There is a "New Thread" button at the top of the forum thread list.
There is a "New Thread" button at the bottom of the forum thread list.
There is a "New Thread" link in the "Forum Tools" drop-down.

It has been years since I modified the standard code to create a new thread in select forums by directing the new thread buttons/links to the appropriate form for that forum, so I'd have to do some legwork to find it again. I'm pretty sure it is discussed earlier in this thread.

When i first made the changes to use a form vs the standard thread composition of vBulletin, I overlooked the drop-down "New Thread" link and had a very small number of users that were posting via the standard interface vs the form. I had to do some investigation to figure-out that they were using the drop-down means vs either of the two "New Thread" buttons.

[snakes1100]

Seems to be an issue again with a sql error, when adding a new question, vb 4.2.5

Database error in vBulletin 4.2.5:

Invalid SQL:
INSERT INTO formbits
(fid, displayorder, type, question, description, options, compulsory, perrow, rows, cols, maxlength, ereg, custom, spacer, size, guestonly, minlength, reference, hidelabel, quiz)
VALUES ('1', '10', '1', 'Date of Event', 'The month & day(s) of your event', '', '1', '0', '0', '0', '255', '', '', '', '40', '0', '5', '', '0', '');

MySQL Error : 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 'rows, cols, maxlength, ereg, custom, spacer, size, guestonly, minlength, referen' at line 2
Error Number : 1064

[IggyP]

did anyone try this with php7.2? i need to test soon, im a little nervous for this one...

[shka]

@snakes1100:

It is not a vB4.2.5 issue. "rows" is a reserved word since MariaDB 10.2.4.

Quick and dirty you can change the sql which is using "rows" to "[rows]" (using square brackets for the field name(s)).
Update Upps, you probably have to use mysql-like backticks.

Better way somebody would change the mod (alter column name in for example rowcount and search and replace every occurrence in codes and templates)

[elikkha]

Originally Posted by shka

@snakes1100:

It is not a vB4.2.5 issue. "rows" is a reserved word since MariaDB 10.2.4.

Quick and dirty you can change the sql which is using "rows" to "[rows]" (using square brackets for the field name(s)).
Update Upps, you probably have to use mysql-like backticks.

Better way somebody would change the mod (alter column name in for example rowcount and search and replace every occurrence in codes and templates)

Hi all

Is there any chance to have a soluce for this plz ?

[edgeless]

Is there a way to put a link to the thread that's auto created into the forum results?

[djbaxter]

Originally Posted by edgeless

Is there a way to put a link to the thread that's auto created into the forum results?

I don't understand your question. What are you trying to do?

[edgeless]

Originally Posted by djbaxter

I don't understand your question. What are you trying to do?

Upon form submission, I have it set to create a thread. I would like to have a clickable link to that thread auto inserted into the form results (table and results list). Is this possible?

[djbaxter]

That should happen automatically when a new thread is created.

[edgeless]

Originally Posted by djbaxter

That should happen automatically when a new thread is created.

It doesn't for me. The new thread is successfully created with the correct information from the submitted form. But the only link that appears in the form results is the username link. It would be great if there were a way to also have a link to the created thread inserted into the form results record as well.

[djbaxter]

Oh I see. No it won't be created in the form. It will be created in the forum though, so visible in the new posts results.

[edgeless]

Originally Posted by djbaxter

Oh I see. No it won't be created in the form. It will be created in the forum though, so visible in the new posts results.

Yes, it does that just fine. For my purpose, though, we have users that we'd prefer use the form results table as a tracking index (of sorts) to allow them to see the information from multiple recent submissions all together. If there were links to each associated thread within each results row, it would be quite handy for quickly clicking into an ensuing thread dialog. My guess is that one problem in achieving that functionality is that the threads are automatically created after the submitted data is saved... so there may have to be a script called that could modify the saved data after the thread creation stage. Conclusion: not such an easy thing to make happen