PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro Bug Reports (http://www.photopost.com/forum/photopost-pro-bug-reports/)
-   -   MySQL Error- lost images and comments (http://www.photopost.com/forum/photopost-pro-bug-reports/127455-mysql-error-lost-images-comments.html)

rstarke September 24th, 2006 07:32 PM

MySQL Error- lost images and comments
 
I got this MySQL Error when a new user uploaded some new photos (I think)

Quote:

An error was encountered during execution of the query:

SELECT bigimage,approved,cat,storecat,title,userid,width,height,date,filesize,rating,views,user FROM pp_photos WHERE id= LIMIT 1

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1
there are now missing images and comments on my PP board
not quite sure how this happened
Any sugestions?

Chuck S September 24th, 2006 07:59 PM

Url to install? Is this a new install an old one?

rstarke September 24th, 2006 08:03 PM

Yes this is a new install
http://www.paint-sculpt.com/gallery/index.php

Chuck S September 25th, 2006 09:03 AM

Where are your categories?

I see you have modified your code and as such you might want to place unmodified files back on your server so that we may provide you product support.

rstarke September 25th, 2006 10:02 PM

ok done
I have been looking into this problem further and it scemes that whenever new images are added I am losing old ones by order of date (IE. a new image is added and the oldest image is droped)
what the heck?
could this just be a setting in admin that I have set incorrectly?
http://www.paint-sculpt.com/gallery/index.php

rstarke September 26th, 2006 06:56 AM

I think I found the problem
my members category had a limit of 30 images
so that is why images (and comments) were being dropped
I just don't understand where the My SQL error came from

Chuck S September 26th, 2006 09:01 AM

Okay so your error is not there


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

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97