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 07-22-2006, 04:26 PM
Chris_M Chris_M is offline
Community Liaison
 
Join Date: Oct 2004
Location: Ohio
Posts: 1,595

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 - Professional Hosting Solutions – Premium Los Angeles Servers and Colo
Quality Dedicated Servers in Los Angeles – From single core to 64 core servers 2GB ram to 512GB Ram
1 hard drive to 45+ drive setups. sales @ webnx.com

Like us on Facebook 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 07-22-2006, 07:05 PM
bigfan bigfan is offline
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 07-22-2006, 07:57 PM
anon-e-mouse anon-e-mouse is online now
Community Leader
 
Join Date: Jul 2002
Location: Tasmania, Australia
Posts: 32,824
Moved to employment by request.

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

Sponsored Links
  #4  
Old 07-22-2006, 08:01 PM
Chris_M Chris_M is offline
Community Liaison
 
Join Date: Oct 2004
Location: Ohio
Posts: 1,595
Thanks, Mouse!


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

__________________
WebNX.com - Professional Hosting Solutions – Premium Los Angeles Servers and Colo
Quality Dedicated Servers in Los Angeles – From single core to 64 core servers 2GB ram to 512GB Ram
1 hard drive to 45+ drive setups. sales @ webnx.com

Like us on Facebook https://www.facebook.com/WebNX


  #5  
Old 07-22-2006, 09:31 PM
ub3r ub3r is offline
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 07-22-2006, 09:35 PM
Chris_M Chris_M is offline
Community Liaison
 
Join Date: Oct 2004
Location: Ohio
Posts: 1,595
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 - Professional Hosting Solutions – Premium Los Angeles Servers and Colo
Quality Dedicated Servers in Los Angeles – From single core to 64 core servers 2GB ram to 512GB Ram
1 hard drive to 45+ drive setups. sales @ webnx.com

Like us on Facebook https://www.facebook.com/WebNX


  #7  
Old 07-22-2006, 10:42 PM
ub3r ub3r is offline
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 07-23-2006, 12:23 AM
Chris_M Chris_M is offline
Community Liaison
 
Join Date: Oct 2004
Location: Ohio
Posts: 1,595
Problem has been solved. Mods please close this thread.

__________________
WebNX.com - Professional Hosting Solutions – Premium Los Angeles Servers and Colo
Quality Dedicated Servers in Los Angeles – From single core to 64 core servers 2GB ram to 512GB Ram
1 hard drive to 45+ drive setups. sales @ webnx.com

Like us on Facebook https://www.facebook.com/WebNX


Closed Thread

Related posts from TheWhir.com
Title Type Date Posted
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
PHP And MySQL Scaling: Preparing A Startup For Growth Blog 2013-08-19 12:25:00
Network Solutions Customers Face Access Issues Following DDoS Attacks Web Hosting News 2013-07-24 15:28:25


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:



 

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?