An Unexpected Syntax Error (Missing Operator)

An Unexpected Syntax Error (Missing Operator)

PROBLEM

  • Getting the following error message in scheduler:

 

CAUSE

There are a few reasons you may be getting this error:

  • You have one or more Staffgroups without any system users in them.
  • The System Users within one or more Staffgroups are inactive.
  • You are filtering items in the Scheduler by a System User that is inactive.
  • You are filtering items in the Scheduler by a System User that is active, but not assigned to any Staffgroups.
  • You have quotation marks within the name of a campaign.

SOLUTION

  1. Click on Tools>Team Management.
  2. Look for any Staffgroups that do not have any System Users listed.
  3. If you find one, highlight that Staffgroup and then choose “Delete” from the right side of the screen.
    • Note: You may get prompted with a message about actions and objectives being assigned to the staff group.  Click “OK” on that message, and then you will be given the opportunity to choose a Staffgroup that you can reassign those items to.
  4. Click to highlight a System User within a Staffgroup.
  5. Check the right side of the screen and make sure the Active box is checked next to the System User.
    • If that box is unchecked, check it.
    • If the System User is no longer needed, click to highlight the Staffgroup and then uncheck the System User name from the right side of the screen.
      • If this causes the Staffgroup to no longer have any System Users, delete the Staffgroup.
  6. If you are filtering items by a specific user, make sure you see that user name within one of the Staffgroups.  If that System User does not show up, click on the Staffgroup that they should be in, and then check their name on the right side of the screen to add them. 

If none of these steps work, check the filters within the Scheduler and make sure you are set to view All.

  1. From the Scheduler, click on the Filter icon from the top left of the screen.
  2. On each tab available, click on “Select All.”
  3. Once everything is selected, click “Apply.” 

Check your campaigns to make sure one does not exist with quotation marks, if you see one in there, you will need to delete it.

  1. Go to Campaigns > Campaign Manager.
  2. Go to File > Delete and then choose the campaign in question.

Now that the campaign is deleted, you can recreate it following the steps in the knowledgebase article: Activating a campaign.

Be sure to leave out the quotation marks when you create the campaign.

If this does not resolve the issue, please call Software Support at 801-553-9888 for further assistance.


    • Related Articles

    • An Unexpected Syntax Error in Union Query

      PROBLEM Getting the error message “An unexpected syntax error in union query.  # error(s) have been logged.” CAUSE This could be a result of a corruption in the database, namely having to do with campaigns. This error may also come from the Current ...

    • Unexpected Disk or Network Error

      PROBLEM "Program Error Intercepted an unexpected 'disk or network error.' error occurred in GorillaCRM. 1 error(s) are logged.” CAUSE This is normally caused by the network or network drives disconnecting while Gorilla is open.  SOLUTION Verify you ...

    • Unexpected the Search Key was not Found

      PROBLEM When trying to add an action into Gorilla, you get the pop up message: Program error intercepted ‘an unexpected the search key was not found in any record’. CAUSE There are potentially a few causes for this issue: The Actions table in the ...

    • Unexpected Automation Error Object Invoked has Disconnected from its Clients

      PROBLEM When trying to print, you get the error "unexpected automation error object invoked has disconnected from its clients." CAUSE This happens when the vsprint7.ocx file gets updated to a version that Gorilla cannot work with. SOLUTION You will ...

    • Unexpected Record Deleted

      PROBLEM When Logging into Gorilla you get the message:  Program Error Intercepted "Unexpected Record Deleted". The above error has also been seen to come up when switching between screens in Gorilla, Example: Switching from the Finder screen into the ...