PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > ReviewPost Pro Support Forums > ReviewPost Bug Reports

ReviewPost Bug Reports Let us know about any post installation problems you are having with ReviewPost.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old November 16th, 2005, 11:38 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Feb 2002
Location: Northern California
Posts: 222
Bulk Upload Products Problem(FIXED)

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: bulkupload

Query: SELECT id FROM rp_products WHERE userid= AND bigimage='MOMO-SW-CHA35BK0B.jpg'

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 'AND bigimage='MOMO-SW-CHA35BK0B.jpg'' at line 1

Database handle: Resource id #7

Running Mysql version MySQL 4.0.15
PHP Version: 4.4.0 (Zend: 1.3.0)
rcsmith is offline   Reply With Quote
Old November 16th, 2005, 11:43 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,802
In bulkupload.php try this change in bold

Code:
Content visible to verified customers only.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old November 16th, 2005, 11:48 AM   #3 (permalink)
Member
Verified Customer
 
Join Date: Feb 2002
Location: Northern California
Posts: 222
I changed it and got this.

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: bulkupload

Query: SELECT id FROM rp_products WHERE userid= AND bigimage='MOMO-SW-CHA35BK0B.jpg'

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 'AND bigimage='MOMO-SW-CHA35BK0B.jpg'' at line 1

Database handle: Resource id #7
rcsmith is offline   Reply With Quote
Old November 16th, 2005, 11:57 AM   #4 (permalink)
Member
Verified Customer
 
Join Date: Feb 2002
Location: Northern California
Posts: 222
there was multiple entries for that change. after I changed it it just loops

Add Reviews - Select Reviews / Configure Properties
rcsmith is offline   Reply With Quote
Old November 16th, 2005, 12:02 PM   #5 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,802
well my question would be why is $User['userid'] empty

This is nothing I can product on my setup

I would suggest you reupload all files and try again and also post a test account here and url for me to try an upload
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
upload limit problem(fixed) quasan Photopost Pro Bug Reports 30 June 9th, 2006 02:35 PM
bulk upload problem zemic Photopost Pro Installation & Upgrades 2 November 2nd, 2005 09:21 AM
Can't post reviews for products(FIXED) Crow ReviewPost Bug Reports 2 September 29th, 2005 10:22 AM
User Upload problem?(FIXED) redback Photopost Pro Bug Reports 6 August 12th, 2005 12:04 AM
5.11 Bulk Upload Problem Steve_C Photopost Pro Bug Reports 5 June 23rd, 2005 08:28 PM


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

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