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

none1983 · Jun 2, 2005

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

RJ · Jun 2, 2005

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 · Jun 2, 2005

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 · Jun 2, 2005

yes, code would be helpful

none1983 · Jun 2, 2005

bad sql query

what code do you need? Php or sql ?

dgaussin · Jun 2, 2005

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 · Jun 2, 2005

where do i go to delete and recreate the table?

dgaussin · Jun 2, 2005

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 · Jun 2, 2005

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

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

New Member

Domain BuyerTop Member

Established Member

A Wealth of KnowledgeVIP Member

New Member

VIP Member

New Member

VIP Member

Domain BuyerTop Member

elex.xyz

Judgmentai.com

Roqa.org

O2.To

CasinoNuts.com

ShangpinBi.com

DermaPremium.com

iambraxton.com

PerlmuttDesign.de

alegria.gr

Similar threads

We're social

elex.xyz

Judgmentai.com

Roqa.org

O2.To

CasinoNuts.com

ShangpinBi.com

DermaPremium.com

iambraxton.com

PerlmuttDesign.de

alegria.gr

Pinned

Appreciation

Agreement

Answers

Relevance

Reaction

Status

Feeling