PhotoPost Community - View Single Post - Install Problem: $result not a valid MySQL resource.

ArchangelX · October 3rd, 2008, 10:33 PM

Chuck,

This is where I'm hung up...I checked my vB MySQL Database for the Userfield Table & field 2...

It's populated and it's full of data:

field2 mediumtext latin1_swedish_ci Yes NULL

For example, if I browse distinct values in that field, I get the following for example:

Rows field2
1682 NULL
287
1 'Ewa Beach, O'ahu
1 -YPO-
1 ..in my EJ1..
1 99-1285 Halawa Valley ST.
1 a designated checkpoint.
5 Aiea
1 Aiea, Hawaii
3 Aiea, HI
1 at my desk
1 auckland,nz
2 Australia
1 Aye Bah Bits
1 Barcelona
etc.

So as you can see, I haven't dropped the location, at least I don't think so. Are you sure this is the correct fix? I'm no coder and I don't meant to question your help, but it doesn't seem like that's the problem.

I don't have a vb table prefix in my main database, either...never set one.

Thanks for the help.

October 3rd, 2008, 10:33 PM	#7 (permalink)
ArchangelX Member Join Date: Feb 2006 Location: Honolulu, HI Posts: 83	Chuck, This is where I'm hung up...I checked my vB MySQL Database for the Userfield Table & field 2... It's populated and it's full of data: field2 mediumtext latin1_swedish_ci Yes NULL For example, if I browse distinct values in that field, I get the following for example: Rows field2 1682 NULL 287 1 'Ewa Beach, O'ahu 1 -YPO- 1 ..in my EJ1.. 1 99-1285 Halawa Valley ST. 1 a designated checkpoint. 5 Aiea 1 Aiea, Hawaii 3 Aiea, HI 1 at my desk 1 auckland,nz 2 Australia 1 Aye Bah Bits 1 Barcelona etc. So as you can see, I haven't dropped the location, at least I don't think so. Are you sure this is the correct fix? I'm no coder and I don't meant to question your help, but it doesn't seem like that's the problem. I don't have a vb table prefix in my main database, either...never set one. Thanks for the help. Last edited by ArchangelX; October 3rd, 2008 at 10:41 PM.