Help Center Live Community

Support => Installation Help & Software Support => Topic started by: Marc Chubbuck on December 10, 2008, 12:41:26 AM



Title: Error on upload of operator picture
Post by: Marc Chubbuck on December 10, 2008, 12:41:26 AM
I am having problems here and can not track the issue, nor can I find the solution here on the forums.    When I, or one of my operators try to upload a picture for their profile, we get the following error:

Code:
Notice: Undefined offset: 1 in /home/vetsolsn/public_html/support/hcl/class/database.php on line 122

Notice: Undefined offset: 1 in /home/vetsolsn/public_html/support/hcl/class/database.php on line 140

Notice: Undefined offset: 2 in /home/vetsolsn/public_html/support/hcl/class/database.php on line 140

Notice: Undefined offset: 3 in /home/vetsolsn/public_html/support/hcl/class/database.php on line 140

Notice: Undefined offset: 1 in /home/vetsolsn/public_html/support/hcl/class/database.php on line 141

Notice: Undefined offset: 1 in /home/vetsolsn/public_html/support/hcl/class/database.php on line 141
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 'SET WHERE' at line 1

UPDATE SET WHERE

Does anyone know how to fix this? This is a new install of HCL 2.   1.   7


Title: Re: Error on upload of operator picture
Post by: Hawk on December 13, 2008, 09:21:32 AM
Are there any special characters in the filename? I just tried changing icons on my installation with no problems.


Title: Re: Error on upload of operator picture
Post by: Orange26 on December 15, 2008, 08:40:26 PM
Here is a thread that may help with your situation:

hxxp: www.  helpcenterlive.  com/smf/tips_and_tricks/mysql_syntax_error_in_downloaded_code-t321.  0.  html

Hope that works for you.