No Category Selected Issue

[cristimarin]

Hi,
I have the vers 1.1.4 and I don't know why but I have people that post without selection a category and it's working, the post become live.

I want to know how to setup this so no one can post without selecting a categ or if there is a way that I can delete all the posts that they are already posted.

Thanks.

[sukrut51]

though it's not possible to post without selecting a category there might be some problem with your installation....!

have you recently changed your hosting service??? bcoz this kind of problems occur during host changing..! if not try reinstalling your site..!

[cristimarin]

No, the host is the same...I can't reinstall the site ..it has 500k Alexa and 10k links..what can I do?

Thanks

[Yankidank]

Yeah, I have no idea how that would happen. Pligg should be marking the stories as discarded if the user doesn't finish submitting the story (ex. if they don't fill in the required details). Perhaps you are publishing discarded stories from the Admin panel?

[cristimarin]

Hi Yankidank,

I am not publishing the discarded stories I delete them all the time.
Is there a mysql command that I can use to delete all these posts that are without category?
Thanks

[urbn]

Why not use a javascript / JQuery form validation for your submission page? You should be doing this anyways to verify all information the users are submittingg is accurate, formatted, not empty, etc.

I would also guess that the problem is that your drop down has a space as a value for the default option

Example:
<select name="category" id="category" style="width:250px;">
<option value = " ">Choose a rage Category.</option>

When it should be:
<select name="category" id="category" style="width:250px;">
<option value = "">Choose a rage Category.</option>

Or some such other minor problem. The submission page specifically checks that the category form is greater then zero (0), but no check is made to see if the field is empty or is numeric (which is really should be doing).

I can't give an exact answer as I threw away the existing submission process and completly re-write one that works with AJAX and recaptcha.

But again, your best fix is using javascript / Jquery to do form validation. Quick 20 minute fix.

[cristimarin]

Hi urbn,
Thanks man..but how to do that java fixing?
Thanks

[urbn]

This is about as simple as it gets. Full documentation on how it works as well as working code examples.

Form Validation using jQuery

[cristimarin]

I got the solution ..read below

[cristimarin]

Here it is how I made this and it works for me just fine.

On phpMyAdmin select de table pligg_links.
Than click on SQL and input this Query:

UPDATE `X`.`pligg_links` SET `link_category` = 'Y' WHERE `pligg_links`.`link_category` = '1';

X= Replace with your database name
Y= Replace with the id of the category that you wan to move all the links that has No Category Selected
1= Leave that as it is. It's a default value for link that has No Category Selected

Make sure you make a backup before just in case.

Cheers