Thread: ALIPAC Volunteers Needed for each state in America!

Originally Posted by tinybobidaho

Idaho has been done for awhile. I posted way back. Guess nobody saw it.

Thanks Tiny!!! I will update, sometimes I am doing too many things at once!!!

If anyone sees something that is not listed correctly on the status update, please let me know.

Volunteers needed for:

Nebraska
New Mexico
New York
Rhode Island
Texas


STATUS UPDATE

Alaska CamilleinChicago: Completed
Arizona Paige: Completed
Arkansas Paige: Completed
Colorado Covered by JAK Status: Completed
Delaware Camillein Chicago: Completed
Georgia Covered by Rockfish Status: In Progress
Idaho Covered by TinyBobIdaho Status: Completed
Illinois Covered by Lone_Patriot Status: Completed
Indiana Covered by Triumph Status: Completed
Nevada Covered by JAK Status: Completed
New Jersey Covered by working4change Status In Progress
North Carolina: Covered by Zeezil Status: Completed
Ohio: Covered by GREGAGREATAMERICAN Status: Completed
Oklahoma Covered by SecureTheBorder Status: Completed
South Dakota: Covered by SAFARI Status: In Progress
Texas Covered by lccat Status: (Not confirmed)
Utah Covered by Paige Status: Completed
Virginia Covered by CCUSA Status: In Progress
Wisconsin Covered by americangirl Status: Completed
New Hampshire: Completed
Missouri: Zeezil In Progress
South Carolina: Florgal : Completed
Tennessee: Catslave: Completed
Pennslyvaina JAK/ Florgal: In PRogress
California Jean/ JAK: Completed
Maryland Fedup Deb: Completed
Connecticut Working4change: In Progress
Kansas April: Completed
Florida April: Completed
Louisiana April: Completed
Massachusetts April: In Progress
Oregon JAK : Completed
Wyoming Paige: Completed
Washington SOSAD: Completed
Hawaii Fedupdeb: Completed
Indiana Fedupdeb: Completed
Iowa Fedupdeb : Completed
Kentucky Fedupdeb: Completed
Maine wmb1957: Completed
Michigan wmb1957: In Progress
Mississippi GOGO: Completed
Minnesota Fedupdeb : IN PRogress
Montana JAK: Completed
Vermont JAK: Completed

Michigan is completed.

Looks like we are hitting with this on about 500 websites too!

http://www.google.com/search?q=%22most+ ... 8&filter=0

Great work!

W

I'm having a problem with the Pennsylvania house website for email addresses. In the meantime I will start work on another state.

http://www.legis.state.pa.us/cfdocs/leg ... cfm?body=H

You have to scroll down to get this message:

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request
Error Executing Database Query.
SQL1035N The database is currently in use. SQLSTATE=57019

The error occurred in D:\INETPUB\WWWROOT\Legis\cfdocs\legis\home\member_ information\email_list.cfm: line 36

34 : and mb.ltmb_mbr_id = ms.ltms_mbr_id
35 : and ms.ltms_sess_yr = (select max(ltms_sess_yr) from legtrk.ltms_mbr_sess_tbl)
36 : and ms.ltms_body = '#FORM.body#'
37 : and ms.ltms_sess_dist_nbr != 0
38 : and ms.ltms_sess_dist_nbr != 600



--------------------------------------------------------------------------------

SQL select ms.ltms_sess_dist_nbr as dist, ms.ltms_mbr_id as id, mb.ltmb_disp_lst_nme as lnme, mb.ltmb_disp_frst_nme as fnme, mb.ltmb_disp_mid as mnme, mb.ltmb_mbr_party as party, mb.ltmb_mbr_email as email from legtrk.ltms_mbr_sess_tbl as ms, legtrk.ltmb_mbr_tbl2 as mb, (select ltms_sess_dist_nbr, max(ltms_sess_fill_seq_nbr) as mSeq from legtrk.ltms_mbr_sess_tbl where ltms_sess_yr = (select max(ltms_sess_yr) from legtrk.ltms_mbr_sess_tbl) and ltms_body = 'H' and ltms_sess_dist_nbr != 0 and ltms_sess_dist_nbr != 600 group by ltms_sess_dist_nbr) as result where ms.ltms_sess_fill_seq_nbr = result.mSeq and ms.ltms_sess_dist_nbr = result.ltms_sess_dist_nbr and mb.ltmb_mbr_id = ms.ltms_mbr_id and ms.ltms_sess_yr = (select max(ltms_sess_yr) from legtrk.ltms_mbr_sess_tbl) and ms.ltms_body = 'H' and ms.ltms_sess_dist_nbr != 0 and ms.ltms_sess_dist_nbr != 600 order by lnme, fnme, mnme
DATASOURCE legisw
VENDORERRORCODE -1035
SQLSTATE 57019

Resources:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)
Remote Address 64.136.49.226
Referrer
Date/Time 08-Dec-07 11:32 PM

Stack Trace (click to expand)
at cfemail_list2ecfm1311830105.runPage(D:\INETPUB\WWW ROOT\Legis\cfdocs\legis\home\member_information\em ail_list.cfm:36)


com.ibm.db2.jcc.b.SqlException: SQL1035N The database is currently in use. SQLSTATE=57019

at com.ibm.db2.jcc.uw.UWExceptionGenerator.a(UWExcept ionGenerator.java:122)
at com.ibm.db2.jcc.uw.UWExceptionGenerator.a(UWExcept ionGenerator.java:157)
at com.ibm.db2.jcc.uw.UWConnection.a(UWConnection.jav a:682)
at com.ibm.db2.jcc.uw.f.b(f.java:254)
at com.ibm.db2.jcc.uw.UWConnection.a(UWConnection.jav a:610)
at com.ibm.db2.jcc.uw.UWConnection.b(UWConnection.jav a:463)
at com.ibm.db2.jcc.uw.UWConnection.<init>(UWConnectio n.java:255)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:2 36)
at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhy sicalConnection(JDBCPool.java:562)
at coldfusion.server.j2ee.sql.pool.ConnectionRunner$R unnableConnection.run(ConnectionRunner.java:67)
at java.lang.Thread.run(Thread.java:534)

I'll start on RHODE ISLAND now.

Will get back on Pennsylvania when they resolve their website problems!

Originally Posted by florgal

I'll start on RHODE ISLAND now.

Will get back on Pennsylvania when they resolve their website problems!

Thanks for all the good work, Florgal!

Volunteers needed for:

Texas


STATUS UPDATE

Alaska CamilleinChicago: Completed
Arizona Paige: Completed
Arkansas Paige: Completed
Colorado Covered by JAK Status: Completed
Delaware Camillein Chicago: Completed
Georgia Covered by Rockfish Status: In Progress
Idaho Covered by TinyBobIdaho Status: Completed
Illinois Covered by Lone_Patriot Status: Completed
Indiana Covered by Triumph Status: Completed
Nevada Covered by JAK Status: Completed
New Jersey Covered by working4change Status In Progress
North Carolina: Covered by Zeezil Status: Completed
Ohio: Covered by GREGAGREATAMERICAN Status: Completed
Oklahoma Covered by SecureTheBorder Status: Completed
South Dakota: Covered by SAFARI Status: In Progress
Texas Covered by lccat Status: (Not confirmed)
Utah Covered by Paige Status: Completed
Virginia Covered by CCUSA Status: In Progress
Wisconsin Covered by americangirl Status: Completed
New Hampshire: Completed
Missouri: Zeezil In Progress
South Carolina: Florgal : Completed
Tennessee: Catslave: Completed
Pennslyvaina JAK/ Florgal: In PRogress
California Jean/ JAK: Completed
Maryland Fedup Deb: Completed
Connecticut Working4change: In Progress
Kansas April: Completed
Florida April: Completed
Louisiana April: Completed
Massachusetts April: In Progress
Oregon JAK : Completed
Wyoming Paige: Completed
Washington SOSAD: Completed
Hawaii Fedupdeb: Completed
Indiana Fedupdeb: Completed
Iowa Fedupdeb : Completed
Kentucky Fedupdeb: Completed
Maine wmb1957: Completed
Michigan wmb1957: In Progress
Mississippi GOGO: Completed
Minnesota Fedupdeb : Completed
New Mexico Fedupdeb: In Progress
Nebraska Fedupdeb: In Progress
Montana JAK: Completed
Vermont JAK: Completed
Rhode Island florgal: Completed

TWO more states to go Patriots!!!!

Originally Posted by ALIPAC

Looks like we are hitting with this on about 500 websites too!

http://www.google.com/search?q=%22most+ ... 8&filter=0

Great work!

W

AWESOME!!!!!