Error emails after upgrade

firstrebel · December 14th, 2009, 07:44 AM

I have just upgraded from PhotoPost Pro 6.23 to 7 and now getting emails with

Quote:

An error was encountered during execution of the query:

SELECT COUNT(*) FROM subscriptions WHERE isactive='yes'

The query returned with an errorcode of:

Table 'photopost.subscriptions' doesn't exist

Bob

Chuck S · December 14th, 2009, 08:26 AM

Bob well you where not running 6.23 then. The subscriptions table was added back in 6.1 so my suggestion is to run the 6.1 to 6.2 upgrade

firstrebel · December 14th, 2009, 08:33 AM

6.1 to 6.2 went OK but after 6.2 to 7 got this:

Quote:

Error performing MySQL command: INSERT INTO settings VALUES (251, 'Number of thumbnail preview columns?', 'previewcols', 'Can be 1 or 3.', '3', 33, 5)
Error: Duplicate entry '251' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (252, 'Border color of currently showing thumbnail in thumbnail preview column?', 'selectcolor', '', '#00cc00', 34, 5)
Error: Duplicate entry '252' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (254, 'Path to ffmpeg (if used)', 'ffmpeg', 'This only needs to be set if you are using ffmpeg to extract video thumbnails. Full server path.', '/usr/bin/ffmpeg', 31, 1)
Error: Duplicate entry '254' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (253, 'SEO meta description for index page?', 'seoindex', '', 'A community photo gallery', 19, 3)
Error: Duplicate entry '253' for key 1

Bob

Chuck S · December 14th, 2009, 09:25 AM

Are you getting that email error anymore

firstrebel · December 14th, 2009, 09:57 AM

Quote:

Originally Posted by Chuck S

Are you getting that email error anymore

No, that has stopped.

Bob

Chuck S · December 14th, 2009, 10:06 AM

Okay then its all good then

firstrebel · December 14th, 2009, 11:55 AM

Everything seems to be working OK now. Thanks

Bob

Chuck S · December 14th, 2009, 12:08 PM

no problem glad to help

firstrebel · December 17th, 2009, 09:29 AM

Got another email about a MySQL error today

Quote:

An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,date,title,description,ismature,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating,votes,allowprint,numcom,lastposter FROM photos WHERE userid= AND storecat=0 ORDER BY disporder,date DESC

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 'AND storecat=0 ORDER BY disporder,date DESC' at line 1

Bob

Chuck S · December 17th, 2009, 09:38 AM

maybe a bot playing with urls I would think

Calling ppuser and removing the actual user id

firstrebel · December 17th, 2009, 10:06 AM

Quote:

Originally Posted by Chuck S

Calling ppuser and removing the actual user id

Not sure I know what you mean by that comment.

Bob

Chuck S · December 17th, 2009, 10:11 AM

what I am saying is that I dont see anywhere in the program that we call showgallery with an empty ppuser statement

it would be nice to know the url this happens at as my thinking here is a bot scans urls and they can play or remove variables in the url which might result in an error

oly51 · December 20th, 2009, 04:24 PM

I've received 18 of those messages today alone. Is there anything we can (or need) to do about them?

Chuck S · December 20th, 2009, 05:08 PM

As stated I dont see anywhere in our program we call anything without ppuser variable set.

To fix something you first need to know where its happening or how.

I can tell you to surpress the error you could encapsulte the variable in the line noted in showgallery

Code:

Content visible to verified customers only.

that line is only found one place so search and replace it with this

Code:

Content visible to verified customers only.