NameSilo

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

SpaceshipSpaceship
Watch
Impact
0
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. www.tararulz.com/gallerytest/categories.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.

Thanks,
Kristopher
 
0
•••
The views expressed on this page by users and staff are their own, not those of NamePros.
Unstoppable Domains โ€” AI StorefrontUnstoppable Domains โ€” AI Storefront
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.
 
0
•••
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. :)
 
0
•••
yes, code would be helpful
 
0
•••
bad sql query

what code do you need? Php or sql ?
 
0
•••
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.
 
0
•••
where do i go to delete and recreate the table?
 
0
•••
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.
 
0
•••
0
•••
Appraise.net
Escrow.com
Spaceship
Rexus Domain
CryptoExchange.com
Domain Recover
CatchDoms
DomDB
NameFit
  • The sidebar remains visible by scrolling at a speed relative to the pageโ€™s height.
Back