hosted by liquidweb


Go Back   Web Hosting Talk : Advertising Forums : Employment Offers & Requests : Employment / Job Offers : MySql DB error
Closed Thread

Forum Jump

MySql DB error

Closed Thread Post New Thread In Employment / Job Offers Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old
Community Liaison
 
Join Date: Oct 2004
Location: Ohio
Posts: 1,606

MySql DB error


Hello, I recently purchased an image hosting script and now I am getting errors with the db and I am not an expert. The issue pops up when I upload an image.
It says that the image is uploaded, but at the bottom of the upload page, I get the following error;

Database error with function: Set Image File Size
SQL: UPDATE images SET filesize= WHERE image_id=3
mySQL Says: 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 'WHERE image_id=3' at line 1

I have no idea what might be causing this or how to fix it. If any of you can offer advice on how to fix it, or if you know you can fix it let me know.

__________________
WebNX.com Enterprise Hosting Solutions – Los Angeles and Manhattan NewYork based Servers
Quality Dedicated Servers – From quad core to 64 core servers 4GB ram to 512GB Ram
1 hard drive to 45+ drive setups. sales @ webnx.com

Facebook only Specials https://www.facebook.com/WebNX



Notice to Consumers
Thread Summary Please be aware that every offer has limits beyond what is displayed in the thread. You should visit the site advertising and read any Terms of Service or Acceptable Use Policy they have in place. If you can't find answers on how they measure what you're purchasing, ask. If the offer or request doesn't regard some type of hosting, you still need to research beyond what’s printed in the ad.
  • Research any provider to know what limits are in place, especially with any offer concerning disk space and/or bandwidth. These are generally defined in the TOS or AUP.
  • Read provider reviews. If you find no reviews, create a thread and ask for others' first-hand experience with the provider.
  • If you're unsure on the exact details of an offer - ask. Simply respond to this thread and ask the provider for clarification.

Sponsored Links
  #2  
Old
WHT Addict
 
Join Date: Nov 2005
Posts: 123
From looking at your error message, it seems the filesize column is not getting a value. Check the code that constructs the query string.

  #3  
Old
Community Leader
 
Join Date: Jul 2002
Location: Tasmania, Australia
Posts: 33,158
Moved to employment by request.

__________________
Sometimes my train of thought leaves the station without me.

Sponsored Links
  #4  
Old
Community Liaison
 
Join Date: Oct 2004
Location: Ohio
Posts: 1,606
Thanks, Mouse!


If anyone thinks they can help me, give me a quote.

__________________
WebNX.com Enterprise Hosting Solutions – Los Angeles and Manhattan NewYork based Servers
Quality Dedicated Servers – From quad core to 64 core servers 4GB ram to 512GB Ram
1 hard drive to 45+ drive setups. sales @ webnx.com

Facebook only Specials https://www.facebook.com/WebNX


  #5  
Old
Disabled
 
Join Date: Dec 2002
Location: chica go go
Posts: 11,858
It sounds like the server is having interpreting the value that is supposed to be sent with the filesize value in your query.

What script are you using? Did you run into any php errors?

I think your host might be disabling use of system(), and the script might be using system() to somehow find the size of the image.

  #6  
Old
Community Liaison
 
Join Date: Oct 2004
Location: Ohio
Posts: 1,606
Hey Mike, I am the only person on the server and no functions are disabled.
The script is PHP Image Host. No php errors.

__________________
WebNX.com Enterprise Hosting Solutions – Los Angeles and Manhattan NewYork based Servers
Quality Dedicated Servers – From quad core to 64 core servers 4GB ram to 512GB Ram
1 hard drive to 45+ drive setups. sales @ webnx.com

Facebook only Specials https://www.facebook.com/WebNX


  #7  
Old
Disabled
 
Join Date: Dec 2002
Location: chica go go
Posts: 11,858
I might be able to figure it out. Contact me via aim, or msn and I'll see if I can figure out what's wrong with it.

  #8  
Old
Community Liaison
 
Join Date: Oct 2004
Location: Ohio
Posts: 1,606
Problem has been solved. Mods please close this thread.

__________________
WebNX.com Enterprise Hosting Solutions – Los Angeles and Manhattan NewYork based Servers
Quality Dedicated Servers – From quad core to 64 core servers 4GB ram to 512GB Ram
1 hard drive to 45+ drive setups. sales @ webnx.com

Facebook only Specials https://www.facebook.com/WebNX


Closed Thread

Related posts from TheWhir.com
Title Type Date Posted
Admin Error Brings Down Joyent’s Ashburn Data Center Web Hosting News 2014-05-28 10:18:18
Tesora's OpenStack DBaaS Supports MongoDB, Cassandra, Redis, and MySQL Web Hosting News 2014-05-23 14:53:11
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Unusual DNS Error Leads to Internet Outage in China Web Hosting News 2014-01-21 12:16:24
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:
WHT Membership
WHT Membership



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?