available/expiry/start date fields don't appear in admin pages when I try to edit.

Hi!

I made a fresh ZC 1.3.5 install and restored my database.

All is working right, except the blank fields in the admin pages where I should put available/expiry/start/end date.

When create a new product or when I try to put a product in featured, I cannot edit start/end date cause there is no field (the label is there but no field on the right of it!).
Tried firefox and IE, the problem is the same.

What should I do?

thanks to all!

in IE now i get this error:

ctlSPiffyCalendarbox not defined

debug?

No idea about what happened...

Try reloading your /admin files ... sounds like some missing, bad or corrupt files are there ...

I've just finished to replace my admin files, but the problem still exists!!

could be a database problem?

You said you made a fresh install of v1.3.5 then you restored your database ... this sounds like you loaded the new code ... then loaded your old database ...

Did you run the /zc_install on the database "after" you restored it to run the UPGRADE on the database?

NOTE: be sure to always do backups of your site and database before upgrading ...

I upgraded the database some days ago from version 1.2.6

I didn't notice this problem until today, when I tried to install news box manager.

I was thinking the problem was in some admin files I changed to install some new features.
So I made a backup of my database, fresh install, then restored the database.

Now I uploaded again admin files, but still no date field, just the label (and the calendar box error).

what should i look at in my database?

What version of Zen Cart was the database backup that you reloaded?

What this backup already upgraded to Zen Cart v1.3.5 or ... was this a copy of your v1.2.6 database?

it was a 1.3.5 version (I made upgrades one by one as suggested in the faq, and they were successfull)
all seems right in the shop, all seems working, except this.

I tried to set an expiry date via php admin in my featured products table.
it works, the date is shown in the list of featured product, but if i try to edit the record in the featured page, when the featured product page shows, there is no field to edit, just the label and nothing else (after i click edit, it doesn't show in the featured product page the value I set - the value is visible in the list of featured products)

What browser are you using?

firefox 1.5.0.7 and ie 6

this is the link to see how featured product edit page appears to me.

http://www.mediapanda.com/feat.jpg

same database is locally working on easyphp, the calendar shows and I could set avaible/expiry dates.

no idea what could be wrong online? should I change template? could be override system responsible of this?

There are no overrides in the Admin ... only add-ons ...

I am trying to see if there is something you could of trashed out ... but off the top of my head ... nothing is coming to light ...

If you look in phpMyAdmin at your database tables ...

Peek in featured table and browse it ...

Are all the dates either:
a real date
0001-01-01
or NULL

As in nothing set to:
0000-00-00

I really appreciate your effort to help! many thanks!

latest news:

I made a backup of my database and a copy of all my site.

Now, I'm using it with easyphp and all is working fine (firefox & IE).

I made the copy of internet site over a fresh zencart install, one folder at a time, to verify when it was going to stop working. but it didn't stop and locally all is working (there are the date fields with the popping up calendar).

now i'll copy all back on the internet to see what happens!

any suggestion? I think the database is OK, if not, why is it working locally?

ps. on the internet admin pages, the same problem applies also to new products date field, sales, etc. (all date fields with calendar are not working).

Ajeh:

Are all the dates either:
a real date
0001-01-01
or NULL

As in nothing set to:
0000-00-00

yes, all the dates are either:
a real date
0001-01-01
or NULL