PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Classifieds Bug Reports (http://www.photopost.com/forum/classifieds-bug-reports/)
-   -   Error in MySql (http://www.photopost.com/forum/classifieds-bug-reports/140883-error-mysql.html)

aberg October 3rd, 2009 03:35 PM

Error in MySql
 
I have change the cookie settings like this cookie prefix = ??
I have done this because when users want to see the ad they will be logout.
So I think this must be a cookie setting.
After this changes I can't go in the admin screen.
In the database I have tried to find the ?? , but I get a error:
#1064 - 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 '\'%cookie%\' OR `title` LIKE \'%cookie%\' OR `varname` LIKE \'%cookie%\' OR `set' at line 1

Any idea what is wrong?

Chuck S October 3rd, 2009 03:44 PM

So you are not getting an error message in our program?

Basically cookies need to be set the same this should help

http://www.photopost.com/forum/photo...-problems.html

Both products should be set the same and as far as cookie prefix if your using vbulletin by default thats going to be bb. You also need the vb license number entered in the photopost config settings.

If users get logged out between applications then your cookies are not set the same.

You can issue a query like this in phpmyadmin to update the cookie prefix

UPDATE cp_settings SET setting='bb' WHERE id=182


All times are GMT -5. The time now is 10:23 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


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