Jump to content

avyona

Member
  • Posts

    44
  • Joined

  • Last visited

Everything posted by avyona

  1. 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 :/
  2. 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?
  3. 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);
  4. ok upgrade is complete!! Now...i went to admin.php and its just a white screen :/
  5. 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
  6. 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.
  7. 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
  8. btw...a long time ago I reset all my customers download links to expire in like 40 years lol...I did a mass update to the table and column to make sure there were no limits for our customers. So the download links should not be expired.
  9. 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.
  10. it went a little further...now its on 5.2.14 or something and I have a new php error: if (!preg_match('#^\w:\d+:\{(.+)\}$#su', $input)) { $input = stripslashes($input); this is line 694 of the database.class.php
  11. 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
  12. [03-Feb-2016 01:32:23 UTC] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 608 bytes) in /home/legacyplanetappl/public_html/classes/db/mysqli.class.php on line 200
  13. what do you recommend for php settings to get the install to go through smooth? It looks to be stuck at 5.0.0b1. I came back to my desk and the screen was blank...so I initiated the setup again from IE and it poped up but its still at 5.0.0b1 I have the worst luck I swear!
  14. sign...lovely! Ok I'll try it again looks like its resuming from 5.0.0b1...fingers crossed i have a dedicated server..so I bumped up the times on the php config
  15. 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...
  16. Thanks Havenswift! It makes sense I got it all done finally this morning...but I will keep that in mind next time to save me some headache lol! I'm trying to use site to site FXP to get all these files removed over!! Just about ready to upgrade the store in a few hours.
  17. 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.
  18. 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
  19. 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!
  20. 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?
  21. I received a notice from paypal regarding us using IPN on our CC3 store: 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.
  22. I just released new designs so traffic is high atm. We average about 50,000 unique visitors a month and release days put a strain on things. I'll look at the MySQL error log
  23. 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.
  24. 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 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
  25. hmmm the plot thickens...ill do a few more tests.
×
×
  • Create New...