PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro Installation & Upgrades (http://www.photopost.com/forum/photopost-pro-installation-upgrades/)
-   -   Moved domain - minor problem (http://www.photopost.com/forum/photopost-pro-installation-upgrades/148396-moved-domain-minor-problem.html)

Kirkus June 24th, 2012 01:06 PM

Moved domain - minor problem
 
I moved my Photopost Pro to a new domain and it's all been working fine. Last night, however, overnight I received the following error about 600 times (as email, not in the browser). It's been running fine for several weeks in a protected directory. I just made it live yesterday, and now these/this error.

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 ppost_photos WHERE userid= AND storecat=0 ORDER BY disporder,bigimage 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,bigimage DESC' at line 1
Any ideas?

Kirkus June 24th, 2012 03:30 PM

Sorry... I'm running 7.0.1

Chuck S June 24th, 2012 07:51 PM

My suggestion would be to upgrade.

Kirkus June 24th, 2012 08:32 PM

I don't want to upgrade.

Is this normal for 7.0.1?

Chuck S June 24th, 2012 09:21 PM

I would suspect this might be something that was updated in any of the numerous updates to the application.

Your using a piece of software that was released 2.5 years ago. Upgrading would be the proper procedure here.

Kirkus June 24th, 2012 09:30 PM

It has to be something I've messed up in the domain move. I've operated a dedicated photo site for years using this version of Photopost. The domains are on the same server and nothing has been updated. It was working flawlessly on the old domain -- on the same server -- just 2 days ago before I shut it down to open it on the new domain.

I don't like version 8. I need the gallery view on the index page and that can't be done in version 8 like it can in version 7.

You can't help to at least point me in the right direction?

Kirkus June 24th, 2012 09:32 PM

It also just started when I removed the password protection on the directory it's in. I've been working with in a password protected directory for several weeks without issue... until I removed the password protection.

Kirkus June 24th, 2012 11:37 PM

I actually renewed my membership here so I could upgrade to 8. But not being able to have a gallery layout on my index page is a deal breaker, unfortunately.

I think I may be on to something. I read a thread here about bots creating these kinds of errors for someone using version 8. After disallowing all bots as a test, I've not received these errors.

Now I just need to find my original version 7 installation files and make sure I have the proper directories/files disallowed.

Kirkus June 25th, 2012 12:03 AM

Yeah. That didn't help. :(

Chuck S June 25th, 2012 08:02 AM

Right but you actually want the updated files so no issue happens. Like I beleive there are changes in the specific file that prevent that. It has been many years and the only course of action I know of is to upgrade.

Kirkus June 25th, 2012 11:46 AM

It seems odd that I didn't have this problem on the old domain... but I can't ask for your help and then ignore it. :)

::

Maybe this should be a new thread, but if I upgrade to 8, is there any way to create an index page like I have now with version 7:

Exclusive tennis photos. Tournament coverage. Tennis events. ATP and WTA players. - TalkAboutTennis.com Photo Site

or am I pretty much stuck with the forum-type list index page?

Because we don't use Photopost Pro as a photo sharing site but rather to show our own photos exclusively, version 8 doesn't seem to give us a good way to display our categories like we do in 7.

Chuck S June 25th, 2012 12:04 PM

Kirkus all I am saying is I do not see any issues with our present code. Your versions is several years old and I do not remember every issue with past versions that may have been present back then. The proper resolution to fix a bug would be to upgrade.

Your using an old like 2003 original photopost category display.

You can try installing version 8 and setting your display to forum style and try replacing your categories-forum template with this template

http://www.photopost.com/forum/1300866-post11.html

No support for that since it is a display we discontinued and few used.

Kirkus June 25th, 2012 12:41 PM

I totally understand what you're saying (I'm thick-headed but eventually it sinks in ;)). And I do appreciate your help. I always do.

I'll give your latest suggestion a shot. And if that doesn't work I'll put on my big-boy pants and do the best I can with version 8.

Seriously, though... thanks for all your help over the years.

Chuck S June 25th, 2012 01:11 PM

I have no doubt this might be a bug in that early version that was probally fixed in 7.02,7.03 etc

You will like version 8


All times are GMT -5. The time now is 03:32 AM.

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