I am not sure what happened but some how it fixed it self, Just added a new draw and working fine just not the first one, Crazy But thank you much for the help and fast response

Your site seems to be down. I'd like info on some of your other raffle addons.

Thanks

My site hasn't been down. It is up.

EDIT: Just to be sure, I checked the server logs and there has been activity at all times during the past 24 hours. And there is no record of a network loss or reboot.

I'm on it now and when I click on register, it slows down and give me a waiting for site message. It then gives me a time out error:

Google Chrome could not load the webpage because snogssite.com took too long to respond. The website may be down, or you may be experiencing issues with your Internet connection.

I'm seeing all other sites fine so I don't think it's me.

If your IP address starts with 184.164, your browser is requesting a file called 'tapatalk.js' and my server is locking you out after repeated requests for a non-existent file. That IP was locked out at 11:50:12 EDT yesterday and 18:49:50 on Saturday.

If that is your IP, find out why you're browser is requesting a file that it shouldn't be.

EDIT: After further investigation of my server logs, that has to be you. Evidently your browser is trying to detect tapatalk by requesting a file from my server (tapatalk.js). Unfortunately, that means that app is poorly written because it asks for the file with every page load. No app should ever ask for a non-existent file from any site. My server considers multiple requests for a non-existent file as an attack and locks out the offending IP address. Either disable tapatalk or use a different browser.

Thanks, will try with another browser. I'm using Chrome.

Any chance of setting 1st, 2nd, and 3rd prizes, that send different PM's to the users.

I've set 3 prizes, and it sends all the users the same PM, so all 3 think they've won the grand prize.

At this time there is no way to send different PMs. I'll take a look at it though.

For now enable 'Show Raffles Already Drawn', it does show the winners in the order they were picked in.

http://www.goaliecrease.net/locker-r...html#post37382

Please read that post, the poor bastard... lol This is why I'm requesting different PM's. ;)

Can I change the auto PM wording?!

Yes.

Go to ACP->Languages & Phrases->Search in Phrases.

Search for Text: raffle_message_body
Search in... tick 'Phrase Variable Name Only'
Click Find.

do you have to use a monetary system? can you not just have a free entry? i tried to get this working but cannot create a raffle any ideas?

No you don't need a monetary system.

What happens when you try to create a raffle?

And, when you create a raffle be sure your usegroup is in the allowed usergroups. Otherwise you won't be able to see it.

Posting a screenshot of your raffle settings and the raffle itself would help.

raffles appears at the top but i cannot create one and i have set admin to create view them...ill take another look...im sure its something simple

You do realize that raffles are created in (left menu) ACP->Raffles>Add New Raffle don't you?

How does this handle unregistered users who win? I haven't run any with this setting yet and I'm curious. Do they have to provide an email, etc?

While the usergroup shows when you set up a raffle, unregistered users aren't allowed to enter at all. The only reason the usergroup shows up is because it's in the vBulletin usergroup list.

In order for someone to enter a raffle, they must have a userid. Without a userid, all they can do is look at raffles if you allow that.

For some reason (my server was down) my raffle didn't process on 04-30-12 at 10am. It's still "waiting to be drawn". How do I manually draw it so I can complete the raffle?

I tried to run it manually using the scheduled task manager.. I got this...

Whats up with that?

I put it in debug mode and ran it again...

But it still shows "Waiting to be Drawn".

To manually draw a raffle, go to ACP->Raffles->Edit Raffles. Click on the Raffle Name. Then click Manually Draw Raffle.

So far as the error goes, I would have to see the complete settings for that raffle to duplicate the problem. I would also need the version of vBulletin you are running.

Didn't do anything when I manually drew it. Nothing happened. I just deleted it, and started a new one.

I had to use random.org to pick a winning ticket number. :|

What version of vBulletin are you running?

My site draws a winner every day using vB 4.1.11 and has done so with every version from 4.0.4 forward.

Hi,

I'm running vB 4.0.6 so I'm also running an older version of Raffles.

When a member entered the Raffle. They get a DB error and this is what I get in email...

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT * FROM raffle
WHERE startdate <= 1336313626
WHERE enddate > 1336313626
ORDER BY id DESC;

MySQL Error : 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 'WHERE enddate > 1336313626
ORDER BY id DESC' at line 3
Error Number : 1064
Request Date : Sunday, May 6th 2012 @ 09:13:46 AM
Error Date : Sunday, May 6th 2012 @ 09:13:46 AM
Script : http://www.twofoursix/forum/raffles.php?do=main
Referrer : http://www.twofoursix.com/forum/raffles.php
IP Address : 77.101.70.149
Username : superjoe
Classname : vB_Database
MySQL Version :

The member appears in the list of members who entered. How can I resolve this error please?

thanks

Update raffles to the latest version.

how can I make all users able to see raffle rules instead of just allowed usergroups? I want to be able to tell them how to join the usergroup in the rules.

Rules won't show up for anyone except allowed usergroups.

Put the instructions about how to join in the raffle description.

v4.1.12 PL1

I understand yours does, but there's a glitch or something going on. I did just fine up until this last draw, and it just didn't.

I did this and still I get....

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT * FROM raffle
WHERE startdate <= 1336589218
WHERE enddate > 1336589218
ORDER BY id DESC;

MySQL Error : 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 'WHERE enddate > 1336589218
ORDER BY id DESC' at line 3
Error Number : 1064
Request Date : Wednesday, May 9th 2012 @ 01:46:58 PM
Error Date : Wednesday, May 9th 2012 @ 01:46:58 PM
Script : http://www.tappletop.com/forum/raffles.php?do=main
Referrer : http://www.tappletop.com/forum/raffles.php
IP Address : 94.168.182.181
Username : Johnjeffs3
Classname : vB_Database
MySQL Version :


This is when the member clicks the button to enter.
????

Edit raffles.php and find this..

Make sure this part says what I show here...
NOT
I don't know why your copy would say 'WHERE' but if it does, change it to 'AND'.

If that's not the problem then turn off Show Raffles Already Drawn in raffle settings. I'll have to dig into it to find out why your system has problems with that code.

Hi,

The code you mentioned to change was already correct in my existing raffles.php file....
I've just checked the " turn off Show Raffles Already Drawn in raffle settings" and it's already turned off and was never on at the point this error was generated.

It is NOT correct. The part I highlight in red and is bold should be AND, not WHERE

Another month has passed, and the raffle is NOT auto drawing.

http://www.goaliecrease.net/raffles.php

As you can see it's says "Waiting to be drawn", with a draw date of 05/31/12 7:00am, which has passed.

I'm not sure what is causing this issue, this is two raffles in a row now.

Status: Waiting to be Drawn
Enter Through: 05-30-2012
Draw Date: 05-31-2012 at 07:00 AM
Credits Cost: 100
Number of Prizes: 3


Tried to run the draw manually, and got a huge code error.. PM'd you the results.

Upgraded to the latest version, exact same issue.

Something has to be very wrong with your setup.

If you are having problems, the best I can offer is to look at your setup.

In order to do that I'll need a temporary admin username and password PM'd to me.

EDIT: Just to double check that PMs are being sent (which is where the errror is happening on your site) I've enabled them in the automated draw on my site. I should know something in the next 30 minutes.

Running it manually may have just complicated things to where an error was forced.

In any case, this is most definitely a server problem on your end. The draw ran and the associated PMs were sent properly on my server. And I would imagine that if this was happening to other people, I'd be inundated with error reports from other users. The raffle draw scheduled task code hasn't changed since version 1.3.0. It hasn't needed to. So I'm sure if there was a problem I would have heard of it long ago.

It could be because the server time doesn't match your set display time. Which would make you think the cron didn't run. See this post...
https://vborg.vbsupport.ru/showpost....&postcount=196

Or it could be a general settings problem for the raffles. And for that I can only check what is wrong with a temporary admin username and password for your site. If you want me to look at it, send me a PM with that info.

Well that's the thing, it just happened out of the blue, nothing was changed. It was running normally for months and months. So I can't see it being a different time issue, or anything. I think I'm just going to uninstall it and no use it if it can't work with my setup. Thanks for your time.

Unfortunately that doesn't solve the problem. You're asking me to locate a problem that doesn't exist on anyone else's system without allowing me to look at your system (which is the only one I know of with this problem) to locate what is causing the issue.

The offer still stands if you want me to look at it.

EDIT: Looking back in post history, it looks like you may have changed the PM message ( https://vborg.vbsupport.ru/showpost....&postcount=450 ). Try putting it back to the original message to see if that fixes the problem. Also, did you attempt to make any changes so the winners get a different PM depending on which prize they won like you mentioned here... https://vborg.vbsupport.ru/showpost....&postcount=447 ? It just seems odd that it worked fine until after that sequence of posts and then the error in the PM routine (which is where the error is on your system) popped up.

I don't know how to change any of that information, that's why I was asking here. So no I didn't change anything.

this would be great if you can implement PayPal to buy tickets any chance you plan on doing this ???

I have no intention of coding a purchase system. There are legal issues involved on my end if I do that.

However, you can use AW Coding's Credit Purchase System so member can purchase "raffle tickets".

Some people report issues with that system, but I have never had a problem setting it up.

I can't figure out how to set it up. Any way you could tell us?

The instructions are included in the raffle zip file.

However if you are using vB 4.2.0, that product has not been updated to work with the new vB version.