DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars WHERE session_id NOT IN ...

none1983 · 06-01-2005, 10:53 PM

My friend is having problems with her webpage. She started to have problems yesterday in her photo gallery. She says she hasn't changed anything (pictures, coding or settings). This is the problem which is popping up:
DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars WHERE session_id NOT IN ('d46d563abb04d5e687db322ad8e7f7f6' ....

The gallery still works but you have 1000 of lines before you get there. http://www.tararulz.com/gallerytest/...php?cat_id=547 is her website.

I'm not very good with PHP and know nothing about SQL. If someone could help I would really appreciate that. If you could also give me some details how to fix the problem.
????: NamePros.com http://www.namepros.com/programming/94937-db-error-bad-sql-query-delete.html

Thanks,
Kristopher

RJ · 06-01-2005, 10:57 PM

That's a whole lot of session variables! I would have to see the actual code to see where it's pulling those from.

But... perhaps if you emptied the 4images_sessionvars table the error would go away, or there might be another table that contains the session_id's that you could empty. Just looks like there just too many entries in the array and MySQL can't handle it.

DN Tycoon · 06-01-2005, 10:58 PM

I'd need to look at the code/DB itself to understand the details of the problem, PM if you can do this and I will see what I can do.

stscac · 06-01-2005, 11:38 PM

yes, code would be helpful

none1983 · 06-02-2005, 06:16 AM

what code do you need? Php or sql ?

dgaussin · 06-02-2005, 06:40 AM

Google is your friend...
http://www.google.com/search?hl=en&q=%22DELETE+FROM+4images_sessionvars+ WHERE+session_id+NOT+IN%22&btnI=I'm Feeling Lucky

Like they said. Check if the table exists. If yes, delete that. And then create the table.

Hope that helps.
David.

none1983 · 06-02-2005, 07:28 AM

where do i go to delete and recreate the table?

dgaussin · 06-02-2005, 07:31 AM

Depending how you're hosted..

If you have CPanel, use the phpMyAdmin link and you'll see your database with 4images tables. If you don't see a 4images_sessionvars table, use the SQL code to create the table.

RJ · 06-02-2005, 11:41 AM

Or try posting your inquiry on their support forum,
http://www.4homepages.de/forum/

06-01-2005, 10:53 PM	THREAD STARTER #1 (permalink)
none1983 New Member Join Date: Jun 2005 Posts: 3	DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars WHERE session_id NOT IN ... My friend is having problems with her webpage. She started to have problems yesterday in her photo gallery. She says she hasn't changed anything (pictures, coding or settings). This is the problem which is popping up: DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars WHERE session_id NOT IN ('d46d563abb04d5e687db322ad8e7f7f6' .... The gallery still works but you have 1000 of lines before you get there. http://www.tararulz.com/gallerytest/...php?cat_id=547 is her website. I'm not very good with PHP and know nothing about SQL. If someone could help I would really appreciate that. If you could also give me some details how to fix the problem. ????: NamePros.com http://www.namepros.com/programming/94937-db-error-bad-sql-query-delete.html Thanks, Kristopher

06-01-2005, 10:57 PM	#2 (permalink)
RJ NamePros Admin Join Date: Feb 2003 Posts: 12,919 Follow @DomainBuyer	That's a whole lot of session variables! I would have to see the actual code to see where it's pulling those from. But... perhaps if you emptied the 4images_sessionvars table the error would go away, or there might be another table that contains the session_id's that you could empty. Just looks like there just too many entries in the array and MySQL can't handle it. __________________ Reach me at rj at namepros dot com

06-02-2005, 06:16 AM	THREAD STARTER #5 (permalink)
none1983 New Member Join Date: Jun 2005 Posts: 3	bad sql query what code do you need? Php or sql ?

06-02-2005, 11:41 AM	#9 (permalink)
RJ NamePros Admin Join Date: Feb 2003 Posts: 12,919 Follow @DomainBuyer	Or try posting your inquiry on their support forum, http://www.4homepages.de/forum/ __________________ Reach me at rj at namepros dot com

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
$ 6.95 Windows Hosting :: MS SQL, ASP.NET, Cold Fusion, Oracle, Multiple domains	JodoHost	Web Hosting Offers	0	03-27-2005 04:36 AM
Connecting to your SQL Database using Enterprise Manager	priyanka[imported]	Web Hosting Discussion	1	12-07-2004 03:21 PM
Connecting to your SQL Database using Enterprise Manager	priyanka[imported]	Webmaster Tutorials	0	12-06-2004 08:58 PM
HELP!!!!!! DB Error? Bad SQL Query?	logos	The Break Room	5	08-25-2004 07:48 PM

06-01-2005, 10:58 PM	#3 (permalink)
DN Tycoon Senior Member Join Date: Apr 2005 Location: Arizona Posts: 1,130	I'd need to look at the code/DB itself to understand the details of the problem, PM if you can do this and I will see what I can do.

06-01-2005, 11:38 PM	#4 (permalink)
stscac A Wealth of Knowledge Join Date: Aug 2004 Posts: 3,803	yes, code would be helpful

06-02-2005, 06:40 AM	#6 (permalink)
dgaussin Senior Member Join Date: May 2004 Location: France Posts: 1,226 Follow @dgaussin	Google is your friend... http://www.google.com/search?hl=en&q=%22DELETE+FROM+4images_sessionvars+ WHERE+session_id+NOT+IN%22&btnI=I'm Feeling Lucky Like they said. Check if the table exists. If yes, delete that. And then create the table. Hope that helps. David.

06-02-2005, 07:28 AM	THREAD STARTER #7 (permalink)
none1983 New Member Join Date: Jun 2005 Posts: 3	where do i go to delete and recreate the table?

06-02-2005, 07:31 AM	#8 (permalink)
dgaussin Senior Member Join Date: May 2004 Location: France Posts: 1,226 Follow @dgaussin	Depending how you're hosted.. If you have CPanel, use the phpMyAdmin link and you'll see your database with 4images tables. If you don't see a 4images_sessionvars table, use the SQL code to create the table.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars WHERE session_id NOT IN ...

bad sql query