[Bug 186] New: some fields are null in beta DB causing fields not to display

[GCD Site Bugs]

http://dev.comics.org/bugs/show_bug.cgi?id=186

Web Browser: ---
Summary: some fields are null in beta DB causing fields not to
display
Product: GCD Online
Version: 0.2 vieux bois
Platform: All
URL: http://beta.comics.org/series/32926/
OS/Version: All
Status: NEW
Severity: normal
Priority: P2
Component: model
AssignedTo: gcd-...@googlegroups.com
ReportedBy: ralf....@gmail.com
Estimated Hours: 0.0


On Sat, Nov 21, 2009 at 08:38, Allen Ross <iama...@yahoo.com> wrote:
>
> Is there a reason the "Publication Dates" and "Number of Issues Published"
> have disappeared from the series page?:
>
> Production: http://www.comics.org/series/32926/
> Beta: http://beta.comics.org/series/32926/

Because the data is only shown when present and it is present in the
series record of the live site but not in the series record of the
beta site. As to why it is that way ... something wrong with the db
migration script?

mysql> select id,publication_dates,first_issue_id from
gcd_beta.gcd_series where id = 32926;
+-------+-------------------+----------------+
| id | publication_dates | first_issue_id |
+-------+-------------------+----------------+
| 32926 | NULL | NULL |
+-------+-------------------+----------------+
1 row in set (0.00 sec)

mysql> select id,pubdates,frst_iss from gcd.series where id = 32926;
+-------+-------------------------+----------+
| id | pubdates | frst_iss |
+-------+-------------------------+----------+
| 32926 | February 2009 - Present | 1 |
+-------+-------------------------+----------+
1 row in set (0.00 sec)

> For that matter, it looks like the contents of the "Published" column have
> disappeared on the Search Results screen (the column is there but empty when
> it should be populated):
>
> Production: http://www.comics.org/series/name/Supergirl%3A/sort/alpha/
> Beta: http://beta.comics.org/series/name/Supergirl%3A/sort/alpha/

Same reason as above. This draws on the series' publication dates field.


--
Configure bugmail: http://dev.comics.org/bugs/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.

[GCD Site Bugs]

http://dev.comics.org/bugs/show_bug.cgi?id=186


Henry Andrews <hh...@cornell.edu> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |hh...@cornell.edu
Status|NEW |RESOLVED
Resolution| |INVALID




--- Comment #1 from Henry Andrews <hh...@cornell.edu> 2009-11-21 11:37:38 PST ---
This is the currently expected behavior until the next DB refresh. See
http://dev.comics.org/reviews/r/208/