ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Missing Column in Schedule Table

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
cbergsma Posted - 05/29/2014 : 06:56:34
We're having a trouble with that column.
When we browse through the Admin-> Schedules menu we are getting this error message:

Invalid column name 'EndMin'.
Invalid column name 'EndHour'.; SQL: SELECT ScheduleName, IsPublic, ScheduleType, CONVERT(varchar,StartDate,101) AS StartDate, CONVERT(varchar,EndDate,101) AS EndDate, StartHour, StartMin, EndHour, EndMin, EveryHour, EveryMinute, WeekOfMonth, RepeatDays, RepeatWeeks
FROM Schedule WHERE ScheduleId = 1022

when i go check on RP database i found that the Schedule table doesn't have the EndMin column.

is there anything we can do this fix this and get our subscriptions back.

Thanks in advance.

Cristian.
2   L A T E S T    R E P L I E S    (Newest First)
cbergsma Posted - 05/29/2014 : 09:04:29
It worked perfectly, thanks a lot.

Regards,

Cristian.
admin Posted - 05/29/2014 : 08:16:03
Please double click this file "C:\inetpub\wwwroot\ReportPortal\UpdateDb.vbs". It will add EndMin column.

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page