[FIXED] Missing column after upgrade

Coscast · 2010-12-11 13:46:30

Query: SELECT adv_id, title, description, type, url, code, image_type, image_url, image_ext, expire FROM adv WHERE adv_group_id = 1 AND status = '1' LIMIT 1
Error Message: Unknown column 'expire' in 'field list'
Error Number: 1054

symtab · 2010-12-11 14:06:18

Shit...fixing...i think i didnt update my database after i added that function. Hmm...for now do this from phpmyadmin:

ALTER TABLE `adv` ADD expire date NOT NULL default '0000-00-00';

symtab · 2010-12-11 14:07:24

Hmm..just checked the column is in the sql file (for the installation) and for the upgrade the column is not removed. How did you upgrade?

Coscast · 2010-12-11 14:25:50

Did it like explained in the howto: beta2 to beta3

May i post the sql here ? <--- forget that.i sent the sql via email.

But Nevertheless. The update worked very good. Well done Adrian.

Last edited by Coscast (2010-12-11 14:33:26)

mfeat50 · 2010-12-11 14:50:04

Thats interesting you had that error..... I did the upgrade by the instructions and everything worked fine. All the tables were there.

Great job Adrian!!!

symtab · 2010-12-11 14:51:49

I think he had a older version of BETA2 where the expire column was not present. Its fixed now.

Coscast · 2010-12-11 15:05:40

No Problem.

It's fixed and that is what counts.

Adult Script Pro Community Forums

#1 2010-12-11 13:46:30

[FIXED] Missing column after upgrade

#2 2010-12-11 14:06:18

Re: [FIXED] Missing column after upgrade

#3 2010-12-11 14:07:24

Re: [FIXED] Missing column after upgrade

#4 2010-12-11 14:25:50

Re: [FIXED] Missing column after upgrade

#5 2010-12-11 14:50:04

Re: [FIXED] Missing column after upgrade

#6 2010-12-11 14:51:49

Re: [FIXED] Missing column after upgrade

#7 2010-12-11 15:05:40

Re: [FIXED] Missing column after upgrade

Board footer