[SOLVED] Something wrong with query??

[glenelkins]

Hi

 

Any ideas whats up with this query:

 

INSERT INTO `images` VALUES ( '', 'Test', 'uploads/images/53a07136a64005ab666135e13ffad263' );

 

The database table has id (auto increment int), image_id(varchar), and image_file(mediumtext)

 

I get this error, its confusing as the query looks fine to me:

 

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 'Resource id #49' at line 1

[JonnoTheDev]

Since your error reads

'Resource id #49'

 

It seems that you maybe passing an object into the query rather than the SQL. There is nothing wrong with the SQL syntax. Check your code.

[glenelkins]

There is no object being sent to the query. Here is the php

 

		$upload_folder = $this->kernel->get_config ( 'uploads_folder' ) . 'images/';
		$image_id = eregi_replace ( ' ', '_', $post_array['image_id'] );
		$file_tmp_name = $files_array['image_file']['tmp_name'];
		$file_name = $files_array['image_file']['tmp_name'];

		// Convert file name to hash code with
		// random string
		$salt1 = rand ( 1, 500 );
		$salt2 = rand ( 1, 500 );

		$file_name = md5 ( $salt1 . $file_name . $salt2 );

		move_uploaded_file ( $file_tmp_name, $upload_folder . $file_name );

		$this->kernel->query ( "INSERT INTO `{$this->kernel->get_config ( 'images_table' )}` VALUES (
								'',
								'$image_id',
								'" . addslashes ( $upload_folder . $file_name ) . "'
								);" );

[JonnoTheDev]

Must be. Use the following:

$this->kernel->query("INSERT INTO ".$this->kernel->get_config('images_table')." VALUES('','".$image_id."','".addslashes($upload_folder.$file_name)."');");

[PFMaBiSmAd]

Then that is not the query that is producing that error.

 

Also, addslashes() does not escape all the special characters that can break a query. Assuming you are using mysql, you should be using mysql_real_escape_string()

[glenelkins]

So then what is producing the error? Its bloody strange

[glenelkins]

hmm its not even that function at all causing the issue here. though it was working fine until i edited that function...agghghgh now i gotta hunt it down ffs

[PFMaBiSmAd]

Since we don't have access to all your code unless you post it, you would need to answer that question or post all the relevant code if you want someone else to help with the problem.

[JonnoTheDev]

Its gotta be this within your query. Check my post above

`{$this->kernel->get_config ( 'images_table' )}`

[glenelkins]

I found the issue. Its in a completely different class one called "template" where the system replaces html tags from a database. For some reason it was getting stuck on one of the objects created in the loop

[glenelkins]

lol in fact it was my stupid error in a function using a query function rather than a fetch array function ...dumb ass!