PhotoPost Community - SELECT joindate,usergroupid FROM pp

PhotoPost Community (http://www.photopost.com/forum/)

- Photopost Pro Bug Reports (http://www.photopost.com/forum/photopost-pro-bug-reports/)

- - SELECT joindate,usergroupid FROM pp_users WHERE userid= LIMIT 1 (http://www.photopost.com/forum/photopost-pro-bug-reports/140765-select-joindate-usergroupid-pp_users-where-userid-limit-1-a.html)

foxfirediego

September 4th, 2009 07:51 PM

SELECT joindate,usergroupid FROM pp_users WHERE userid= LIMIT 1

I'm receving this kind of errors:

Quote:

An error was encountered during execution of the query:

SELECT joindate,usergroupid FROM pp_users WHERE userid= LIMIT 1

The query returned with an errorcode of:

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 'LIMIT 1' at line 1

If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community

To turn off these emails, set $debug=0 in your config-inc.php file.

Chuck S

September 5th, 2009 08:46 AM

Well the question is why unless this is a bot trying out urls?

That query in the code is only ran from member.php in the verification email for a registration and in the link in the email we pass the uid so its not empty

Code:

Content visible to verified customers only.

Therefore I think this is just some bot trickery and not an issue. Your users would definately have the correct url.

All times are GMT -5. The time now is 11:29 PM.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97