SQL Error

[kevinrstruck]

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

[Chuck S]

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.

[kevinrstruck]

I changed the permissions on the site to allow you to view the site without being logged in. Sorry about that.

[Chuck S]

For now turn off the random image feature and let me search some old threads as I stated

[kevinrstruck]

Random images is off. Thanks.

[Chuck S]

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.

[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?

[Chuck S]

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?

[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.

[Chuck S]

More important would be to PM a link to your database so I can see and yes you can send admin login