Jump to content

avyona

Member
 View Profile  See their activity

  • Posts

    44

  • Joined

  • Last visited

 Content Type 

Posts posted by avyona

    Dropbox Saver Integration

    in Technical Help

    Posted

    Hi!

     

    So I put the dropbox saver button javascript in the cart.tpl file from my dropbox api panel.  Its a simple <script>. I added just before the closing </body> tag so that it loads last on the page which is much better for page speed testing.

     

    Then I went into the vieworder.tpl and I duplicated the download link to look like this: 

    		<!-- BEGIN: digital_link -->
		<br />
		<a href="{VAL_DOWNLOAD_LINK}" class="txtUpdate">{LANG_DOWNLOAD_LINK}</a>  or <a href="{VAL_DOWNLOAD_LINK}" class="dropbox-saver"></a>
		<!-- END: digital_link -->

    On the front end, when the save to dropbox button is clicked, it tried to download the download.php file.

     

    I'm assuming its because the link is encoded and dynamic. I've gotten it to work fine for other platforms. What do you guys think?  BTW, this is on 3.0 store. I tried to update all the way to 6.0 but it didnt work out :/ 

    Upgrading from 3.0.21 to 6.0.10

    in Install & Upgrade Support

    Posted

    ok so a summary:

    1) I have admin.php 500 server errors and cannot login to admin (its  a white page and the errors are listed above)

    2) I went into cubecart_downloads and set the order_inv_id to = the digital_id column so those match now per the instructions in the knowledge base

    3) I login to a customer account on the website front end and navigate to Downloads

         a- The Product Name and Product File name DONT match see the attached image

         b- When I click on the button that says 'Download' -it tries to download a completely different file!

         c- The Download results in a 403 error

         d- The error log shows this is happening when a link is clicked: 

    [03-Feb-2016 08:52:52 UTC] PHP Fatal error:  Undefined class constant 'FM_DL_ERROR_NORECORD' in /home/legacyplanetappl/public_html/classes/filemanager.class.php on line 405

    Im bout to just buy tech support....can they fix this?

    testdown.jpg

    testdown1.jpg

    Upgrading from 3.0.21 to 6.0.10

    in Install & Upgrade Support

    Posted

    admin.php? gives this error in error log

      

    [03-Feb-2016 08:16:41 UTC] PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 78 bytes) in /home/legacyplanetappl/public_html/classes/db/mysqli.class.php on line 208

    which is this in the php file: 

    $this->_result[] = array_map(array(&$this, 'strip_slashes'), $row);

     

    Upgrading from 3.0.21 to 6.0.10

    in Install & Upgrade Support

    Posted

    cool i pushed that limiter up again hehe. Yes its one hellava database...several gigs.

    I'm going to read that topic right now!

    I read it. Ok that makes me feel better because I LOVE THE DOWNLOADS TAB in My Account :)  If for for reason it does not copy those values..i will run a sql command to copy one column to the other

     

    bsmither, wouldnt this be easier for me to just install 6.0 right off the batt and then import my database and make the changes to the database if it needs it? I know you dont normally recommend this to folks because of mods and customizations...but im wondering in my case if it would be easier.  Last year you told me to load cc3, import my tables, then upgrade to 6.0.  And that works fine for most folks probably...but because my tables are so large...im wondering if i would get this done quicker if I do my changes directly to 6.0 databse

    [Resolved] How Do i Bulk Delete Customers?

    in Technical Help

    Posted

    im coming in late on this...but I do this every 6 months. First time I did it there were like 8,000 of those 'fake' customers.  Here is the SQL command I used in phpmyadmin on my granny version 3.0 store:

    DELETE FROM `CubeCart_customer` WHERE noOrders  =  0 AND regTime < 1454012330;

    Since you are running 6.0 then you would probably run it like this:

    DELETE FROM `CubeCart_customer` WHERE order_count  =  0 AND registered < 1460000000;

    or even better:

    DELETE FROM `CubeCart_customer` WHERE order_count  =  0;

    It will clean house in a second!

    i like to put a timestamp on it so that if someone has been shopping in the past two weeks and havent donea  checkout yet and are still thinking...then they wont be lost and end up having to reregister.

     

    • Like 1

    Upgrading from 3.0.21 to 6.0.10

    in Install & Upgrade Support

    Posted

    the latest error (I keep refreshing it each time the setup stops):

    [03-Feb-2016 06:44:19 UTC] PHP Fatal error:  Maximum execution time of 900 seconds exceeded in /home/legacyplanetappl/public_html/classes/cache/file.class.php on line 61

    I'm assuming when its all done then those downloads will work ?  If not let me know now haha!  I will figure out something to do about that. I mess with databases all the time and do a LOT or bulk editing importing and exporting of sql files

     

    im assuming the setup script...it does a little and then the poor thing gets tuckered out. I hit refresh and it does a little more and so on..eventually I think if I keep refreshing it will be upgraded to 6.0.10 hopefully before the sun rises :) its 2am here

     

    thats  what i get for running on 3.0 for 10 years!  When its time to upgrade its not fun to put it sweetly

    Upgrading from 3.0.21 to 6.0.10

    in Install & Upgrade Support

    Posted

    im up late...i refuse to sleep until I get this done...wheres my coffee lol

    Why cant I just install a fresh 6.0.10 install and import my tables?  ALSO while im sitting here..I logged into a customer account on the front side to see download links. They all say "This download is no longer available." for every link.  If I do get this thing upgraded will this resolve or is there something else I need to do?  Thanks in advance...I'm still searching the forum for like problems.

     

     

    Upgrading from 3.0.21 to 6.0.10

    in Install & Upgrade Support

    Posted

    i didnt upload any product pics...they wont be seen anywhoo so I thought id leave them out...should I add them to the images folder?  Is it causing an issue for them not to be there?

     

    well I made the changes both the setup/index.php and also the WHM I changed the php settings in there to match those in the file...well I actually did 4000M for memory instead of 256M.  Now it just spins and spins...like its stuck :( /cry

    Upgrading from 3.0.21 to 6.0.10

    in Install & Upgrade Support

    Posted

    lol! Thanks Dirty.

     

    So I started the upgrade and after a while I got an internal 500 error. I have no clue if the upgrade went all the way through,but  I deleted the setup folder to see if it would go away and it did.   Next issue I tried to login to admin and got a 404 error lol. So I read online that admin access is now admin.php for security reasons.  I typed that in and now my password wont work. So I went into the database and deleted the salt and manually reset the password and MD5'd it.  I was able to login but it was a blank screen. So I closed the window and tried again and now I get a 500 server error again!

    Everything that is a link on the front end of the website returns a 404 error. I'm assuming I need to do something in the admin to correct that part but I cant login. 

    Store url is:

    www.legacyplanetapplique.com

     

    Any insights? The plot thickens...

    Upgrading from 3.0.21 to 6.0.10

    in Install & Upgrade Support

    Posted

    I am actually creating a legacy store...to save all old order history so I didnt move EVERYTHING over...just whatever is essential allow customers to login using their password and download their purchases ;) So like I didnt move the documents etc. Customers wont be checking out on the site...they will be just using the new install for getting at those old orders that are WEIGHING down our server, database etc.

    So If I use the upgrade guide on the knowledge base to go from 3.0 to 6.0 then it will take care of all the inbetweens?

    do i navigate to www.mysite.com/upgrade  or do I need to manually install cubecart 6 and use the install or upgrade folder that way?

    oh nevermind lol..i see i need to install it manually ;)

     

    Also I had some serious timeout issues importing tables!! I had to use SQL queries to select sections of specific tables at a time and export "chunks" .  The tables ARE HUGE!! I have 7 sql files just for the order.inv table alone lol. I am hitting that 50mb imported uploaded file limit...so yeah im going craaaazy. Its more tedious but its coming along. This is why I did not just simply export the entire database and import.

     

    Upgrading from 3.0.21 to 6.0.10

    in Install & Upgrade Support

    Posted

    I am working on moving my old cart to a new server and want to go ahead and upgrade it while im at it.  So far I have installed 3.0.21 manually from the cubecart website, set up a database, and I've just spent the last two days importing over essential tables : inventory, customer, orderinv, ordersum, cat, and downloads.  I've also uploaded all pics and downloadable files.  My domain name is changing, so I will have to go through and do a find and replace on the inventory table to change the file path to the new file path for all the downloads for each product.

    Now my questions are:

    1) Am I correct up to this point?

    2) Do I need to upgrade to 4.0 then to 5.0 then to 6.0 or can I go straight to the 6.0.10?

    Thanks!

    Been a long process...we have over 500k orders, 80k customers, and 3 million download links lol....shew

    [Resolved] Paypal SHA-256 and Cubecart

    in Technical Help

    Posted

    Please see the latest announcement.... your CubeCart v3 and v4 shop should continue to work ok too. Surely it's WAY past time to upgrade though!!?? :rolleyes: 

    It IS way past time haha!  We are working on it. I have done so many modifications on my own and we have just under a million orders...my main concern is database tables matching up. Its taking some time to work on...but its coming along haha and thanks for the heads up about PHP 7!

    [Resolved] Paypal SHA-256 and Cubecart

    in Technical Help

    Posted

    planetapplique.com and we dont have a SSL install since we use PP for processing

    Ian I think you are right about the SSL.  There were some links in the email as well and when I clicked on them and read over the actions needing to be taken they were all related to using SHA-1 SSL certificates.  I supposed then since we dont use a SSL on this domain ( I do have one for our other website which uses a EV SSL through comodo) then it doesnt affect me?

    [Resolved] Paypal SHA-256 and Cubecart

    in Technical Help

    Posted

    I received a notice from paypal regarding us using IPN on our CC3 store:

    Rehbecca Lowder,

    As we have previously communicated to you, PayPal is upgrading the certificate for www.paypal.com to SHA-256. This endpoint is also used by merchants using the Instant Payment Notification (IPN) product.

     

     

     

    This upgrade is scheduled for 9/30/2015; however, we may need to change this date on short notice to you to align to the industry security standard.

     

    You’re receiving this notification because you’ve been identified as a merchant who has used IPN endpoints within the past year. If you have not made the necessary changes, we urge you to do so right away to avoid a disruption of your service!

     

    Because these changes are technical in nature, we advise that you consult with your individuals responsible for your PayPal integration. They will be able to identify what, if any, changes are needed. Please share this email and the hyperlinks below with your technical contact for evaluation.

    It looks like the API connection endpoints that CC 3 uses is being phased out. I'm totally freaking out because I dont want our website to break. Does anyone know how I might upgrade the IPN protocol so that we will be compliant when the change happens? Thanks in advance for your thoughts! I hope someone can shed some light.

    Customer Account Pages SLOW

    in Technical Help

    Posted

    here is a new link:  http://planetapplique.com/download.php?pid=1090&oid=MTUwNzI5LTE2NTU0OC0xNjkz&ak=pLgUGTcc

    I dont think its the download file size either. They are not too terribly large mostly well below 1mb. I tried from email to download using that link and its still slow. So it has to be something with the link and how that is executed, but not necessarily the server like you said. Its like the "form" or "function" is not right. Imma have to pour through my cpanel filemanager to try to located where I added the redirect for those links. I didnt add it to the template or to the inc.php file for the view order so its gotta be somewhere. I might have done it in the header or somewhere else. Ugh...need some tylenol haha. I'm determined to find it now!  I still have plans for CC6 integration but I have to get everything working properly cause im like that. Thanks BSmither, you have been a HUGE help to bounce my thoughts off of.

    Customer Account Pages SLOW

    in Technical Help

    Posted

    When I used pingdom.com to test that download url it returns a performance details that their is a redirect on the download link.  I remember having to get a little creative when I implemented to freebies because i had to put a doc as the download items so for instance instead of:

     

    http://mysite.com/files/uploads/file.zip

     

    I had to do this so provide MULTIPLE download links:

    http://mysite.com/files/uploads/file.html

     

    I remember the cart not liking the html extension and I had to alter code somewhere to accept the html most likely using a generic target="_blank" or something along those lines for it to even work.  Now I cant remember which file I edited to get that to work. Been looking for it for about two hours now lol download.php, vieworder.inc.php, vieworder.tpl index.php, cart.php ...nada... I usually take notes when I make a modification and I havent located it on the drive. Keep in mind I made that change in 2010 :/

    /rage quit :2guns:

    I'm going to take a break before I flip out..

    i also did a test order just now and sent myself download links.  It automatically opened a new tab about:blank and then the oct stream kicked in with the save dialog box. It shouldnt do that normally. What the heck did i change!? lol

     

×
×
  • Create New...