Help, Please. I tried to post a topic and received the following error message:
Phorum Database Error
Sorry, a Phorum database error occurred.
Please try again later!
Error:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (1267): SELECT message_id FROM ph_messages WHERE forum_id = 2 AND author ='Bayberry' AND subject ='Reflections on the First Five Months of Mystery Shopping' AND body ='Hi Shoppers!\r\n\r\nI thought this might answer some questions for new shoppers. Basically, the whole getting started process is a crap shoot. Sign up, hold your breath, and jump in.\r\n\r\nI am a part time shopper, and I am MSPA silver certified. My first mystery shop was 2/18/14. I am now signed up with 181 companies. Most of those companies do not have anything in my area or anything I am willing to do. I have done (or currently have scheduled) 68 shops with 28 different mystery shopping companies. I have made over $1,400 in fees and have received $4,000 in reimbursements. $2,288 of the reimbursement is from hotels, so not particularly meaningful. After five months, my heart has finally stopped pounding every time I do a shop, but I still forget to note the time when the shop is over. \r\n\r\nCompanies I have shopped for (number of shops): A Closer Look (8), About Face (3), Ann Michaels (1), aTH (1), B Business (1), Bare (3), Coyle (5), Customer Impact (2), Customer Service Experts (1), Dataquest (1), Goodwin (2), ICCDS (1), Informa (2), Intellishop(3), Int’l Service Check (1), Market Force (3), MercSystems (3), Mintel (3), NSite (1), Person to Person (5), Reality Based (1), Reality Check (1), Regal (5), Satisfaction Services (5), Service Performance Group (1), Service Sleuth (2), Strategic Reflections (2)\r\n\r\nMy first five shops (way before I found the Forum) were with:\r\nAbout Face – Cosmetics\r\nIntellishop – Assisted Living\r\nMarket Force – Fast Casual\r\nA Closer Look – Upscale Dining\r\nReality Based – Valet Parking\r\nTypes of Shops: Banking (11), Fine Dining (10), Parking (8), Integrity Bar or Buffet (7), Hotel (6)\r\n\r\nOther benefits from shopping:\r\n -learned about a local bank paying 1% on checking accounts\r\n-saved $177 on a hotel room I had already booked for a family reunion by using the free hotel night I got from signing up for Chase Marriott Rewards credit card \r\n- $100 from Bank of America for signing up for their cash rewards credit card \r\n- Found the Forum ïŠ\r\nBiggest tip I got from the Forum: buy a digital voice recorder' AND datestamp > 1406476297
Backtrace:
Function interact() called at
{path to Phorum}/include/db/PhorumMysqlDB.php:164
----
Function interact() called at
{path to Phorum}/include/db/PhorumDB.php:1109
----
Function post_message() called at
{path to Phorum}/include/posting/action_post.php:146
----
Function include() called at
{path to Phorum}/posting.php:619
***************************
Thanks to all the forum members!