Blog News Main Page NEWS FROM 2006-03-25
Blog Entry: 3/25/2006 4:32:46 PM
After taking another look at this and trying your suggestions without success, it appears that in Windows 2003 server it is nearly impossible to remove the READ ONLY attribute from the _database folder. I'm wonder if this could the cause?
Thanks , ok, I got it all sorted out for you and aspupload seems to be working now.
Basically they seem to have an odd version of it installed and I had to tweak the code a little. I also uploaded the server info page in the admin area to test for it.
Just back up the gallery folder so you have a backup copy of the modified code.
CJW ,
I dont what it is..u got to just keep trying stuff like connecting to different versions of the database and maybe even the version with no password set on it.. maybe do some iisresets in between if it is your server.. maybe try putting the database in a different folder
Usually people have zero trouble setting up this particular app because everything is so time tested and rock solid...
its just got to be something related to the actual data connection.. low level stuff , Additional Information.
A set of these variables get created for every user that logs in to your site. For performance and memory conservation reasons some of them can be turned off and are optional.
If you look in the "check_user_inc.asp" file or the "check_admin_inc.asp" file you will see a section of code like this
' Start of optional session variables to be set ' Recommended that you remark out any of the session variables below that you don't really need to use ' This will save a lot of server resource because every user logged in has a set of these ' I added some code here to not create these if they are empty If CmdCheckUser("First_Name") <> "" Then Session("First_Name") = CmdCheckUser("First_Name") If CmdCheckUser("Last_Name") <> "" Then Session("Last_Name") = CmdCheckUser("Last_Name") If CmdCheckUser("Company_Name") <> "" Then Session("Company_Name") = CmdCheckUser("Company_Name") If CmdCheckUser("Email") <> "" Then Session("Email") = CmdCheckUser("Email") If CmdCheckUser("Address") <> "" Then Session("Address") = CmdCheckUser("Address") If CmdCheckUser("City") <> "" Then Session("City") = CmdCheckUser("City") If CmdCheckUser("State_Province") <> "" Then Session("State_Province") = CmdCheckUser("State_Province") If CmdCheckUser("Zipcode_Postal_Code") <> "" Then Session("Zipcode_Postal_Code") = CmdCheckUser("Zipcode_Postal_Code") If CmdCheckUser("Phone") <> "" Then Session("Phone") = CmdCheckUser("Phone") If CmdCheckUser("Custom1") <> "" Then Session("Custom1") = CmdCheckUser("Custom1") If CmdCheckUser("Custom2") <> "" Then Session("Custom2") = CmdCheckUser("Custom2") If CmdCheckUser("Custom3") <> "" Then Session("Custom3") = CmdCheckUser("Custom3") If CmdCheckUser("Custom4") <> "" Then Session("Custom4") = CmdCheckUser("Custom4") If CmdCheckUser("Custom5") <> "" Then Session("Custom5") = CmdCheckUser("Custom5") If CmdCheckUser("Custom6") <> "" Then Session("Custom6") = CmdCheckUser("Custom6") ' End of optional session variables to be set
If you do not need a particular variable to be set as a session variable simply comment that line out with single quote.
If you have an extremely busy site with a lot of users this is a good idea. If not, you probably don't need to bother doing this. I added some code in there so they will not be created if they are empty and that alone helps out a lot. cwilliams38419.5459606481, Just wanted to say how much I like the program! I hunted for days and finally purchased a Perl based product. After several days of goofing with it I gave up. ASPPhoto worked right on first install!!!!
Way to go! , You have old code I think.
It's probably because his password used with your encryption key by chance creates a single quote and messes up the database query
A notice went out about this. I will PM you the latest download with the updated files. , is that lindsey lohan and her fake boobs as ur avatar?
I am installing IIS and all of its glory on the other computer now... gotta love remote desktop (the pc is at work ) , sorry for delay responding,
I got bombarded with support inquiries while I was gone and I missed this one since I been home.
Does the server_info.asp page I provide say that aspupload is indeed installed. Let's start there. , Hello,
I do not really understand what you mean? There are no country and city lists in ASPClassifieds. cwilliams38391.0301388889, IMPORTANT UPDATE - READ THIS http://support.cjwsoft.com/forum/forum_posts.asp?TID=205& ; ; ; ; ; ; ; ; ; ; ;PN=1
The 2Checkout Support Pack which is built in to ASPProtect 7 contains all the pre-built scripts you need to implement 2Checkout Payments with ASPProtect. You must be using version 2 of the 2checkout system. They are phasing out version 1 regardless so everyone will be using version 2 very soon if they are not already.
THIS IS NOT INTENDED OR DESIGNED TO USE 2CHECKOUT SUBSCRIPTIONS. (see bottom of this thread for more info on that)
This Support Pack basically gives you an additional signup and registration directory "2checkout_signup" and it should not interfere with any changes or customizations you have made to your ASPProtect setup in general. New users can register in this directory and pay for membership at the same time. Existing users whether active or expired can be sent to this directory where they can lookup their account and buy additional membership time online. You can also assign various Access and Group Levels during signup and you can set up various prices for various amounts of time as well. This is a real-time setup for the most part. As soon as a user pays via 2Checkout your system is updated and they will have access.
The 2checkout pack is NEW.. and was released on March 19, 2005. If you don't have it and would like it please just ask.
To start using this edit the "2checkout_signup/2checkout_config_inc.asp" file
You will be entering your 2Checkout Account number in that file as well as the URL you want a user to go to after payment. It is all commented in that file. (There is also a testing variable you can set to True if you want to do testing without real charges being applied)
After editing that file run this page.
http://www.mysite.com/2checkout_signup/show_postback_path.asp
Replacing the part in blue with your website info.
It will report back that postback url you need to use in the 2checkout system.
Log into your 2checkout version 2 account and under the "look & feel section" enter that postback url for both the "Approved URL" and the "Pending URL"
Trust me: You want the URL there for a pending URL because the 2Checkout system is quite random and 95% of the payments that come in go to the pending URL and end up being legitimate sales. (at least for me they do)
Now make sure the Direct Return option on that page is on as well.
If set to Yes buyers will be immediately directed to your URLs below once they click the Complete Order button. If set to No the buyers will have to click a button to return to your URLs below. |
>> |
Save that page... and leave 2checkout.
| Now, delete this page from your ASPProtect setup. http://www.mysite.com/2checkout_signup/show_postback_path.asp
It's a minor security risk and is no longer needed needed.
The basic setup is finished. All you have to now is set up payments options the way you want them.
Changing Payment Options
In the "2checkout1.asp" file there are form options set up.
They look like this and you can have as many as you like.
<option selected value="30,9.95,3,">30 Days, 9.95</option>
In this option... A user has the option to purchase 30 days for $9.95 and he will be set to Access Level 3 when payment in completed.
Here is how it works.
The value setting (red) is essentially and array that can be made up 4 elements separated by comma's They must be separated by a comma and there can be no spaces. In this example the 4th value was not used but the last comma must still be there. If you didn't want to set an access level and left out the "3" there would 2 commas at the end. etc etc Basically there must always be 3 commas but you only have to set the 1st 2 values which are days and price.
days,price,access level,groups
The 1st value is the amount of days. The 2nd value is the price for the amount of days. The 3rd value is the access level you want to user assigned to. The 4th option is the groups you want the user assigned to. (see PayPal subscription thread for examples of specifying group info)
Now, the label for the option in (blue) can say whatever you like. , ok... glad ya figured it out.
Yes.. for ASP server side code to run the page extension must be ".asp". I was gonna mention that but I guess I just didnt think anyone would do that.
no offense.. not everyone works with this stuff every day.. , Not really sure how to do this.... i think you know what i am looking to do.. is there anyway you can show me or create that solution for me? It would prob. take you minutes as its been taking me hours  , I am getting the same error looking at the previous post, I looked in settings and my Registration-URL is pointing at the correct location.
Is there any other thoughts on this issue
Thank you!
Matt2112 , Hello:
When using the Mass Mail feature and selecting the Users to ‘Active’ and the Access Level I want to send to the system will still send e-mails to the ‘Inactive’ users from the same Access Level.
In other words it sends to everyone in the Access Level regardless if you choose “Active” only.
Any ideas to correct?
Thanks,
-Ricardo , We want to insert a hyperlink i the mesage area when we e-mail users from the Password Admin area. Is ther an easy way to insert the hyperlink so when the user gets the e-mail, they can just click on it and go the the page we want them to?
Thanks,
Andy cwilliams38456.0983101852, ok.. the count your talking about wont increment until someone other than you views the page.
After that you can increment it one time...
It keeps track of the last IP that hit it.. if it is the same it doesn't increment
This is all by design... so the same person doesn't increment the count over and over..
It's simplitist and it can be tricked... but it does what it needs to do
, Will purchasing an additional license resolve the issue which will allow another installation or is this a function of the application that it can only protect one site per server?, This is the 1st time anyone has ever told me they had any issues with the import process so I need more detailed information.
What upload component/method are you using ? Are you using an image resizing component ? Have permissions been set on the import folder ?
And lastly.. Can I see this happening ?
If not please put it on a live server where I can troubleshoot it for you. Like we say on our site.
In some cases in order to receive proper tech support your application will be need to be installed on a live server on the Internet. We simply cannot troubleshoot all issues when the application is only installed on your local machine. We also may require access to your server in order to troubleshoot any issues.
cwilliams38394.7298263889,
Thanks for the quick reply.
I will consider editing the code. , when did you puchase/download the application? you may have old code., Ok I used the following for the sql string.. is this correct?
SELECT COUNT(Album_ID) AS Alb_Count FROM " & tbl_label_albums & " WHERE (User_ID = " & CmdListUsers("User_ID") & " AND Album_Active = '-1'" & ")" , (User Photo Upload Mod) for ASPProtect Version 7.x
This will allow an individual user to upload a user picture instead of just the admin.
Notes: This is a down and dirty mod. The user upload code was copied from the admin area and there are no safeguards. Meaning there is no limit on the file size a user uploads and there is no confirmation process in case something they upload is inappropriate. etc etc etc
If you want that you will have to work on that on your own.

Directions: Back up your existing ASPProtect installation.
copy these files into your "users" folder
2006-01-24_111305_User_Upload_Mod.zip , Now, we can connect to the MySQL database with ASPBanner using the following connection string if we like.
"driver={MySQL ODBC 3.51 Driver};server=localhost;port=3306;uid=root;pwd=temp;databas e=aspbanner;option=16386"
But we really do not want to connect to the aspbanner MySQL database using the "root" account
So, lets make an account to use..
In MySQL Administrator select "User Administration"
Down below you will see the user "root"
Right click on "root" and select "Add new user"

Type in a New MySQL Username and Password
I am going to call my new user "aspbanneruser"
Hit the Schema Privileges" tab

In this case since I am using the root account to manage my MySQL system I am just going to give this new user account what it needs to use the aspbanner database.. you may want to apply more permissions to the new account, that is up to you.. I am giving the new user (select, insert, update, delete, execute) So I right click on the aspbanner and then bring over the permissions I need for it.. and hit apply changes down in the bottom right.
We can now connect to the aspbanner MySQL database using this new account like so.
"driver={MySQL ODBC 3.51 Driver};server=localhost;port=3306;uid=aspbanneruser;pwd=tem p;databas e=aspbanner;option=16386"
------------------------------------------------------------ ----- article still in the process of being written (3/14/06) , You know what, you really are frigin goofy to say you might think we
didn't write the software. I got source code to the license dll as well
as about 12 revisions of the application sitting on my development
server as well as about 1200 emails between John & Myself as we
worked on it. Not to mention all those .vb files that come with the
application. What do you think those are ? I bet you don't even really
know based on something you said in one of your earlier forum posts.
Did you even read this cause this is YOU... !!! http://support.cjwsoft.com/code/moreinfo234-1.htm And we say right on the ASPProtect.NET product page to read that article before making a purchase.
Moving
on... it basically says on the site ASPProtect.NET works the way
it is shown to work. You can use it that way or you can further edit
the code with Visual Studio.NET. If you are so good with asp.net then
you should be editing the code to work differently or writing your own
authentication that works exactly how you want it to. End of story. You
keep arguing about things your done... you are so done !!! I won't keep
putting up with you., No worries
then..
is there any way I can get rid of those information shown on User activity screen, so I can at least know who logged in current day?
thank you in advance , The links to view that info are on the main users screen of the admin area.
Down below...
They wont show up unless you have that stuff enabled in the settings screen as well.
, Sorry, there is no option for that.
I'll take it into consideration, but the way the banner rotation logic works would make adding such an option very complicated.
Just give it an expiration date way into the future if you do not want an ad to expire anytime soon.
I usually just make all my ads expire in like 2020 or something like that since I don't want them to stop running either on some of my sites. cwilliams38247.1116319444, I have ASPPhotoGallery installed. Everything has been working great for some time. Suddenly, for no apparent reason, I am not getting the "Hits" incremented when a user opens an album. It works when an administrator is logged on. Does not for any anonymous users. Everything else seems to work fine. Again, this used to work. Any ideas. , ahhh ok.. I was going to wait till morning to answer this one..
glad ya figured it out
, Triple check the upgrade instructions because I think you missed something important.
line 227 on "/password_admin/save.asp" refers to the "Password" field
the error your getting most likely means it is not there..
Pay close attention to the areas in the upgrade instructions regarding renaming your existing "Password" field to "Old_Password"
Then making a new "Password" field and carefully following the instructions needed to convert your old passwords for use with the new system.
If you don't everything carefully and perfectly this is the sort of error you will get.
cwilliams38451.8787268519, While attempting the database connection test, I receive the following error:
Server Error in '/' Application.
Security Exception
Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.
Exception Details: System.Security.SecurityException: Security error.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. | Stack Trace:
[SecurityException: Security error.]
aspprotectnet.DBConnectTest.Page_Load(Object sender, EventArgs e) +0
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +2112
System.Web.UI.Page.ProcessRequest() +218
System.Web.UI.Page.ProcessRequest(HttpContext context) +18
System.Web.CallHandlerExecutionStep.System.Web.HttpApplicati on+IExecutionStep.Execute() +179
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87
|
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
My guess is that this is an issue with the fact that I'm in a shared hosting environment that is restricted by CAS. Before I move to a dedicated server, I'd like to verify that this is the issue. I'd appreciate your input.
My host is 1and1 Internet. You may find this FAQ helpful: http://faq.1and1.com/scripting_languages_supported/_net/16.h tml.
, I get this error, Any ideas?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/guestbook/save.asp, line 109 , Just installed software, when I attempt to log on I get the following error (actually this is after I moved some of the include files to user).
Active Server Pages error 'ASP 0131'
Disallowed Parent Path
/gallery_admin/default.asp, line 25
The Include file '../dataconn_inc.asp' cannot contain '..' to indicate the parent directory.
What do I need to do to fix?
thanks. , Yup everything looks ok - but why no error?
This just gets better - now the email a friend link says sent successfully and doesn't send out - what the heck...
What would cause it to 'think' it is doing the task yet still fail? , Christopher
Found this but I dont really know what to do with it or even if its the right thing.
<% '=========================================================== ==================='
' Application: Utiity Function ' Author:   ; John Gardner ' Date: & nbsp; 20th December 2004 ' Description: Used to check the validity of a postcode ' QueryString: None ' Version: V1.0
' Required routines: &nb sp; None '----------------------------------------------------------- -------------------'
function Check_Postcode (byRef strPostcode)
' This routine checks the value of the form element specified by the parameter ' for a valid postcode.
' The definition of a valid postcode has been taken from: ' http:'www.royalmail.com/docContent/other/Downloadable_Files/ PAF_Digest_Issue_5_0.pdf
' If the element is a valid postcode, the function value is returned as TRUE ' and the postcode is returned in uppercase with the separating space in the ' right place.
Dim strPostcodeRegExp(2) ' holds the regular expressions for valid postcodes Dim intCount &nbs p; ' For loop counter Dim strPostcodeCopy ' Copy of postcode ' Variables used to hold regular expression object Dim objRegExp, objMatches, objMatch ' Expression for postcodes: AN NAA, ANN NAA, AAN NAA, and AANN NAA strPostcodeRegExp(0) = "^([a-z]{1,2}[0-9]{1,2})([0-9]{1}[abdefghjlnpqrstuwxyz]{2})$"
' Expression for postcodes: ANA NAA, and AANA NAA strPostcodeRegExp(1) = "^([a-z]{1,2}[0-9]{1}[a-z]{1})([0-9]{1}[abdefghjlnpqrstuwxyz]{2})$" ' Exception for the special postcode GIR 0AA strPostcodeRegExp(2) = "^(gir)(0aa)$"
' Copy the parameter and convert into lowercase strPostcodeCopy = Lcase(strPostCode) ' Assume we're not going to find a valid postcode Check_Postcode = false ' Strip out spaces strPostcodeCopy = Replace (strPostcodeCopy, " ", "") Check_Postcode = False Set objRegExp = New RegExp ' Check the string against valid types of post codes For intCount = 0 to Ubound(strPostCodeRegExp) ' Check next pattern in list objRegExp.Pattern = strPostcodeRegExp(intCount) If objRegExp.Test (strPostcodeCopy) Then ' Post code found. Ensure input parameter is in correct format. Set objMatches = objRegExp.Execute (strPostcodeCopy) Set objMatch = objMatches(0) strPostcodeCopy = Ucase (objMatch.subMatches (0)) & " " & Ucase (objMatch.subMatches (1)) ' Show that we have found the postcode Check_Postcode = True End if Next ' Ensure that the uppercase postcode gets returned if valid If Check_Postcode Then strPostcode = strPostcodeCopy End Function %>
regards
John
, again I will ask you what is the real error??
see the link above when I asked you the 1st time. (I need the error details and line number.. etc etc)
and what kind of a server are you trying to run it on ? you mention xp pro but in a confusing way ? , you not seeing the real error
http://support.cjwsoft.com/forum/forum_posts.asp?TID=11& PN=1 , Things have now changed I found out godaddy has persitis aspUPload and aspjpeg as value added products, I have the aspjpeg working but have been unable to upload when using aspUPload, everything works fine with the vbscript method so I think my permissions are correct. Whenever you get a chance, any help would be appreciated.
Thanks
Mark , This is the error that I am getting when I try to add a banner...
[code]Microsoft OLE DB Provider for SQL Server error '80040e09'
EXECUTE permission denied on object 'sp_ASPBanner_GetZones', database
'aspbanner', owner 'dbo'.
/aspbanner/appinfo_inc.asp, line 67[/code]
also, when i go to the banners tab i see this in the banner list...
[code](3 Banners Found)
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '='.
/aspbanner/banners.asp, line 306[/code]
Help., I'll send you something.. ,
Timecard Entry: 3/25/2006 4:32:46 PM
Start moving out the downstairs office, and putting desks in their for Mary and Cathy. Also did over an hour on tech support because Robby's kid was in the ER., vacation time, At home doing realtor.com upload remotely for mls site...., helped a user that couldn't surf. did some radlogs, teched calls, meeting with jcc/discussed workshop ideas. watertown office, met with jg., Management of Employees, Infrastructure, and Projects, Working on pocket real estate files as well as expirimenting with my Visor and how it works, extra busy in the aftrnoon, timberview lodge- pual- gave password/internet conection
black river valley club- set up appointment
north country orthopedic- set up meeting to go over changes for web site
, Over all net design. DSL, VT Review, New customer set-up & invoicing, IMCNET again, but Seth fixed it though Justin walked over there anyways., AT work working on new password protection code for new MLS software., Resetting open modems. , 24 miles to Clayton, Entered deposits and pulled invoices, Back to file encryption routines for sending secure documents., Very busy because of the mail sever problems and I took a bunch of sign ups., working on getting beth's computer to hook up to the quickbooks server. talked to andy about it, he'll see what he can do., Garlock - matt- domain registration
howland pump- tom larose- vitrual email
al chaney - customer send info out
timecard info- and tracking system
, Steady, but not bad, ACHESON CREATIONS SEARCH ENGINE REGISTRATION, Nortel, Traveled through Ogdensburg and then back home. , Fairpoint LD call, travel 69070-69106, Howard, Jim, State Tower Bldg - Office Space, lunch, logins / logins / phones.,
|