Error on top of page after upgrade 2.5 -> 2.6

[PowerBook]

Hi,

I upgraded from 2.5 -> 2.6 and are getting this error message on top of my Classifieds page:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /classifieds/forums/vb3.php on line 171

I don't use the zip codes and have just truncated the table and populated my own hor/lat coordinates but apart from that everything is standard.

EDIT: I don't get this on the main classifieds page, placing a new add etc but when I go into the detail of a add or showroduct. I also disabled ZIP integration but it still occurs.

[Chuck S]

Your vbulletin has been altered to drop the location field in your userfield table

Try issuing this query in your vb sql window make sure to replace with whatever table prefix you have

ALTER TABLE userfield ADD field2 VARCHAR(50) default NULL;

[PowerBook]

Hi,

I am not second guessing your reply but what I am trying to understand or get my head around is the fact that I only upgraded my PhotoPost Classifieds from 2.5 to 2.6. My table structure for classifieds is "cp_" and stayed the same. For the rest of vBulletin I use "resu_" prefixes.

I didn't make any changes to vBulletin. I went through your 2.6 change log document and that doesn't show any table structure changes.

Before the upgrade the classifieds software I tested everything and this didn't show up.

EDIT: Now I get it and what you meant thanks.

[PowerBook]

Very strange but fixed, thanks

[Chuck S]

No problem have a good one.