 | |  | | | Photopost Pro Installation & Upgrades If you're having install or upgrade problems | 
October 1st, 2007, 08:21 AM
|
#1 (permalink)
| | Member Verified Customer
Join Date: Nov 2005
Posts: 124
| 6.0 query error message INSERT IGNORE
I had the following debug email this morning after upgrading over the weekend. Any ideas? Thanks! Quote:
An error was encountered during execution of the query:
INSERT IGNORE INTO pp_buddies (id,userid,buddy) VALUES( NULL, 5, 1495
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 '' at line 1
| | 
|  | |
October 1st, 2007, 09:15 AM
|
#2 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
What build are you using? I do not see any issues with that query in showframe.php. Try redownloading the build and upload the files minus the config files.
| |
| | |
October 4th, 2007, 05:15 PM
|
#3 (permalink)
| | Member Verified Customer
Join Date: Jan 2006
Posts: 209
|
I get similar. Used the latest build compiled on September 27th. Quote:
An error was encountered during execution of the query:
INSERT IGNORE INTO pp_buddies (id,userid,buddy) VALUES( NULL, 62097, 42971
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 '' at line 1
If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html
To turn off these emails, set $debug=0 in your config-inc.php file.
| | |
| | |
October 6th, 2007, 10:15 AM
|
#4 (permalink)
| | Member Verified Customer
Join Date: Nov 2005
Posts: 124
|
I had a another error with 6.0 this morning: Quote:
An error was encountered during execution of the query:
INSERT IGNORE INTO pp_buddies (id,userid,buddy) VALUES( NULL, 3075, 737
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 '' at line 1
| Where do I see the build number of the install?
| |
| | |
October 6th, 2007, 10:30 AM
|
#5 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
IN showframe this line try adding the missing closing bracket  Code: Content visible to verified customers only.
| |
| | |
October 9th, 2007, 06:19 PM
|
#6 (permalink)
| | Member Verified Customer
Join Date: Jan 2006
Posts: 209
|
Thank you. This also wasn't included in the latest build. Hopefully it can be added now. Cheers.
| |
| | |
October 10th, 2007, 10:31 AM
|
#7 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
I already emailed Michael on it thanks. | |
| | |
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
| | | All times are GMT -5. The time now is 02:56 PM. | |
