2 replies to this topic

[Slightly Wonky Robob]

I've been working on an image gallery, where the images are stored in a database... everything had been working for the past month or so until today after i uploaded a couple of images it comes up with an error when i try and upload a new image.

Quote

Warning: sqlite_exec() [function.sqlite-exec]: too much data for one table row in C:\Documents and Settings\Bob\My Documents\My Sites\Gallery6.0\post.php on line 33

I've done a little searching, but what little i do find i can't make heads nor tails of it.

The weird thing is, i can upload any image that i have already uploaded (to a new line) no problem, but as soon as i try a new picture this happens (even if its a small file, which i thought might be the problem)

Anyone had this problem (maybe a similar one in My SQL)? More importantly how do i fix it?

[Felix Lockhart]

Honestly, I've never used SQLite, and I know nothing about it. But, Google seems to say that this is an actual limit in SQLite, so I'm not sure what you can do about it, but I hope this helps at least a little.

http://sqlite.org/limits.html
http://osdir.com/ml/...5/msg00218.html
http://osdir.com/ml/...1/msg00211.html

[Slightly Wonky Robob]

I'd actually already looked at them, and i understand them in theory, but the weird thing is the images i'm trying to put up are smaller than ones i've uploaded in the past

on the plus side, it appears i was just having a run of bad luck, it just appeared that every picture i chose from random was one that had a problem D: Thankfully, others are loading now, but thanks for the links anyway