[PurpleCow]

Hi,

On my site The Most Hyped Gadget In History / The Hype, when the user submits a story in the third step of submission is throwing warning messages as below;

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), link_votes=1, link_karma=1 WHERE link_id=1190' at line 1 in /path/to/libs/db.php on line 207

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), link_votes=1, link_karma=1 WHERE link_id=1190' at line 1 in /path/to/libs/db.php on line 207

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), link_votes=0, link_karma=1 WHERE link_id=1190' at line 1 in /path/to/libs/db.php on line 207

However, if I click on the back button in the 3rd step, and again click on preview and submit, i get only teh following warning message;

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), link_votes=0, link_karma=1 WHERE link_id=1190' at line 1 in /path/to/libs/db.php on line 207

Additionally,

1. the submitter vote is not counted which is evident in the 3rd step of submission

2. In the 3rd Step, if i click on submit, the submitted story doesn't show up in upcoming. However, if i go into my admin panel and change the status of that submitted story to queued, it gets displayed in the upcoming, but without the submitter vote.

Notes:

Only changes is customizations and the voting script developed. In the voting script, no db changes are done and the actual voting mechanism inbuilt in the voting method 1 of pligg isn't modified.

On my server, they have only upgraded to PHP 5 and no other changes done.

This site was working perfectly fine untill now.

Using Pligg v3.6

Thank you for any help.

Thanks

[PurpleCow]

Hi,

Any help greatly appreciated.
Thanks

[AshDigg]

Please take a look at this post.

[PurpleCow]

Hi,

I tried what you suggested by replacing the link.php file.
But i am still having the same problem in the 3rd step of link/story submission.

Any further help - greatly appreciated.

Thanks

[jobert]

Well, i had that error before and believe me it was harrowing. I had users who just couldn't submit anything. They press submit and it doesn't appear.

Template: Sizeone
Pligg version: 9.7
site: Coffeespark / Published News

You could do two things.

1. If the poster has pressed submit, then more or less it would appear in News Management of Admin as discarded. Just manually bring it back to publish.

2. I noticed with my problem, if I manually publish it, it comes up with a Vote of 0. If it's not a problem then just go to configure coffeespark and set number of votes to publish to 0. And the story will auto publish but with 0 votes.

The 2 above are just quick fixes while you try and solve the problem. Either way, you will still have error messages in Step 3 so make sure you inform the user to ignore those and just press submit.

I upgraded Pligg to 9.8.1 from 9.7 and the problem seems to have disappeared. Be wary though that 9.8.1 may have some registration bugs that you have to look up here in the forums.

[PurpleCow]

Hi jobert,

This is the exact same problem, I am having at tmhgih.com

1. Error in the 3rd step of story submission
2. Submitted stories getting discarded
3. Admin needs to manually publish them with a 0 vote count.

Anyone has a fix for this without needing to upgrade my pligg?

Thanks

[jobert]

The site was running fine. Then stupid old me started tinkering around. I was having problems with how the embedded video was showing up at the time (the sidebar formatting was messed up and the post along with the video was rendered twice). The problem happened when I installed TinyMCE which after I took out because of formatting probs (the line breaks weren't showing on the post, it had to be put in manually for some reason). Anyway, I'm digressing.

Let me run you thru what I did to get that error. Maybe we can backtrack to the source of the problem.

1. I looked at the modules installed. I decided to take out the Thickbox Module since I thought it was useless at the time.
2. I moved the html tags for embedding video to the front of the line. (This is in configure coffeespark)
3. I removed the Embed Video module and reinstalled it.
4. I went to the following files (not sure if I changed anything)

• a. submit.php
• b. submit2.tpl
• c. submit3.tpl
• d. Pligg.tpl
• e. Topusers.php (which I modified to rank users by Karma)
• f. Header.tpl (which I modified to rank users by Karma, previously it had a "?sortby=3" to sort by comments.
• g. link.php

5. I went to an old post with a video problem and was repeatedly discarding it, editing it and then publishing it to see it the problem would disappear (which it didn't)..

After that, the error appeared. I guess, if you can upload the original source files of the above, things may be back to normal.

I didn't try it though since I saw it as a sign to upgrade to 9.8.1 hehehe.

[PurpleCow]

Okay, i just noticed another serious issue today.

I haven't changed anything at all. But now even the vote count is disappeared.

Thanks for any help.

[coli]

I've got the same problem. All new posts remain "discarded" in the submit process.

Same errors as the OP mentioned. TinyMCE installed.

[coli]

Ok, got that fixed. I replaced the function store_basic() in /libs/link.php from my 9.7.0 with function store_basic() of 9.8.0.