NamePros
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.

Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
FAQ & TOS Register Search Today's Posts Mark Forums Read

Go Back   NamePros.com > Website Development Discussion Forums > Programming
Reload this Page DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars WHERE session_id NOT IN ...

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.

Advanced Search
7 members in live chat ~  


Closed Thread
 
LinkBack Thread Tools
Old 06-01-2005, 10:53 PM THREAD STARTER               #1 (permalink)
New Member
Join Date: Jun 2005
Posts: 3
none1983 is an unknown quantity at this point
 



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
none1983 is offline  
Old 06-01-2005, 10:57 PM   #2 (permalink)
RJ
NamePros Admin


 
RJ's Avatar
Join Date: Feb 2003
Posts: 12,919
RJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatness
 



Find Marrow Donors! Cystic Fibrosis Parkinson's Disease
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
RJ is offline  
Old 06-01-2005, 10:58 PM   #3 (permalink)
Senior Member
 
DN Tycoon's Avatar
Join Date: Apr 2005
Location: Arizona
Posts: 1,130
DN Tycoon is just really niceDN Tycoon is just really niceDN Tycoon is just really niceDN Tycoon is just really nice
 



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.
DN Tycoon is offline  
Old 06-01-2005, 11:38 PM   #4 (permalink)
A Wealth of Knowledge
 
stscac's Avatar
Join Date: Aug 2004
Posts: 3,803
stscac has much to be proud ofstscac has much to be proud ofstscac has much to be proud ofstscac has much to be proud ofstscac has much to be proud ofstscac has much to be proud ofstscac has much to be proud ofstscac has much to be proud of
 



yes, code would be helpful
stscac is offline  
Old 06-02-2005, 06:16 AM THREAD STARTER               #5 (permalink)
New Member
Join Date: Jun 2005
Posts: 3
none1983 is an unknown quantity at this point
 



bad sql query


what code do you need? Php or sql ?
none1983 is offline  
Old 06-02-2005, 06:40 AM   #6 (permalink)
Senior Member
 
dgaussin's Avatar
Join Date: May 2004
Location: France
Posts: 1,226
dgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to behold
 




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.
dgaussin is offline  
Old 06-02-2005, 07:28 AM THREAD STARTER               #7 (permalink)
New Member
Join Date: Jun 2005
Posts: 3
none1983 is an unknown quantity at this point
 



where do i go to delete and recreate the table?
none1983 is offline  
Old 06-02-2005, 07:31 AM   #8 (permalink)
Senior Member
 
dgaussin's Avatar
Join Date: May 2004
Location: France
Posts: 1,226
dgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to beholddgaussin is a splendid one to behold
 




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.
dgaussin is offline  
Old 06-02-2005, 11:41 AM   #9 (permalink)
RJ
NamePros Admin


 
RJ's Avatar
Join Date: Feb 2003
Posts: 12,919
RJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatnessRJ Has achieved greatness
 



Find Marrow Donors! Cystic Fibrosis Parkinson's Disease
Or try posting your inquiry on their support forum,
http://www.4homepages.de/forum/
__________________
Reach me at rj at namepros dot com
RJ is offline  
Closed Thread


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


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

 
All times are GMT -7. The time now is 02:55 PM.

Domain name forum recommended by Domaining.com Powered by: vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0 Ad Management plugin by RedTyger