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 > PhotoPost Pro Support Forums > Photopost Pro Installation & Upgrades

Photopost Pro Installation & Upgrades If you're having install or upgrade problems

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old October 21st, 2004, 11:06 PM   #1 (permalink)
Member
 
Join Date: Dec 2002
Location: Lone Tree, Colorado
Posts: 140
Send a message via AIM to kevinrstruck Send a message via Yahoo to kevinrstruck
SQL Error

Wow - Got things working (I thought) but I get this error when going to: http://thephotostation.net/photopost/index.php/cat/1

All of my personal galleries are screwed up it looks like. Any ideas? I do not even know where to begin.





MySQL error reported!

Script: index

Query: SELECT id,user,userid,cat,storecat,title,bigimage,views,height,width, id*0+RAND() as rand_col FROM photos WHERE approved='1' AND cat in (1,9512,9399,9400,9435,9433,9436,9418,9511,9421,9509,9424,9462,9540,9548,9549,9550,9663,9595,9596,9624,9625,9626,9631,9632,9634,9635,9646,9659,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,6012,6013,6017,9034,9036,9047,9049,9060,9080,9088,9089,9094,) ORDER BY rand_col DESC

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 ') ORDER BY rand_col DESC' at line 1

Database handle: Resource id #19
kevinrstruck is offline   Reply With Quote
Old October 22nd, 2004, 09:22 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
I can not view your forum since it requires a login.

Have you tried turning off the random images pal.

I will have to research the code as your getting an error that should not be happening. You missing some cat variables it looks like. Let me go research some and I will post anything I find.
__________________
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 October 22nd, 2004, 12:27 PM   #3 (permalink)
Member
 
Join Date: Dec 2002
Location: Lone Tree, Colorado
Posts: 140
Send a message via AIM to kevinrstruck Send a message via Yahoo to kevinrstruck
I changed the permissions on the site to allow you to view the site without being logged in. Sorry about that.
kevinrstruck is offline   Reply With Quote
Old October 22nd, 2004, 05:03 PM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
For now turn off the random image feature and let me search some old threads as I stated
__________________
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 October 22nd, 2004, 08:33 PM   #5 (permalink)
Member
 
Join Date: Dec 2002
Location: Lone Tree, Colorado
Posts: 140
Send a message via AIM to kevinrstruck Send a message via Yahoo to kevinrstruck
Random images is off. Thanks.
kevinrstruck is offline   Reply With Quote
Old October 22nd, 2004, 08:53 PM   #6 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
Is your children field in the category table a text field or varchar (255)?

If so try changing your field type in the database for the children field from varchar(255) to a TEXT using phpMyAdmin. Then go into your admin panel, and play with your cats again so it can reload the field.
__________________
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 October 22nd, 2004, 09:09 PM   #7 (permalink)
Member
 
Join Date: Dec 2002
Location: Lone Tree, Colorado
Posts: 140
Send a message via AIM to kevinrstruck Send a message via Yahoo to kevinrstruck
OK - Did what you suggested. Looks like that error is gone but all of my personal galleries are in the "Main Category" and not tied to the individual users???

Any idea how that happened?
kevinrstruck is offline   Reply With Quote
Old October 23rd, 2004, 11:38 AM   #8 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
what do you mean not tied to users?

The children field should be text and thats what you changed. Have you when to your category editor and reSAVED the cats to update things. Same for personal albums?
__________________
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 October 23rd, 2004, 11:14 PM   #9 (permalink)
Member
 
Join Date: Dec 2002
Location: Lone Tree, Colorado
Posts: 140
Send a message via AIM to kevinrstruck Send a message via Yahoo to kevinrstruck
I am not sure what you mean here. I pesonally should have about 40-50 personal albums for me alone. When I click on My Albums, nothing is there. They are all under the "Main" category. Same for all of my other users.

I hope I explained this well enough. If you need my ID and password, let me know and I will PM you.
kevinrstruck is offline   Reply With Quote
Old October 24th, 2004, 08:44 AM   #10 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
More important would be to PM a link to your database so I can see and yes you can send admin login
__________________
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
SQL Error prodigy Classifieds Bug Reports 1 August 31st, 2005 09:55 AM
SQL Error digitalpoint Bugs - vBulletin 3.5.X 2 July 24th, 2005 09:21 PM
pp 5.1.1 sql error Fenriz Photopost Pro Bug Reports 5 June 11th, 2005 11:36 AM
SQL Error iphoto Photopost Pro Installation & Upgrades 1 November 12th, 2004 07:49 PM


All times are GMT -5. The time now is 07:25 AM.

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