 | |  | | | Photopost Pro Installation & Upgrades If you're having install or upgrade problems | 
November 28th, 2006, 12:49 AM
|
#1 (permalink)
| | Member Verified Customer
Join Date: Dec 2005
Posts: 44
| Search error messages
Hello All,
I'm on 5.61 and when doing a search this is whats happing...
Rex...
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script: search
Query: SELECT id,user,userid,date,bigimage,cat,storecat,rating,title,description FROM photos WHERE id IN () LIMIT 0
Result: 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 0' at line 1
Database handle: Resource id #7
| 
|  | |
November 28th, 2006, 08:34 AM
|
#2 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
Have you uploaded the new files and ran the upgrade script?
| |
| | |
November 28th, 2006, 08:53 AM
|
#3 (permalink)
| | Member Verified Customer
Join Date: Dec 2005
Posts: 44
|
Hello Chuck,
Yes have all the latest files uploaded and the 5.6 script ran without errors. www.donwoodphoto.com
/Rex
| |
| | |
November 28th, 2006, 09:10 AM
|
#4 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
we do have a 5.61 release I would suggest you download and upgrade running both the 5.5 and 5.6 upgrades
| |
| | |
November 28th, 2006, 09:17 AM
|
#5 (permalink)
| | Member Verified Customer
Join Date: Dec 2005
Posts: 44
|
Hello Again Chuck,
I made a mistake,, I'm at 5.61 without script errors. www.donwoodphoto.com
/Rex
| |
| | |
November 28th, 2006, 09:32 AM
|
#6 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
I would again suggest you run the two upgrades mentioned and then try if your using the 5.61 files
You can also as admin in global options set debug to display errors so when you are logged in you will see the exact error and be able to post it here.
| |
| | |
November 28th, 2006, 10:23 AM
|
#7 (permalink)
| | Member Verified Customer
Join Date: Dec 2005
Posts: 44
|
Global options set debug, is on display, and no errors, try your last request, the site is dead, IE no images. www.donwoodphoto.com | |
| | |
November 28th, 2006, 11:23 AM
|
#8 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
You need to do a search after you set the display errors debug when logged in as admin that way you will be able to tell us the exact error. The we have experienced an error does not give me anything to work with.
Have you downloaded the latest 5.61 download and ran both the upgrade 5.5 and 5.6 scripts as asked?
| |
| | |
November 28th, 2006, 11:53 AM
|
#9 (permalink)
| | Member Verified Customer
Join Date: Dec 2005
Posts: 44
|
Hello Chuck,
I've try all that u ask me todo, I the same errors msg.
Done this request below..
You need to do a search after you set the display errors debug when logged in as admin that way you will be able to tell us the exact error. The we have experienced an error does not give me anything to work with.
Done this request below...
Have you downloaded the latest 5.61 download and ran both the upgrade 5.5 and 5.6 scripts as asked?
Please goto www.donwoodphoto.com and do a search...
best Rex
| |
| | |
November 28th, 2006, 01:10 PM
|
#10 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
what is the exact error message is it above?
| |
| | |
November 28th, 2006, 01:15 PM
|
#11 (permalink)
| | Member Verified Customer
Join Date: Dec 2005
Posts: 44
|
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script: search
Query: SELECT id,user,userid,date,bigimage,cat,storecat,rating,title,description FROM photos WHERE id IN () LIMIT 0
Result: 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 0' at line 1
Database handle: Resource id #7
| |
| | |
November 28th, 2006, 01:27 PM
|
#12 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
well I do not get this error on my site or others I look at but doing a brand new install now and we shall see
| |
| | |
November 28th, 2006, 02:05 PM
|
#13 (permalink)
| | Member Verified Customer
Join Date: Dec 2005
Posts: 44
|
Hello Again,
The site been working fine until I updated to 5.6 and then, u asked me to update to 5.6.1 at 5.6 that when the search broke. www.donwoodphoto.com
/Rex
| |
| | |
November 28th, 2006, 04:54 PM
|
#14 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
I just did a clean install and same thing works fine
You can email server login stuff
| |
| | |
November 29th, 2006, 08:47 AM
|
#16 (permalink)
| | Member Verified Customer
Join Date: Dec 2005
Posts: 44
|
Hello Chuck,
Cold in Los Angeles this morning, OK, I've just install mysqladmin, would you like the user and passwd for that also?
/Rex..
| |
| | |
November 29th, 2006, 10:17 AM
|
#17 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
sure still waiting on your email here
| |
| | |
November 29th, 2006, 10:34 AM
|
#18 (permalink)
| | Member Verified Customer
Join Date: Dec 2005
Posts: 44
|
Hello Chuck,
Sent email again.... Just now.. www.donwoodphoto.com
/Rex
| |
| | |
November 29th, 2006, 10:48 AM
|
#19 (permalink)
| | Member Verified Customer
Join Date: Dec 2005
Posts: 44
|
Sent: FTP info login, PhotoPost admin login and mysqladmin login..
Thanks Chuck, Rex...
Via your email address chuck@photopost.com | |
| | |
November 29th, 2006, 12:19 PM
|
#20 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
You have default posts to show set to 0 in your admin options
| |
| | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Thread Tools | | | | Display Modes | Rate This Thread |  Linear Mode | | 
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off
| | | 
Similar Threads | | Thread | Thread Starter | Forum | Replies | Last Post | | error messages | whitetigergrowl | Photopost Pro How Do I...? | 8 | June 18th, 2006 09:45 PM | | Several error messages | jbwax | Photopost Pro Bug Reports | 18 | February 1st, 2006 04:05 PM | | re: I get error messages | agardonia | Photopost Pro Installation & Upgrades | 1 | June 21st, 2005 07:36 AM | All times are GMT -5. The time now is 02:42 PM. | |
