[SQLite] too much data for one table row
Slightly Wonky Robob 26 Feb 2008
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.
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?
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 27 Feb 2008
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
http://sqlite.org/limits.html
http://osdir.com/ml/...5/msg00218.html
http://osdir.com/ml/...1/msg00211.html
Slightly Wonky Robob 27 Feb 2008
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
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